Strange crash with pg_dump - Mailing list pgsql-hackers

From Olivier PRENANT
Subject Strange crash with pg_dump
Date
Msg-id Pine.UW2.4.21.0303031329470.2927-100000@server
Whole thread Raw
List pgsql-hackers
Hi everyone.

Environment:
OS: UW 713
PG: 7.3.2

I've been banging my head for a few weeks on this one and could'nt find
any answer:

pg_dump is crashing with SIGSEGV before it connects to database.
I've re-compiled with --enable-debug and --enable-cassert and even that
did'nt help.

this is gdb output not showing much:
Script started on Mon Mar  3 13:26:51 2003
~ 13:26:51: gdb /usr/local/pgsql/bin/pg_dump /archives/dbbackup/core.28913 
GNU gdb 5.3
Copyright 2002 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "i686-unknown-sysv5UnixWare7.1.3"...
Core was generated by `pg_dump forums_ahe'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /usr/local/pgsql/lib/libpq.so.3...done.
Loaded symbols for /usr/local/pgsql/lib/libpq.so.3
Reading symbols from /usr/lib/libz.so...done.
Loaded symbols for /usr/lib/libz.so
Reading symbols from /usr/local/lib/libreadline.so.3...done.
Loaded symbols for /usr/local/lib/libreadline.so.3
Reading symbols from /usr/lib/libresolv.so.2...done.
Loaded symbols for /usr/lib/libresolv.so.2
Reading symbols from /usr/lib/libsocket.so.2...done.
Loaded symbols for /usr/lib/libsocket.so.2
Reading symbols from /usr/lib/libnsl.so.1...done.
Loaded symbols for /usr/lib/libnsl.so.1
Reading symbols from /usr/lib/libdl.so.1...
warning: Lowest section in /usr/lib/libdl.so.1 is .hash at 000000a0
done.
Loaded symbols for /usr/lib/libdl.so.1
Reading symbols from /usr/lib/libm.so.1...done.
Loaded symbols for /usr/lib/libm.so.1
Reading symbols from /usr/lib/libc.so.1...done.
Loaded symbols for /usr/lib/libc.so.1
Reading symbols from /usr/lib/ns.so.1...done.
Loaded symbols for /usr/lib/ns.so.1
#0  0xbffa3dd0 in flushsmall () from /usr/lib/libc.so.1
(gdb) bt
#0  0xbffa3dd0 in flushsmall () from /usr/lib/libc.so.1
#1  0x00000030 in ?? ()
(gdb) ~ 13:27:44: exit

script done on Mon Mar  3 13:27:48 2003

If I vacuum the databse it starts to work again until the script doing
backup runs then pg_dump crashes again.

This is a test system so databases are not even accessed!
They are pulled from the real server running 7.2.3 with pg_dumpall (the
7.3 one) -h server -c|psql template1

It doesn't seem to be a database issue because it used to crash on another
one.

While I'm at it : what is the procedure to remove template1 and replace it
by template0 after a reload? It doesn't seem right to me that pg_dumpall
replace template1 but maybe I'm wrong on this one.

Thanks for your tim and help
-- 
Olivier PRENANT             Tel:    +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)



pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: GiST: Bad newtup On Exit From gistSplit() ?
Next
From: cbbrowne@cbbrowne.com
Date:
Subject: Re: Yet another open-source benchmark