Re: unable to dump database, toast errors

On Thu, 3 Apr 2003, Tom Lane wrote:
> Lonni Friedman <lfriedman(at)vasoftware(dot)com> writes:
> > ok, i got psql to dump core (30M in size). What do I need to do to
> > generate a stack trace?
>
> $ gdb /path/to/psql core
> gdb> bt
> gdb> quit
>
> If you just get numbers then you need to rebuild with debug symbols
> enabled (configure --enable-debug) and try again.

this looks interesting....

# gdb /usr/bin/psql core
GNU gdb Red Hat Linux 7.x (5.0rh-15) (MI_OUT)
This GDB was configured as "i386-redhat-linux"...
Core was generated by `psql sfee'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /usr/lib/libpq.so.2...done.
Loaded symbols for /usr/lib/libpq.so.2
Reading symbols from /lib/libpam.so.0...done.
Reading symbols from /lib/libssl.so.2...done.
Loaded symbols for /lib/libssl.so.2
Reading symbols from /lib/libcrypto.so.2...done.
Loaded symbols for /lib/libcrypto.so.2
Reading symbols from /usr/kerberos/lib/libkrb5.so.3...done.
Loaded symbols for /usr/kerberos/lib/libkrb5.so.3
Reading symbols from /usr/kerberos/lib/libk5crypto.so.3...done.
Loaded symbols for /usr/kerberos/lib/libk5crypto.so.3
Reading symbols from /usr/kerberos/lib/libcom_err.so.3...done.
Loaded symbols for /usr/kerberos/lib/libcom_err.so.3
Reading symbols from /usr/lib/libz.so.1...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/libresolv.so.2...done.
Loaded symbols for /lib/libresolv.so.2
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/libdl.so.2...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/i686/libm.so.6...done.
Loaded symbols for /lib/i686/libm.so.6
Reading symbols from /usr/lib/libreadline.so.4...done.
Loaded symbols for /usr/lib/libreadline.so.4
Reading symbols from /lib/libtermcap.so.2...done.
Loaded symbols for /lib/libtermcap.so.2
Reading symbols from /lib/i686/libc.so.6...done.
Loaded symbols for /lib/i686/libc.so.6
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
Reading symbols from /lib/libnss_compat.so.2...done.
Loaded symbols for /lib/libnss_compat.so.2
#0 0x402a1771 in _IO_vfprintf (s=0x4037e180, format=0x8060979
"%-*s%s%-*s", ap=0xbffff90c) at vfprintf.c:1524
1524 vfprintf.c: No such file or directory. in vfprintf.c
(gdb) bt
#0 0x402a1771 in _IO_vfprintf (s=0x4037e180, format=0x8060979
"%-*s%s%-*s", ap=0xbffff90c) at vfprintf.c:1524
#1 0x402a9ce7 in fprintf (stream=0x4037e180, format=0x8060979
"%-*s%s%-*s") at fprintf.c:32
#2 0x08053464 in print_aligned_text () at eval.c:41
#3 0x080549f0 in printTable () at eval.c:41
#4 0x08054dc7 in printQuery () at eval.c:41
#5 0x0804e089 in SendQuery () at eval.c:41
#6 0x0804fd3f in MainLoop () at eval.c:41
#7 0x08051226 in main () at eval.c:41
#8 0x40266507 in __libc_start_main (main=0x8050b20 <main>, argc=2,
ubp_av=0xbffffba4, init=0x8049d70 <_init>, fini=0x8059c80 <_fini>,
rtld_fini=0x4000dc14 <_dl_fini>, stack_end=0xbffffb9c) at
../sysdeps/generic/libc-start.c:129

I hope tha this means significantly more to you, than it does to me.
Not sure if it matters, but this server is running the (semi) official
RPMs from postgresql.org:
postgresql-7.2.1-2PGDG