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
