<?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 Alfresco 2 - Reindex Full vey slow in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/alfresco-2-reindex-full-vey-slow/m-p/267044#M220174</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Configuration&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;- SunFire V240 with 4GB RAM and SunOS 5.10&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;- N° Documents 167.602&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;- dir.root : 18 GB occuped , disk free 60%&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;- dir.contentstore : 35 GB occuped,&amp;nbsp; disk free 80%&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;- Alfresco Enterprise ver.2.2.0&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;- Jboss Portal ver.2.6.5&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;- Oracle 10g rel.2&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Hi,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;after the problem with search fails i set the index recovery mode FULL then restart but this process it's very very slow and terminated with timeout Jdbc after 14Hours &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;each step of process rebuild is bigger then 2 Hour&lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;18:53:27,313 INFO&amp;nbsp; [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started: 167,880 transactions.&lt;BR /&gt;20:00:25,858 INFO&amp;nbsp; [org.alfresco.repo.node.index.FullIndexRecoveryComponent]&amp;nbsp;&amp;nbsp;&amp;nbsp; 10 % complete.&lt;BR /&gt;21:10:11,334 INFO&amp;nbsp; [org.alfresco.repo.node.index.FullIndexRecoveryComponent]&amp;nbsp;&amp;nbsp;&amp;nbsp; 20 % complete.&lt;BR /&gt;23:05:49,801 INFO&amp;nbsp; [org.alfresco.repo.node.index.FullIndexRecoveryComponent]&amp;nbsp;&amp;nbsp;&amp;nbsp; 30 % complete.&lt;BR /&gt;01:36:01,231 INFO&amp;nbsp; [org.alfresco.repo.node.index.FullIndexRecoveryComponent]&amp;nbsp;&amp;nbsp;&amp;nbsp; 40 % complete.&lt;BR /&gt;03:05:07,831 INFO&amp;nbsp; [org.alfresco.repo.node.index.FullIndexRecoveryComponent]&amp;nbsp;&amp;nbsp;&amp;nbsp; 50 % complete.&lt;BR /&gt;05:00:54,973 INFO&amp;nbsp; [org.alfresco.repo.node.index.FullIndexRecoveryComponent]&amp;nbsp;&amp;nbsp;&amp;nbsp; 60 % complete.&lt;BR /&gt;07:46:19,514 INFO&amp;nbsp; [org.alfresco.repo.node.index.FullIndexRecoveryComponent]&amp;nbsp;&amp;nbsp;&amp;nbsp; 70 % complete.&lt;BR /&gt;09:57:22,152 INFO&amp;nbsp; [org.alfresco.repo.node.index.FullIndexRecoveryComponent]&amp;nbsp;&amp;nbsp;&amp;nbsp; 80 % complete.&lt;BR /&gt;11:02:02,044 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failed&lt;BR /&gt;java.sql.SQLException: Closed Connection&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1142)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:581)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:745)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:722)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:325)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:498)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:309)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:190)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:220)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.alfresco.repo.node.index.IndexRecoveryBootstrapBean.onBootstrap(IndexRecoveryBootstrapBean.java:35)&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)&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;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;a) How set the alfresco/lucene parameter, and alfresco/hibernate transaction,&amp;nbsp; for optimize the reindex process?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;b) It's possibile to start alfresco api for only reindex document with no start alfresco.war include in the container JEE (in this case Jboss)?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;thanks in advanced&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 23 Feb 2012 11:14:17 GMT</pubDate>
    <dc:creator>stylus753</dc:creator>
    <dc:date>2012-02-23T11:14:17Z</dc:date>
    <item>
      <title>Alfresco 2 - Reindex Full vey slow</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/alfresco-2-reindex-full-vey-slow/m-p/267044#M220174</link>
      <description>Configuration- SunFire V240 with 4GB RAM and SunOS 5.10- N° Documents 167.602- dir.root : 18 GB occuped , disk free 60%- dir.contentstore : 35 GB occuped,&amp;nbsp; disk free 80%- Alfresco Enterprise ver.2.2.0- Jboss Portal ver.2.6.5- Oracle 10g rel.2Hi,after the problem with search fails i set the index rec</description>
      <pubDate>Thu, 23 Feb 2012 11:14:17 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/alfresco-2-reindex-full-vey-slow/m-p/267044#M220174</guid>
      <dc:creator>stylus753</dc:creator>
      <dc:date>2012-02-23T11:14:17Z</dc:date>
    </item>
    <item>
      <title>Re: Alfresco 2 - Reindex Full vey slow</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/alfresco-2-reindex-full-vey-slow/m-p/267045#M220175</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Unless this is all AVM data this should not take that long - even with your setup.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I do not think 2.2 had multi-threaded index rebuild.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The V240 was EOL in Sept 2006 &lt;span class="lia-unicode-emoji" title=":slightly_smiling_face:"&gt;🙂&lt;/span&gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Did you delete the index first?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I would suggest you upgrade or change your DB timeout, ….&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Andy&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 23 Feb 2012 11:58:59 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/alfresco-2-reindex-full-vey-slow/m-p/267045#M220175</guid>
      <dc:creator>andy</dc:creator>
      <dc:date>2012-02-23T11:58:59Z</dc:date>
    </item>
    <item>
      <title>Re: Alfresco 2 - Reindex Full vey slow</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/alfresco-2-reindex-full-vey-slow/m-p/267046#M220176</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;in dir.root the directory is &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;audit.contentstore, backup-lucene-indexes, contentstore.deleted and lucene-indexes&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;therefore i delete the directory "lucene-indexes" and restart the index Full?&amp;nbsp; :roll:&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 24 Feb 2012 17:40:12 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/alfresco-2-reindex-full-vey-slow/m-p/267046#M220176</guid>
      <dc:creator>stylus753</dc:creator>
      <dc:date>2012-02-24T17:40:12Z</dc:date>
    </item>
    <item>
      <title>Re: Alfresco 2 - Reindex Full vey slow</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/alfresco-2-reindex-full-vey-slow/m-p/267047#M220177</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;yes. Do not delete the content stores.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;The rebuiild will be faster - it may still time out - so up the DB timeout.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Andy&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 24 Feb 2012 18:02:02 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/alfresco-2-reindex-full-vey-slow/m-p/267047#M220177</guid>
      <dc:creator>andy</dc:creator>
      <dc:date>2012-02-24T18:02:02Z</dc:date>
    </item>
  </channel>
</rss>

