Re: BUG #6204: Using plperl functions generate crash - Mailing list pgsql-bugs

From Shahaf
Subject Re: BUG #6204: Using plperl functions generate crash
Date
Msg-id 1324485031237-5092359.post@n5.nabble.com
Whole thread Raw
In response to Re: BUG #6204: Using plperl functions generate crash  (Guimarães Faria Corcete DUTRA, Leandro <l@dutras.org>)
Responses Re: BUG #6204: Using plperl functions generate crash
List pgsql-bugs
I'm running into the same issue.  I can "create language plperl;"
successfully, but as soon as I try to create a function (as shown above),
Postgres dies.

Guimaraes - did you find a solution using standard installers?
sachin - have you tried on win7?
pasman - what's the process to install from source?

More detail on my setup...

I'm on Win7.

Postgres 9.1 32-bit:
http://www.enterprisedb.com/products/pgdownload.do#windows (version 9.1.2-1)

Perl 5.14 32-bit, I've tried both:
http://downloads.activestate.com/ActivePerl/releases/5.14.2.1402/ActivePerl-5.14.2.1402-MSWin32-x86-295342.msi
http://downloads.activestate.com/ActivePerl/releases/5.14.1.1401/ActivePerl-5.14.1.1401-MSWin32-x86-294969.msi

Here's what I see in the log file:

2011-12-21 08:10:49 PST LOG:  server process (PID 7296) was terminated by
exception 0xC0000005
2011-12-21 08:10:49 PST HINT:  See C include file "ntstatus.h" for a
description of the hexadecimal value.
2011-12-21 08:10:49 PST LOG:  terminating any other active server processes
2011-12-21 08:10:49 PST WARNING:  terminating connection because of crash of
another server process
2011-12-21 08:10:49 PST DETAIL:  The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2011-12-21 08:10:49 PST HINT:  In a moment you should be able to reconnect
to the database and repeat your command.
2011-12-21 08:10:49 PST LOG:  all server processes terminated;
reinitializing
2011-12-21 08:10:59 PST FATAL:  pre-existing shared memory block is still in
use
2011-12-21 08:10:59 PST HINT:  Check if there are any old server processes
still running, and terminate them.


--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-6204-Using-plperl-functions-generate-crash-tp4802111p5092359.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

pgsql-bugs by date:

Previous
From: christian_oederan@gmx.de
Date:
Subject: BUG #6351: ERROR: btree index keys must be ordered by attribute
Next
From: l
Date:
Subject: Re: BUG #6204: Using plperl functions generate crash