Hi, Our EJB app contains a servlet which runs a number of daemon threads on startup. Threads access entity beans that use common JDBC connections pool. I'm observing strange problems in the following scenario: - daemon calls entity bean finder - (due to our bug) finder generates NPE and fails As far as I can see it all happens without a TX context, so there's nothing to rollback. - another daemon thread tries to get a connection from the pool but hits "Transaction is not active". It looks like some connection in the pool gets 'broken', daemon threads can't ever get DB connections after this. Here's a relevant stack trace: anonymous wrote : | 2006-12-27 14:43:29,158 ERROR [jb.plugins.LogInterceptor] TransactionRolledbackException in method: public abstract java.util.Collection com.supportwizard.dml.interfaces.SWRecordHome.findByTableAndFieldValue(com.supportwizard.seance.Seance,java.lang.Long,java.lang.String,java.lang.Object) throws javax.ejb.FinderException,java.rmi.RemoteException, causedBy: | java.lang.NullPointerException | at java.lang.StringBuffer.(StringBuffer.java:104) | at com.supportwizard.db.SQLBase.prepareColumnName(SQLBase.java:179) | at com.supportwizard.db.SQLBase.prepareWhere(SQLBase.java:100) | at com.supportwizard.db.SQLText_mysql.getQueryText(SQLText_mysql.java:133) | at com.supportwizard.db.SQLText.getQueryText(SQLText.java:121) | at com.supportwizard.db.SWInternal_SQL.sqlQuery(SWInternal_SQL.java:470) | at com.supportwizard.db.SWInternal_SQL.sqlQuery(SWInternal_SQL.java:447) | at com.supportwizard.utils.ejb.SWBMPEntityBean.genericMultiFind(SWBMPEntityBean.java:957) | at com.supportwizard.utils.ejb.SWBMPEntityBean.genericMultiFind(SWBMPEntityBean.java:920) | at com.supportwizard.utils.ejb.SWBMPEntityBean.genericMultiFind(SWBMPEntityBean.java:865) | at com.supportwizard.utils.ejb.SWBMPEntityBean.genericMultiFind(SWBMPEntityBean.java:834) | at com.supportwizard.dml.ejb.SWRecordBean.ejbFindByTableAndFieldValues(SWRecordBean.java:447) | at com.supportwizard.dml.ejb.SWRecordBean.ejbFindByTableAndFieldValue(SWRecordBean.java:401) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:585) | at org.jboss.ejb.plugins.BMPPersistenceManager.callFinderMethod(BMPPersistenceManager.java:632) | at org.jboss.ejb.plugins.BMPPersistenceManager.findEntities(BMPPersistenceManager.java:335) | at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(CachedConnectionInterceptor.java:242) | at org.jboss.ejb.EntityContainer.find(EntityContainer.java:706) | at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:585) | at org.jboss.invocation.Invocation.performCall(Invocation.java:359) | at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1130) | at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:203) | at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:189) | at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:105) | at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:134) | at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:76) | at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:43) | at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:125) | at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:378) | at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:161) | at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:145) | at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:132) | at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:107) | at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:514) | at org.jboss.ejb.Container.invoke(Container.java:975) | at sun.reflect.GeneratedMethodAccessor174.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:585) | at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) | at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) | at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) | at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169) | at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118) | at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:206) | at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:192) | at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61) | at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70) | at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:184) | at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100) | at $Proxy1164.findByTableAndFieldValue(Unknown Source) | at com.supportwizard.swmail.daemon.UserHelper.getUserIdByEmailColumns(UserHelper.java:208) | at com.supportwizard.swmail.daemon.UserHelper.getUserIdByEmailAndProject(UserHelper.java:181) | at com.supportwizard.swmail.daemon.EmailDaemon.processIncomingMail(EmailDaemon.java:243) | at com.supportwizard.swmail.daemon.EmailDaemon.run(EmailDaemon.java:784) | at com.supportwizard.swmail.daemon.manager.TaskCarrier.run(TaskCarrier.java:84) | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) | at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280) | at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135) | at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65) | at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142) | at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166) | at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) | at java.lang.Thread.run(Thread.java:595) | 2006-12-27 14:43:29,163 ERROR [.InboundEmailFilterHelper] Delete not accepted | 2006-12-27 14:43:29,168 WARN [swmail.daemon.EmailDaemon] Checking email failed | com.supportwizard.utils.SWRuntimeException: com.supportwizard.db.SW_SQLException: Exception in DBConnect | at com.supportwizard.swmail.MailStorageBase.dbConnect(MailStorageBase.java:40) | at com.supportwizard.swmail.ReceivedMailsStorage.delete(ReceivedMailsStorage.java:221) | at com.supportwizard.swmail.daemon.EmailDaemon.run(EmailDaemon.java:785) | at com.supportwizard.swmail.daemon.manager.TaskCarrier.run(TaskCarrier.java:84) | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) | at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280) | at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135) | at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65) | at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142) | at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166) | at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) | at java.lang.Thread.run(Thread.java:595) | Caused by: com.supportwizard.db.SW_SQLException: Exception in DBConnect | at com.supportwizard.db.SWInternal_SQL.dbConnect(SWInternal_SQL.java:263) | at com.supportwizard.db.SWInternal_SQL.dbConnect(SWInternal_SQL.java:213) | at com.supportwizard.swmail.MailStorageBase.dbConnect(MailStorageBase.java:37) | ... 12 more | Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=server7/3995, BranchQual=, localId=3995]; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=server7/3995, BranchQual=, localId=3995]) | at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94) | at com.supportwizard.db.SWInternal_SQL.dbConnect(SWInternal_SQL.java:253) | ... 14 more | Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=server7/3995, BranchQual=, localId=3995] | at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:290) | at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:379) | at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:812) | at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88) | ... 15 more | The first 'TransactionRolledBack' message makes me think that in fact there is a transaction, but I can't find where it is created. UserTransaction isn't used anywhere, SWRecordBean finders are marked as 'Supports'. Of course we will fix this NPE, but the fact that such exception can leave connection pool in an inconsistent state really frightens me. Is it a JBoss bug or we're doing something wrong? Thanks. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3996661#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...