Thread: 7.3 pg_dump with -Fc option crashes
This works: pg_dump -h myhost -p 5432 -f mydb.cpgdmp mydb This does not: pg_dump -h myhost -p 5432 -Fc -f mydb.cpgdmp mydb Segmentation fault (core dumped) Nor does this: pg_dump -h myhost -p 5432 -Ft -f mydb.cpgdmp mydb (but I need the -Fc badly as my dbs backup up to large files) Here's a stack track (if needed): (adb) bt #0 0x080562a6 in WriteStr (AH=0x8074638, c=0x6c627570 <Address 0x6c627570 out of bounds>) at pg_backup_archiver.c:1519 #1 0x080569b2 in WriteToc (AH=0x8074638) at pg_backup_archiver.c:1851 #2 0x080594b2 in _CloseArchive (AH=0x8074638) at pg_backup_custom.c:802 #3 0x080545ef in CloseArchive (AHX=0x8074638) at pg_backup_archiver.c:113 #4 0x0804a846 in main (argc=9, argv=0xbffff4cc) at pg_dump.c:645 #5 0x401ef306 in __libc_start_main (main=0x8049db0 <main>, argc=9, ubp_av=0xbffff4cc, init=0x8049634 <_init>, fini=0x8064720<_fini>, rtld_fini=0x4000d2dc <_dl_fini>, stack_end=0xbffff4bc) at ../sysdeps/generic/libc-start.c:129 Thanks, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. wwy.nextbus.com ---------------------------------- Life is an SQL old chum...
Oh goodness it's even worse as pg_restore can't read the archive from the first pg_dump: pg_dump -h myhost -p 5432 -f mydb.pgdmp mydb pg_restore -l mydb.pgdmp pg_restore: [archiver] input file does not appear to be a valid archive Thanks, L. On Fri, 10 Jan 2003, Laurette Cisneros wrote: > > This works: > pg_dump -h myhost -p 5432 -f mydb.cpgdmp mydb > > This does not: > pg_dump -h myhost -p 5432 -Fc -f mydb.cpgdmp mydb > Segmentation fault (core dumped) > > Nor does this: > pg_dump -h myhost -p 5432 -Ft -f mydb.cpgdmp mydb > (but I need the -Fc badly as my dbs backup up to large files) > > Here's a stack track (if needed): > (adb) bt > #0 0x080562a6 in WriteStr (AH=0x8074638, > c=0x6c627570 <Address 0x6c627570 out of bounds>) at > pg_backup_archiver.c:1519 > #1 0x080569b2 in WriteToc (AH=0x8074638) at pg_backup_archiver.c:1851 > #2 0x080594b2 in _CloseArchive (AH=0x8074638) at pg_backup_custom.c:802 > #3 0x080545ef in CloseArchive (AHX=0x8074638) at pg_backup_archiver.c:113 > #4 0x0804a846 in main (argc=9, argv=0xbffff4cc) at pg_dump.c:645 > #5 0x401ef306 in __libc_start_main (main=0x8049db0 <main>, argc=9, > ubp_av=0xbffff4cc, init=0x8049634 <_init>, fini=0x8064720 <_fini>, > rtld_fini=0x4000d2dc <_dl_fini>, stack_end=0xbffff4bc) > at ../sysdeps/generic/libc-start.c:129 > > Thanks, > > -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com ---------------------------------- Life is an SQL old chum...
Laurette Cisneros <laurette@nextbus.com> writes: > This does not: > pg_dump -h myhost -p 5432 -Fc -f mydb.cpgdmp mydb > Segmentation fault (core dumped) If you have any comments on views, this is probably an instance of a known bug: 2002-12-27 12:10 tgl * src/bin/pg_dump/: pg_dump.c (REL7_3_STABLE), pg_dump.c: Removeoverenthusiastic free'ing of comment dependencies; couldlead tocore dump in pg_dump when dumping views having comments. See bug#855. This fix postdates 7.3.1, but you could get the patch from the CVS server or the pgsql-bugs archives. regards, tom lane
Thanks. I've nulled all the "comment on view"s but still get it... On Fri, 10 Jan 2003, Tom Lane wrote: > Laurette Cisneros <laurette@nextbus.com> writes: > > This does not: > > pg_dump -h myhost -p 5432 -Fc -f mydb.cpgdmp mydb > > Segmentation fault (core dumped) > > If you have any comments on views, this is probably an instance of a > known bug: > > 2002-12-27 12:10 tgl > > * src/bin/pg_dump/: pg_dump.c (REL7_3_STABLE), pg_dump.c: Remove > overenthusiastic free'ing of comment dependencies; could lead to > core dump in pg_dump when dumping views having comments. See bug > #855. > > This fix postdates 7.3.1, but you could get the patch from the CVS > server or the pgsql-bugs archives. > > regards, tom lane > -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com ---------------------------------- Life is an SQL old chum...
That did the trick...fixed pg_dump! And, pg_restore works on it too! Yay, I can go home now. Thanks very much for your help! On Fri, 10 Jan 2003, Tom Lane wrote: > Laurette Cisneros <laurette@nextbus.com> writes: > > This does not: > > pg_dump -h myhost -p 5432 -Fc -f mydb.cpgdmp mydb > > Segmentation fault (core dumped) > > If you have any comments on views, this is probably an instance of a > known bug: > > 2002-12-27 12:10 tgl > > * src/bin/pg_dump/: pg_dump.c (REL7_3_STABLE), pg_dump.c: Remove > overenthusiastic free'ing of comment dependencies; could lead to > core dump in pg_dump when dumping views having comments. See bug > #855. > > This fix postdates 7.3.1, but you could get the patch from the CVS > server or the pgsql-bugs archives. > > regards, tom lane > -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com ---------------------------------- Life is an SQL old chum...
Are we near needing 7.3.2? The contraint dump patch is post-7.3.1 too, and Tom applied a big fix recently to 7.3.X. --------------------------------------------------------------------------- Laurette Cisneros wrote: > That did the trick...fixed pg_dump! > > And, pg_restore works on it too! > > Yay, I can go home now. > > Thanks very much for your help! > > On Fri, 10 Jan 2003, Tom Lane wrote: > > > Laurette Cisneros <laurette@nextbus.com> writes: > > > This does not: > > > pg_dump -h myhost -p 5432 -Fc -f mydb.cpgdmp mydb > > > Segmentation fault (core dumped) > > > > If you have any comments on views, this is probably an instance of a > > known bug: > > > > 2002-12-27 12:10 tgl > > > > * src/bin/pg_dump/: pg_dump.c (REL7_3_STABLE), pg_dump.c: Remove > > overenthusiastic free'ing of comment dependencies; could lead to > > core dump in pg_dump when dumping views having comments. See bug > > #855. > > > > This fix postdates 7.3.1, but you could get the patch from the CVS > > server or the pgsql-bugs archives. > > > > regards, tom lane > > > > -- > Laurette Cisneros > The Database Group > (510) 420-3137 > NextBus Information Systems, Inc. > www.nextbus.com > ---------------------------------- > Life is an SQL old chum... > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
Bruce Momjian <pgman@candle.pha.pa.us> writes: > Are we near needing 7.3.2? We clearly need to have a 7.3.2, but I was thinking late January would be about the right time frame. Bugs are still trickling in (eg, the plpgsql one Neil just identified), and so far we've not seen anything that would make me feel we need an immediate release ... regards, tom lane
> We clearly need to have a 7.3.2, but I was thinking late January would > be about the right time frame. Bugs are still trickling in (eg, the > plpgsql one Neil just identified), and so far we've not seen anything > that would make me feel we need an immediate release ... I'm biased, but I think the SSL problems fixed since 7.3.1 are pretty big. 7.3.1 is still pretty much unuseable if SSL support is required. --Nate