Skip site navigation (1) Skip section navigation (2)

Re: BUG #6204: Using plperl functions generate crash

From: Shahaf <shahaf(at)redfin(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6204: Using plperl functions generate crash
Date: 2011-12-21 16:30:31
Message-ID: 1324485031237-5092359.post@n5.nabble.com (view raw or flat)
Thread:
Lists: 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.

In response to

Responses

pgsql-bugs by date

Next:From: marcDate: 2011-12-21 16:32:25
Subject: BUG #6350: Delete a role which is still in use
Previous:From: Alvaro HerreraDate: 2011-12-21 16:25:53
Subject: Re: BUG #6348: PROBLEMAS DELETE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group