IdleConnectionTimeout, HSQL, DefaultDS, Log Thread creates t
I am observing a connection leak with the out of the box jboss-3.2.1 server for the defaultds connection pool which points to to the Hypersonic database.
As shown in the trace below the IdleConnectionTimeout setting comes into play and the idle connections are cleaned. Before cleaning it was using Thread-55. After cleaning it starts using Thread-117 but thread 54 is never cleaned and remains in the thread list. This happens when the server is under load every 15 minutes which is the default of the IdleConnectionTimeout. I also pasted part of the Thread listing below as well as a JVM Thread trace. Thread-54 is a previously lost thread.
In the JVM trace we can see that Thread 54 is stuck in the log thread.
"Thread-54" daemon prio=1 tid=0x0x8165a10 nid=0x72d0 waiting on condition [507fe000..507fe810]
at java.lang.Thread.sleep(Native Method)
at org.hsqldb.Log.run(Unknown Source)
at java.lang.Thread.run(Thread.java:536)
2003-06-03 08:42:24,337 2124565 INFO [STDOUT] (Thread-55:) 10:COMMIT
2003-06-03 08:42:24,337 2124565 INFO [STDOUT] (Thread-55:) 10:SET AUTOCOMMIT TRUE
2003-06-03 08:42:24,724 2124952 INFO [STDOUT] (Thread-56:) 11:DISCONNECT
2003-06-03 08:42:24,724 2124952 INFO [STDOUT] (Thread-57:) 12:DISCONNECT
2003-06-03 08:42:24,725 2124953 INFO [STDOUT] (Thread-58:) 13:DISCONNECT
2003-06-03 08:42:24,725 2124953 INFO [STDOUT] (Thread-59:) 14:DISCONNECT
2003-06-03 08:42:24,728 2124956 INFO [STDOUT] (Thread-114:) 15:trying to connect user sa
2003-06-03 08:42:24,728 2124956 INFO [STDOUT] (Thread-115:) 16:trying to connect user sa
2003-06-03 08:42:24,729 2124957 INFO [STDOUT] (Thread-116:) 17:trying to connect user sa
2003-06-03 08:42:24,729 2124957 INFO [STDOUT] (Thread-117:) 18:trying to connect user sa
2003-06-03 08:42:25,836 2126064 INFO [STDOUT] (Thread-117:) 18:SET AUTOCOMMIT FALSE
2003-06-03 08:42:25,838 2126066 INFO [STDOUT] (Thread-117:) 18:INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(665,'QUEUE.cometPersistenceQueue','aced00057372001d6f72672e6a626f73732e6d712e5370794f626a6563744d6573736167657a433e68af7042b80c0000787200176f72672e6a626f73732e6d712e5370794d657373616765067bd98e2509da340c000078707a000003de020015636f6d657450657273697374656e636551756575650000000200000000000000000000000407001549443a392d31303534363437393032353935373236000000f58de9e1830109ffffffff000900000107000449443a3900000000000000037baced0005737200317379732e636f6d65742e636f6d6d6f6e2e6d6573736167652e456c656374726f6e69634a6f75726e616c4d657373616765200d32e240284d710200164c000d6163636f756e744e756d6265727400124c6a6176612f6c616e672f537472696e673b4c000f6170706c69636174696f6e5479706571007e00014c001564697370656e736564446f6c6c6172416d6f756e7471007e00014c000b66726f6d4163636f756e7471007e00014c0006686f7374494471007e00014c00106d65737361676544656c696d6974657271007e00014c000c7265636f7264466f726d617471007e00014c000b726571756573745479706571007e00014c0015726571756573746564446f6c6c6172416d6f756e7471007e00014c000c726573706f6e7365436f646571007e00014c001872657472696576616c5265666572656e63654e756d62657271007e00014c000c73657269616c4e756d62657271007e00014c000e736574746c656d656e744461746571007e00014c000f737572636861726765416d6f756e7471007e00014c001673797374656d547261636541756469744e756d62657271007e00014c000a7465726d696e616c494471007e00014c0009746f4163636f756e7471007e00014c000f7472616e73616374696f6e4461746571007e00014c00197472616e73616374696f6e53657175656e63654e756d62657271007e00014c00117472616e73616374696f6e53746174757371007e00014c000f7472616e73616374696f6e54696d6571007e00014c000f7472616e73616374696f6e5479706571007e0001787200287379732e636f6d65742e636f6d6d6f6e2e6d6573736167652e5465726d696e616c4d65737361676536ae0309bedee27b020000787200247379732e636f6d65742e6d6573736167696e672e4d657373616765436f6e7374616e7473b23791cfd641b903020001490005636f756e7478700000007e74001034333838363432323137393636373830740001307400043430303074000243527400064353504d47527400012e74000149740002353174000434303030740002303074000c303030304e5a30393738363774000e3237373835343130313835313933740008303331373230303374000331353074000630393738363774000838313737303030377400023f3f7400083033313632303033740004313438367400023030740006323032373532740002435778',NULL,'A')
2003-06-03 08:42:25,840 2126068 INFO [STDOUT] (Thread-117:) 18:COMMIT
2003-06-03 08:42:25,840 2126068 INFO [STDOUT] (Thread-117:) 18:SET AUTOCOMMIT TRUE
2003-06-03 08:42:27,320 2127548 INFO [STDOUT] (Thread-117:) 18:SET AUTOCOMMIT FALSE
2003-06-03 08:42:27,321 2127549 INFO [STDOUT] (Thread-117:) 18:INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID
Thread: Thread-54 : priority:5, demon:true
Thread: Thread-55 : priority:5, demon:true
Thread: Thread-114 : priority:5, demon:true
Thread: Thread-115 : priority:5, demon:true
Thread: Thread-116 : priority:5, demon:true
Thread: Thread-117 : priority:5, demon:true
