Re: BUG #17863: Unable to restore dump 12.12 -> 15.2

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

In response to

Responses

Browse pgsql-bugs by date

  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