Bug #955: server crashes during plperl execution

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #955: server crashes during plperl execution
Date: 2003-04-26 11:34:43
Message-ID: 20030426113443.8454A47630B@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

A.Bhuvaneswaran (bhuvansql(at)myrealbox(dot)com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
server crashes during plperl execution

Long Description
Hi,

I am using postgresql 7.3.2.

When i execute a simple plperl procedure, the server is crashed. What could be the reason? FYI, i have included the perl code and the server log.

regards,
bhuvaneswaran

Sample Code
create or replace function perl_test (text, text)
returns int as '

my ($A1, $A2) = @_;
print "Argument 1 :$A1:\n";
print "Argument 2 :$A2:\n";
return 1;
'
language 'plperl';

test=# SELECT version();
version
-------------------------------------------------------------
PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

test=# SELECT perl_test('a1', 'a2');
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
test=#\q

<log>
LOG: server process (pid 20676) was terminated by signal 11
LOG: terminating any other active server processes
WARNING: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
LOG: all server processes terminated; reinitializing shared memory and semaphores
LOG: database system was interrupted at 2003-04-26 16:39:07 IST
LOG: checkpoint record is at 0/52DAFAC0
LOG: redo record is at 0/52DAFAC0; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 107226806; next oid: 4350544
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 0/52DAFB00
LOG: ReadRecord: record with zero length at 0/52DCAA74
LOG: redo done at 0/52DCAA50
LOG: database system is ready
</log>

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2003-04-26 11:47:25 Bug #956: plperl vs. plperlu
Previous Message Oliver Elphick 2003-04-26 06:02:27 Re: BUG: Infinite syslog() loop