| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Maurice Balick <balm(at)smiley(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: locked up backends |
| Date: | 2001-04-05 23:12:12 |
| Message-ID: | 6619.986512332@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Maurice Balick <balm(at)smiley(dot)com> writes:
> We are running Postgres 7.0.2 on Linux RH 6.2 Dell servers.
> When traffic gets heavy we often get one of the backend locked up in an
> UPDATE, INSERT or COMMIT request. Eventually all the other backends end
> up locking too as they try to access a row locked by the original
> backend.
Try updating to 7.0.3. You may be getting caught by 7.0.2's failure to
release locks when a client disconnects partway through a transaction
block.
If you still see this in 7.0.3 then it'd be worth further investigation.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Randall F. Kern | 2001-04-05 23:35:55 | RE: locked up backends |
| Previous Message | Joel Burton | 2001-04-05 23:04:05 | Re: Relation XX does not exist |