[Postgres-xc-bugs] Postgresql-XC Segmentation fault when add new coordinator

[Julian <jul...@gm...>]

Hi,  

When i try to add new coordinator to my cluster but failed, and generate a segmentation fault.

then i try to using gdb to trace it and here is the result.

(gdb) p
$38 = 0x2ac8650 "SET default_with_oids = false;"
(gdb) c
Continuing.

Breakpoint 2, PostgresMain (argc=1, argv=0x2ab14f8, dbname=0x2ab13a8 "pgxc", username=0x2ab1390 "pgxc") at postgres.c:4198
4198                                            SetCurrentStatementStartTimestamp();
(gdb) p
$39 = 0x2ac8650 "CREATE TABLE user_info_hash (\n    id integer NOT NULL,\n    firstname text,\n    lastname text,\n    info text\n)\nDISTRIBUTE BY HASH (id)\nTO NODE (datanode1,datanode2,datanode3);"
(gdb) n
4200                                            query_string = pq_getmsgstring(&input_message);
(gdb)  
4201                                            pq_getmsgend(&input_message);
(gdb)  
4203                                            exec_simple_query(query_string);
(gdb)  

Program received signal SIGSEGV, Segmentation fault.
0x000000000087fa40 in AllocSetAlloc (context=0x2bc5d48, size=280) at aset.c:639
639                     set->freelist[fidx] = (AllocChunk) chunk->aset;
(gdb) bt
#0  0x000000000087fa40 in AllocSetAlloc (context=0x2bc5d48, size=280) at aset.c:639
#1  0x00000000008808fa in MemoryContextAlloc (context=0x2bc5d48, size=280) at mcxt.c:580
#2  0x0000000000472344 in CreateTemplateTupleDesc (natts=2, hasoid=0 '\000') at tupdesc.c:65
#3  0x0000000000505243 in ConstructTupleDescriptor (heapRelation=0x7ffcaa266690, indexInfo=0x2bded68, indexColNames=0x2bdbb48, accessMethodObjectId=403,  
    collationObjectId=0x7fff49a3d9a0, classObjectId=0x7fff49a3d990) at index.c:298
#4  0x0000000000506069 in index_create (heapRelation=0x7ffcaa266690, indexRelationName=0x7fff49a3d9b0 "pg_toast_24590_index", indexRelationId=0, relFileNode=0,  
    indexInfo=0x2bded68, indexColNames=0x2bdbb48, accessMethodObjectId=403, tableSpaceId=0, collationObjectId=0x7fff49a3d9a0, classObjectId=0x7fff49a3d990,  
    coloptions=0x7fff49a3d980, reloptions=0, isprimary=1 '\001', isconstraint=0 '\000', deferrable=0 '\000', initdeferred=0 '\000', allow_system_table_mods=1 '\001',  
    skip_build=0 '\000', concurrent=0 '\000') at index.c:777
#5  0x000000000052afbc in create_toast_table (rel=0x7ffcaa1c8bf8, toastOid=0, toastIndexOid=0, reloptions=0) at toasting.c:277
#6  0x000000000052a993 in AlterTableCreateToastTable (relOid=24590, reloptions=0) at toasting.c:70
#7  0x00000000007549fd in standard_ProcessUtility (parsetree=0x2ac9b70,  
    queryString=0x2ac8650 "CREATE TABLE user_info_hash (\n    id integer NOT NULL,\n    firstname text,\n    lastname text,\n    info text\n)\nDISTRIBUTE BY HASH (id)\nTO NODE (datanode1,datanode2,datanode3);", params=0x0, isTopLevel=1 '\001', dest=0x2ac9f10, sentToRemote=0 '\000', completionTag=0x7fff49a3e110 "") at utility.c:746
#8  0x0000000000754064 in ProcessUtility (parsetree=0x2ac9b70,  
    queryString=0x2ac8650 "CREATE TABLE user_info_hash (\n    id integer NOT NULL,\n    firstname text,\n    lastname text,\n    info text\n)\nDISTRIBUTE BY HASH (id)\nTO NODE (datanode1,datanode2,datanode3);", params=0x0, isTopLevel=1 '\001', dest=0x2ac9f10, sentToRemote=0 '\000', completionTag=0x7fff49a3e110 "") at utility.c:377
#9  0x0000000000752ff1 in PortalRunUtility (portal=0x2bc8e50, utilityStmt=0x2ac9b70, isTopLevel=1 '\001', dest=0x2ac9f10, completionTag=0x7fff49a3e110 "")
    at pquery.c:1283
#10 0x000000000075321e in PortalRunMulti (portal=0x2bc8e50, isTopLevel=1 '\001', dest=0x2ac9f10, altdest=0x2ac9f10, completionTag=0x7fff49a3e110 "") at pquery.c:1430
#11 0x00000000007526c5 in PortalRun (portal=0x2bc8e50, count=9223372036854775807, isTopLevel=1 '\001', dest=0x2ac9f10, altdest=0x2ac9f10,  
    completionTag=0x7fff49a3e110 "") at pquery.c:880
#12 0x000000000074c244 in exec_simple_query (
    query_string=0x2ac8650 "CREATE TABLE user_info_hash (\n    id integer NOT NULL,\n    firstname text,\n    lastname text,\n    info text\n)\nDISTRIBUTE BY HASH (id)\nTO NODE (datanode1,datanode2,datanode3);") at postgres.c:1136
#13 0x0000000000750644 in PostgresMain (argc=1, argv=0x2ab14f8, dbname=0x2ab13a8 "pgxc", username=0x2ab1390 "pgxc") at postgres.c:4203
#14 0x00000000006fa60f in BackendRun (port=0x2ad2d80) at postmaster.c:3804
#15 0x00000000006f9d14 in BackendStartup (port=0x2ad2d80) at postmaster.c:3494
#16 0x00000000006f6ace in ServerLoop () at postmaster.c:1472
#17 0x00000000006f64d7 in PostmasterMain (argc=6, argv=0x2aaf2a0) at postmaster.c:1232
#18 0x000000000065f56a in main (argc=6, argv=0x2aaf2a0) at main.c:199


and caused by this sql statement  

CREATE TABLE user_info_hash (
    id integer NOT NULL,
    firstname text,
    lastname text,
    info text
)
DISTRIBUTE BY HASH (id)
TO NODE (datanode1,datanode2,datanode3);



Regards;

--  
Julian
使用 Sparrow (http://www.sparrowmailapp.com/?sig) 發信