Re: Troubleshooting cored dumps

On Fri, 19 Apr 2002, Vince Vielhaber wrote:

> On Fri, 19 Apr 2002, Francisco Reyes wrote:
>
> > How does one go about troubleshooting Core Dumps?
> > server sent data ("D" message) without prior row description ("T" message)
> > server sent data ("D" message) without prior row description ("T" message)
> > server sent data ("D" message) without prior row description ("T" message)
> > server sent data ("D" message) without prior row description ("T" message)
> > server sent data ("D" message) without prior row description ("T" message)
> > server sent data ("D" message) without prior row description ("T" message)
> > DEBUG:  pq_flush: send() failed: Broken pipe
> > Segmentation fault (core dumped)
>
> gdb /full/path/to/postmaster /full/path/to/corefile

Ignore the previous post. :-)
Left out the program.

It turns out that it was psql that crashed.

bestpal:~/sql>gdb /usr/local/bin/psql psql.core
no debugging symbols found)...
Core was generated by `psql'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /usr/local/lib/libpq.so.2...(no debugging symbols
found)...done.
Reading symbols from /usr/local/lib/libgnugetopt.so.1...(no debugging
symbols found)...done.
Reading symbols from /usr/lib/libssl.so.2...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libcrypto.so.2...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libz.so.2...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libcrypt.so.2...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libm.so.2...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libutil.so.3...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libreadline.so.4...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libc.so.4...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libncurses.so.5...(no debugging symbols
found)...done.
Reading symbols from /usr/libexec/ld-elf.so.1...(no debugging symbols
found)...done.
#0  0x28088fec in appendPQExpBufferStr () from /usr/local/lib/libpq.so.2
(gdb) where
#0  0x28088fec in appendPQExpBufferStr () from /usr/local/lib/libpq.so.2
#1  0x28084dfa in PQexec () from /usr/local/lib/libpq.so.2
#2  0x804d6e3 in PQclientEncoding ()
#3  0x804f09e in PQclientEncoding ()
#4  0x80504e8 in PQclientEncoding ()
#5  0x804a125 in PQclientEncoding ()