Strange crash with pg_dump

From: Olivier PRENANT <ohp(at)pyrenet(dot)fr>
To: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Strange crash with pg_dump
Date: 2003-03-03 12:39:44
Message-ID: Pine.UW2.4.21.0303031329470.2927-100000@server
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)

Browse pgsql-hackers by date

  From Date Subject
Next Message cbbrowne 2003-03-03 12:41:05 Re: Yet another open-source benchmark
Previous Message Teodor Sigaev 2003-03-03 09:57:51 Re: GiST: Bad newtup On Exit From gistSplit() ?