Re: ant test psql and lots of connections

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Mon May 07 2007 - 06:52:13 EDT

  • Next message: Andrus Adamchik: "Re: [JIRA] Created: (CAY-787) RAT failures for 2.0 branch"

    Glad to hear this problem is solved. I was a bit worried about
    PostgreSQL leaking connections in light of our recent discussions on
    user.

    I also noticed that we need 1.2.3 Maven bundles under [1]. Tore,
    could you please run "ant mvn-bundle -Dproject.version=1.2.3" and
    appload all generated *bundle.jar files to people.apache.org? I just
    updated the release guide to include this step.

    Thanks
    Andrus

    [1] http://people.apache.org/~torehalset/release/1.2.3/

    On May 7, 2007, at 1:56 AM, Tore Halset wrote:

    > Hello.
    >
    > Working on the release today I got a problem with testing on
    > PostgreSQL. Others did not see the problem. The problem was that to
    > many connections to the database was opened, but not closed.
    >
    > ERROR CayenneTestResources: Error generating schema...
    > org.postgresql.util.PSQLException: ERROR: language "plpgsql" does
    > not exist
    > at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
    > (QueryExecutorImpl.java:1548)
    > at org.postgresql.core.v3.QueryExecutorImpl.processResults
    > (QueryExecutorImpl.java:1316)
    > at org.postgresql.core.v3.QueryExecutorImpl.execute
    > (QueryExecutorImpl.java:191)
    > at org.postgresql.jdbc2.AbstractJdbc2Statement.execute
    > (AbstractJdbc2Statement.java:452)
    > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags
    > (AbstractJdbc2Statement.java:337)
    > at org.postgresql.jdbc2.AbstractJdbc2Statement.execute
    > (AbstractJdbc2Statement.java:329)
    > at org.objectstyle.cayenne.unit.AccessStackAdapter.executeDDL
    > (AccessStackAdapter.java:217)
    > at org.objectstyle.cayenne.unit.AccessStackAdapter.executeDDL
    > (AccessStackAdapter.java:226)
    > at org.objectstyle.cayenne.unit.PostgresStackAdapter.createdTables
    > (PostgresStackAdapter.java:99)
    > at org.objectstyle.cayenne.unit.AbstractAccessStack.createSchema
    > (AbstractAccessStack.java:304)
    > at org.objectstyle.cayenne.unit.SimpleAccessStack.createSchema
    > (SimpleAccessStack.java:156)
    > at org.objectstyle.cayenne.unit.CayenneTestResources.rebuildSchema
    > (CayenneTestResources.java:228)
    > at org.objectstyle.cayenne.unit.CayenneTestResources.loadResources
    > (CayenneTestResources.java:135)
    > at org.objectstyle.cayenne.unit.CayenneTestResources.getResources
    > (CayenneTestResources.java:158)
    > at org.objectstyle.cayenne.unit.CayenneTestCase.<init>
    > (CayenneTestCase.java:101)
    > at org.objectstyle.cayenne.query.SelectQueryBase.<init>
    > (SelectQueryBase.java:63)
    > at org.objectstyle.cayenne.query.SelectQueryTst.<init>
    > (SelectQueryTst.java:75)
    >
    > After issuing a "createlang plpgsql cayenne" the problem went away
    > and all tests pass. Even with this SQLException, the Connections
    > should be closed.
    >
    > Regards,
    > - Tore.
    >

    This archive was generated by hypermail 2.0.0 : Mon May 07 2007 - 06:52:54 EDT