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

BUG #6204: Using plperl functions generate crash

From: "pasman" <pasman(dot)p(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6204: Using plperl functions generate crash
Date: 2011-09-14 09:15:54
Message-ID: 201109140915.p8E9Fs0w075076@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      6204
Logged by:          pasman
Email address:      pasman(dot)p(at)gmail(dot)com
PostgreSQL version: 9.1.0
Operating system:   WinXP sp3
Description:        Using plperl functions generate crash
Details: 

After install postgresql 9.1.0 and Activestate perl 5.14.1 execute:

create function perl_test() returns void as
$$
$$
language plperl


This generates server crash. Log contain:


2011-09-14 11:08:22 CEST STATEMENT:  create function perl_test() returns
void as 	$$ 	$$ 	language plperl
2011-09-14 11:08:47 CEST LOG:  server process (PID 560) was terminated by
exception 0xC0000005
2011-09-14 11:08:47 CEST HINT:  See C include file "ntstatus.h" for a
description of the hexadecimal value.
2011-09-14 11:08:47 CEST LOG:  terminating any other active server
processes
2011-09-14 11:08:47 CEST WARNING:  terminating connection because of crash
of another server process
2011-09-14 11:08:47 CEST 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-09-14 11:08:47 CEST HINT:  In a moment you should be able to reconnect
to the database and repeat your command.
2011-09-14 11:08:47 CEST WARNING:  terminating connection because of crash
of another server process
2011-09-14 11:08:47 CEST 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-09-14 11:08:47 CEST HINT:  In a moment you should be able to reconnect
to the database and repeat your command.
2011-09-14 11:08:47 CEST WARNING:  terminating connection because of crash
of another server process
2011-09-14 11:08:47 CEST 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-09-14 11:08:47 CEST HINT:  In a moment you should be able to reconnect
to the database and repeat your command.
2011-09-14 11:08:47 CEST LOG:  all server processes terminated;
reinitializing
2011-09-14 11:08:57 CEST FATAL:  pre-existing shared memory block is still
in use
2011-09-14 11:08:57 CEST HINT:  Check if there are any old server processes
still running, and terminate them.

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2011-09-14 15:04:05
Subject: Re: BUG #6203: Building libpq with Visual Studio 9.0 error
Previous:From: Thomas KellererDate: 2011-09-14 06:41:42
Subject: Re: Problem with the 9.1 one-click installer Windows7 64bit

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