topic cant Upgrade from .4d to 4.0e Ubu10.4 MySQL, reindex failed in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/cant-upgrade-from-4d-to-4-0e-ubu10-4-mysql-reindex-failed/m-p/276736#M229866 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>i am trying to upgrade my Alfresco 3.4d to 4.0e on Ubuntu 10.04 with mysql database.</SPAN><BR /><SPAN>After reading the forum i was able to fix some trouble's, but currently it still doesn't work.</SPAN><BR /><BR /><SPAN>what i have done:</SPAN><BR /><SPAN>dump alfresco34d mysql database and converted to UTF8.</SPAN><BR /><SPAN>stopped&nbsp; MySQL</SPAN><BR /><BR /><SPAN>installed Ubuntu Mysql and modiefied my.cnf with lower_case_table_names=1.</SPAN><BR /><BR /><SPAN>Imported the databases to schema alfresc40e.</SPAN><BR /><BR /><SPAN>installed alfresco 4.0e detailed without postgres.</SPAN><BR /><BR /><SPAN>modified alfresco-global.properties</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />### database connection properties ###<BR />db.driver=org.gjt.mm.mysql.Driver<BR />db.username=alfresco&nbsp; <BR />db.password=xxx<BR />db.name=alfresco40e<BR />db.url=jdbc:mysql://localhost:3306/${db.name}?useUnicode=yes&amp;characterEncoding=UTF-8<BR />index.recovery.mode=AUTO<BR />#index.recovery.mode=FULL<BR /><BR /><BR />### Solr indexing ###<BR />#index.subsystem.name=solr<BR />#dir.keystore=${dir.root}/keystore<BR />#solr.port.ssl=8443<BR /><BR />index.subsystem.name=lucene<BR />dir.keystore=${dir.root}/keystore<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>modified tomcat/scripts/ctl.sh</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />export JAVA_OPTS="-XX:MaxPermSize=512m -Xms1G -Xmx4G -XX:NewSize=512m -server .. as mentoined in the the forum.<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>first start brought an error about unknown setting in alfresco-global.propierties about unknown indexing.</SPAN><BR /><SPAN>found out at the end was some spaces. </SPAN><BR /><BR /><SPAN>on second startup it started schema conversation, but:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />2012-10-27 23:04:14,181&nbsp; WARN&nbsp; [domain.schema.SchemaBootstrap] [main] Schema validation found 58 potential problems, results written to: /opt/alfresco-4.0.e/t<BR />omcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Post-Upgrade-5614290682137725255.txt<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN><img id="smileysad" class="emoticon emoticon-smileysad" src="https://connect.hyland.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" /> tomcat temp seems to get cleaned on restart <img id="smileysad" class="emoticon emoticon-smileysad" src="https://connect.hyland.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" /> there was some complains about some forein-keys and unneeded tables?</SPAN><BR /><SPAN>but in the end i got</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />Normalized schema (pre-bootstrap)&nbsp; dumped to file /opt/alfresco-4.0.e/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-1019265373457968514-Startup.xml.<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>and the the index recovery started with 648190 transactions. which took a while.</SPAN><BR /><SPAN>I got some times (6?):</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />### Error querying database.&nbsp; Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.io.StreamCorruptedException: invalid stream hea<BR />der: C2ACC3AD<BR />### The error may involve alfresco.node.select_NodeProperties-Inline<BR />### The error occurred while setting parameters<BR />### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.io.StreamCorruptedException: invalid stream header: C2ACC3AD.<BR /> 2012-10-27 23:08:54,228&nbsp; WARN&nbsp; [index.AbstractReindexComponent.threads] [indexTrackerThread2] org.mybatis.spring.MyBatisSystemException: nested exception is o<BR />rg.apache.ibatis.exceptions.PersistenceException: <BR />### Error querying database.&nbsp; Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.io.StreamCorruptedException: invalid stream hea<BR />der: C2ACC3AD<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>in the end i got </SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR /> 2012-10-28 00:39:14,425&nbsp; INFO&nbsp; [node.index.FullIndexRecoveryComponent] [main] Index recovery completed.<BR /> 2012-10-28 00:39:15,026&nbsp; INFO&nbsp; [node.index.AVMFullIndexRecoveryComponent] [main] Rebuilding indexes for 1 AVM Stores<BR /> 2012-10-28 00:39:15,026&nbsp; INFO&nbsp; [node.index.AVMFullIndexRecoveryComponent] [main]&nbsp;&nbsp;&nbsp;&nbsp; Rebuilding index for sitestore<BR /> 2012-10-28 00:39:15,269&nbsp; INFO&nbsp; [node.index.AVMFullIndexRecoveryComponent] [main]&nbsp;&nbsp; Reindex&nbsp;&nbsp; 100% complete<BR /> 2012-10-28 00:39:15,269&nbsp; INFO&nbsp; [node.index.AVMFullIndexRecoveryComponent] [main] Finished rebuilding indexes for AVM Stores<BR /> 2012-10-28 00:39:35,831&nbsp; INFO&nbsp; [repo.admin.ConfigurationChecker] [main] The Alfresco root data directory ('dir.root') is: /opt/alfresco-4.0.e/alf_data<BR /> 2012-10-28 00:39:35,843&nbsp; INFO&nbsp; [admin.patch.PatchExecuter] [main] Checking for patches to apply …<BR /> 2012-10-28 00:39:36,167&nbsp; INFO&nbsp; [admin.patch.PatchExecuter] [main]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Applying patch 'patch.fixUserQNames' (Fixes user store qnames to improve native authentication performance).<BR /> 2012-10-28 00:39:36,445&nbsp; INFO&nbsp; [patch.impl.FixUserQNamesPatch] [main] FixUserQNamesPatch: Commencing batch of 21 entries<BR /> 2012-10-28 00:39:37,590&nbsp; INFO&nbsp; [patch.impl.FixUserQNamesPatch] [main] FixUserQNamesPatch: Processed 21 entries out of 21. 100% complete. Rate: 18 per second. 0 failures detected.<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>finally i got</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR /> 2012-10-28 00:40:52,165&nbsp; INFO&nbsp; [service.descriptor.DescriptorService] [main] Alfresco JVM - v1.6.0_22-b04; maximum heap size 3756,500MB<BR /> 2012-10-28 00:40:52,166&nbsp; INFO&nbsp; [service.descriptor.DescriptorService] [main] Alfresco started (Community). Current version: 4.0.0 (7) schema 5.025. Originally<BR /> installed version: 3.2.0 (r2 2440) schema 3.300.<BR />28.10.2012 00:41:17 org.apache.catalina.startup.Catalina start<BR />INFO: Server startup in 6322610 ms<BR />2012-10-28 00:42:26,995&nbsp; ERROR [extensions.webscripts.AbstractRuntime] [http-8443-6] Exception from executeScript - redirecting to status template error: 09280002 Wrapped Exception (with status template): 09280008 Problem converting to Freemarker<BR /> org.springframework.extensions.webscripts.WebScriptException: 09280002 Wrapped Exception (with status template): 09280008 Problem converting to Freemarker<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>then i stopped alfresco, modified indexing to AUTO and restarted again.</SPAN><BR /><SPAN>It does again start a full reindex!</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />ransactionalCache' is full (65000).<BR /> 2012-10-28 09:54:06,300&nbsp; ERROR [index.AbstractReindexComponent.threads] [indexTrackerThread2] Reindexer&nbsp;&nbsp;&nbsp;&nbsp; 2 failed with error: nested exception is org.apache.ibatis.exceptions.PersistenceException: <BR />### Error querying database.&nbsp; Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.io.StreamCorruptedException: invalid stream header: C2ACC3AD<BR />### The error may involve alfresco.node.select_NodeProperties-Inline<BR />### The error occurred while setting parameters<BR />### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.io.StreamCorruptedException: invalid stream header: C2ACC3AD.<BR /> 2012-10-28 09:54:06,301&nbsp; WARN&nbsp; [index.AbstractReindexComponent.threads] [indexTrackerThread2] org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: <BR />..<BR />..<BR />2012-10-28 11:17:21,081&nbsp; INFO&nbsp; [repo.admin.ConfigurationChecker] [main] The Alfresco root data directory ('dir.root') is: /opt/alfresco-4.0.e/alf_data<BR /> 2012-10-28 11:17:21,112&nbsp; ERROR [repo.admin.ConfigurationChecker] [main] CONTENT INTEGRITY ERROR: Indexes not found for 6 stores.<BR /> 2012-10-28 11:17:21,112&nbsp; INFO&nbsp; [repo.admin.ConfigurationChecker] [main] You may set 'index.recovery.mode=FULL' if you need to rebuild the indexes.<BR /> 2012-10-28 11:17:21,112&nbsp; ERROR [repo.admin.ConfigurationChecker] [main] Ensure that the 'dir.root' property is pointing to the correct data location.<BR /> 2012-10-28 11:17:21,132&nbsp; ERROR [web.context.ContextLoader] [main] Context initialization failed<BR /> org.alfresco.error.AlfrescoRuntimeException: 09280000 Ensure that the 'dir.root' property is pointing to the correct data location.<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:248)<BR /><BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>currently i can't overcome this reindex error and afterwards i am unable to login to the share Interface as i get:</SPAN><BR /><SPAN>Remoteserver is reachable or logindata are not correct.</SPAN><BR /><BR /><SPAN>how can i force a successfull reindex?</SPAN><BR /><BR /><SPAN>best regards.thomas</SPAN></BODY></HTML> Sun, 28 Oct 2012 21:41:40 GMT stegbth 2012-10-28T21:41:40Z cant Upgrade from .4d to 4.0e Ubu10.4 MySQL, reindex failed https://connect.hyland.com/t5/alfresco-archive/cant-upgrade-from-4d-to-4-0e-ubu10-4-mysql-reindex-failed/m-p/276736#M229866 Hi,i am trying to upgrade my Alfresco 3.4d to 4.0e on Ubuntu 10.04 with mysql database.After reading the forum i was able to fix some trouble's, but currently it still doesn't work.what i have done:dump alfresco34d mysql database and converted to UTF8.stopped&nbsp; MySQLinstalled Ubuntu Mysql and modiefi Sun, 28 Oct 2012 21:41:40 GMT https://connect.hyland.com/t5/alfresco-archive/cant-upgrade-from-4d-to-4-0e-ubu10-4-mysql-reindex-failed/m-p/276736#M229866 stegbth 2012-10-28T21:41:40Z Re: cant Upgrade from .4d to 4.0e Ubu10.4 MySQL, reindex failed https://connect.hyland.com/t5/alfresco-archive/cant-upgrade-from-4d-to-4-0e-ubu10-4-mysql-reindex-failed/m-p/276737#M229867 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>In order to perform a full reindex you have to </SPAN><BR /><UL><LI>stop Alfresco</LI><BR /><LI>modify alfresco-global.properties adding the property index.recovery.mode=FULL</LI><BR /><LI>restart Alfresco in order to let the index being rebuilt</LI><BR /><LI>stop Alfresco again</LI><BR /><LI>modify alfresco-global.properties modifying the property index.recovery.mode=AUTO</LI><BR /><LI>start Alfresco</LI></UL><SPAN>Regards,</SPAN><BR /><SPAN>Andrea</SPAN></BODY></HTML> Mon, 29 Oct 2012 13:07:19 GMT https://connect.hyland.com/t5/alfresco-archive/cant-upgrade-from-4d-to-4-0e-ubu10-4-mysql-reindex-failed/m-p/276737#M229867 abarisone 2012-10-29T13:07:19Z Re: cant Upgrade from .4d to 4.0e Ubu10.4 MySQL, reindex failed https://connect.hyland.com/t5/alfresco-archive/cant-upgrade-from-4d-to-4-0e-ubu10-4-mysql-reindex-failed/m-p/276738#M229868 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>i found one error.</SPAN><BR /><SPAN>i coverted the database from defaultlocation latin1 to utf8.</SPAN><BR /><BR /><SPAN>no i imported the 3.4d mysql database with latin1 and left in alfresco-global.properties:</SPAN><BR /><SPAN>db.url=jdbc:mysql://localhost:3306/${db.name}?useUnicode=yes&amp;characterEncoding=UTF-8</SPAN><BR /><BR /><SPAN>Now the Umlauts are visible.</SPAN><BR /><BR /><SPAN>After the reindex of lucene the search queries worked.</SPAN><BR /><BR /><SPAN>Then i switched to solr, delete in the archive the index and spellchecker ( </SPAN><A href="http://deepak-keswani.blogspot.de/2012/07/how-to-rebuild-solr-indexes-in-alfresco.html" rel="nofollow noopener noreferrer">http://deepak-keswani.blogspot.de/2012/07/how-to-rebuild-solr-indexes-in-alfresco.html</A><SPAN> )</SPAN><BR /><SPAN>After starting alfresco it working a long time (high load of java), but the index doesn't find anything?</SPAN><BR /><BR /><SPAN>When following this guide (</SPAN><A href="http://docs.alfresco.com/4.0/index.jsp?topic=%2Fcom.alfresco.enterprise.doc%2Ftasks%2Flucene-solr-migration.html" rel="nofollow noopener noreferrer">http://docs.alfresco.com/4.0/index.jsp?topic=%2Fcom.alfresco.enterprise.doc%2Ftasks%2Flucene-solr-migration.html</A><SPAN> )</SPAN><BR /><SPAN>i can't connect the ip, cause i get </SPAN><BR /><SPAN>192.168.50.59:8443 aufgetreten.</SPAN><BR /><BR /><SPAN>the remote-end cant verify your ssl-certificate</SPAN><BR /><SPAN>(Fehlercode: ssl_error_bad_cert_alert)</SPAN><BR /><BR /><SPAN>so how can i switch correctly to solr?</SPAN><BR /><SPAN>doesn't it matter if database is on latin1 collation?</SPAN><BR /><BR /><SPAN>best regards</SPAN><BR /><SPAN>thomas</SPAN></BODY></HTML> Fri, 02 Nov 2012 00:22:35 GMT https://connect.hyland.com/t5/alfresco-archive/cant-upgrade-from-4d-to-4-0e-ubu10-4-mysql-reindex-failed/m-p/276738#M229868 stegbth 2012-11-02T00:22:35Z