0 Replies Latest reply on Aug 22, 2002 6:19 AM by Feroz

    DB Error : Interrupted while requesting permit !

    Feroz Newbie

      Hi everybody,
      I faced this problem recently while stress testing an application deployed on JBoss 3.0.1 - Jetty ( on Win NT4)
      Does anyone have any idea what this means. I am trying to connect to the MySQL 3.23.51 DB using the LocalDataSource in JBoss. The thing is, that it all works perfectly fine under normal circumstances. This error comes only when I'm subjecting the application to a stress level of ~50 requests per minute for an extended period of time.
      The MySQL -service is also shown below and the stack trace. Any pointers will be greatly appreciated.

      Thanks already...
      Feroz

      -------------------------------------
      Stack Trace
      -------------------------------------

      Caused by: javax.resource.ResourceException: Interrupted while requesting permit!
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:127)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:312)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:467)
      at org.jboss.resource.connectionmanager.LocalTxConnectionManager.getManagedConnection(LocalTxConnectionManager.java:221)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:532)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:812)
      at org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:102)
      ... 43 more


      ----------------------------------------
      MySQL -service.xml contents
      ----------------------------------------


      <depends optional-attribute-name="ManagedConnectionFactoryName">

      MySqlDS


      <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://localhost:3306/dbname</config-property>
      <config-property name="DriverClass" type="java.lang.String">org.gjt.mm.mysql.Driver</config-property>
      <config-property name="UserName" type="java.lang.String">user</config-property>
      <config-property name="Password" type="java.lang.String">password</config-property>


      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper


      <depends optional-attribute-name="ManagedConnectionPool">

      0
      50
      5000
      15
      ByContainer


      <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
      <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager
      java:/TransactionManager
      jboss.jca:service=RARDeployer