System hangs when Insert/Update

From: Lee Kwok Shing <kslee(at)graduate(dot)hku(dot)hk>
To: pgsql-admin(at)postgresql(dot)org
Subject: System hangs when Insert/Update
Date: 2001-06-02 03:48:32
Message-ID: 3B186210.CBEB2494@graduate.hku.hk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,
I am using PostgreSQL 7.0.2 on RH 6.2

The DB works smoothly in the past 8 months but until recently, the
system would hang when doing insert or update statements.

When I use
ps aux
I found a lot of processes like
postgres localhost xxx xxx INSERT
postgres localhost xxx xxx SELECT
postgres localhost xxx xxx idle
are running

When I killed one process using
kill -TERM pid
all those processes gone and the DB returns to normal. But after some
insert/update, the problem exists again...

I tried to use strace on the process and found that they seems waiting

for something since the following statements are execution repeatedly
select (0, NULL, NULL, .....
Maybe they had been fall in some infinite loop..

Could you give me some help ?

Best regards,
--
Lee Kwok Shing (***)
http://www.geocities.com/lkslee.geo

Attachment Content-Type Size
kslee.vcf text/x-vcard 178 bytes

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-06-02 06:02:46 Re: System hangs when Insert/Update
Previous Message Lee Kwok Shing 2001-06-02 02:33:36 Hang when doing insert/update