| From: | Bart McFarling <bartm(at)IMCG(dot)COM> |
|---|---|
| To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Deadlock |
| Date: | 2005-09-15 17:32:05 |
| Message-ID: | 8E8024127641D911B85B0002A5FBC9DB01B05FE1@exchange |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Is there some kind of log, table or something that I could get more
information about a deadlock situation that is occurring in my database? I
just get a transaction number and a process id, which is useless to me
because my application terminates on any errors from the database? It occurs
infrequently (about once a day) and I have no idea how to track it down.
Also sometimes the database just freezes (RedHat EL 3.0 Postgresql 8.0.1)
could this be a deadlock situation? There is nothing in the log about
deadlock or anything else when it freezes (this happens about once every
month or so)
Thanks,
Bart
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Mayer | 2005-09-15 18:02:47 | Re: oracle's first_value function for postgres? |
| Previous Message | Tom Lane | 2005-09-15 16:23:29 | Re: Problem with 64-bit Postgres |