It is so only on large table(s) with sizes at least more, than 1262 MB. I think it is about amount of data, not about data itself.
Like this
psql:alizenko.sql:3108625: ERROR: extra data after last expected column CONTEXT: COPY <table_name2>, line 2424915: "1643415437295 KYOCY MORNINGSTAR f {"rSquare": 38.657029, "nonDivBeta": 0.9944, "nonDivAlpha": 0.0042..."
Any ideas how to debug? GDB? Or I may try to obfuscate my example and share it somehow.
will try to, it would take some time. But may be we have two problems here.
On Thu, 23 Mar 2023 at 12:32, Daniel Gustafsson <daniel@yesql.se> wrote:
> On 23 Mar 2023, at 12:30, Andrey Lizenko <lizenko79@gmail.com> wrote: > > (copying here as it was a misclick about "reply all" button) > > I'll try to, but even plain text dump didn't work > > psql:<db_name>_20230323.sql:5672327: ERROR: extra data after last expected column > CONTEXT: COPY alpha_beta, line 3828998: "1643415437295 SRSR MORN1661692859461 NODK MORNINGSTAR f {"fiscalYearEndMonth": "12"} 0P00019YC1 0C00..." > > I can check md5sum if there is an idea about network issue.
Are you able to generate a small reproducible test case with a schema like yours and a row of data which fails like this?