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
modified tomcat/scripts/ctl.sh
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:
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
and the the index recovery started with 648190 transactions. which took a while.
I got some times (6?):
in the end i got
finally i got
then i stopped alfresco, modified indexing to AUTO and restarted again.
It does again start a full reindex!
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
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
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
