BUG #8214: SIGSEGV in PyEval_EvalFrameEx

The following bug has been logged on the website:

Bug reference: 8214
Logged by: Miron Cuperman
Email address: m+psql(at)tradehill(dot)com
PostgreSQL version: 9.2.4
Operating system: Debian 6.0 (squeeze)
Description:

This is an intermittent crash during a ~5 minute unit test run.

My intuition is that raising an uncaught exception in python tends to
trigger this, but I could be wrong.

Packages:

ii pgdg-keyring 2012.1 keyring
for apt.postgresql.org
ii postgresql-9.2 9.2.4-1.pgdg60+1
object-relational SQL database, version 9.2 server
ii postgresql-9.2-dbg 9.2.4-1.pgdg60+1 debug
symbols for postgresql-9.2
ii postgresql-client-9.2 9.2.4-1.pgdg60+1
front-end programs for PostgreSQL 9.2
ii postgresql-client-common 141.pgdg60+1 manager
for multiple PostgreSQL client versions
ii postgresql-common 141.pgdg60+1
PostgreSQL database-cluster manager
ii postgresql-contrib 9.2+141.pgdg60+1
additional facilities for PostgreSQL (supported version)
ii postgresql-contrib-9.2 9.2.4-1.pgdg60+1
additional facilities for PostgreSQL
ii postgresql-plpython3-9.2 9.2.4-1.pgdg60+1
PL/Python 3 procedural language for PostgreSQL 9.2

Stack trace from core:

#0 0x00007f012b5b1997 in ?? () from /usr/lib/libpython3.1.so.1.0
#1 0x00007f012b615045 in PyEval_EvalFrameEx () from
/usr/lib/libpython3.1.so.1.0
#2 0x00007f012b5a6068 in ?? () from /usr/lib/libpython3.1.so.1.0
#3 0x00007f012b5824ab in PyIter_Next () from /usr/lib/libpython3.1.so.1.0
#4 0x00007f012ba53ab7 in PLy_exec_function (fcinfo=<optimized out>,
proc=<optimized out>)
at
/tmp/buildd/postgresql-9.2-9.2.4/build-py3/../src/pl/plpython/plpy_exec.c:108
#5 0x00007f012ba544c4 in plpython3_call_handler (fcinfo=<optimized out>)
at
/tmp/buildd/postgresql-9.2-9.2.4/build-py3/../src/pl/plpython/plpy_main.c:236
#6 0x00007f01389e98b7 in ExecMakeFunctionResult (fcache=0x7f013ac5f9a0,
econtext=<optimized out>,
isNull=0x7f013ac603f8 "p\345K:\001\177", isDone=0x7f013ac60510)
at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/executor/execQual.c:1794
#7 0x00007f01389e4c6e in ExecTargetList (isDone=<optimized out>,
itemIsDone=<optimized out>,
isnull=<optimized out>, values=<optimized out>, econtext=<optimized
out>, targetlist=<optimized out>)
at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/executor/execQual.c:5221
#8 ExecProject (projInfo=<optimized out>, isDone=<optimized out>)
at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/executor/execQual.c:5436
#9 0x00007f01389fce7b in ExecResult (node=0x7f013ac5f6a0)
at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/executor/nodeResult.c:155
#10 0x00007f01389e4218 in ExecProcNode (node=0x7f013ac5f6a0)
at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/executor/execProcnode.c:372
#11 0x00007f01389e300a in ExecutePlan (dest=<optimized out>,
direction=<optimized out>,
numberTuples=<optimized out>, sendTuples=<optimized out>,
operation=<optimized out>,
planstate=<optimized out>, estate=<optimized out>)
at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/executor/execMain.c:1395
#12 standard_ExecutorRun (queryDesc=0x7f013acc5660, direction=731641472,
count=0)
at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/executor/execMain.c:303
#13 0x00007f0138ac2837 in PortalRunSelect (portal=0x7f013a4f5920,
forward=<optimized out>, count=0,
dest=0x7f013a581a78) at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/tcop/pquery.c:944
#14 0x00007f0138ac3c80 in PortalRun (portal=<optimized out>,
count=<optimized out>,
isTopLevel=<optimized out>, dest=<optimized out>, altdest=<optimized
out>,
completionTag=<optimized out>)
at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/tcop/pquery.c:788
#15 0x00007f0138abfe0d in exec_simple_query (query_string=<optimized out>)
at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/tcop/postgres.c:1046
---Type <return> to continue, or q <return> to quit---
#16 0x00007f0138ac0e00 in PostgresMain (argc=<optimized out>,
argv=<optimized out>,
dbname=0x7f013a4bf6a8 "app_test", username=<optimized out>)
at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/tcop/postgres.c:3959
#17 0x00007f0138a79cf3 in BackendRun (port=<optimized out>)
at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/postmaster/postmaster.c:3614
#18 BackendStartup (port=<optimized out>)
at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/postmaster/postmaster.c:3304
#19 ServerLoop () at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/postmaster/postmaster.c:1367
#20 0x00007f0138a7cc8c in PostmasterMain (argc=<optimized out>,
argv=0x7f013a4be190)
at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/postmaster/postmaster.c:1127
#21 0x00007f0138a1838b in main (argc=5, argv=0x7f013a4be170)
at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/main/main.c:199