"sks4jboss" wrote : | 19:39:12,435 ERROR [BeanLock] Saw rolled back tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=cmp2app01/47048457, BranchQual=, localId=47048457] | 19:39:12,438 ERROR [LogInterceptor] TransactionRolledbackLocalException in method: public abstract com.mobilgw.sam.definition.cp.CPDetailsDef com.mobilgw.sam.definition.cp.CPDetailsDefLocalRemote.getData(), causedBy: | java.lang.RuntimeException: Transaction marked for rollback, possibly a timeout | at org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock.doSchedule(QueuedPessimisticEJBLock.java:228) | This adds no new information. It just says the transaction was marked for rollback and guesses it was a tx timeout waiting for CMP pessimistic lock. You don't show any associated WARN about a transaction timeout for that XI which would mean it waited 5 minutes (the default). anonymous wrote : | Also we have observed that getting a queue receiver usually fails when we hit this kinda problem hits with DB. So was just thinking if it has some relation. Below is the error for queue receiver. | | anonymous wrote : | | org.jboss.mq.SpyJMSException: Error creating connection to the database.; - nested throwable: (org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))) | | | | So it waited 30 seconds for somebody to give up a connection before | throwing that error. | | You really aren't showing us any useful information. These are just the symptoms. | Both are just errors saying "I've given up waiting". | The real question is why is it waiting? | | Use "READ THIS FIRST" (logging, thread dumps), the JMX Console (e.g. CachedConnectionManager and Pool to get real stats), | and the docs! e.g. the EntityLockMonitor | | That's as far as I am going to in playing "20 questions" with you. | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4067085#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...