deadlock detection

From: SHOBHA HALDONKAR <shobha(at)phildigital(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: deadlock detection
Date: 2003-04-08 06:03:58
Message-ID: 3E92664D.313C3DFE@phil.com.sg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


HI ,

We are currenlty using postgresql 7.2.1 database. But it does not
seem to detect deadlocks .
Suppose if a record is locked with update command and another
concurrent user tries to lock the same record and the first transaction
for some reason , eg. m/c hangings is not committed both the
transactions remains locked for indefinite period . I have checked the
setting in postgresql.config for deadlock_timeout which is set to 1000
. Than why doesn't the transaction deatect deadlock after 1000
millisecond .
Secondly if the frontend process is killed but due to some reason the
backend postgres process remains , than how can it be terminated .For
if i try to use kill command all the postgres processes gets
terminated .
Please help

--
Regards,
Shobha

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message mlaks 2003-04-08 07:11:18 trouble connecting to Postgresql Database via apache-perl script on localhost ? pg_hba.conf issue
Previous Message Nikolaus Dilger 2003-04-08 03:50:42 Re: Trying to Tunning DB