AnsweredAssumed Answered

Alfresco log Error

Question asked by paramesh on Aug 6, 2012
Latest reply on Aug 6, 2012 by afaust
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

Outcomes