Re: Psql crashes with Segmentation fault on copy from - Mailing list pgsql-general

On 11:09 am 05/28/08 Tom Lane <tgl@sss.pgh.pa.us> wrote:

Re-send. Didn't do reply-all before.

> Well, it would be if it were right; but PQsendQuery doesn't call
> PQunescapeBytea, so there's something wrong with the debug info.
..
> >  compat-postgresql-libs-debuginfo-3-2PGDG.rhel4.x86_64.rpm

That was the wrong lib.
Installed
postgresql-debuginfo-8.2.7-1PGDG.rhel4.x86_64.rpm and got
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 182895355296 (LWP 5008)]
0x0000003cc31723e6 in memcpy () from /lib64/tls/libc.so.6
(gdb) bt
#0  0x0000003cc31723e6 in memcpy () from /lib64/tls/libc.so.6
#1  0x0000002a955820ae in pqPutMsgBytes (buf=0x2a9860a010, len=2147483647,
conn=0x560a80) at fe-misc.c:475
#2  0x0000002a95582230 in pqPuts (
    s=0x2a9860a010 "yjbjK8WKLRHKavptOqlPD4QeI24=\t200803\t2008-03-11\t0\t10.47\t08620667742MDF1\t\tMCDONALD'S
F7742\t5814\t1003\t1187954\nyjbjK8WKLRHKavptOqlPD4QeI24=\t200803\t2008-03-11\t0\t16.99\t00614111869AWG1\t\tPIGGLY
WIGGLY#52\t5411"...,
    conn=0x560a80) at fe-misc.c:151
#3  0x0000002a9558009e in PQsendQuery (conn=0x560a80,
    query=0x2a9860a010 "yjbjK8WKLRHKavptOqlPD4QeI24=\t200803\t2008-03-11\t0\t10.47\t08620667742MDF1\t\tMCDONALD'S
F7742\t5814\t1003\t1187954\nyjbjK8WKLRHKavptOqlPD4QeI24=\t200803\t2008-03-11\t0\t16.99\t00614111869AWG1\t\tPIGGLY
WIGGLY#52\t5411"...)
    at fe-exec.c:687
#4  0x0000002a95580788 in PQexec (conn=0x560a80,
    query=0x2a9860a010 "yjbjK8WKLRHKavptOqlPD4QeI24=\t200803\t2008-03-11\t0\t10.47\t08620667742MDF1\t\tMCDONALD'S
F7742\t5814\t1003\t1187954\nyjbjK8WKLRHKavptOqlPD4QeI24=\t200803\t2008-03-11\t0\t16.99\t00614111869AWG1\t\tPIGGLY
WIGGLY#52\t5411"...)
    at fe-exec.c:1288
#5  0x0000000000406e95 in SendQuery (
    query=0x2a9860a010 "yjbjK8WKLRHKavptOqlPD4QeI24=\t200803\t2008-03-11\t0\t10.47\t08620667742MDF1\t\tMCDONALD'S
F7742\t5814\t1003\t1187954\nyjbjK8WKLRHKavptOqlPD4QeI24=\t200803\t2008-03-11\t0\t16.99\t00614111869AWG1\t\tPIGGLY
WIGGLY#52\t5411"...)
    at common.c:878
#6  0x0000000000409dfa in MainLoop (source=0x5414f0) at mainloop.c:340
#7  0x000000000040408d in process_file (filename=0x541d70
"data/usb_t_60M.sql", single_txn=0 '\0') at command.c:1394
#8  0x00000000004057cd in exec_command (cmd=0x541bc0 "i",
scan_state=0x549b30, query_buf=0x549890) at command.c:546
#9  0x0000000000406286 in HandleSlashCmds (scan_state=0x549b30,
query_buf=0x549890) at command.c:92
#10 0x0000000000409f66 in MainLoop (source=0x541070) at mainloop.c:259
#11 0x000000000040408d in process_file (filename=0x560750
"bench-index-after.sql", single_txn=0 '\0') at command.c:1394
#12 0x00000000004057cd in exec_command (
    cmd=0x569360 "Hxnh9aOwMviVVP9I=\t200803\t2008-03-10\t0\t15.54\t434240509886\t\tNU-YALE CLEANERS
(BARD\t4225\t0\t11636644\n3MM9gwBGMHiyPGmUrqIEOOha1Ao=\t200803\t2008-03-11\t0\t739.95\t554172100100007\t\tUSAAP&C
PREMIUM\t6300\t0\t183718"...,
    scan_state=0x549c20, query_buf=0x54a480) at command.c:546
#13 0x0000000000406286 in HandleSlashCmds (scan_state=0x549c20,
query_buf=0x54a480) at command.c:92
#14 0x0000000000409f66 in MainLoop (source=0x3cc332fb00) at mainloop.c:259
#15 0x000000000040c687 in main (argc=80207, argv=0x0) at startup.c:367
#16 0x0000003cc311c3fb in __libc_start_main () from /lib64/tls/libc.so.6
#17 0x0000000000403d2a in _start ()
#18 0x0000007fbffff558 in ?? ()
#19 0x000000000000001c in ?? ()
#20 0x0000000000000001 in ?? ()
#21 0x0000007fbffff795 in ?? ()
#22 0x0000000000000000 in ?? ()