[jboss-user] [JCA/JBoss] - Re: Message DB + Oracle database connection count problems

[adrian@jboss.org]

"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#4067085

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4067085