Thread: BUG #2728: Core dump while pgdump DB

BUG #2728: Core dump while pgdump DB

From
"Yee"
Date:
The following bug has been logged online:

Bug reference:      2728
Logged by:          Yee
Email address:      christ1783@yahoo.com
PostgreSQL version: 7.4.1
Operating system:   Solaris 9
Description:        Core dump while pgdump DB
Details:

I tried to export a large DB from PostgreSQL and a core_dump file was found
after the process.

The following was what I found from the core_dump:

GNU gdb 6.0
Copyright 2003 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 "sparc-sun-solaris2.9"...
Core was generated by `/gen/tools/pgsql/bin/postmaster -i -S -D
/gen/tools/pgsql/data'.
Program terminated with signal 6, Aborted.
Reading symbols from /usr/lib/librt.so.1...done.
Loaded symbols for /usr/lib/librt.so.1
Reading symbols from /usr/lib/libresolv.so.2...done.
Loaded symbols for /usr/lib/libresolv.so.2
Reading symbols from /usr/lib/libgen.so.1...done.
Loaded symbols for /usr/lib/libgen.so.1
Reading symbols from /usr/lib/libsocket.so.1...done.
Loaded symbols for /usr/lib/libsocket.so.1
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...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/libaio.so.1...done.
Loaded symbols for /usr/lib/libaio.so.1
Reading symbols from /usr/lib/libmd5.so.1...done.
Loaded symbols for /usr/lib/libmd5.so.1
Reading symbols from /usr/lib/libmp.so.2...done.
Loaded symbols for /usr/lib/libmp.so.2
Reading symbols from
/usr/platform/SUNW,Sun-Fire-V440/lib/libc_psr.so.1...done.
Loaded symbols for /usr/platform/SUNW,Sun-Fire-V440/lib/libc_psr.so.1
#0  0x7f9204f8 in __tbl_10_big_digits () from /usr/lib/libc.so.1

Re: BUG #2728: Core dump while pgdump DB

From
Tom Lane
Date:
"Yee" <christ1783@yahoo.com> writes:
> Core was generated by `/gen/tools/pgsql/bin/postmaster -i -S -D
> /gen/tools/pgsql/data'.
> Program terminated with signal 6, Aborted.

We need to see the backtrace (gdb "bt" command) from this.  Also,
did you look in the postmaster log?  Signal 6 probably means that
an Assert() test failed, in which case something would have been
printed in the log before aborting.

            regards, tom lane