Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-29853

Fix error logged when doing a rollback on PostgreSQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 11.3
    • Fix Version/s: 11.4, 2021.0
    • Component/s: Runtime

      Description

      When doing a rollback on PostgreSQL, the following error is logged, but this doesn't prevent the application from working.

      2020-11-15 16:16:10,455 [mythread] WARN  [SwallowedExceptionLogger] An internal object pool swallowed an Exception.
      org.postgresql.util.PSQLException: Cannot rollback when autoCommit is enabled.
      	at org.postgresql.jdbc.PgConnection.rollback(PgConnection.java:895) ~[postgresql-42.2.18.jar:42.2.18]
      	at org.apache.commons.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:482) ~[commons-dbcp2-2.8.0.jar:2.8.0]
      	at org.apache.commons.dbcp2.PoolableConnectionFactory.passivateObject(PoolableConnectionFactory.java:427) ~[commons-dbcp2-2.8.0.jar:2.8.0]
      	at org.apache.commons.pool2.impl.GenericObjectPool.returnObject(GenericObjectPool.java:557) ~[commons-pool2-2.9.0.jar:2.9.0]
      	at org.apache.commons.dbcp2.PoolableConnection.close(PoolableConnection.java:203) ~[commons-dbcp2-2.8.0.jar:2.8.0]
      	at org.apache.commons.dbcp2.DelegatingConnection.closeInternal(DelegatingConnection.java:236) ~[commons-dbcp2-2.8.0.jar:2.8.0]
      	at org.apache.commons.dbcp2.DelegatingConnection.close(DelegatingConnection.java:207) ~[commons-dbcp2-2.8.0.jar:2.8.0]
      	at org.apache.commons.dbcp2.managed.ManagedConnection.close(ManagedConnection.java:111) ~[commons-dbcp2-2.8.0.jar:2.8.0]
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCConnection.closeConnection(JDBCConnection.java:152) ~[classes/:?]
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.close(JDBCMapper.java:113) ~[classes/:?]
      	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingMapper.close(SoftRefCachingMapper.java:73) ~[classes/:?]
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.closeSession(SessionImpl.java:197) ~[classes/:?]
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.close(SessionImpl.java:188) ~[classes/:?]
      	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.destroy(SQLSession.java:122) ~[classes/:?]
      	at org.nuxeo.ecm.core.repository.RepositoryService$SessionFactory.destroyObject(RepositoryService.java:398) ~[main/:?]
      	at org.nuxeo.ecm.core.repository.RepositoryService$SessionFactory.destroyObject(RepositoryService.java:1) ~[main/:?]
      	at org.apache.commons.pool2.KeyedPooledObjectFactory.destroyObject(KeyedPooledObjectFactory.java:133) ~[commons-pool2-2.9.0.jar:2.9.0]
      	at org.apache.commons.pool2.impl.GenericKeyedObjectPool.destroy(GenericKeyedObjectPool.java:1128) ~[commons-pool2-2.9.0.jar:2.9.0]
      	at org.apache.commons.pool2.impl.GenericKeyedObjectPool.invalidateObject(GenericKeyedObjectPool.java:594) ~[commons-pool2-2.9.0.jar:2.9.0]
      	at org.apache.commons.pool2.impl.GenericKeyedObjectPool.invalidateObject(GenericKeyedObjectPool.java:563) ~[commons-pool2-2.9.0.jar:2.9.0]
      	at org.apache.commons.pool2.PoolUtils$ErodingKeyedObjectPool.invalidateObject(PoolUtils.java:1694) ~[commons-pool2-2.9.0.jar:2.9.0]
      	at org.nuxeo.ecm.core.repository.RepositoryService$SessionSynchronization.afterCompletion(RepositoryService.java:365) ~[main/:?]
      	at org.apache.geronimo.transaction.manager.TransactionImpl.afterCompletion(TransactionImpl.java:559) ~[geronimo-transaction-3.1.4.jar:3.1.4]
      	at org.apache.geronimo.transaction.manager.TransactionImpl.afterCompletion(TransactionImpl.java:552) ~[geronimo-transaction-3.1.4.jar:3.1.4]
      	at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:503) ~[geronimo-transaction-3.1.4.jar:3.1.4]
      	at org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:265) ~[geronimo-transaction-3.1.4.jar:3.1.4]
      	at org.nuxeo.runtime.jtajca.NuxeoContainer$UserTransactionImpl.rollback(NuxeoContainer.java:440) ~[main/:?]
      	at org.nuxeo.runtime.transaction.TransactionHelper.commitOrRollbackTransaction(TransactionHelper.java:408) ~[main/:?]
      

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day
                  1d