Re: Problem using COPY command to load data

On 11/11/08 2:25 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> The most direct evidence about why it's stuck would probably be had by
> attaching to the backend process with gdb and getting a stack trace.

It wasn't built with debugging symbols so there is some missing info, but
here is what I get if I attach with gdb:

(gdb) where
#0 0xb7f63410 in __kernel_vsyscall ()
#1 0xb7ac9273 in read () from /lib/tls/i686/cmov/libc.so.6
#2 0xb7d42d37 in ?? () from /usr/lib/i686/cmov/libcrypto.so.0.9.8
#3 0x081a1226 in ?? ()
#4 0xb7d40db1 in BIO_read () from /usr/lib/i686/cmov/libcrypto.so.0.9.8
#5 0xb7e05362 in ssl3_read_n () from /usr/lib/i686/cmov/libssl.so.0.9.8
#6 0xb7e05b2e in ssl3_read_bytes () from /usr/lib/i686/cmov/libssl.so.0.9.8
#7 0xb7e03096 in ssl3_read () from /usr/lib/i686/cmov/libssl.so.0.9.8
#8 0xb7e13b78 in SSL_read () from /usr/lib/i686/cmov/libssl.so.0.9.8
#9 0x081a128a in secure_read ()
#10 0x081a94c1 in ?? ()
#11 0x081a95d9 in pq_getbytes ()
#12 0x081a9744 in pq_getmessage ()
#13 0x0813853c in ?? ()
#14 0x0813883a in ?? ()
#15 0x08138a05 in ?? ()
#16 0x0813b456 in DoCopy ()
#17 0x082302e4 in ProcessUtility ()
#18 0x0822cc6b in ?? ()
#19 0x0822d8e3 in ?? ()
#20 0x0822e104 in PortalRun ()
#21 0x08228eb5 in ?? ()
#22 0x08229f6b in PostgresMain ()
#23 0x081fa39d in ?? ()
#24 0x081fb3cb in PostmasterMain ()
#25 0x081ab902 in main ()

--
Glen L. Beane
Software Engineer
The Jackson Laboratory
Phone (207) 288-6153