Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » "Transaction cannot proceed STATUS_COMMITTED" while leaving EJB container("Transaction cannot proceed STATUS_COMMITTED" while leaving EJB container)
"Transaction cannot proceed STATUS_COMMITTED" while leaving EJB container [message #1712399] Fri, 23 October 2015 15:32 Go to next message
Steffen Ewert is currently offline Steffen EwertFriend
Messages: 2
Registered: October 2015
Junior Member
Hi,

we have a problem on our productive server application. On our development and test servers we don't have this problem. On the productive system (JBoss 7.1, eclipselink 2.6.0) we get some times (not often) following exception while leaving the EJB container:

12:14:26,659 INFO  [stdout] (Thread-172) [EL Info]: 2015-10-23 12:14:26.631--ServerSession(939804344)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
12:14:26,662 INFO  [stdout] (Thread-172) Internal Exception: java.sql.SQLException: Transaction cannot proceed STATUS_COMMITTED
12:14:26,663 INFO  [stdout] (Thread-172) Error Code: 0
12:14:26,663 INFO  [stdout] (Thread-172) Call: SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)
12:14:26,664 INFO  [stdout] (Thread-172)        bind => [1 parameter bound]
12:14:26,665 INFO  [stdout] (Thread-172) Query: ReadAllQuery(name="fileVersions" referenceClass=ChangeSetFileVersion sql="SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)").
12:14:26,668 INFO  [stdout] (Thread-172) [EL Info]: 2015-10-23 12:14:26.667--ServerSession(939804344)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
12:14:26,671 INFO  [stdout] (Thread-172) Internal Exception: java.sql.SQLException: Transaction cannot proceed STATUS_COMMITTED
12:14:26,672 INFO  [stdout] (Thread-172) Error Code: 0
12:14:26,672 INFO  [stdout] (Thread-172) Call: SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)
12:14:26,673 INFO  [stdout] (Thread-172)        bind => [1 parameter bound]
12:14:26,673 INFO  [stdout] (Thread-172) Query: ReadAllQuery(name="fileVersions" referenceClass=ChangeSetFileVersion sql="SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)").
12:14:26,860 INFO  [con.xy.model.util.EMailMDB] (Thread-5818 (HornetQ-client-global-threads-1245004491)) <info@beck-projektmanagement.de> E-Mail "HNP Planserver: Es wurden neue Dokumente eingespielt" to [IT-Support@hermetic-pumpen.com] successful sent!
12:14:26,862 INFO  [con.xy.model.util.EMailMDB] (Thread-5818 (HornetQ-client-global-threads-1245004491)) <no user> Semaphore leaved (number of available free processes: 1; number of waiting processes are: 6)
12:14:26,862 INFO  [con.xy.model.util.EMailMDB] (Thread-5816 (HornetQ-client-global-threads-1245004491)) <no user> Enter Semaphore (number of available free processes: 0; number of waiting processes are: 5)
12:14:31,675 INFO  [stdout] (Thread-172) [EL Info]: 2015-10-23 12:14:31.675--ServerSession(939804344)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
12:14:31,678 INFO  [stdout] (Thread-172) Internal Exception: java.sql.SQLException: Transaction cannot proceed STATUS_COMMITTED
12:14:31,678 INFO  [stdout] (Thread-172) Error Code: 0
12:14:31,679 INFO  [stdout] (Thread-172) Call: SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)
12:14:31,680 INFO  [stdout] (Thread-172)        bind => [1 parameter bound]
12:14:31,680 INFO  [stdout] (Thread-172) Query: ReadAllQuery(name="fileVersions" referenceClass=ChangeSetFileVersion sql="SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)").
12:14:36,683 INFO  [stdout] (Thread-172) [EL Info]: 2015-10-23 12:14:36.682--ServerSession(939804344)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
12:14:36,701 INFO  [stdout] (Thread-172) Internal Exception: java.sql.SQLException: Transaction cannot proceed STATUS_COMMITTED
12:14:36,702 INFO  [stdout] (Thread-172) Error Code: 0
12:14:36,703 INFO  [stdout] (Thread-172) Call: SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)
12:14:36,704 INFO  [stdout] (Thread-172)        bind => [1 parameter bound]
12:14:36,704 INFO  [stdout] (Thread-172) Query: ReadAllQuery(name="fileVersions" referenceClass=ChangeSetFileVersion sql="SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)").
12:14:41,705 INFO  [stdout] (Thread-172) [EL Info]: 2015-10-23 12:14:41.705--ServerSession(939804344)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
12:14:41,724 INFO  [stdout] (Thread-172) Internal Exception: java.sql.SQLException: Transaction cannot proceed STATUS_COMMITTED
12:14:41,725 INFO  [stdout] (Thread-172) Error Code: 0
12:14:41,725 INFO  [stdout] (Thread-172) Call: SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)
12:14:41,727 INFO  [stdout] (Thread-172)        bind => [1 parameter bound]
12:14:41,727 INFO  [stdout] (Thread-172) Query: ReadAllQuery(name="fileVersions" referenceClass=ChangeSetFileVersion sql="SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)").
12:14:41,729 INFO  [stdout] (Thread-172) [EL Warning]: 2015-10-23 12:14:41.729--ServerSession(939804344)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
12:14:41,731 INFO  [stdout] (Thread-172) Internal Exception: java.sql.SQLException: Transaction cannot proceed STATUS_COMMITTED
12:14:41,732 INFO  [stdout] (Thread-172) Error Code: 0
12:14:41,733 INFO  [stdout] (Thread-172) Call: SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)
12:14:41,733 INFO  [stdout] (Thread-172)        bind => [1 parameter bound]
12:14:41,734 INFO  [stdout] (Thread-172) Query: ReadAllQuery(name="fileVersions" referenceClass=ChangeSetFileVersion sql="SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)")
12:14:41,736 INFO  [con.xy.model.util.EMailMDB] (Thread-5816 (HornetQ-client-global-threads-1245004491)) <info@beck-projektmanagement.de> Sending EMail "HNP Planserver: Es wurden neue Dokumente eingespielt" to [Lars.Wildbredt@carre-gmbh.de, Bernd.Fuechter@carre-gmbh.de, Juergen.Hildebrandt@carre-gmbh.de, markus.schaetzle@carre-gmbh.de] ...
12:14:41,735 WARN  [com.arjuna.ats.jta] (Thread-172) ARJUNA016029: SynchronizationImple.afterCompletion - failed for org.eclipse.persistence.transaction.JTASynchronizationListener@17ee82d8 with exception: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Transaction cannot proceed STATUS_COMMITTED
Error Code: 0
Call: SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)
        bind => [1 parameter bound]
Query: ReadAllQuery(name="fileVersions" referenceClass=ChangeSetFileVersion sql="SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)")
        at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl$1.handleException(EntityManagerSetupImpl.java:696) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.transaction.AbstractSynchronizationListener.handleException(AbstractSynchronizationListener.java:275) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.transaction.AbstractSynchronizationListener.afterCompletion(AbstractSynchronizationListener.java:242) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.transaction.JTASynchronizationListener.afterCompletion(JTASynchronizationListener.java:79) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.afterCompletion(SynchronizationImple.java:96)
        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.afterCompletion(TwoPhaseCoordinator.java:402)
        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:103)
        at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:164)
        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1165)
        at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:117)
        at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)
        at org.jboss.as.ejb3.tx.CMTTxInterceptor.endTransaction(CMTTxInterceptor.java:92) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
        at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:232) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
        at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:304) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
        at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:190) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
        at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
        at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
        at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
        at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:32) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
        at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
        at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
        at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
        at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:173) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
        at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
        at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
        at con.xy.view.fileExplorer.UploadFilesCtlrBean$$$view95.moveFiles(Unknown Source) [c-onXYModel.jar:2.3 Build 1300]
        at con.xy.vaadin.fileExplorer.UploadFilesView.updateModelValues(UploadFilesView.java:926) [c-onXYVaadin.jar:2.3 Build 1300]
        at con.xy.vaadin.util.XYViewComponent.doOk(XYViewComponent.java:411) [c-onXYVaadin.jar:2.3 Build 1300]
        at con.xy.vaadin.util.XYViewComponent.access$000(XYViewComponent.java:41) [c-onXYVaadin.jar:2.3 Build 1300]
        at con.xy.vaadin.util.XYViewComponent$DoOkWorker.workOutThread(XYViewComponent.java:668) [c-onXYVaadin.jar:2.3 Build 1300]
        at con.xy.vaadin.util.ThreadSwitcher.run(ThreadSwitcher.java:40) [c-onXYVaadin.jar:2.3 Build 1300]
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Transaction cannot proceed STATUS_COMMITTED
Error Code: 0
Call: SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)
        bind => [1 parameter bound]
Query: ReadAllQuery(name="fileVersions" referenceClass=ChangeSetFileVersion sql="SELECT id, closed, changeSetID, dfFileVersionID FROM File.CHANGESETFILEVERSION WHERE (changeSetID = ?)")
        at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1611) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:674) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1991) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2738) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2691) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:495) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1168) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1127) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:403) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:3203) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1793) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.AbstractSession.retryQuery(AbstractSession.java:1863) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.retryQuery(DatabaseSessionImpl.java:999) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1829) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.AbstractSession.retryQuery(AbstractSession.java:1863) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.retryQuery(DatabaseSessionImpl.java:999) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1829) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.AbstractSession.retryQuery(AbstractSession.java:1863) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.retryQuery(DatabaseSessionImpl.java:999) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1829) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.AbstractSession.retryQuery(AbstractSession.java:1863) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.retryQuery(DatabaseSessionImpl.java:999) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1829) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1775) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:129) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:116) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:89) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.indirection.IndirectList.buildDelegate(IndirectList.java:252) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.indirection.IndirectList.getDelegate(IndirectList.java:423) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.indirection.IndirectList.size(IndirectList.java:761) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.queries.CollectionContainerPolicy.sizeFor(CollectionContainerPolicy.java:177) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.mappings.CollectionMapping.mergeIntoObject(CollectionMapping.java:1520) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.descriptors.ObjectBuilder.mergeIntoObject(ObjectBuilder.java:4128) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.descriptors.ObjectBuilder.mergeChangesIntoObject(ObjectBuilder.java:4061) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.MergeManager.mergeChangesOfWorkingCopyIntoOriginal(MergeManager.java:884) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.MergeManager.mergeChangesOfWorkingCopyIntoOriginal(MergeManager.java:698) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.MergeManager.mergeChanges(MergeManager.java:309) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.mergeChangesIntoParent(UnitOfWorkImpl.java:3280) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.mergeChangesIntoParent(RepeatableWriteUnitOfWork.java:376) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.mergeClonesAfterCompletion(UnitOfWorkImpl.java:3412) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.transaction.AbstractSynchronizationListener.afterCompletion(AbstractSynchronizationListener.java:217) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        ... 35 more
Caused by: java.sql.SQLException: Transaction cannot proceed STATUS_COMMITTED
        at org.jboss.jca.adapters.jdbc.WrapperDataSource.checkTransactionActive(WrapperDataSource.java:240)
        at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransactionActive(WrappedConnection.java:1599)
        at org.jboss.jca.adapters.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:1614)
        at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1588)
        at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:397)
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1556) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1505) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:778) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:619) [eclipselink.jar:2.5.1.v20130918-f2b9fc5]
        ... 81 more

12:14:41,792 WARN  [com.arjuna.ats.arjuna] (Thread-172) ARJUNA012127: TwoPhaseCoordinator.afterCompletion - returned failure for SynchronizationImple< 0:ffff92002463:-41a463bf:5625176d:1d176, org.eclipse.persistence.transaction.JTASynchronizationListener@17ee82d8 >


Seems that there was execute a SELECT statement AFTER the transaction was closed.

Anybody knows what can cause this?

Thanks,
Steffen
Re: "Transaction cannot proceed STATUS_COMMITTED" while leaving EJB container [message #1713069 is a reply to message #1712399] Fri, 30 October 2015 15:02 Go to previous messageGo to next message
Chris Delahunt is currently offline Chris DelahuntFriend
Messages: 1389
Registered: July 2009
Senior Member
The stack shows that EclipseLink is attempting to merge changes to a collection/list with indirection on it into the shared cache. Oddly, the collection in the shared cache has not been fetched, and the merge is triggering it.

This might occur if the entity/object in the shared cache was refreshed, causing its indirectList to be reset. I suspect that this is a bug though, as EclipseLink shouldn't need to merge if indirection hasn't already been triggered - the next access to the list will bring in the changes anyway.

Please try the latest version (2.5.2 or 2.6) and file a bug if it still occurs. A workaround might be to provide a non-transactional datasource so that EclipseLInk can perform the read outside of the transaction scope, though I hope someone else might come up with something better.
Re: "Transaction cannot proceed STATUS_COMMITTED" while leaving EJB container [message #1713136 is a reply to message #1713069] Sun, 01 November 2015 10:11 Go to previous message
Steffen Ewert is currently offline Steffen EwertFriend
Messages: 2
Registered: October 2015
Junior Member
Thanks for your response!

After the bug occurres the first time we had already switch to the newest eclipselink (2.6.0). But seems that the bug is still there ...

I have add a bug item to eclipselink: https://bugs.eclipse.org/bugs/show_bug.cgi?id=481185

Another idea for a workaround is to load all items of all indirect lists loaded within the current transaction before the EJB container was leaved ... We will check this the next days.

[Updated on: Sun, 01 November 2015 10:11]

Report message to a moderator

Previous Topic:Translated SQL is null
Next Topic:Where is the Mapping Workbench in 2.6 ?
Goto Forum:
  


Current Time: Fri Oct 11 15:16:45 GMT 2024

Powered by FUDForum. Page generated in 0.06347 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top