Re: pg_dump crashes - Mailing list pgsql-general

From Nico De Ranter
Subject Re: pg_dump crashes
Date
Msg-id CALVv0fZZruB6i9mRZD5zJW21Sn40p19pfjxj3Se2Hxe0VcDAFA@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump crashes  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: pg_dump crashes
List pgsql-general


On Fri, May 22, 2020 at 5:09 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 5/22/20 8:05 AM, Nico De Ranter wrote:
>
> On Fri, May 22, 2020 at 5:02 PM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     On 5/22/20 7:55 AM, Nico De Ranter wrote:
>      > Correct.
>      >
>      > If I run 'pg_dumpall --cluster 11/main --file=dump.sql'   the end
>     of the
>      > file looks like:
>      >
>      > ###### cut here
>      > 4557430888798830399 1061109567 1061109567 1061109567 1061109567
>     16191 \N
>      > \N ??????????????????????????????
>      > 4557430888798830399 1061109567 1061109567 1061109567 1061109567
>     16191 \N
>      > \N ??????????????????????????????
>      > \.
>      >
>      > ###### cut here
>      >
>      > If I run 'pg_dump --table=public.file --cluster 11/main
>      > --file=dump-2.sql bacula'  those lines are actually followed by
>     about
>      > 850 or so lines that look ok.  I'm assuming the difference is due to
>      > buffering.
>      > However the fact that I do see a number of regular lines
>     following this
>      > may suggest it's just garbage in the table but not really causing
>     the
>      > issue afterall.
>
>     Assuming the above matches:
>
>     COPY public.file (fileid, fileindex, jobid, pathid, filenameid,
>     deltaseq, markid, lstat, md5)
>
>     the '????????????????????' would be for the md5 field. I'm going to say
>     that is important.
>
>
> But that would be content of the database only. The should matter for
> the application but not for a dump of the database, right?

I would think that depends on what '???????' is really representing.

In the database try:

SELECT md5 FROM public.file where fileid = 4557430888798830399;



bacula=# SELECT md5 FROM public.file where fileid = 4557430888798830399;
 md5
-----
(0 rows)
 
So that fileid is bogus too (max(bigint) I assume)

--

Nico De Ranter

Operations Engineer

T. +32 16 38 72 10



eSATURNUS
Philipssite 5, D, box 28
3001 Leuven – Belgium

T. +32 16 40 12 82
F. +32 16 40 84 77
www.esaturnus.com

For Service & Support :

Support Line Belgium: +32 2 2009897

Support Line International: +44 12 56 68 38 78

Or via email : medical.services.eu@sony.com


pgsql-general by date:

Previous
From: stan
Date:
Subject: Query to get name a data type of a view
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dump crashes