Re: assessing parallel-safety - Mailing list pgsql-hackers

<div dir="ltr">On 20 March 2015 at 15:25, Robert Haas <<a
href="mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>>wrote:<br />> On Fri, Mar 20, 2015 at 11:08 AM,
ThomBrown <<a href="mailto:thom@linux.com">thom@linux.com</a>> wrote:<br />>> On 20 March 2015 at 15:02,
RobertHaas <<a href="mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>> wrote:<br />>>> On Fri,
Mar20, 2015 at 10:24 AM, Thom Brown <<a href="mailto:thom@linux.com">thom@linux.com</a>> wrote:<br
/>>>>>2015-03-20 14:19:31 GMT [4273]: [78-1] user=,db=,client= DEBUG:<br />>>>> server process
(PID4285) was terminated by signal 11: Segmentation<br />>>>> fault<br />>>><br />>>> Any
chanceyou can get us a stack backtrace of this crash?<br />>><br />>> (gdb) cont<br />>>
Continuing.<br/>>><br />>> Program received signal SIGSEGV, Segmentation fault.<br />>>
0x0000000000770843in pfree ()<br />>> (gdb) bt<br />>> #0  0x0000000000770843 in pfree ()<br />>> #1
 0x00000000005a382fin ExecEndFunnel ()<br />>> #2  0x000000000059fe75 in ExecEndAppend ()<br />>> #3
 0x00000000005920bdin standard_ExecutorEnd ()<br />>> #4  0x000000000055004b in ExplainOnePlan ()<br />>>
#5 0x000000000055025d in ExplainOneQuery ()<br />>> #6  0x000000000055064d in ExplainQuery ()<br />>> #7
 0x0000000000680db1in standard_ProcessUtility ()<br />>> #8  0x000000000067e1c1 in PortalRunUtility ()<br
/>>>#9  0x000000000067ef1d in FillPortalStore ()<br />>> #10 0x000000000067f8eb in PortalRun ()<br
/>>>#11 0x000000000067d628 in PostgresMain ()<br />>> #12 0x0000000000462c5e in ServerLoop ()<br />>>
#130x000000000062e363 in PostmasterMain ()<br />>> #14 0x00000000004636ad in main ()<br />><br />> OK,
thanks. That looks like it's probably the fault of parallel seq<br />> scan patch rather than this one.  It would
helpif you could build<br />> with debug symbols so that we can see line numbers and arguments.<br /><br />Sure.<br
/><br/>Program received signal SIGABRT, Aborted.<br />0x00007f5a49fce1d5 in raise () from
/lib/x86_64-linux-gnu/libc.so.6<br/>(gdb) bt<br />#0  0x00007f5a49fce1d5 in raise () from
/lib/x86_64-linux-gnu/libc.so.6<br/>#1  0x00007f5a49fd1388 in abort () from /lib/x86_64-linux-gnu/libc.so.6<br />#2
 0x00000000007a053ain ExceptionalCondition (conditionName=conditionName@entry=0x813a4b "!(IsInParallelMode())",
errorType=errorType@entry=0x7da1d6"FailedAssertion", fileName=fileName@entry=0x81397d "parallel.c",
lineNumber=lineNumber@entry=123)at assert.c:54<br />#3  0x00000000004cd5ba in CreateParallelContext
(entrypoint=entrypoint@entry=0x659d2c<ParallelQueryMain>, nworkers=nworkers@entry=8) at parallel.c:123<br />#4
 0x000000000065a1c0in InitializeParallelWorkers (plan=0x281e6a0, estate=estate@entry=0x28b99a8,
rel=rel@entry=0x7f594eab2370,inst_options_space=inst_options_space@entry=0x28bbfa8,
buffer_usage_space=buffer_usage_space@entry=0x28bbfb0,responseqp=responseqp@entry=0x28bbf98,
pcxtp=pcxtp@entry=0x28bbf90,nWorkers=8) at backendworker.c:279<br />#5  0x00000000005d0e75 in InitFunnel
(node=node@entry=0x28bbf00,estate=estate@entry=0x28b99a8, eflags=eflags@entry=17) at nodeFunnel.c:61<br />#6
 0x00000000005d1026in ExecInitFunnel (node=0x281e738, estate=0x28b99a8, eflags=17) at nodeFunnel.c:121<br />#7
 0x00000000005c0f95in ExecInitNode (node=0x281e738, estate=estate@entry=0x28b99a8, eflags=eflags@entry=17) at
execProcnode.c:201<br/>#8  0x00000000005cd316 in ExecInitAppend (node=<optimized out>, estate=0x28b99a8,
eflags=17)at nodeAppend.c:168<br />#9  0x00000000005c0f25 in ExecInitNode (node=0x288b990,
estate=estate@entry=0x28b99a8,eflags=eflags@entry=17) at execProcnode.c:163<br />#10 0x00000000005ce849 in ExecInitAgg
(node=0x288ba28,estate=0x28b99a8, eflags=17) at nodeAgg.c:1580<br />#11 0x00000000005c10bf in ExecInitNode
(node=node@entry=0x288ba28,estate=estate@entry=0x28b99a8, eflags=eflags@entry=17) at execProcnode.c:302<br />#12
0x00000000005bfb35in InitPlan (queryDesc=queryDesc@entry=0x28b5868, eflags=eflags@entry=17) at execMain.c:939<br />#13
0x00000000005bfd49in standard_ExecutorStart (queryDesc=0x28b5868, eflags=17) at execMain.c:234<br />#14
0x00000000005bfd95in ExecutorStart (queryDesc=queryDesc@entry=0x28b5868, eflags=eflags@entry=1) at execMain.c:134<br
/>#150x0000000000573f21 in ExplainOnePlan (plannedstmt=plannedstmt@entry=0x28b7878, into=into@entry=0x0,
es=es@entry=0x24cde68,queryString=queryString@entry=0x248a398 "EXPLAIN SELECT DISTINCT bid FROM pgbench_accounts;",
params=params@entry=0x0,planduration=planduration@entry=0x7fffb64f4bf0) at explain.c:478<br />#16 0x0000000000574160 in
ExplainOneQuery(query=<optimized out>, into=into@entry=0x0, es=es@entry=0x24cde68,
queryString=queryString@entry=0x248a398"EXPLAIN SELECT DISTINCT bid FROM pgbench_accounts;", params=params@entry=0x0)
atexplain.c:346<br />#17 0x000000000057478a in ExplainQuery (stmt=stmt@entry=0x248b1b0,
queryString=queryString@entry=0x248a398"EXPLAIN SELECT DISTINCT bid FROM pgbench_accounts;", params=params@entry=0x0,
dest=dest@entry=0x24cddd0)at explain.c:234<br />#18 0x00000000006c6419 in standard_ProcessUtility (parsetree=0x248b1b0,
queryString=0x248a398"EXPLAIN SELECT DISTINCT bid FROM pgbench_accounts;", context=PROCESS_UTILITY_TOPLEVEL,
params=0x0,dest=0x24cddd0, completionTag=0x7fffb64f4d90 "") at utility.c:657<br />#19 0x00000000006c6808 in
ProcessUtility(parsetree=parsetree@entry=0x248b1b0, queryString=<optimized out>,
context=context@entry=PROCESS_UTILITY_TOPLEVEL,params=<optimized out>, dest=dest@entry=0x24cddd0,
completionTag=completionTag@entry=0x7fffb64f4d90"") at utility.c:333<br />#20 0x00000000006c3272 in PortalRunUtility
(portal=portal@entry=0x24f2e28,utilityStmt=0x248b1b0, isTopLevel=<optimized out>, dest=dest@entry=0x24cddd0,
completionTag=completionTag@entry=0x7fffb64f4d90"") at pquery.c:1188<br />#21 0x00000000006c4039 in FillPortalStore
(portal=portal@entry=0x24f2e28,isTopLevel=isTopLevel@entry=1 '\001') at pquery.c:1062<br />#22 0x00000000006c4a12 in
PortalRun(portal=portal@entry=0x24f2e28, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001',
dest=dest@entry=0x248b5e8,altdest=altdest@entry=0x248b5e8, completionTag=completionTag@entry=0x7fffb64f4fa0 "") at
pquery.c:786<br/>#23 0x00000000006c12c3 in exec_simple_query (query_string=query_string@entry=0x248a398 "EXPLAIN SELECT
DISTINCTbid FROM pgbench_accounts;") at postgres.c:1107<br />#24 0x00000000006c2de4 in PostgresMain (argc=<optimized
out>,argv=argv@entry=0x2421c28, dbname=0x2421a90 "pgbench", username=<optimized out>) at postgres.c:4118<br
/>#250x0000000000665c55 in BackendRun (port=port@entry=0x2447540) at postmaster.c:4148<br />#26 0x00000000006675a8 in
BackendStartup(port=port@entry=0x2447540) at postmaster.c:3833<br />#27 0x000000000066784b in ServerLoop () at
postmaster.c:1601<br/>#28 0x000000000066898d in PostmasterMain (argc=argc@entry=1, argv=argv@entry=0x2420c90) at
postmaster.c:1248<br/>#29 0x00000000005f5a25 in main (argc=1, argv=0x2420c90) at main.c:221<br /><br /><br />-- <br
/>Thom</div>