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

[Kevin Conner (JIRA)]

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
             Fix For: 4.8


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 at 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 at 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 at 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira