From: | Andrey Lizenko <lizenko79(at)gmail(dot)com> |
---|---|
To: | Daniel Gustafsson <daniel(at)yesql(dot)se> |
Cc: | pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #17863: Unable to restore dump 12.12 -> 15.2 |
Date: | 2023-03-24 06:50:16 |
Message-ID: | CADKuZZDoKmxkTc=CWDz60CyVpe09zJYy+BK35Gy7KVxmPJZaOg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
>
> small reproducible test case
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.
On Thu, 23 Mar 2023 at 12:37, Andrey Lizenko <lizenko79(at)gmail(dot)com> wrote:
> 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(at)yesql(dot)se> wrote:
>
>> > On 23 Mar 2023, at 12:30, Andrey Lizenko <lizenko79(at)gmail(dot)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?
>>
>> --
>> Daniel Gustafsson
>>
>>
>
> --
> Regards, Andrei Lizenko
>
--
Regards, Andrei Lizenko
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2023-03-24 08:02:21 | BUG #17867: pg_dump intermittently hangs |
Previous Message | Daniel Gustafsson | 2023-03-23 22:00:24 | Re: BUG #17866: behavior does not match documentation |