From: xiong w. <wan...@gm...> - 2010-12-13 07:19:40
|
Hi Mason, Take a look at the following cases: postgres=# CREATE TABLE atest5 (one int, two int, three int); CREATE TABLE postgres=# INSERT INTO atest5 (two) VALUES (3); server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. postgres=# INSERT INTO atest5(three) VALUES (3); server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. Core was generated by `postgres: postgres postgres [local] INSERT '. Program terminated with signal 11, Segmentation fault. [New process 27754] #0 0x0000000000530bbf in CopySendString (cstate=0x5c82238, str=0x0) at copy.c:450 450 appendBinaryStringInfo(cstate->fe_msgbuf, str, strlen(str)); (gdb) bt #0 0x0000000000530bbf in CopySendString (cstate=0x5c82238, str=0x0) at copy.c:450 #1 0x000000000053407b in CopyOneRowTo (cstate=0x5c82238, tupleOid=0, values=0x5c82f68, nulls=0x5c82f98 "\001\001") at copy.c:1716 #2 0x0000000000538789 in DoInsertSelectCopy (estate=0x5c7da50, slot=0x5c81b88) at copy.c:4017 #3 0x000000000058b185 in ExecutePlan (estate=0x5c7da50, planstate=0x5c7f8e0, operation=CMD_INSERT, numberTuples=0, direction=ForwardScanDirection, dest=0x5c78860) at execMain.c:1698 #4 0x0000000000588f3c in standard_ExecutorRun (queryDesc=0x5c36330, direction=ForwardScanDirection, count=0) at execMain.c:312 #5 0x0000000000588e45 in ExecutorRun (queryDesc=0x5c36330, direction=ForwardScanDirection, count=0) at execMain.c:261 #6 0x000000000068f51a in ProcessQuery (plan=0x5c78780, sourceText=0x5c13ee0 "INSERT INTO atest5(three) VALUES (3);", params=0x0, dest=0x5c78860, completionTag=0x7fff6d345520 "") at pquery.c:205 #7 0x0000000000690c8b in PortalRunMulti (portal=0x5c79a30, isTopLevel=1 '\001', dest=0x5c78860, altdest=0x5c78860, completionTag=0x7fff6d345520 "") at pquery.c:1299 #8 0x000000000069036f in PortalRun (portal=0x5c79a30, count=9223372036854775807, isTopLevel=1 '\001', dest=0x5c78860, altdest=0x5c78860, completionTag=0x7fff6d345520 "") at pquery.c:843 #9 0x000000000068a64a in exec_simple_query (query_string=0x5c13ee0 "INSERT INTO atest5(three) VALUES (3);") at postgres.c:1054 #10 0x000000000068e5b8 in PostgresMain (argc=4, argv=0x5b69520, username=0x5b694e0 "postgres") at postgres.c:3767 #11 0x000000000065620a in BackendRun (port=0x5b8aba0) at postmaster.c:3607 #12 0x0000000000655767 in BackendStartup (port=0x5b8aba0) at postmaster.c:3216 #13 0x0000000000652b32 in ServerLoop () at postmaster.c:1445 #14 0x00000000006522d8 in PostmasterMain (argc=9, argv=0x5b668d0) at postmaster.c:1098 #15 0x00000000005d9c1f in main (argc=9, argv=0x5b668d0) at main.c:188 Regards, Benny |