AnsweredAssumed Answered

ReIndex after backup

Question asked by javi.gimeno on Oct 27, 2010
Latest reply on Oct 28, 2010 by javi.gimeno
Good morning,
according to our contingency plan I am doing a new environment for testing. For this I took the backup of the production environment to restore an identical copy in this new environment. The environments are:
W2003 Server 32 Bits + Tomcat 6 + MySQL 5.1 + Alfresco 3.2 CE + Java 1.6
2 Processor Intel Xeon 5130 2Ghz (2 core).
JVM: JAVA_OPTS=-Xms768m -Xmx1536m -Xss1m -XX:MaxPermSize=128m -Xcomp -Xbatch -XX:+UseConcMarkSweepGC -XX:+CMSIncrementalMode -XX:NewSize=384m -XX:CMSInitiatingOccupancyFraction=80 -server -Dalfresco.home=%ALF_HOME%

Virtual Machine
W2008 Server 64bits + Tomcat 6 + MySQL 5.1 64 bits +Alfresco 3.2 CE + Java 1.6 64 Bits
4 Processor Intel Xeon E7440 2.4Ghz
JVM: JAVA_OPTS=-server -Xcomp -Xbatch -Xss1M -Xms2G -Xmx3G -XX:+UseConcMarkSweepGC -XX:+CMSIncrementalMode -XX:NewSize=1G -XX:MaxPermSize=256M -XX:CMSInitiatingOccupancyFraction=80

To restore the backup follow the steps in the wiki backup. When restored the indices gives an error:
14:01:46,772 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No se hicieron cambios en el esquema.
14:01:58,348 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: FULL
14:02:03,455 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Iniciada la recuperación de índices: 205.526 transaciones.
15:42:36,353 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    10 % completado.
19:06:47,530 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failed
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
   at java.lang.reflect.Constructor.newInstance(
   at com.mysql.jdbc.Util.handleNewInstance(
   at com.mysql.jdbc.Util.getInstance(
   at com.mysql.jdbc.SQLError.createSQLException(
   at com.mysql.jdbc.SQLError.createSQLException(
   at com.mysql.jdbc.SQLError.createSQLException(
   at com.mysql.jdbc.ConnectionImpl.getMutex(
   at com.mysql.jdbc.ConnectionImpl.rollback(
   at org.apache.commons.dbcp.DelegatingConnection.rollback(
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(
   at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(
   at org.hibernate.transaction.JDBCTransaction.rollback(
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(
   at org.alfresco.repo.node.index.AbstractReindexComponent$
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(
   at java.util.concurrent.ThreadPoolExecutor$

Is it normal to take so long for 205,526 transactions?, To get the 10% of completed takes over an hour and a half, plus the following answer him nearly 5 hours and returns an error as if it had a problem with the database data …

Anyone feel the same? do you advise me to solve the problem?, I read a lot for the forum and the logs I've seen other installations take less time to reindex the index.

Thanks and regards.