nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

ReIndex after backup

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:
Production:
W2003 Server 32 Bits + Tomcat 6 + MySQL 5.1 + Alfresco 3.2 CE + Java 1.6
2 Processor Intel Xeon 5130 2Ghz (2 core).
4 GB RAM
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% -Dcom.sun.management.jmxremote

Test:
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
8GB RAM
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(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
   at com.mysql.jdbc.Util.getInstance(Util.java:381)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
   at com.mysql.jdbc.ConnectionImpl.getMutex(ConnectionImpl.java:3032)
   at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4606)
   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)
   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.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
   at java.lang.Thread.run(Thread.java:662)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

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.

Find more posts tagged with

Comments

pjcaracuel

It´s easy.

Put in alfresco-global.properties
index.recovery.mode=FULL

Too, delete de index folder and backup index folder (lucene-indexes) and when you start alfresco, index will be create.

Regards

javi_gimeno

Hi abhaychaware
Documenting how to back up and restore is described here:
http://wiki.alfresco.com/wiki/Backup_and_Restore

I recommend you make a cold backup, with Alfresco stopped. Once you want to restore, with Alfresco stopped, you should:
1 - Restore the copy of the database
2 - Copy the entire contents of the folder alf_data
3 - In some places recommended to delete the contents of the folders backup-lucene-index and lucene-index.
4 - repository.properties file you have to do is put the property index.recovery.mode = FULL
5 - Start Alfresco and begin to restore the index. Once refurbished, this property should be left to index.recovery.mode = AUTO.

The performance of the restoration of the copies is based on the version you have of Alfresco, the database manager, operating system, the hardware you are using etc …

There is a post where they write some tips to retrieve the index:
http://forums.alfresco.com/en/viewtopic.php?t=10984

javi_gimeno

In manual data backup and recovery is essential to have a copy of the database and repository. I think if you lack either of these two components can not retrieve the repository. I have read some cases similar to yours in the forum and there is no solution, at least I do not know.

pjcaracuel

You must start from a clean installation and do not forget to backup properly to the next time .. Sorry

pjcaracuel

If you have an ACP files with all repository content then you can do the import action with alfresco web client. But the import will be in a alfresco instance clean.

Regards