Re: Idle in transaction state.

Peter,

On 9-Sep-06, at 2:14 PM, Peter L. Berghold wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi folks,
>
> I've run into an issue that I'm sure there's a fix for, I just haven't
> quite figured it out on my own.
>
> First the overview of the environment:
> Linux (CentOS release 4.2)
> Tomcat 5.x application server
> Struts/Tiles MVC
> Hibernate 3.1 Object Persistence
> postgresql-8.2dev-500.jdbc2.jar for JDBC drivers
>
> What I'm seeing is the first time my web application is being run
> there
> is a bunch of processes running around that look like:
> "postgres: peter peter_trialdb 127.0.0.1(46222) idle"

I presume you mean "idle in transaction"
>
> in the process table. What's worse, is if I try to modify my database
> schema while these processes are running (and they seem to stick
> around
> forever) the psql session running the SQL script to do the
> modifications
> hangs on the first statement that modifies or drops an existing table.
>
> I'm not even sure what part of this puzzle is the root cause of the
> problem. JDBC drivers? Hibernate configuration? Elvis?
It's the pooling implementation, it should be setting autocommit to
true when closing the connection, which really means returning the
connection to the pool.
>
> Any insight is welcome and appreciated.
>
Dave
>
> - --
> ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
> ::
> Peter L. Berghold
> Peter(at)Berghold(dot)Net
> "Those who fail to learn from history are condemned to repeat it."
> AIM: redcowdawg Yahoo IM: blue_cowdawg ICQ:
> 11455958
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.6 (GNU/Linux)
> Comment: Using GnuPG with Red Hat - http://enigmail.mozdev.org
>
> iD8DBQFFAwRuUM9/01RIhaARAvouAJ9S5BT0aDd4MR2Ps0XXUOCVCU5/vACgtU2E
> +drcu3MQ1wVPWq7FnanBOa0=
> =xqRU
> -----END PGP SIGNATURE-----
> <Peter.vcf>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings