2 Replies Latest reply on Sep 22, 2003 8:38 AM by Eiman Abdel-Moneim

    IdleConnectionTimeout, HSQL, DefaultDS, Log Thread creates t

    Shawn Stephens Newbie

      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