BUG #7516: PL/Perl crash - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      7516
Logged by:          Marko Tiikkaja
Email address:      pgmail@joh.to
PostgreSQL version: 9.1.5
Operating system:   64-bit linux
Description:        =


Hi,

We had a segmentation fault in PostgreSQL 9.1.5 with PL/PerlU.

The backtrace looks like this:

#0  0x00007f80be88cb04 in plperl_spi_exec_prepared (query=3D0x1671eb8
"0x168cd70", attr=3D0x0, argc=3D2, argv=3D0x19b4e40) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/pl/plperl/plperl.c:3373
#1  0x00007f80be88e4f0 in XS__spi_exec_prepared (my_perl=3D<optimized out>,
cv=3D<optimized out>) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/pl/plperl/SPI.xs:141
#2  0x00007f80be5b67ff in Perl_pp_entersub () from /usr/lib/libperl.so.5.14
#3  0x00007f80be5adc96 in Perl_runops_standard () from
/usr/lib/libperl.so.5.14
#4  0x00007f80be54959e in Perl_call_sv () from /usr/lib/libperl.so.5.14
#5  0x00007f80be885c55 in plperl_call_perl_func (desc=3D0x189a010,
fcinfo=3D0x188c490) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/pl/plperl/plperl.c:2017
#6  0x00007f80be88a17c in plperl_func_handler (fcinfo=3D0x188c490) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/pl/plperl/plperl.c:2156
#7  plperl_call_handler (fcinfo=3D0x188c490) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/pl/plperl/plperl.c:1671
#8  0x0000000000707147 in fmgr_security_definer (fcinfo=3D0x188c490) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/utils/fmgr/fmgr.c:9=
75
#9  0x0000000000575e45 in ExecMakeFunctionResult (fcache=3D0x188c420,
econtext=3D0x188c230, isNull=3D0x188cec8 "id", isDone=3D0x188cfe0)
    at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/executor/execQual.c=
:1917
#10 0x0000000000578512 in ExecTargetList (isDone=3D0x7fff051891ec,
itemIsDone=3D0x188cfe0, isnull=3D0x188cec8 "id", values=3D0x188ceb0,
econtext=3D0x188c230, targetlist=3D0x188cfb0)
    at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/executor/execQual.c=
:5210
#11 ExecProject (projInfo=3D<optimized out>, isDone=3D0x7fff051891ec) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/executor/execQual.c=
:5425
#12 0x0000000000588b4a in ExecResult (node=3D0x188c120) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/executor/nodeResult=
.c:155
#13 0x00000000005713e8 in ExecProcNode (node=3D0x188c120) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/executor/execProcno=
de.c:367
#14 0x000000000056e662 in ExecutePlan (dest=3D0x15ae900, direction=3D<optim=
ized
out>, numberTuples=3D0, sendTuples=3D1 '\001', operation=3DCMD_SELECT,
planstate=3D0x188c120, estate=3D0x188c010)
    at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/executor/execMain.c=
:1440
15 standard_ExecutorRun (queryDesc=3D0x1464830, direction=3D<optimized out>,
count=3D0) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/executor/execMain.c=
:314
#16 0x0000000000642ee7 in PortalRunSelect (portal=3D0x1421710,
forward=3D<optimized out>, count=3D0, dest=3D0x15ae900) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/tcop/pquery.c:943
#17 0x00000000006443d0 in PortalRun (portal=3D0x1421710,
count=3D9223372036854775807, isTopLevel=3D1 '\001', dest=3D0x15ae900,
altdest=3D0x15ae900, completionTag=3D0x7fff05189670 "")
    at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/tcop/pquery.c:787
#18 0x0000000000640fba in exec_execute_message (max_rows=3D<optimized out>,
portal_name=3D0x15ae4f0 "") at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/tcop/postgres.c:1965
#19 PostgresMain (argc=3D<optimized out>, argv=3D<optimized out>,
username=3D<optimized out>) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/tcop/postgres.c:4025
#20 0x0000000000602813 in BackendRun (port=3D0x145b990) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/postmaster/postmast=
er.c:3617
#21 BackendStartup (port=3D0x145b990) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/postmaster/postmast=
er.c:3302
#22 ServerLoop () at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/postmaster/postmast=
er.c:1466
#23 0x0000000000603281 in PostmasterMain (argc=3D<optimized out>,
argv=3D<optimized out>) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/postmaster/postmast=
er.c:1127
#24 0x000000000045a440 in main (argc=3D5, argv=3D0x1416170) at
/build/buildd/postgresql-9.1-9.1.5/build/../src/backend/main/main.c:199

It seems to have happened when a PL/PerlU executed a prepared statement
which calls another PL/PerlU function.

So far we have not been able to reproduce the problem.  Any thoughts? =

Someone seen something similar?


Regards,
Marko Tiikkaja