Alfresco services hanging..please help me..

[paramesh]

Hi all,
My web site using Alfresco…last few days onwards my alfresco site is hanging…and i found some errors in my alfresco log file….i did observe that after i got that error (Please look into below) my alfresco and my web site both are hanging…we deployed the website using "JBOSS 2.6.7 GA" and Alfresco version is 3.0.0…

15:00:22,521 WARN  [org.springframework.jdbc.support.SQLErrorCodesFactory] Error
while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Error while extracting
DatabaseMetaData; nested exception is java.sql.SQLNonTransientConnectionException: No current connection.
Caused by: java.sql.SQLNonTransientConnectionException: No current connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.getMetaData(Unknown Source)
        at org.apache.commons.dbcp.DelegatingConnection.getMetaData(DelegatingConnection.java:247)
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.
getMetaData(PoolingDataSource.java:231)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)
        at $Proxy63.getMetaData(Unknown Source)
        at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:189)
        at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:224)
        at org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:214)
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.s
etDataSource(SQLErrorCodeSQLExceptionTranslator.java:133)
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.<
init>(SQLErrorCodeSQLExceptionTranslator.java:98)
        at org.springframework.orm.hibernate3.SessionFactoryUtils.newJdbcExcepti
onTranslator(SessionFactoryUtils.java:143)
        at org.springframework.orm.hibernate3.HibernateAccessor.getDefaultJdbcEx
ceptionTranslator(HibernateAccessor.java:453)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernate
AccessException(HibernateAccessor.java:410)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:377)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getCh
ildAssocs(HibernateNodeDaoServiceImpl.java:2014)
        at sun.reflect.GeneratedMethodAccessor407.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:177)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
        at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:68)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invoke(DirtySessionMethodInterceptor.java:381)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy2.getChildAssocs(Unknown Source)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.getChildAssocs(DbNodeServceImpl.java:1376)
        at sun.reflect.GeneratedMethodAccessor235.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:177)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:144)
        at org.alfresco.repo.transaction.SingleEntryTransactionResourceIntercept
or.invokeInternal(SingleEntryTransactionResourceInterceptor.java:163)
at org.alfresco.repo.transaction.SingleEntryTransactionResourceIntercept
or.invoke(SingleEntryTransactionResourceInterceptor.java:138)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy7.getChildAssocs(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor235.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJonpoint(ReflectiveMethodInvocation.java:177)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
        at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy7.getChildAssocs(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor235.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvoc
ationHandler.invoke(StoreRedirectorProxyFactory.java:221)
        at $Proxy8.getChildAssocs(Unknown Source)
        at org.alfresco.repo.search.DocumentNavigator.getChildAxisIterator(DocumentNavigator.java:423)
        at org.jaxen.expr.iter.IterableChildAxis.namedAccessIterator(IterableChildAxis.java:105)
        at org.jaxen.expr.DefaultNameStep.evaluate(DefaultNameStep.java:187)
        at org.jaxen.expr.DefaultLocationPath.evaluate(DefaultLocationPath.java:154)
        at org.jaxen.expr.DefaultXPathExpr.asList(DefaultXPathExpr.java:112)
        at org.jaxen.BaseXPath.selectNodesForContext(BaseXPath.java:688)
        at org.jaxen.BaseXPath.selectNodes(BaseXPath.java:227)
        at org.alfresco.repo.search.NodeServiceXPath.selectNodes(NodeServiceXPath.java:195)
        at org.alfresco.repo.search.impl.NodeSearcher.selectNodes(NodeSearcher.java:138)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.selectNodes(ADMLuceneSearcherImpl.java:652)
        at org.alfresco.repo.search.SearcherComponent.selectNodes(SearcherComponent.java:108)
        at org.alfresco.repo.search.AbstractSearcherComponent.selectNodes(AbstractSearcherComponent.java:77)
        at sun.reflect.GeneratedMethodAccessor480.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:177)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:144)
        at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInter
ceptor.invoke(MethodSecurityInterceptor.java:80)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:275)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy20.selectNodes(Unknown Source)
        at org.alfresco.web.bean.repository.User$1.execute(User.java:246)
        at org.alfresco.web.bean.repository.User$1.execute(User.java:227)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)
        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(AutheticationHelper.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(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        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)
Caused by: java.sql.SQLException: No current connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
        … 120 more
15:00:28,599 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failed
java.sql.SQLNonTransientConnectionException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source)
        at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)
        at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
        at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doRoll
back(HibernateTransactionManager.java:594)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.processRollback(AbstractPlatformTransactionManager.java:753)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.rollback(AbstractPlatformTransactionManager.java:730)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
        at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTran
sactionAfterThrowing(SpringAwareUserTransaction.java:561)
        at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(Spr
ingAwareUserTransaction.java:531)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransacti
on(RetryingTransactionHelper.java:388)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransacti
on(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(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        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)
Caused by: java.sql.SQLException: No current connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransport
AcrossDRDA(Unknown Source)
        … 42 more
15:00:28,601 WARN  [org.springframework.jdbc.support.SQLErrorCodesFactory] Error
while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Error while extracting
DatabaseMetaData; nested exception is java.sql.SQLNonTransientConnectionExcepti
on: No current connection.
Caused by: java.sql.SQLNonTransientConnectionException: No current connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.getMetaData(Unknown Source)
        at org.apache.commons.dbcp.DelegatingConnection.getMetaData(DelegatingConnection.java:247)
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.
getMetaData(PoolingDataSource.java:231)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)
        at $Proxy63.getMetaData(Unknown Source)
        at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:189)
        at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:224)
        at org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(QLErrorCodesFactory.java:214)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.s
etDataSource(SQLErrorCodeSQLExceptionTranslator.java:133)
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.<
init>(SQLErrorCodeSQLExceptionTranslator.java:98)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.getDef
aultJdbcExceptionTranslator(HibernateTransactionManager.java:738)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.conver
tHibernateAccessException(HibernateTransactionManager.java:712)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doRoll
back(HibernateTransactionManager.java:601)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.processRollback(AbstractPlatformTransactionManager.java:753)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.rollback(AbstractPlatformTransactionManager.java:730)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
        at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTran
sactionAfterThrowing(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.doInTransactin(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(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
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.java845)
        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)
Caused by: java.sql.SQLException: No current connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
        … 52 more
15:00:28,602 ERROR [org.alfresco.util.transaction.SpringAwareUserTransaction] Ap
plication exception overridden by rollback exceptionjava.lang.Exception
        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.java224)
        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)

15:00:28,603 ERROR [org.alfresco.repo.transaction.RetryingTransactionHelper] Rol
lback failure.  Normal retry behaviour will resume.
org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: Cannot r
elease connection; uncategorized SQLException for SQL [???]; SQL state [null]; e
rror code [0]; Already closed.; nested 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$PoolGuardConnectionWrapperclose(PoolingDataSource.java:180)
        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.
closeConnection(LocalDataSourceConnectionProvider.java:95)
        at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:451)
        at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:406)

15:00:37,807 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failed
java.sql.SQLNonTransientConnectionException: No current connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source)
        at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.
ollback(PoolingDataSource.java:288)
        at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
        at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:594)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.processRollback(AbstractPlatformTransactionManager.java:753)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.rollback(AbstractPlatformTransactionManager.java:730)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
15:00:37,808 ERROR [org.alfresco.util.transaction.SpringAwareUserTransaction] Ap
plication exception overridden by rollback exceptionjava.lang.Exception
        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.java224)
        at org.alfresco.web.bean.repository.User.getPreferences(User.java:206)
        at org.alfresco.web.bean.repository.PreferencesService.getPreferences(Pr
eferencesService.java:71)
15:00:37,809 ERROR [org.alfresco.repo.transaction.RetryingTransactionHelper] Rol
lback failure.  Normal retry behaviour will resume.
org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: Cannot r
elease connection; uncategorized SQLException for SQL [???]; SQL state [null]; e
rror code [0]; Already closed.; nested 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.

Please help me to solve this issue…..it is happening frequently twice or  thrice a day..please help me..
Thanks in advance..

[afaust]

Hello,

you are using Derby as your database. This is not a supported database for the current Alfresco version, but I do not know, if this was the case for Alfresco 3.0.0 (which is quite old). It might by that you suffer from this: https://issues.apache.org/jira/browse/DERBY-3379

Generally, I'd advise to consider upgrading / updating your software stack. JBoss 2.x is quite old as well and who knows what other components might contain some potential, long fixed errors / bugs…

Regards
Axel

[paramesh]

Hello,

you are using Derby as your database. This is not a supported database for the current Alfresco version, but I do not know, if this was the case for Alfresco 3.0.0 (which is quite old). It might by that you suffer from this: https://issues.apache.org/jira/browse/DERBY-3379

Generally, I'd advise to consider upgrading / updating your software stack. JBoss 2.x is quite old as well and who knows what other components might contain some potential, long fixed errors / bugs…

Regards
Axel

Dear Sir,

Is there any solution except upgrading…because it been running from last four years…

Thank you.

[afaust]

Hello,

upgrading is an advice and not a must, since I have not the necessary information to judge it as such. At the least, you should consider upgrading your Derby components, as the issue linked is very similar to what you experience and should be fixed in a newer version.

Regards
Axel

[mrogers]

If you don't want to migrate or upgrade you will need to figure out what's gone wrong with your database.   There's no information in your posting that helps diagnose your problem.   All that can be said is that you have some sort of  database problem.

[paramesh]

If you don't want to migrate or upgrade you will need to figure out what's gone wrong with your database.   There's no information in your posting that helps diagnose your problem.   All that can be said is that you have some sort of  database problem.

Dear Sir,

I have checked the derby.log file and i found some error in it.

Cleanup action completed
2012-08-10 08:02:39.198 GMT Thread[http-8082-35,5,main] (XID = 42207274), (SESSI
ONID = 131), (DATABASE = /u01/Alfresco/alf_data/derby_data/alfresco), (DRDAID =
null), Cleanup action starting
2012-08-10 08:02:39.198 GMT Thread[http-8082-35,5,main] (XID = 42207274), (SESSI
ONID = 131), (DATABASE = /u01/Alfresco/alf_data/derby_data/alfresco), (DRDAID =
null), Failed Statement is: select childassoc0_.id as col_0_0_, childassoc0_.typ
e_qname_id as col_1_0_, childassoc0_.qname_ns_id as col_2_0_, childassoc0_.qname
_localname as col_3_0_, childassoc0_.is_primary as col_4_0_, childassoc0_.assoc_
index as col_5_0_, nodeimpl2_.id as col_6_0_, storeimpl3_.protocol as col_7_0_,
storeimpl3_.identifier as col_8_0_, nodeimpl2_.uuid as col_9_0_ from alf_child_a
ssoc childassoc0_ inner join alf_node nodeimpl1_ on childassoc0_.parent_node_id=
nodeimpl1_.id inner join alf_node nodeimpl2_ on childassoc0_.child_node_id=nodei
mpl2_.id inner join alf_store storeimpl3_ on nodeimpl2_.store_id=storeimpl3_.id
where nodeimpl1_.id=? and childassoc0_.qname_ns_id=? and childassoc0_.qname_loca
lname=? order by childassoc0_.assoc_index, childassoc0_.id with 3 parameters beg
in parameter #1: 197057 :end parameter begin parameter #2: 65542 :end parameter
begin parameter #3: preferences :end parameter
java.lang.OutOfMemoryError: GC overhead limit exceeded
        at org.apache.derby.impl.services.locks.ConcurrentLockSet$Entry.<init>(U
nknown Source)
        at org.apache.derby.impl.services.locks.ConcurrentLockSet$Entry.<init>(U
nknown Source)
        at org.apache.derby.impl.services.locks.ConcurrentLockSet.getEntry(Unkno
wn Source)
        at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unk
nown Source)
        at org.apache.derby.impl.services.locks.AbstractPool.lockObject(Unknown
Source)
        at org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(Unknow
n Source)
        at org.apache.derby.impl.store.raw.xact.RowLocking2.lockRecordForRead(Un


If you want more details please let me know i will provide you..

Thank you..

[afaust]

Hello,

this indicates that either a) your Derby has a memory leak and runs full of memory, or b) due to size / transactional data set, the memory alloted to your Derby instance is not enough. An alternative scenario c) could be that the settings for GC are not optimal and may cause an unstable JVM in certain conditions - but this is difficult to say without extensive analysis.

You should check your Derby JVM settings and adjust the max heap size as a short term solution to a) / long term adaption to b). In order to determine wether a) is the case, you would need to profile / analyze the Derby JVM memory usage.

Regards
Axel

[paramesh]

Hello,

this indicates that either a) your Derby has a memory leak and runs full of memory, or b) due to size / transactional data set, the memory alloted to your Derby instance is not enough. An alternative scenario c) could be that the settings for GC are not optimal and may cause an unstable JVM in certain conditions - but this is difficult to say without extensive analysis.

You should check your Derby JVM settings and adjust the max heap size as a short term solution to a) / long term adaption to b). In order to determine wether a) is the case, you would need to profile / analyze the Derby JVM memory usage.

Regards
Axel

Dear Sir,
Could you please let me know how adjust the heap size for DERBY DATABASE..i know how to change the heap size for Alfresco("JAVA_OPTS=") in "./alfresco.sh" file but i do not know for DERBY please tell me how do so…or is there any way to free up the derby memory..

Thank You..

[afaust]

Hello,

this depends on how you have deployed / setup Derby. Basically, it is the same parameters used to increase heap for Alfresco (since both run in a JVM).
An example can be found via http://lmgtfy.com/?q=apache+derby+heap+size

Regards
Axel