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@tradehill.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=3D<optimized out>,
proc=3D<optimized out>)
    at
/tmp/buildd/postgresql-9.2-9.2.4/build-py3/../src/pl/plpython/plpy_exec.c:1=
08
#5  0x00007f012ba544c4 in plpython3_call_handler (fcinfo=3D<optimized out>)
    at
/tmp/buildd/postgresql-9.2-9.2.4/build-py3/../src/pl/plpython/plpy_main.c:2=
36
#6  0x00007f01389e98b7 in ExecMakeFunctionResult (fcache=3D0x7f013ac5f9a0,
econtext=3D<optimized out>, =

    isNull=3D0x7f013ac603f8 "p\345K:\001\177", isDone=3D0x7f013ac60510)
    at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/executor/execQual.c:1=
794
#7  0x00007f01389e4c6e in ExecTargetList (isDone=3D<optimized out>,
itemIsDone=3D<optimized out>, =

    isnull=3D<optimized out>, values=3D<optimized out>, econtext=3D<optimiz=
ed
out>, targetlist=3D<optimized out>)
    at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/executor/execQual.c:5=
221
#8  ExecProject (projInfo=3D<optimized out>, isDone=3D<optimized out>)
    at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/executor/execQual.c:5=
436
#9  0x00007f01389fce7b in ExecResult (node=3D0x7f013ac5f6a0)
    at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/executor/nodeResult.c=
:155
#10 0x00007f01389e4218 in ExecProcNode (node=3D0x7f013ac5f6a0)
    at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/executor/execProcnode=
.c:372
#11 0x00007f01389e300a in ExecutePlan (dest=3D<optimized out>,
direction=3D<optimized out>, =

    numberTuples=3D<optimized out>, sendTuples=3D<optimized out>,
operation=3D<optimized out>, =

    planstate=3D<optimized out>, estate=3D<optimized out>)
    at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/executor/execMain.c:1=
395
#12 standard_ExecutorRun (queryDesc=3D0x7f013acc5660, direction=3D731641472,
count=3D0)
    at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/executor/execMain.c:3=
03
#13 0x00007f0138ac2837 in PortalRunSelect (portal=3D0x7f013a4f5920,
forward=3D<optimized out>, count=3D0, =

    dest=3D0x7f013a581a78) at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/tcop/pquery.c:944
#14 0x00007f0138ac3c80 in PortalRun (portal=3D<optimized out>,
count=3D<optimized out>, =

    isTopLevel=3D<optimized out>, dest=3D<optimized out>, altdest=3D<optimi=
zed
out>, =

    completionTag=3D<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=3D<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=3D<optimized out>,
argv=3D<optimized out>, =

    dbname=3D0x7f013a4bf6a8 "app_test", username=3D<optimized out>)
    at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/tcop/postgres.c:3959
#17 0x00007f0138a79cf3 in BackendRun (port=3D<optimized out>)
    at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/postmaster/postmaster=
.c:3614
#18 BackendStartup (port=3D<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=3D<optimized out>,
argv=3D0x7f013a4be190)
    at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/postmaster/postmaster=
.c:1127
#21 0x00007f0138a1838b in main (argc=3D5, argv=3D0x7f013a4be170)
    at
/tmp/buildd/postgresql-9.2-9.2.4/build/../src/backend/main/main.c:199