Re: plperl db crash

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: plperl db crash
Date: 2003-10-03 17:23:03
Message-ID: 3F7DB077.2050504@e-trolley.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Nabil Sayegh wrote:
> I had a db lock up on one of our machines.
> To reproduce it, I did a fresh install on a testing machine.
>
> On the other machine where it occured the first time the db just hung,
> but it didn't crash. I tried to /etc/init.d/postgresql stop
> But it didn't stop.

Another fact I had forgotten:
The 'original' problem occured when I wanted to
DROP FUNCTION perlsub;
The 'original' system was 7.3.4-5, too.
It didn't crash when executing the function but locked up the db when i
wanted to remove the function.

Sorry for not mentioning it before :|

However the testing system crashes when executing the function.

I will upgrade ASA it is in my apt sources.

cu
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-10-03 18:02:19 Re: cancel request in progress
Previous Message Josh Berkus 2003-10-03 17:20:05 Re: Rounding