[jboss-user] [JBoss Messaging] - Re: HeuristicMixedException: cause and remedy?

Craig Watcham [http://community.jboss.org/people/watchamcb] created the discussion "Re: HeuristicMixedException: cause and remedy?" To view the discussion, visit: http://community.jboss.org/message/645319#645319 -------------------------------------------------------------- The cause of this issue in our production environment appears to be result of the maxSession attribute on the MDB being greater than the max-pool-size in the DataSource descriptor. Under heavy load the MDB was unable to retrieve a connection from the pool and would try and roll-back the transaction which would then throw HeuristicMixedException. In JBoss 4.2.2 the stack trace on the actual cause is below, issue was resolved by increasing the pool size in *-ds.xml descriptor to be greater than the MDB session size. Caused by: javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )         at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:301)         at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:538)         at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)         at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:315)         at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)         at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)         at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88) Hope this helps... -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/645319#645319] Start a new discussion in JBoss Messaging at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]