Alfresco log Error

[paramesh]

Hi to all,

i found some errors in my alfresco log file…due to which my web page getting effected..i gone through some articles in google  but i am not get rid of it..if any solution would be appreciated..

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(SpringAwareUserTransaction.java:531)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.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.java:185)
        at org.alfresco.web.app.servlet.AuthenticationHelper.authenticate(AuthenticationHelper.java: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)
12:32:47,016 INFO  [org.alfresco.web.app.servlet.DownloadContentServlet] Client aborted stream re
ad:        node: workspace://SpacesStore/f2a87b91-2210-4739-94dc-ce18565901d5
        content: ContentAccessor[ contentUrl=store://2012/6/23/11/26/98e77cf9-cecf-4c23-bfe9-3e34
7ab8a8b0.bin, mimetype=application/pdf, size=190197, encoding=UTF-8, locale=en_US]
12:33:30,578 INFO  [org.alfresco.web.app.servlet.DownloadContentServlet] Client aborted stream re
ad:
node: workspace://SpacesStore/7a61f56c-c584-4a8e-8b9e-b490364e5bfd

[afaust]

Hello,

unfortunately, to solve this issue, you would need to get at the root cause of the rollback itself. This you could to by elevating the logger settings of the RetryingTransactionHelper leg level in the log4j.properties file.

By the way, it is interesting to see the same error reporting by an (alleged) alternative user via https://forums.alfresco.com/en/viewtopic.php?f=7&t=45817 - any relation to you?

Regards
Axel