From: | Nico De Ranter <nico(dot)deranter(at)esaturnus(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dump crashes |
Date: | 2020-05-22 15:13:07 |
Message-ID: | CALVv0fZZruB6i9mRZD5zJW21Sn40p19pfjxj3Se2Hxe0VcDAFA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, May 22, 2020 at 5:09 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
> > <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)services(dot)eu(at)sony(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-05-22 15:13:54 | Re: pg_dump crashes |
Previous Message | stan | 2020-05-22 15:11:15 | Query to get name a data type of a view |