| From: | Garo Hussenjian <garo(at)xapnet(dot)com> |
|---|---|
| To: | Postgresql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Idle transaction causing problems. |
| Date: | 2003-02-18 22:08:43 |
| Message-ID: | BA77EEEB.79DD%garo@xapnet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a server (pgsql 7.1.2) that periodically racks up a bunch of UPDATE
waiting processes causing my php application to hang... I used gdb to get
the debug_query_string on one of the UPDATE waiting processes and found it
to be a very simple query on our session table... Not a server-breaker!
The culprit seemed to be another process with status 'transaction idle' but
the gdb debug_query_string was null (pointed to 0x0)... When I killed the
transaction idle process the UPDATE waiting processes cleared out
immediately and we were up and running again...
Is there a way (w/ gdb or other) to determine the source of the idle
transaction blocking traffic?
Regards,
Garo
=-=-==-=-=-==
Xapnet Internet Solutions
1501 Powell St., Suite N
Emeryville, CA 94608
Tel - (510) 655-9771
Fax - (510) 655-9775
Web - http://www.xapnet.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2003-02-18 22:40:35 | Re: Creating index does not make any change in query plan. |
| Previous Message | Diogo de Oliveira Biazus | 2003-02-18 21:32:14 | problems with tsearch |