<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic ReIndex after backup in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/reindex-after-backup/m-p/242080#M195210</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Good morning,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;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:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Production:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;W2003 Server 32 Bits + Tomcat 6 + MySQL 5.1 + Alfresco 3.2 CE + Java 1.6&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;2 Processor Intel Xeon 5130 2Ghz (2 core).&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;4 GB RAM&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;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&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Test:&lt;/SPAN&gt;&lt;BR /&gt;&lt;STRONG&gt;Virtual Machine&lt;/STRONG&gt;&lt;BR /&gt;&lt;SPAN&gt;W2008 Server 64bits + Tomcat 6 + MySQL 5.1 64 bits +Alfresco 3.2 CE + Java 1.6 64 Bits&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;4 Processor Intel Xeon E7440 2.4Ghz &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;8GB RAM&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;JVM: JAVA_OPTS=-server -Xcomp -Xbatch -Xss1M -Xms2G -Xmx3G -XX:+UseConcMarkSweepGC -XX:+CMSIncrementalMode -XX:NewSize=1G -XX:MaxPermSize=256M -XX:CMSInitiatingOccupancyFraction=80&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;To restore the backup follow the steps in the wiki backup. When restored the indices gives an error:&lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;14:01:46,772 INFO&amp;nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] No se hicieron cambios en el esquema.&lt;BR /&gt;14:01:58,348 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: FULL&lt;BR /&gt;14:02:03,455 INFO&amp;nbsp; [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Iniciada la recuperación de índices: 205.526 transaciones.&lt;BR /&gt;15:42:36,353 INFO&amp;nbsp; [org.alfresco.repo.node.index.FullIndexRecoveryComponent] &amp;nbsp;&amp;nbsp;&amp;nbsp;10 % completado.&lt;BR /&gt;19:06:47,530 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failed&lt;BR /&gt;com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.lang.reflect.Constructor.newInstance(Constructor.java:513)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.mysql.jdbc.Util.getInstance(Util.java:381)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.mysql.jdbc.ConnectionImpl.getMutex(ConnectionImpl.java:3032)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4606)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:328)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:312)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:597)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at java.lang.Thread.run(Thread.java:662)&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;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 …&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;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.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks and regards.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 27 Oct 2010 09:07:55 GMT</pubDate>
    <dc:creator>javi_gimeno</dc:creator>
    <dc:date>2010-10-27T09:07:55Z</dc:date>
    <item>
      <title>ReIndex after backup</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/reindex-after-backup/m-p/242080#M195210</link>
      <description>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&lt;IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" /&gt;roduction:W2003 Server 32 Bits + Tomcat 6 + MySQL 5.1 + Alfresco 3.2 CE + Java</description>
      <pubDate>Wed, 27 Oct 2010 09:07:55 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/reindex-after-backup/m-p/242080#M195210</guid>
      <dc:creator>javi_gimeno</dc:creator>
      <dc:date>2010-10-27T09:07:55Z</dc:date>
    </item>
    <item>
      <title>Re: ReIndex after backup</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/reindex-after-backup/m-p/242081#M195211</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;It´s easy.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Put in alfresco-global.properties&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;index.recovery.mode=FULL&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Too, delete de index folder and backup index folder (lucene-indexes) and when you start alfresco, index will be create.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Regards&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 28 Oct 2010 08:33:31 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/reindex-after-backup/m-p/242081#M195211</guid>
      <dc:creator>pjcaracuel</dc:creator>
      <dc:date>2010-10-28T08:33:31Z</dc:date>
    </item>
    <item>
      <title>Re: ReIndex after backup</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/reindex-after-backup/m-p/242082#M195212</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi abhaychaware&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Documenting how to back up and restore is described here:&lt;/SPAN&gt;&lt;BR /&gt;&lt;A href="http://wiki.alfresco.com/wiki/Backup_and_Restore" rel="nofollow noopener noreferrer"&gt;http://wiki.alfresco.com/wiki/Backup_and_Restore&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I recommend you make a cold backup, with Alfresco stopped. Once you want to restore, with Alfresco stopped, you should:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;1 - Restore the copy of the database&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;2 - Copy the entire contents of the folder alf_data&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;3 - In some places recommended to delete the contents of the folders backup-lucene-index and lucene-index.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;4 - repository.properties file you have to do is put the property index.recovery.mode = FULL&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;5 - Start Alfresco and begin to restore the index. Once refurbished, this property should be left to index.recovery.mode = AUTO.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;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 …&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;There is a post where they write some tips to retrieve the index:&lt;/SPAN&gt;&lt;BR /&gt;&lt;A href="http://forums.alfresco.com/en/viewtopic.php?t=10984" rel="nofollow noopener noreferrer"&gt;http://forums.alfresco.com/en/viewtopic.php?t=10984&lt;/A&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 28 Oct 2010 08:35:49 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/reindex-after-backup/m-p/242082#M195212</guid>
      <dc:creator>javi_gimeno</dc:creator>
      <dc:date>2010-10-28T08:35:49Z</dc:date>
    </item>
    <item>
      <title>Re: ReIndex after backup</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/reindex-after-backup/m-p/242083#M195213</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;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.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 28 Oct 2010 10:17:01 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/reindex-after-backup/m-p/242083#M195213</guid>
      <dc:creator>javi_gimeno</dc:creator>
      <dc:date>2010-10-28T10:17:01Z</dc:date>
    </item>
    <item>
      <title>Re: ReIndex after backup</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/reindex-after-backup/m-p/242084#M195214</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;You must start from a clean installation and do not forget to backup properly to the next time .. Sorry&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 28 Oct 2010 10:22:50 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/reindex-after-backup/m-p/242084#M195214</guid>
      <dc:creator>pjcaracuel</dc:creator>
      <dc:date>2010-10-28T10:22:50Z</dc:date>
    </item>
    <item>
      <title>Re: ReIndex after backup</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/reindex-after-backup/m-p/242085#M195215</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;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.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Regards&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 28 Oct 2010 11:33:35 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/reindex-after-backup/m-p/242085#M195215</guid>
      <dc:creator>pjcaracuel</dc:creator>
      <dc:date>2010-10-28T11:33:35Z</dc:date>
    </item>
  </channel>
</rss>

