[postgis-tickets] [PostGIS] #2982: Crashing on PostgreSQL9.5 dev on topology

Tue Nov 4 14:37:52 PST 2014

#2982: Crashing on PostgreSQL9.5 dev on topology
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  strk         
     Type:  defect          |      Status:  new          
 Priority:  blocker         |   Milestone:  PostGIS 2.2.0
Component:  topology        |     Version:  trunk        
 Keywords:  postgresql 9.5  |  
----------------------------+-----------------------------------------------

Comment(by robe):

 Okay I did a back trace of it and this is what it looks like

 {{{

 Program received signal SIGSEGV, Segmentation fault.
 [Switching to Thread 5568.0x15c4]
 0x000000000054fbc9 in AfterTriggerPendingOnRel (relid=17984) at
 trigger.c:4781
 4781                    for_each_event_chunk(event, chunk,
 afterTriggers.query_stack[depth])
 (gdb) bt
 #0  0x000000000054fbc9 in AfterTriggerPendingOnRel (relid=17984) at
 trigger.c:4781
 #1  0x000000000053e05c in CheckTableNotInUse (rel=0xe650dc0, stmt=0x8ab69a
 <__func__.77621+8091> "ALTER TABLE") at tablecmds.c:2652
 #2  0x0000000000545315 in AlterTable (relid=relid at entry=17984,
 lockmode=lockmode at entry=8, stmt=0xe32b580) at tablecmds.c:2724
 #3  0x00000000006701ec in ProcessUtilitySlow (parsetree=0x256e290,
 queryString=0x256e0e8 " r2\016", context=<optimized out>,
 params=0xe32ae20, completionTag=0x256e290 "", dest=<optimize
 #4  0x000000000066ee43 in standard_ProcessUtility (parsetree=0xe32ae20,
 queryString=0xdab7ec8 "ALTER TABLE tt.bigareas ADD COLUMN tg
 topology.TopoGeometry;", context=<optimized out>, pa
 #5  0x000000000058ba46 in _SPI_execute_plan (plan=plan at entry=0x256e360,
 paramLI=paramLI at entry=0x0, snapshot=snapshot at entry=0x0,
 crosscheck_snapshot=crosscheck_snapshot at entry=0x0, read_o
 #6  0x000000000058c035 in SPI_execute (src=src at entry=0xdab7ec8 "ALTER
 TABLE tt.bigareas ADD COLUMN tg topology.TopoGeometry;",
 read_only=<optimized out>, tcount=tcount at entry=0) at spi.c
 #7  0x000000006ab50cf7 in exec_stmt_dynexecute (stmt=0xd974418,
 estate=0x256e730) at pl_exec.c:3521
 #8  exec_stmt (stmt=0xd974418, estate=0x256e730) at pl_exec.c:1473
 #9  exec_stmts (estate=0x256e730, stmts=<optimized out>) at pl_exec.c:1368
 #10 0x000000006ab52151 in exec_stmt_block (estate=0x0,
 estate at entry=0x256e730, block=0xd9e42d0) at pl_exec.c:1306
 #11 0x000000006ab523cd in plpgsql_exec_function (func=0xd9ca430,
 func at entry=0xd9bc740, fcinfo=0xd9bc740, fcinfo at entry=0x256e988,
 simple_eval_estate=simple_eval_estate at entry=0x0) at pl_e
 #12 0x000000006ab473bb in plpgsql_call_handler (fcinfo=0x256e988) at
 pl_handler.c:243
 #13 0x0000000000567ddb in ExecMakeFunctionResultNoSets (fcache=0xd9bc6d0,
 econtext=0xd9bc4d0, isNull=0xd988371 "\177~\177\177\177\177\177\210o+\r",
 isDone=<optimized out>) at execQual.c
 #14 0x000000000056dd80 in ExecTargetList (isDone=0x256eafc,
 itemIsDone=0xd9884e8, isnull=0xd988370 "", values=0xd988348,
 econtext=0xd9bc4d0, targetlist=0xd988488) at execQual.c:5265
 #15 ExecProject (projInfo=projInfo at entry=0xd988390,
 isDone=isDone at entry=0x256eafc) at execQual.c:5480
 #16 0x000000000056e1d0 in ExecScan (node=node at entry=0xd9bc3b8,
 accessMtd=accessMtd at entry=0x5815c0 <SeqNext>,
 recheckMtd=recheckMtd at entry=0x5815b0 <SeqRecheck>) at execScan.c:207
 #17 0x0000000000581633 in ExecSeqScan (node=node at entry=0xd9bc3b8) at
 nodeSeqscan.c:116
 #18 0x0000000000566d38 in ExecProcNode (node=node at entry=0xd9bc3b8) at
 execProcnode.c:400
 #19 0x000000000057e68d in ExecModifyTable (node=node at entry=0xd9bc260) at
 nodeModifyTable.c:926
 #20 0x0000000000566d78 in ExecProcNode (node=node at entry=0xd9bc260) at
 execProcnode.c:377
 #21 0x0000000000563c8e in ExecutePlan (dest=0xda608a0,
 direction=<optimized out>, numberTuples=0, sendTuples=0 '\000',
 operation=CMD_INSERT, planstate=0xd9bc260, estate=0xd9bc078) at ex
 #22 standard_ExecutorRun (queryDesc=0xe3e4e38, direction=<optimized out>,
 count=0) at execMain.c:308
 #23 0x000000000066c67c in ProcessQuery (plan=<optimized out>,
 sourceText=0x18fb00 "INSERT INTO _test_layers SELECT 2,\n
 AddTopoGeometryColumn('tt', 'tt', 'bigareas', 'tg', 'polygon', l
     params=0x0, dest=0xda608a0, completionTag=0x256f230 "") at
 pquery.c:185
 #24 0x000000000066c908 in PortalRunMulti (portal=portal at entry=0xd876b48,
 isTopLevel=isTopLevel at entry=0 '\000', dest=0xda608a0, dest at entry=0x0,
 altdest=0xda608a0, altdest at entry=0x75aed7
 #25 0x000000000066d53c in PortalRun (portal=0x256eeb0,
 portal at entry=0xd876b48, count=39252592, count at entry=2147483647,
 isTopLevel=isTopLevel at entry=0 '\000', dest=0x0, dest at entry=0xda608
     completionTag at entry=0x400000000c7 <Address 0x400000000c7 out of
 bounds>) at pquery.c:816
 #26 0x000000000066af76 in exec_simple_query (query_string=0x7fefef23fc0
 <msvcrt!__iob_func> "H\215\005\271ê\a") at postgres.c:1045
 #27 PostgresMain (argc=<optimized out>, argv=argv at entry=0xc80d8,
 dbname=0x8000700060017 <Address 0x8000700060017 out of bounds>,
 username=<optimized out>) at postgres.c:4010
 #28 0x000000000060e363 in BackendRun (port=0x256f420) at postmaster.c:4118
 #29 SubPostmasterMain (argc=argc at entry=3, argv=argv at entry=0x137e00) at
 postmaster.c:4622
 #30 0x000000000079aab0 in main (argc=3, argv=0x137e00) at main.c:197
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2982#comment:7>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.