Aflresco error in the logs

[fluca1978]

Hi,
in my alfresco installation I find repeated errors like the following, even during night when nobody is using the service. Can anybody give me an hint about?

Thanks

15:16:24,877 ERROR [org.alfresco.repo.transaction.RetryingTransactionHelper] 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 failedCaused 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:597)        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)        at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)        at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)        at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)        at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:233)        at org.alfresco.repo.avm.OrphanReaper.doBatch(OrphanReaper.java:351)        at org.alfresco.repo.avm.OrphanReaper.execute(OrphanReaper.java:58)        at org.alfresco.repo.avm.OrphanReaperJob.execute(OrphanReaperJob.java:44)        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)Caused by: java.sql.SQLRecoverableException: Non vi sono altri dati da leggere nel socket        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200)        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)        at oracle.jdbc.driver.T4C7Ocommoncall.doOROLLBACK(T4C7Ocommoncall.java:68)        at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:642)        at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3716)        at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:328)        at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:328)        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:312)        at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)        at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)        … 13 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[mrogers]

I suspect something is going on on your network or database.    For example your database may be taken off line while it is backed up?

[fluca1978]

Uhm…it could happen during night, but I'm sure it cannot happen during the daylight, as the error is reporting 15:16 time. I'm also sure there is not a network error since at that time I'm able to access the database.