| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Rich Ryan <rich(at)usedcars(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: idle in transaction |
| Date: | 2001-12-08 19:27:30 |
| Message-ID: | 20011208111308.J48625-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
It looks like you've got a transaction which is staying open while holding
a lock. I'm not sure why it'd be different between versions.
If you turn up the debugging level and turn on at least log_pid you should
be able to see what statements the process from that pid has executed.
> If I kill pid 4168, the idle in transaction process, then the vacuum and all
> the other waiting processes will proceed fine. Any clues to what could be
> hanging or how I could get more information from postmaster about what
> transaction is hanging?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brook Milligan | 2001-12-08 21:17:40 | Re: papers on datatype design |
| Previous Message | Stephan Szabo | 2001-12-08 19:25:22 | Re: Fieldname size ?? |