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
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 |