pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kaolin Fire <cognosco@tentacle.net>
To: pgsql-admin@postgresql.org
Subject: long idle connections causing problems?
Date: Thu, 18 Aug 2005 10:00:31 -0700
Message-ID: <4304BEAF.6010308@tentacle.net> (raw)

Just in the past month or so (no code changes, server changes that I 
know of, etc, for the last six months), I've started getting errors like:

org.postgresql.util.PSQLException: Unknown Response Type 8
	at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:192)
	at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
	at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
	at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
	at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)

The particular response type will change each page load.

Doing a process query will show a number of long-running idle postgres 
processes for that particular website.  Other site pools don't seem 
affected, but this one is heavier load than the others (still only ten 
thousand hits a day or so).  If I kill all the idle processes for the 
site, one of them will still remain:

24619 ?        S     14:21 postgres: xxxxxxx xxxxxxx 127.0.0.1 idle

Which I then have to kill -9... which then requires a restart of tomcat 
to hook back up.

possibly relevant version numbers?

    psql (PostgreSQL) 7.4.7
    Apache Tomcat/4.1.31
    Apache/2.0.51
    Fedora Core 2, kernel 2.6.9

Any  thoughts on what configuration I should be looking at, or if 
there's something I just dearly need to upgrade, ...?

Thank you for your time. :)

-kaolin fire
-http://erif.org/code/detritus/



Message-ID: <4304BEAF.6010308@tentacle.net>
Permalink:  ../4304BEAF.6010308@tentacle.net/
Also on:    postgresql.org/message-id/4304BEAF.6010308@tentacle.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: cognosco@tentacle.net
  Subject: Re: long idle connections causing problems?
  In-Reply-To: <4304BEAF.6010308@tentacle.net>
  References: <4304BEAF.6010308@tentacle.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox