On 14-02-2018 3:43, Peter Eisentraut wrote:
On 2/13/18 05:40, Marina Polyakova wrote:
Binary search has shown that this failure begins with commit
8561e4840c81f7e345be2df170839846814fa004 (Transaction control in PL
procedures.). On the previous commit
(b9ff79b8f17697f3df492017d454caa9920a7183) there's no
plpython_transaction test and plpython check passes.


OK, can you get some kind of stack trace or other debugging information?

I got this backtrace from gdb:

Program received signal SIGSEGV, Segmentation fault.
0xffffffff7d13bb50 in strlen () from /lib/64/libc.so.1
(gdb) bt
#0  0xffffffff7d13bb50 in strlen () from /lib/64/libc.so.1
#1  0xffffffff7d1aabf8 in _ndoprnt () from /lib/64/libc.so.1
#2  0xffffffff7d1ad3d4 in vsnprintf () from /lib/64/libc.so.1
#3  0x00000001009ab174 in pvsnprintf (
buf=0x100d680e3 "PL/Python function \"", '\177' <repeats 180 times>..., len=933, fmt=0x100d684a0 "PL/Python function \"%s\"", args=0xffffffff7fff77f8) at psprintf.c:121
#4  0x0000000100492bd0 in appendStringInfoVA (str=0xffffffff7fff7738,
fmt=0x100d684a0 "PL/Python function \"%s\"", args=0xffffffff7fff77f8) at stringinfo.c:130 #5 0x0000000100911038 in errcontext_msg (fmt=0xffffffff7aa1eb98 "PL/Python function \"%s\"")
    at elog.c:1021
#6 0xffffffff7aa11ea8 in plpython_error_callback (arg=0x100e7d7e8) at plpy_main.c:402
#7  0x000000010090e9f8 in errfinish (dummy=0) at elog.c:438
#8  0x0000000100482e78 in SPI_commit () at spi.c:211
#9 0xffffffff7aa13e90 in PLy_commit (self=0x0, args=0x0) at plpy_plpymodule.c:602 #10 0xffffffff71a1ca40 in PyEval_EvalFrameEx (f=0xffffffff70619548, throwflag=2147449896)
    at Python/ceval.c:4004
#11 0xffffffff71a1d8a0 in PyEval_EvalFrameEx (f=0xffffffff706193a0, throwflag=2147450456)
    at Python/ceval.c:4106
#12 0xffffffff71a1ed20 in PyEval_EvalCodeEx (co=0xffffffff7060e6b0, globals=0xffffffff705236b4, locals=0xffffffff71bf9940 <_PyThreadState_Current>, args=0x0, argcount=0, kws=0x0, kwcount=0,
    defs=0x0, defcount=0, closure=0x0) at Python/ceval.c:3252
#13 0xffffffff71a1ef64 in PyEval_EvalCode (co=0xffffffff7060e6b0, globals=0xffffffff70525c58,
    locals=0xffffffff70525c58) at Python/ceval.c:667
#14 0xffffffff7aa10938 in PLy_procedure_call (proc=0xffffffff7fff8580,
kargs=0xffffffff7aa1e128 "args", vargs=0xffffffff7060d290) at plpy_exec.c:1031 #15 0xffffffff7aa0cf08 in PLy_exec_function (fcinfo=0xffffffff7fff86f0, proc=0xffffffff7fff8580)
    at plpy_exec.c:107
#16 0xffffffff7aa11c64 in plpython_inline_handler (fcinfo=0xffffffff7fff8be0) at plpy_main.c:353 #17 0x000000010091e44c in OidFunctionCall1Coll (functionId=16385, collation=0, arg1=4311287992)
    at fmgr.c:1327
#18 0x00000001003746ec in ExecuteDoStmt (stmt=0x100f8fa70, atomic=1 '\001') at functioncmds.c:2183
#19 0x00000001006f420c in standard_ProcessUtility (pstmt=0x100f90768,
queryString=0xffffffff70528054 "DO LANGUAGE plpythonu $x$ plpy.commit() $x$", context=PROCESS_UTILITY_QUERY, params=0x0, queryEnv=0x0, dest=0x100cd6708 <spi_printtupDR>,
    completionTag=0xffffffff7fff93f8 "") at utility.c:533
#20 0x00000001006f3b04 in ProcessUtility (pstmt=0x100f90768,
queryString=0xffffffff70528054 "DO LANGUAGE plpythonu $x$ plpy.commit() $x$", context=PROCESS_UTILITY_QUERY, params=0x0, queryEnv=0x0, dest=0x100cd6708 <spi_printtupDR>,
    completionTag=0xffffffff7fff93f8 "") at utility.c:358
#21 0x00000001004886e0 in _SPI_execute_plan (plan=0xffffffff7fff95b0, paramLI=0x0, snapshot=0x0, crosscheck_snapshot=0x0, read_only=0 '\000', fire_triggers=1 '\001', tcount=0) at spi.c:2207
#22 0x0000000100483980 in SPI_execute (
src=0xffffffff70528054 "DO LANGUAGE plpythonu $x$ plpy.commit() $x$", read_only=0 '\000',
    tcount=0) at spi.c:416
#23 0xffffffff7aa17698 in PLy_spi_execute_query (
query=0xffffffff70528054 "DO LANGUAGE plpythonu $x$ plpy.commit() $x$", limit=0)
    at plpy_spi.c:331
#24 0xffffffff7aa16c3c in PLy_spi_execute (self=0x0, args=0xffffffff7051fb50) at plpy_spi.c:168 #25 0xffffffff719af824 in PyCFunction_Call (func=0xffffffff7062a098, arg=0xffffffff7051fb50, kw=0x0)
    at Objects/methodobject.c:116
#26 0xffffffff71a1cfb0 in PyEval_EvalFrameEx (f=0xffffffff7af29c20, throwflag=2147457704)
    at Python/ceval.c:4020
#27 0xffffffff71a1d8a0 in PyEval_EvalFrameEx (f=0xffffffff706191f8, throwflag=2147458264)
    at Python/ceval.c:4106
#28 0xffffffff71a1ed20 in PyEval_EvalCodeEx (co=0xffffffff7072cf30, globals=0xffffffff70523624, locals=0xffffffff71bf9940 <_PyThreadState_Current>, args=0x0, argcount=0, kws=0x0, kwcount=0,
    defs=0x0, defcount=0, closure=0x0) at Python/ceval.c:3252
#29 0xffffffff71a1ef64 in PyEval_EvalCode (co=0xffffffff7072cf30, globals=0xffffffff70525910,
    locals=0xffffffff70525910) at Python/ceval.c:667
---Type <return> to continue, or q <return> to quit---
#30 0xffffffff7aa10938 in PLy_procedure_call (proc=0x100f91278, kargs=0xffffffff7aa1e128 "args",
    vargs=0xffffffff7060d0e0) at plpy_exec.c:1031
#31 0xffffffff7aa0cf08 in PLy_exec_function (fcinfo=0x100e7d8d0, proc=0x100f91278)
    at plpy_exec.c:107
#32 0xffffffff7aa11710 in plpython_call_handler (fcinfo=0x100e7d8d0) at plpy_main.c:271 #33 0x0000000100414ad4 in ExecInterpExpr (state=0x100e7d7e8, econtext=0x100e7d498,
    isnull=0xffffffff7fffa987 "\350") at execExprInterp.c:652
#34 0x0000000100416d78 in ExecInterpExprStillValid (state=0x100e7d7e8, econtext=0x100e7d498,
    isNull=0xffffffff7fffa987 "\350") at execExprInterp.c:1789
#35 0x000000010046c244 in ExecEvalExprSwitchContext (state=0x100e7d7e8, econtext=0x100e7d498, isNull=0xffffffff7fffa987 "\350") at ../../../src/include/executor/executor.h:307
#36 0x000000010046c2b4 in ExecProject (projInfo=0x100e7d7e0)
    at ../../../src/include/executor/executor.h:341
#37 0x000000010046c580 in ExecResult (pstate=0x100e7d380) at nodeResult.c:136 #38 0x000000010042efa8 in ExecProcNodeFirst (node=0x100e7d380) at execProcnode.c:446
#39 0x0000000100421e74 in ExecProcNode (node=0x100e7d380)
    at ../../../src/include/executor/executor.h:246
#40 0x0000000100425e0c in ExecutePlan (estate=0x100e7d168, planstate=0x100e7d380, use_parallel_mode=0 '\000', operation=CMD_SELECT, sendTuples=1 '\001', numberTuples=0, direction=ForwardScanDirection, dest=0x100d905b0, execute_once=1 '\001') at execMain.c:1721
#41 0x0000000100422800 in standard_ExecutorRun (queryDesc=0x100d8ee48,
direction=ForwardScanDirection, count=0, execute_once=1 '\001') at execMain.c:361 #42 0x00000001004224e8 in ExecutorRun (queryDesc=0x100d8ee48, direction=ForwardScanDirection,
    count=0, execute_once=1 '\001') at execMain.c:304
#43 0x00000001006f14d0 in PortalRunSelect (portal=0x100dcf218, forward=1 '\001', count=0,
    dest=0x100d905b0) at pquery.c:932
#44 0x00000001006f0f54 in PortalRun (portal=0x100dcf218, count=9223372036854775807, isTopLevel=1 '\001', run_once=1 '\001', dest=0x100d905b0, altdest=0x100d905b0,
    completionTag=0xffffffff7fffb198 "") at pquery.c:773
#45 0x00000001006e5f78 in exec_simple_query (query_string=0x100d6a628 "SELECT transaction_test4();")
    at postgres.c:1120
#46 0x00000001006ee044 in PostgresMain (argc=1, argv=0x100d95750, dbname=0x100d95728 "postgres",
    username=0x100d95700 "buildfarm") at postgres.c:4144
#47 0x00000001005e4398 in BackendRun (port=0x100d8bbe0) at postmaster.c:4412 #48 0x00000001005e3504 in BackendStartup (port=0x100d8bbe0) at postmaster.c:4084
#49 0x00000001005dbbfc in ServerLoop () at postmaster.c:1757
#50 0x00000001005da99c in PostmasterMain (argc=5, argv=0x100d63ea0) at postmaster.c:1365
#51 0x00000001004b9c4c in main (argc=5, argv=0x100d63ea0) at main.c:228
(gdb)

--
Marina Polyakova
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Reply via email to