[esb-issues] [JBoss JIRA] Closed: (JBESB-2975) hsql db related test failures

hsql db related test failures ----------------------------- Key: JBESB-2975 URL: https://jira.jboss.org/jira/browse/JBESB-2975 Project: JBoss ESB Issue Type: Bug Security Level: Public(Everyone can see) Components: Testing Affects Versions: 4.7 Reporter: Kevin Conner Assignee: Kevin Conner Fix For: 4.7 Having changed the way in which hsql is being used within our tests, we are now seeing two different types of failure. The first is a deadlock in hsql, caused by the shutdown method sleeping while holding a lock on the server. java.lang.Thread.State: TIMED_WAITING (sleeping) [java] [junit] at java.lang.Thread.sleep(Native Method) [java] [junit] at org.hsqldb.Server.shutdown(Unknown Source) [java] [junit] - locked <0xae4bec58> (a org.hsqldb.Server) [java] [junit] at org.hsqldb.Server.shutdown(Unknown Source) [java] [junit] at org.jboss.soa.esb.testutils.HsqldbUtil.stopHsqldb(HsqldbUtil.java:99) [java] [junit] at org.jboss.soa.esb.persistence.tests.ScheduledRedeliveryUnitTest.runAfterAllTests(ScheduledRedeliveryUnitTest.java:198) [java] [junit] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] [junit] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) The second is being seen on windows only, exhibited as follows [java] [junit] [Server@750159]: [Thread[HSQLDB Server @750159,5,main]]: Database [index=0db=file:E:\hudson\data\jobs\JBoss_ESB\workspace\trunk\product\build\testdb/persistUnitTestDB, alias=persistunittestdb] did not open: org.hsqldb.HsqlException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@57a1a0db[file =E:\hudson\data\jobs\JBoss_ESB\workspace\trunk\product\build\testdb\persistUnitTestDB.lck, exists=true, locked=false, valid=false, fl =null]: java.lang.Exception: checkHeartbeat(): lock file [E:\hudson\data\jobs\JBoss_ESB\workspace\trunk\product\build\testdb\persistUnitTestDB.lck] is presumably locked by another process. [java] [junit] [Server@750159]: [Thread[HSQLDB Server @750159,5,main]]: Shutting down because there are no open databases Updating the hsql version to the latest download (hsqldb_1_8_1_1.zip) fixes the first and appears to fix the second. I have successfully executed a full CI run on windows and have verified the code changes for the deadlock.