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
|
