ant test psql and lots of connections

From: Tore Halset (halse..vv.ntnu.no)
Date: Sun May 06 2007 - 18:56:42 EDT

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

    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 : Sun May 06 2007 - 18:56:15 EDT