| From: | Ben Chobot <bench(at)silentmedia(dot)com> |
|---|---|
| To: | Jonathan Vanasco <postgres(at)2xlp(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: how can i bugfix "idle in transaction" lockups ? |
| Date: | 2010-11-30 15:49:14 |
| Message-ID: | 1781F88D-CA84-4EAC-9513-8BAF32822230@silentmedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Nov 30, 2010, at 7:21 AM, Jonathan Vanasco wrote:
> on a project, i find myself continually finding the database locked up with "idle in transaction" connections
>
> are there any commands that will allow me to check exactly what was going on in that transaction ?
>
> i couldn't find anything in the docs, and the project has decent traffic, so its going to be an issue to log all statements so I can sift through the data by PID
Are those transactions actually holding locks? (You can verify by checking pg_locks.) If so, that might give you a clue. If not, then they shouldn't be causing any lockups....
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wappler, Robert | 2010-11-30 16:21:00 | How to indicate failure of a shell script to pgagent |
| Previous Message | Andy Colson | 2010-11-30 15:37:29 | Re: advise on performance issues please |