pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDeadlock Issue with PostgreSQL
4+ messages / 3 participants
[nested] [flat]
* Deadlock Issue with PostgreSQL
@ 2005-09-21 01:44 Anu Kucharlapati <anuk@rapidweb.com.au>
2005-09-21 02:15 ` Re: Deadlock Issue with PostgreSQL Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Anu Kucharlapati @ 2005-09-21 01:44 UTC (permalink / raw)
To: pgsql-performance; +Cc: Owen Blizzard <owenb@rapidweb.com.au>
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
Attachments:
postgresql.conf (application/octet-stream, 4.1K) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Deadlock Issue with PostgreSQL
2005-09-21 01:44 Deadlock Issue with PostgreSQL Anu Kucharlapati <anuk@rapidweb.com.au>
@ 2005-09-21 02:15 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2005-09-21 02:15 UTC (permalink / raw)
To: Anu Kucharlapati <anuk@rapidweb.com.au>; +Cc: pgsql-performance@postgresql.org, "Owen Blizzard" <owenb@rapidweb.com.au>
"Anu Kucharlapati" <anuk@rapidweb.com.au> writes:
> Red Hat Linux release 7.3
> Apache 1.3.20
> PostgreSQL 7.1.3
I'm not sure about Apache, but both the RHL and Postgres versions
you are using are stone age --- *please* update. Red Hat stopped
supporting that release years ago, and the PG community isn't
supporting 7.1.* anymore either. There are too many known problems
in 7.1.* that are unfixable without a major-version upgrade.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* FW: Deadlock Issue with PostgreSQL
@ 2005-09-23 00:21 Anu Kucharlapati <anuk@rapidweb.com.au>
2005-09-23 02:49 ` Re: FW: Deadlock Issue with PostgreSQL Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 4+ messages in thread
From: Anu Kucharlapati @ 2005-09-23 00:21 UTC (permalink / raw)
To: tgl@sss.pgh.pa.us; +Cc: pgsql-performance
Hello Tom,
Thanks a lot for your quick response. Which version do you think is the
more stable one that we should upgrade to?
Please provide us with the Upgrade instructions/documentation to be
followed for both red hat and PostgreSQL.
Thanks and Best Regards,
Anu
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, September 21, 2005 12:15 PM
To: Anu Kucharlapati
Cc: pgsql-performance@postgresql.org; Owen Blizzard
Subject: Re: [PERFORM] Deadlock Issue with PostgreSQL
"Anu Kucharlapati" <anuk@rapidweb.com.au> writes:
> Red Hat Linux release 7.3
> Apache 1.3.20
> PostgreSQL 7.1.3
I'm not sure about Apache, but both the RHL and Postgres versions
you are using are stone age --- *please* update. Red Hat stopped
supporting that release years ago, and the PG community isn't
supporting 7.1.* anymore either. There are too many known problems
in 7.1.* that are unfixable without a major-version upgrade.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: FW: Deadlock Issue with PostgreSQL
2005-09-23 00:21 FW: Deadlock Issue with PostgreSQL Anu Kucharlapati <anuk@rapidweb.com.au>
@ 2005-09-23 02:49 ` Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 4+ messages in thread
From: Josh Berkus @ 2005-09-23 02:49 UTC (permalink / raw)
To: pgsql-performance; +Cc: Anu Kucharlapati <anuk@rapidweb.com.au>; tgl@sss.pgh.pa.us
Anu,
> Thanks a lot for your quick response. Which version do you think is the
> more stable one that we should upgrade to?
8.0.3
> Please provide us with the Upgrade instructions/documentation to be
> followed for both red hat and PostgreSQL.
See the PostgreSQL documentation for upgrade instructions. Given how old
your version is, you might need to go through an intermediate version,
like 7.3.
Red Hat upgrades are between you and Red Hat. They sell support for a
reason ...
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-09-23 02:49 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-21 01:44 Deadlock Issue with PostgreSQL Anu Kucharlapati <anuk@rapidweb.com.au>
2005-09-21 02:15 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-09-23 00:21 FW: Deadlock Issue with PostgreSQL Anu Kucharlapati <anuk@rapidweb.com.au>
2005-09-23 02:49 ` Josh Berkus <josh@agliodbs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox