Search Postgresql Archives

Re: "Idle in Transaction" and hung connections

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Tom --

Thanks for the suggestion, and the rapid response on something which may not be truely a postgres issue (perhaps more a JDBC thing)!

I'll make sure to try this next time we see this oddness in action. May be hours, may be days...

Greg

-----Original Message-----
From:	Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent:	Thu 4/29/2004 3:03 PM
To:	Gregory S. Williamson
Cc:	pgsql-general@postgresql.org
Subject:	Re:  "Idle in Transaction" and hung connections 
"Gregory S. Williamson" <gsw@globexplorer.com> writes:
> Very occasionally we will see a thread go wild, taking up a huge
> amount of processor time (the load will climb by "1" for each process
> -- usual load is around .2, when these hit the load rises to 1.x all
> the way up to a load of about 40 once). The pg_stat_activity shows
> these conections as being old -- much older than any live thread. All
> such connections are in a state of "IDLE IN TRANSACTION" which seems
> odd

This is not unexpected due to the way JDBC (mis)uses BEGIN/COMMIT.
However it is strange that such a connection would start using
a significant amount of CPU time.  It should be waiting for a new
client query.

> Does anyone have any ideas what might be triggering this ?

No.  Try attaching to a looping backend with gdb so you can get a stack
trace.  I would suggest something along the lines of

	gdb /path/to/postgres PID
	bt
	cont
	... wait a few seconds, press control-C, and again do:
	bt
	cont
	... lather, rinse, repeat a few times, then control-C and:
	quit

Comparison of four or five stack traces obtained this way should make it
fairly clear where the loop is, and then we can determine whether we
need more info to solve it.

			regards, tom lane




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux