From: | "Anu Kucharlapati" <anuk(at)rapidweb(dot)com(dot)au> |
---|---|
To: | <pgsql-performance(at)postgresql(dot)org> |
Cc: | "Owen Blizzard" <owenb(at)rapidweb(dot)com(dot)au> |
Subject: | Deadlock Issue with PostgreSQL |
Date: | 2005-09-21 01:44:54 |
Message-ID: | 684E37D19BEFA148B453F5C4FB466B6223A3E9@rws-exch01.rapidweb.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Background: We are running a web application on apache with database
server as PostgreSQL. The application is a expense claim application
with workflow. The software versions are specified below:
Red Hat Linux release 7.3
Apache 1.3.20
PostgreSQL 7.1.3
Problem: When the application is accessed by many users like say 40, the
PostgreSQL database freezes.
Description of Process happening behind: The application mainly puts
load on one table (worklist) where the steps were created for each
expense claim initiated. While creating each step for claim there is
exclusive row lock and at the end inserts a new step. Both these
statements are in one transaction. When the apache hangs in between the
deadlock remains. In this way there are many deadlocks created which
makes the database to finally freeze. To resolve this we were restarting
the PostgreSQl db. Sometime the apache also hangs. Then we were
restarting the apache. There is no log created in postgreSQL. Whereas
our application records an error log: 'Failed to gain exclusive table
row lock'
We were guessing that the database hanging is due to deadlock issue. But
not sure of it.
I have attached the postgreSQL.conf file for your reference to check the
settings.
Please let me know what might be the reason and how to check and resolve
it.
Thanks and Best Regards,
Anu
Attachment | Content-Type | Size |
---|---|---|
postgresql.conf | application/octet-stream | 4.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-09-21 02:15:24 | Re: Deadlock Issue with PostgreSQL |
Previous Message | Markus Benne | 2005-09-20 18:53:19 | VACUUM FULL vs CLUSTER |