4 Replies Latest reply on Mar 3, 2005 11:02 AM by Anil Saldanha

    Jboss/JMS out of managed connections on java:/DefaultDS

    Zsolt Berentey Newbie

      We have a system deployed on Jboss 3.2.6 that uses JMS queues to log audit information into a database. (It uses other queues for other things as well) After some time of running, the log writer queue reports the following:

      2005-02-04 15:41:07,831 ERROR [org.jboss.security.auth.spi.DatabaseServerLoginModule] SQL failure
      org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.Reso
      urceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))

      It seems that the it has run out of hsql connections to authenticate the user (always null/null).

      Nobody uses this data source other than jboss. There is no unusual load on the system that could cause this. How can this pool run out of connections, and why does this condition last for 10 days? (after which the jboss instance has been restarted)