AnsweredAssumed Answered

cant Upgrade from .4d to 4.0e  Ubu10.4 MySQL, reindex failed

Question asked by stegbth on Oct 28, 2012
Latest reply on Nov 2, 2012 by stegbth
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  MySQL

installed Ubuntu Mysql and modiefied my.cnf with lower_case_table_names=1.

Imported the databases to schema alfresc40e.

installed alfresco 4.0e detailed without postgres.

modified alfresco-global.properties

### database connection properties ###
db.driver=org.gjt.mm.mysql.Driver
db.username=alfresco 
db.password=xxx
db.name=alfresco40e
db.url=jdbc:mysql://localhost:3306/${db.name}?useUnicode=yes&characterEncoding=UTF-8
index.recovery.mode=AUTO
#index.recovery.mode=FULL


### Solr indexing ###
#index.subsystem.name=solr
#dir.keystore=${dir.root}/keystore
#solr.port.ssl=8443

index.subsystem.name=lucene
dir.keystore=${dir.root}/keystore


modified tomcat/scripts/ctl.sh

export JAVA_OPTS="-XX:MaxPermSize=512m -Xms1G -Xmx4G -XX:NewSize=512m -server .. as mentoined in the the forum.

first start brought an error about unknown setting in alfresco-global.propierties about unknown indexing.
found out at the end was some spaces.

on second startup it started schema conversation, but:

2012-10-27 23:04:14,181  WARN  [domain.schema.SchemaBootstrap] [main] Schema validation found 58 potential problems, results written to: /opt/alfresco-4.0.e/t
omcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Post-Upgrade-5614290682137725255.txt

:( tomcat temp seems to get cleaned on restart :( there was some complains about some forein-keys and unneeded tables?
but in the end i got

Normalized schema (pre-bootstrap)  dumped to file /opt/alfresco-4.0.e/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-1019265373457968514-Startup.xml.

and the the index recovery started with 648190 transactions. which took a while.
I got some times (6?):

### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.io.StreamCorruptedException: invalid stream hea
der: C2ACC3AD
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.io.StreamCorruptedException: invalid stream header: C2ACC3AD.
2012-10-27 23:08:54,228  WARN  [index.AbstractReindexComponent.threads] [indexTrackerThread2] org.mybatis.spring.MyBatisSystemException: nested exception is o
rg.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.io.StreamCorruptedException: invalid stream hea
der: C2ACC3AD

in the end i got

2012-10-28 00:39:14,425  INFO  [node.index.FullIndexRecoveryComponent] [main] Index recovery completed.
2012-10-28 00:39:15,026  INFO  [node.index.AVMFullIndexRecoveryComponent] [main] Rebuilding indexes for 1 AVM Stores
2012-10-28 00:39:15,026  INFO  [node.index.AVMFullIndexRecoveryComponent] [main]     Rebuilding index for sitestore
2012-10-28 00:39:15,269  INFO  [node.index.AVMFullIndexRecoveryComponent] [main]   Reindex   100% complete
2012-10-28 00:39:15,269  INFO  [node.index.AVMFullIndexRecoveryComponent] [main] Finished rebuilding indexes for AVM Stores
2012-10-28 00:39:35,831  INFO  [repo.admin.ConfigurationChecker] [main] The Alfresco root data directory ('dir.root') is: /opt/alfresco-4.0.e/alf_data
2012-10-28 00:39:35,843  INFO  [admin.patch.PatchExecuter] [main] Checking for patches to apply …
2012-10-28 00:39:36,167  INFO  [admin.patch.PatchExecuter] [main]      Applying patch 'patch.fixUserQNames' (Fixes user store qnames to improve native authentication performance).
2012-10-28 00:39:36,445  INFO  [patch.impl.FixUserQNamesPatch] [main] FixUserQNamesPatch: Commencing batch of 21 entries
2012-10-28 00:39:37,590  INFO  [patch.impl.FixUserQNamesPatch] [main] FixUserQNamesPatch: Processed 21 entries out of 21. 100% complete. Rate: 18 per second. 0 failures detected.

finally i got

2012-10-28 00:40:52,165  INFO  [service.descriptor.DescriptorService] [main] Alfresco JVM - v1.6.0_22-b04; maximum heap size 3756,500MB
2012-10-28 00:40:52,166  INFO  [service.descriptor.DescriptorService] [main] Alfresco started (Community). Current version: 4.0.0 (7) schema 5.025. Originally
installed version: 3.2.0 (r2 2440) schema 3.300.
28.10.2012 00:41:17 org.apache.catalina.startup.Catalina start
INFO: Server startup in 6322610 ms
2012-10-28 00:42:26,995  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
org.springframework.extensions.webscripts.WebScriptException: 09280002 Wrapped Exception (with status template): 09280008 Problem converting to Freemarker

then i stopped alfresco, modified indexing to AUTO and restarted again.
It does again start a full reindex!

ransactionalCache' is full (65000).
2012-10-28 09:54:06,300  ERROR [index.AbstractReindexComponent.threads] [indexTrackerThread2] Reindexer     2 failed with error: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.io.StreamCorruptedException: invalid stream header: C2ACC3AD
### The error may involve alfresco.node.select_NodeProperties-Inline
### The error occurred while setting parameters
### Cause: org.alfresco.ibatis.SerializableTypeHandler$DeserializationException: java.io.StreamCorruptedException: invalid stream header: C2ACC3AD.
2012-10-28 09:54:06,301  WARN  [index.AbstractReindexComponent.threads] [indexTrackerThread2] org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
..
..
2012-10-28 11:17:21,081  INFO  [repo.admin.ConfigurationChecker] [main] The Alfresco root data directory ('dir.root') is: /opt/alfresco-4.0.e/alf_data
2012-10-28 11:17:21,112  ERROR [repo.admin.ConfigurationChecker] [main] CONTENT INTEGRITY ERROR: Indexes not found for 6 stores.
2012-10-28 11:17:21,112  INFO  [repo.admin.ConfigurationChecker] [main] You may set 'index.recovery.mode=FULL' if you need to rebuild the indexes.
2012-10-28 11:17:21,112  ERROR [repo.admin.ConfigurationChecker] [main] Ensure that the 'dir.root' property is pointing to the correct data location.
2012-10-28 11:17:21,132  ERROR [web.context.ContextLoader] [main] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 09280000 Ensure that the 'dir.root' property is pointing to the correct data location.
        at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:248)



currently i can't overcome this reindex error and afterwards i am unable to login to the share Interface as i get:
Remoteserver is reachable or logindata are not correct.

how can i force a successfull reindex?

best regards.thomas

Outcomes