[jboss-user] [JCA] - Question for the ResourceException: Interrupted while requesting permit! Waited 0 ms

nie feng do-not-reply at jboss.com
Fri Sep 24 09:14:18 EDT 2010


nie feng [http://community.jboss.org/people/niefeng] created the discussion

"Question for the ResourceException: Interrupted while requesting permit! Waited 0 ms"

To view the discussion, visit: http://community.jboss.org/message/563541#563541

--------------------------------------------------------------
Hi all,

I am observing the error +"ResourceException: Interrupted while requesting permit! Waited 0 ms"+ in the peer node in the cluster when main node (the first node started in the cluster) is crashed unexpectedly.

The detail stack trace as follow

org.jboss.util.NestedSQLException: Interrupted while requesting permit! Waited 0 ms; - nested throwable: (javax.resource.ResourceException: Interrupted while requesting permit! Waited 0 ms)
    at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
 
Caused by: javax.resource.ResourceException: Interrupted while requesting permit! Waited 0 ms
    at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:312)
    at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:613)
    at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
    at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)
    at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
    at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
    at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
    ... 154 more


I am using JBOSS 4.2.3 GA, and the cluster is consisting of 2 nodes. The DB i am using is postgres 8.4.4 and i am using a Fedora 8 box.

I have read the thread ( http://community.jboss.org/message/150841#150841 http://community.jboss.org/message/150841) and it mentioned the error is related to the transaction time out, and it suggested that to include the option <blocking-timeout-millis> in the ds.xml. I still observing such error even after such option is enable in my db ds file.


<!--DS -->
  <local-tx-datasource>
    <jndi-name>dbdatasource</jndi-name>
    <connection-url>jdbc:postgresql://localhost:35432/myPgsql</connection-url>
    <driver-class>org.postgresql.Driver</driver-class>
    <user-name>postgres</user-name>
    <password>XXXXX</password>
    <min-pool-size>10</min-pool-size>
    <max-pool-size>40</max-pool-size>
    <idle-timeout-minutes>15</idle-timeout-minutes>
    <blocking-timeout-millis>400000</blocking-timeout-millis>
        <!-- sql to call when connection is created.  Can be anything, select 1 is valid for PostgreSQL
        <new-connection-sql>select 1</new-connection-sql>
        -->


        <!-- sql to call on an existing pooled connection when it is obtained from pool.  Can be anything, select 1 is valid for PostgreSQL
        <check-valid-connection-sql>select 1</check-valid-connection-sql>
        -->


      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
      <metadata>
         <type-mapping>PostgreSQL 7.2</type-mapping>
      </metadata>
  </local-tx-datasource>

Could it be my configuration is wrong? or what are the additional configuration i need to specify?

Regards
Niefeng
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/563541#563541]

Start a new discussion in JCA at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2098]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100924/43884223/attachment.html 


More information about the jboss-user mailing list