Hi
I have alfresco community 4.0.d. It was working fine for a month but today I am getting following errors in the alfresco log whenever I start the alfresco.
2012-07-02 12:40:06,065 WARN [jdbc.support.SQLErrorCodesFactory] [DefaultScheduler_Worker-7] Error while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.postgresql.util.PSQLException: This connection has been closed.
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:296)
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:320)
at org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:213)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setDataSource(SQLErrorCodeSQLExceptionTranslator.java:141)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.<init>(SQLErrorCodeSQLExceptionTranslator.java:104)
at org.mybatis.spring.MyBatisExceptionTranslator.initExceptionTranslator(MyBatisExceptionTranslator.java:84)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:70)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
at $Proxy6.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)
at org.alfresco.repo.domain.locks.ibatis.LockDAOImpl.getLockResource(LockDAOImpl.java:63)
at org.alfresco.repo.domain.locks.AbstractLockDAOImpl.getLock(AbstractLockDAOImpl.java:79)
at org.alfresco.repo.lock.JobLockServiceImpl$4.execute(JobLockServiceImpl.java:449)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc4.Jdbc4Connection.getMetaData(Jdbc4Connection.java:54)
at org.apache.commons.dbcp.DelegatingConnection.getMetaData(DelegatingConnection.java:345)
at org.apache.commons.dbcp.DelegatingConnection.getMetaData(DelegatingConnection.java:345)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getMetaData(PoolingDataSource.java:245)
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 $Proxy5.getMetaData(Unknown Source)
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:285)
… 22 more
2012-07-02 12:40:06,066 ERROR [hibernate.transaction.JDBCTransaction] [DefaultScheduler_Worker-7] JDBC rollback failed
org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
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:676)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411)
at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:567)
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2012-07-02 12:40:06,071 ERROR [post.lookup.PostLookup] [DefaultScheduler_Worker-10] Exception during update of posts
org.springframework.dao.DataAccessResourceFailureException:
### Error querying database. Cause: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
### The error may involve alfresco.activities.select_activity_posts_by_status-Inline
### The error occurred while setting parameters
### Cause: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
; SQL []; An I/O error occured while sending to the backend.; nested exception is org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
at $Proxy6.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:189)
at org.alfresco.repo.domain.activities.ibatis.ActivityPostDAOImpl.selectPosts(ActivityPostDAOImpl.java:43)
at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:140)
at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:283)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:39)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:120)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:75)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:75)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:69)
at sun.reflect.GeneratedMethodAccessor265.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)
… 7 more
Caused by: java.net.SocketException: Connection reset by peer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
at org.postgresql.core.PGStream.flush(PGStream.java:523)
at org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1142)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:256)
… 24 more
2012-07-02 12:40:06,066 ERROR [hibernate.transaction.JDBCTransaction] [AlfrescoJbpmJobExecutor:172.16.3.74:1] JDBC rollback failed
org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
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:676)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411)
at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:567)
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.getExecutorLock(AlfrescoJobExecutorThread.java:370)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.access$200(AlfrescoJobExecutorThread.java:52)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:115)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:106)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:259)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.acquireJobs(AlfrescoJobExecutorThread.java:104)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:54)
2012-07-02 12:40:06,073 ERROR [util.transaction.SpringAwareUserTransaction] [DefaultScheduler_Worker-7] Application exception overridden by rollback exception
java.lang.Exception
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2012-07-02 12:40:06,073 ERROR [util.transaction.SpringAwareUserTransaction] [AlfrescoJbpmJobExecutor:172.16.3.74:1] Application exception overridden by rollback exception
java.lang.Exception
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.getExecutorLock(AlfrescoJobExecutorThread.java:370)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.access$200(AlfrescoJobExecutorThread.java:52)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:115)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:106)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:259)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.acquireJobs(AlfrescoJobExecutorThread.java:104)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:54)
2012-07-02 12:40:06,077 ERROR [repo.transaction.RetryingTransactionHelper] [DefaultScheduler_Worker-7] Rollback failure. Normal retry behaviour will resume.
org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:679)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411)
at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:567)
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: org.hibernate.TransactionException: JDBC rollback failed
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:676)
… 15 more
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
… 16 more
2012-07-02 12:40:06,077 ERROR [repo.transaction.RetryingTransactionHelper] [AlfrescoJbpmJobExecutor:172.16.3.74:1] Rollback failure. Normal retry behaviour will resume.
org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:679)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411)
at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:567)
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.getExecutorLock(AlfrescoJobExecutorThread.java:370)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.access$200(AlfrescoJobExecutorThread.java:52)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:115)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:106)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:259)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.acquireJobs(AlfrescoJobExecutorThread.java:104)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:54)
Caused by: org.hibernate.TransactionException: JDBC rollback failed
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:676)
… 17 more
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
… 18 more
2012-07-02 12:40:06,097 ERROR [hibernate.transaction.JDBCTransaction] [DefaultScheduler_Worker-7] JDBC rollback failed
org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
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:676)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411)
at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:567)
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2012-07-02 12:40:06,097 ERROR [hibernate.transaction.JDBCTransaction] [AlfrescoJbpmJobExecutor:172.16.3.74:1] JDBC rollback failed
org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
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:676)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411)
at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:567)
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.getExecutorLock(AlfrescoJobExecutorThread.java:370)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.access$200(AlfrescoJobExecutorThread.java:52)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:115)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:106)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:259)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.acquireJobs(AlfrescoJobExecutorThread.java:104)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:54)
2012-07-02 12:40:06,098 ERROR [util.transaction.SpringAwareUserTransaction] [DefaultScheduler_Worker-7] Application exception overridden by rollback exception
java.lang.Exception
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2012-07-02 12:40:06,098 ERROR [repo.transaction.RetryingTransactionHelper] [DefaultScheduler_Worker-7] Rollback failure. Normal retry behaviour will resume.
org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:679)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411)
at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:567)
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: org.hibernate.TransactionException: JDBC rollback failed
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:676)
… 15 more
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
… 16 more
2012-07-02 12:40:06,098 ERROR [util.transaction.SpringAwareUserTransaction] [AlfrescoJbpmJobExecutor:172.16.3.74:1] Application exception overridden by rollback exception
java.lang.Exception
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.getExecutorLock(AlfrescoJobExecutorThread.java:370)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.access$200(AlfrescoJobExecutorThread.java:52)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:115)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:106)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:259)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.acquireJobs(AlfrescoJobExecutorThread.java:104)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:54)
2012-07-02 12:40:06,098 ERROR [repo.transaction.RetryingTransactionHelper] [AlfrescoJbpmJobExecutor:172.16.3.74:1] Rollback failure. Normal retry behaviour will resume.
org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:679)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411)
at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:567)
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.getExecutorLock(AlfrescoJobExecutorThread.java:370)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.access$200(AlfrescoJobExecutorThread.java:52)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:115)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:106)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:259)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.acquireJobs(AlfrescoJobExecutorThread.java:104)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:54)
Caused by: org.hibernate.TransactionException: JDBC rollback failed
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:676)
… 17 more
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
… 18 more
2012-07-02 12:40:06,108 ERROR [hibernate.transaction.JDBCTransaction] [DefaultScheduler_Worker-7] JDBC rollback failed
org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
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:676)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411)
at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:567)
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2012-07-02 12:40:06,108 ERROR [util.transaction.SpringAwareUserTransaction] [DefaultScheduler_Worker-7] Application exception overridden by rollback exception
java.lang.Exception
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2012-07-02 12:40:06,108 ERROR [repo.transaction.RetryingTransactionHelper] [DefaultScheduler_Worker-7] Rollback failure. Normal retry behaviour will resume.
org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:679)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411)
at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:567)
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: org.hibernate.TransactionException: JDBC rollback failed
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:676)
… 15 more
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
… 16 more
2012-07-02 12:40:06,109 ERROR [hibernate.transaction.JDBCTransaction] [AlfrescoJbpmJobExecutor:172.16.3.74:1] JDBC rollback failed
org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
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:676)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411)
at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:567)
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.getExecutorLock(AlfrescoJobExecutorThread.java:370)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.access$200(AlfrescoJobExecutorThread.java:52)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:115)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:106)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:259)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.acquireJobs(AlfrescoJobExecutorThread.java:104)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:54)
2012-07-02 12:40:06,109 ERROR [util.transaction.SpringAwareUserTransaction] [AlfrescoJbpmJobExecutor:172.16.3.74:1] Application exception overridden by rollback exception
java.lang.Exception
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.getExecutorLock(AlfrescoJobExecutorThread.java:370)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.access$200(AlfrescoJobExecutorThread.java:52)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:115)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:106)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:259)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.acquireJobs(AlfrescoJobExecutorThread.java:104)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:54)
2012-07-02 12:40:06,109 ERROR [repo.transaction.RetryingTransactionHelper] [AlfrescoJbpmJobExecutor:172.16.3.74:1] Rollback failure. Normal retry behaviour will resume.
org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:679)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411)
at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:567)
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.getExecutorLock(AlfrescoJobExecutorThread.java:370)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.access$200(AlfrescoJobExecutorThread.java:52)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:115)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread$1.execute(AlfrescoJobExecutorThread.java:106)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:259)
at org.alfresco.repo.workflow.jbpm.AlfrescoJobExecutorThread.acquireJobs(AlfrescoJobExecutorThread.java:104)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:54)
Caused by: org.hibernate.TransactionException: JDBC rollback failed
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:676)
… 17 more
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
… 18 more
2012-07-02 12:40:06,119 ERROR [hibernate.transaction.JDBCTransaction] [DefaultScheduler_Worker-7] JDBC rollback failed
org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
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:676)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411)
at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:567)
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2012-07-02 12:40:06,119 ERROR [util.transaction.SpringAwareUserTransaction] [DefaultScheduler_Worker-7] Application exception overridden by rollback exception
java.lang.Exception
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2012-07-02 12:40:06,119 ERROR [repo.transaction.RetryingTransactionHelper] [DefaultScheduler_Worker-7] Rollback failure. Normal retry behaviour will resume.
org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:679)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411)
at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:567)
at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:537)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: org.hibernate.TransactionException: JDBC rollback failed
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:676)
… 15 more
Caused by: org.postgresql.util.PSQLException: This connection has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
… 16 more
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
2012-07-02 12:40:07,297 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopping 'Replication' subsystem, ID: [Replication, default]
2012-07-02 12:40:07,297 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopped 'Replication' subsystem, ID: [Replication, default]
2012-07-02 12:40:08,316 WARN [factory.support.DisposableBeanAdapter] [Thread-1] Invocation of destroy method failed on bean with name 'activitiProcessEngine': org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection
2012-07-02 12:40:08,322 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopping 'Subscriptions' subsystem, ID: [Subscriptions, default]
2012-07-02 12:40:08,322 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopped 'Subscriptions' subsystem, ID: [Subscriptions, default]
2012-07-02 12:40:08,322 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopping 'googledocs' subsystem, ID: [googledocs, default]
2012-07-02 12:40:08,322 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopped 'googledocs' subsystem, ID: [googledocs, default]
2012-07-02 12:40:08,322 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopping 'email' subsystem, ID: [email, inbound]
2012-07-02 12:40:08,322 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopped 'email' subsystem, ID: [email, inbound]
2012-07-02 12:40:08,327 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopping 'fileServers' subsystem, ID: [fileServers, default]
2012-07-02 12:40:10,338 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopped 'fileServers' subsystem, ID: [fileServers, default]
2012-07-02 12:40:10,340 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopping 'ActivitiesFeed' subsystem, ID: [ActivitiesFeed, default]
2012-07-02 12:40:10,341 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopped 'ActivitiesFeed' subsystem, ID: [ActivitiesFeed, default]
2012-07-02 12:40:10,344 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopping 'OOoDirect' subsystem, ID: [OOoDirect, default]
2012-07-02 12:40:10,345 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopped 'OOoDirect' subsystem, ID: [OOoDirect, default]
2012-07-02 12:40:10,347 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopping 'Synchronization' subsystem, ID: [Synchronization, default]
2012-07-02 12:40:10,347 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopped 'Synchronization' subsystem, ID: [Synchronization, default]
2012-07-02 12:40:10,349 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopping 'email' subsystem, ID: [email, outbound]
2012-07-02 12:40:10,349 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopped 'email' subsystem, ID: [email, outbound]
2012-07-02 12:40:10,351 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopping 'imap' subsystem, ID: [imap, default]
2012-07-02 12:40:10,351 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopped 'imap' subsystem, ID: [imap, default]
2012-07-02 12:40:12,195 ERROR [activities.feed.AbstractFeedGenerator] [DefaultScheduler_Worker-7] Exception during generation of feeds
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:596)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:273)
at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:411)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:377)
at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:501)
at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:455)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:218)
at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:209)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.acquireLock(AbstractFeedGenerator.java:207)
at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:161)
at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:555)
… 14 more
Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1158)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
… 19 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at java.net.Socket.connect(Socket.java:478)
at java.net.Socket.<init>(Socket.java:375)
at java.net.Socket.<init>(Socket.java:189)
at org.postgresql.core.PGStream.<init>(PGStream.java:62)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
… 34 more
2012-07-02 12:40:12,216 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopping 'Search' subsystem, ID: [Search, managed, solr]
2012-07-02 12:40:12,216 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopped 'Search' subsystem, ID: [Search, managed, solr]
2012-07-02 12:40:12,235 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopping 'thirdparty' subsystem, ID: [thirdparty, default]
2012-07-02 12:40:12,235 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopped 'thirdparty' subsystem, ID: [thirdparty, default]
2012-07-02 12:40:12,237 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopping 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]
2012-07-02 12:40:12,239 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopped 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]
2012-07-02 12:40:12,243 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopping 'sysAdmin' subsystem, ID: [sysAdmin, default]
2012-07-02 12:40:12,243 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Stopped 'sysAdmin' subsystem, ID: [sysAdmin, default]
log4j:WARN No appenders could be found for logger (org.alfresco.repo.management.subsystems.ChildApplicationContextFactory).
log4j:WARN Please initialize the log4j system properly.
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
2012-07-02 12:41:39,900 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
2012-07-02 12:41:39,942 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
2012-07-02 12:41:45,160 WARN [alfresco.util.AbstractTriggerBean] [Thread-1] Job ehCacheTracerJob is not active/enabled
2012-07-02 12:41:49,832 INFO [extensions.webscripts.TemplateProcessorRegistry] [Thread-1] Registered template processor Repository Template Processor for extension ftl
2012-07-02 12:41:49,833 INFO [extensions.webscripts.ScriptProcessorRegistry] [Thread-1] Registered script processor Repository Script Processor for extension js
2012-07-02 12:41:53,656 INFO [domain.schema.SchemaBootstrap] [Thread-1] Schema managed by database dialect org.hibernate.dialect.PostgreSQLDialect.
2012-07-02 12:41:55,575 INFO [domain.schema.SchemaBootstrap] [Thread-1] No changes were made to the schema.
2012-07-02 12:41:55,958 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'Search' subsystem, ID: [Search, managed, solr]
2012-07-02 12:41:56,060 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'Search' subsystem, ID: [Search, managed, solr] complete
2012-07-02 12:41:57,130 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'thirdparty' subsystem, ID: [thirdparty, default]
2012-07-02 12:41:57,413 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete
2012-07-02 12:41:57,413 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'OOoDirect' subsystem, ID: [OOoDirect, default]
2012-07-02 12:41:58,866 WARN [alfresco.util.OpenOfficeConnectionTester] [Thread-1] An initial OpenOffice connection could not be established.
2012-07-02 12:41:58,869 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'OOoDirect' subsystem, ID: [OOoDirect, default] complete
2012-07-02 12:41:59,022 INFO [repo.admin.ConfigurationChecker] [Thread-1] The Alfresco root data directory ('dir.root') is: C:\Alfresco\alf_data
2012-07-02 12:41:59,046 INFO [admin.patch.PatchExecuter] [Thread-1] Checking for patches to apply …
2012-07-02 12:41:59,489 INFO [admin.patch.PatchExecuter] [Thread-1] No patches were required.
2012-07-02 12:41:59,503 INFO [repo.module.ModuleServiceImpl] [Thread-1] Found 2 module(s).
2012-07-02 12:41:59,543 INFO [repo.module.ModuleServiceImpl] [Thread-1] Starting module 'org_alfresco_module_wcmquickstart' version 1.0.
2012-07-02 12:41:59,549 DEBUG [repo.module.ModuleComponentHelper] [Thread-1] Started module 'ModuleDetails[{module.version=1.0, module.description=Web Quick Start, module.id=org_alfresco_module_wcmquickstart, module.repo.version.max=999, module.title=Web Quick Start, module.repo.version.min=3.3, module.installState=INSTALLED, module.installDate=2012-06-04T11:29:49.870+05:30}]' including 0components.
2012-07-02 12:41:59,562 INFO [repo.module.ModuleServiceImpl] [Thread-1] Starting module 'org.alfresco.module.vti' version 1.2.
2012-07-02 12:41:59,566 DEBUG [repo.module.ModuleComponentHelper] [Thread-1] Started module 'ModuleDetails[{module.version=1.2, module.description=Alfresco Vti Extension, module.id=org.alfresco.module.vti, module.repo.version.max=999, module.title=Vti, module.repo.version.min=0, module.installState=INSTALLED, module.installDate=2012-06-04T11:29:45.878+05:30}]' including 0components.
2012-07-02 12:41:59,570 DEBUG [repo.module.ModuleComponentHelper] [Thread-1] Installed module found in distribution: org_alfresco_module_wcmquickstart
2012-07-02 12:41:59,570 DEBUG [repo.module.ModuleComponentHelper] [Thread-1] Installed module found in distribution: org.alfresco.module.vti
2012-07-02 12:41:59,570 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'fileServers' subsystem, ID: [fileServers, default]
2012-07-02 12:41:59,943 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]
2012-07-02 12:42:00,062 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1] complete
2012-07-02 12:42:00,193 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'fileServers' subsystem, ID: [fileServers, default] complete
2012-07-02 12:42:00,194 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'imap' subsystem, ID: [imap, default]
2012-07-02 12:42:00,297 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'imap' subsystem, ID: [imap, default] complete
2012-07-02 12:42:00,297 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'email' subsystem, ID: [email, outbound]
2012-07-02 12:42:00,380 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'email' subsystem, ID: [email, outbound] complete
2012-07-02 12:42:00,381 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'email' subsystem, ID: [email, inbound]
2012-07-02 12:42:00,451 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'email' subsystem, ID: [email, inbound] complete
2012-07-02 12:42:00,451 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'googledocs' subsystem, ID: [googledocs, default]
2012-07-02 12:42:00,551 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'googledocs' subsystem, ID: [googledocs, default] complete
2012-07-02 12:42:00,552 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'Subscriptions' subsystem, ID: [Subscriptions, default]
2012-07-02 12:42:00,566 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'Subscriptions' subsystem, ID: [Subscriptions, default] complete
2012-07-02 12:42:00,568 INFO [repo.usage.UserUsageTrackingComponent] [Thread-1] Disabled - clear non-missing user usages …
2012-07-02 12:42:00,683 INFO [repo.usage.UserUsageTrackingComponent] [Thread-1] Found 0 users to clear
2012-07-02 12:42:00,683 INFO [repo.usage.UserUsageTrackingComponent] [Thread-1] … cleared non-missing usages for 0 users
2012-07-02 12:42:00,683 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'Synchronization' subsystem, ID: [Synchronization, default]
2012-07-02 12:42:00,969 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'Synchronization' subsystem, ID: [Synchronization, default] complete
2012-07-02 12:42:01,101 INFO [service.descriptor.DescriptorService] [Thread-1] Alfresco JVM - v1.6.0_22-b04; maximum heap size 910.250MB
2012-07-02 12:42:01,102 INFO [service.descriptor.DescriptorService] [Thread-1] Alfresco started (Community). Current version: 4.0.0 (4003) schema 5,025. Originally installed version: 4.0.0 (4003) schema 5,025.
2012-07-02 12:42:01,102 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'ActivitiesFeed' subsystem, ID: [ActivitiesFeed, default]
2012-07-02 12:42:01,182 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'ActivitiesFeed' subsystem, ID: [ActivitiesFeed, default] complete
2012-07-02 12:42:01,182 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'Replication' subsystem, ID: [Replication, default]
2012-07-02 12:42:01,195 INFO [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'Replication' subsystem, ID: [Replication, default] complete
2012-07-02 12:42:01,724 INFO [alfresco.util.OpenOfficeConnectionTester] [DefaultScheduler_Worker-1] The OpenOffice connection was re-established.
2012-07-02 12:42:02,372 INFO [module.vti.VtiServer] [Thread-1] Vti server started successfully on port: 7070
2012-07-02 12:42:02,373 INFO [module.vti.VtiServer] [Thread-1] Vti server SessionIdManagerWorkerName: jetty1
2012-07-02 12:42:09,147 WARN [extensions.webscripts.DeclarativeRegistry] [Thread-1] Unable to register script classpath:webscripts/org/springframework/extensions/cmis/content.get.desc.xml due to error: 06020000 Web Script document org/springframework/extensions/cmis/content.get.desc.xml is attempting to define the url '/cmis/content:GET' already defined by org/alfresco/cmis/client/content.get.desc.xml
2012-07-02 12:42:09,147 INFO [extensions.webscripts.DeclarativeRegistry] [Thread-1] Registered 477 Web Scripts (+1 failed), 745 URLs
2012-07-02 12:42:09,147 INFO [extensions.webscripts.DeclarativeRegistry] [Thread-1] Registered 2 Package Description Documents (+0 failed)
2012-07-02 12:42:09,147 INFO [extensions.webscripts.DeclarativeRegistry] [Thread-1] Registered 1 Schema Description Documents (+0 failed)
2012-07-02 12:42:09,148 INFO [extensions.webscripts.AbstractRuntimeContainer] [Thread-1] Initialised Repository Web Script Container (in 4627.1226ms)
2012-07-02 12:42:09,157 INFO [extensions.webscripts.TemplateProcessorRegistry] [Thread-1] Registered template processor freemarker for extension ftl
2012-07-02 12:42:09,157 INFO [extensions.webscripts.ScriptProcessorRegistry] [Thread-1] Registered script processor javascript for extension js
2012-07-02 12:42:23,393 INFO [extensions.webscripts.TemplateProcessorRegistry] [Thread-1] Registered template processor freemarker for extension ftl
2012-07-02 12:42:23,451 INFO [extensions.webscripts.ScriptProcessorRegistry] [Thread-1] Registered script processor javascript for extension js
2012-07-02 12:42:23,451 INFO [extensions.webscripts.TemplateProcessorRegistry] [Thread-1] Registered template processor freemarker for extension ftl
2012-07-02 12:42:23,454 INFO [extensions.webscripts.ScriptProcessorRegistry] [Thread-1] Registered script processor javascript for extension js
2012-07-02 12:42:26,872 INFO [extensions.webscripts.DeclarativeRegistry] [Thread-1] Registered 314 Web Scripts (+0 failed), 324 URLs
2012-07-02 12:42:26,872 INFO [extensions.webscripts.DeclarativeRegistry] [Thread-1] Registered 8 Package Description Documents (+0 failed)
2012-07-02 12:42:26,872 INFO [extensions.webscripts.DeclarativeRegistry] [Thread-1] Registered 0 Schema Description Documents (+0 failed)
2012-07-02 12:42:27,038 INFO [extensions.webscripts.AbstractRuntimeContainer] [Thread-1] Initialised Spring Surf Container Web Script Container (in 3570.126ms)
2012-07-02 12:42:27,042 INFO [extensions.webscripts.TemplateProcessorRegistry] [Thread-1] Registered template processor freemarker for extension ftl
2012-07-02 12:42:27,045 INFO [extensions.webscripts.ScriptProcessorRegistry] [Thread-1] Registered script processor javascript for extension js
12:42:28,264 WARN [org.apache.myfaces.shared_impl.util.LocaleUtils] Locale name in faces-config.xml null or empty, setting locale to default locale : en_US
Any idea about the problem?