Rollback failure. Normal retry behaviour will resume.

[vuppalaravikant]

Hi everybody, I am getting the following error in the alfresco. Can Someone please provide the solution.


12:29:48,694 ERROR [org.alfresco.repo.transaction.RetryingTransactionHelper] Rollback failure.  N

ormal retry behaviour will resume.

org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: Cannot release connection

; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Already closed.; ne

sted exception is java.sql.SQLException: Already closed.

Caused by: java.sql.SQLException: Already closed.

        at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:77)

        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingData

Source.java:180)

        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.closeConnection(L

ocalDataSourceConnectionProvider.java:95)

        at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:451)

        at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:406)

        at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:293)

        at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:225)

        at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:174)

        at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTra

nsactionManager.java:594)

        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRoll

back(AbstractPlatformTransactionManager.java:753)

        at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(Ab

stractPlatformTransactionManager.java:730)

        at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransacti

onAfterThrowing(TransactionAspectSupport.java:332)

        at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrow

ing(SpringAwareUserTransaction.java:561)

        at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTrans

action.java:531)

        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransa

ctionHelper.java:388)

        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransa

ctionHelper.java:227)

        at org.alfresco.web.bean.repository.User.getUserPreferencesRef(User.java:224)

        at org.alfresco.web.bean.repository.User.getPreferences(User.java:206)

        at org.alfresco.web.bean.repository.PreferencesService.getPreferences(PreferencesService.

java:71)

        at org.alfresco.web.app.Application.getLanguage(Application.java:688)

        at org.alfresco.web.app.servlet.AuthenticationHelper.authenticate(AuthenticationHelper.ja

va:185)

        at org.alfresco.web.app.servlet.AuthenticationHelper.authenticate(AuthenticationHelper.ja

va:106)

        at org.alfresco.web.app.servlet.BaseServlet.servletAuthenticate(BaseServlet.java:156)

        at org.alfresco.web.app.servlet.BaseServlet.servletAuthenticate(BaseServlet.java:126)

        at org.alfresco.web.app.servlet.DownloadContentServlet.doGet(DownloadContentServlet.java:

100)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChai

n.java:290)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:2

06)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)

        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)

        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol

.java:583)

        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

        at java.lang.Thread.run(Thread.java:619)

[afaust]

Hello,

please see the answer provided in https://forums.alfresco.com/en/viewtopic.php?f=14&t=45819&p=135169#p135169.

Regards
Axel