Dear peoples,
Periodically we are getting runaway postgres processes on our Linux (2.4.21-0.13 on
Dell servers), using 7.4 and GIS (0.8 USE_GEOS=1 USE_PROJ=1 USE_STATS=1).
All of the queries come in from remote servers using JDBC/proxool; once every 4 hours
we have a process on the client side that cleans out old connections.
All the processes are doing is single queries -- no inserts or updates.
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
as these are all queries and presumably each query is a complete transaction. My
tenative theory is that something is killing the client while the server side still
thinks it has data to send, or some such variant. The client machines don't have a
corresponding connection to the one on the postgres server.
Killing the runaways with a -15 seems to bring the load back down and all is well,
until it happens again.
Does anyone have any ideas what might be triggering this ? It is mostly an annoyance
but on a couple of occasions seems to have brought down a server, or at least rendered
it non-functional.
Thanks for any advice !
Greg Williamson
DBA
GlobeXplorer LLC
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
