postgres, idle in transaction

From: Peter Schröder (Peter.Schroede..reenet-ag.de)
Date: Tue Apr 24 2007 - 02:48:12 EDT

  • Next message: Gary Jarrel: "cayenne-nodeps-2.0.2-sources.jar permission denied"

    hi,

    we are still experiencing trouble with our postgres db and connections hanging "idle in transaction".

    we debugged the postgres driver and found out that he starts a transaction on every select-query but does not close it.

    cayenne does not seem to bother and re-uses these connections for the next query, but other apps have trouble with the transactions, cause they lock the used tables.

    funny thing is that we cannot reproduce this failure with our test-environment wich has the exact same setup as our live-servers...

    currently we are doing a commitChanges() after every select-query as a workaround. setting autoCommit to true would have the same effect, but i dont like that idea...

    kind regards,
    peter

    This archive was generated by hypermail 2.0.0 : Tue Apr 24 2007 - 02:48:55 EDT