05-20-2011 02:19 AM
> mysqldump alfresco > alfresco_latin1.sql
> iconv -f ISO8859-1 -t UTF-8 alfresco_latin1.sql > alfresco_utf8.sql
> cat alfresco_utf8.sql | sed -e 's/DEFAULT CHARSET=latin1;/DEFAULT CHARSET=utf8 COLLATE utf8_bin;/' > alfresco_utf8-1.sql
> cat alfresco_utf8-1.sql | sed -e 's/SET NAMES latin1/SET NAMES utf8/' > alfresco_utf8-2.sql
> mysql create database alfresco_utf8 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
> mysql alfresco_utf8 < alfresco_latin1.sql
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}?useUnicode\=yes&characterEncoding\=UTF-8
…Please did anybody had experience with migrating latin1 to utf-8 character set on mysql and how you resolved issue?
7:43:14,673 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 50 % complete.
17:43:35,556 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 60 % complete.
17:43:45,039 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer 182 failed with error: could not deserialize; nested exception is org.hibernate.type.SerializationException: could not deserialize.
17:43:53,811 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 70 % complete.
17:44:04,810 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 80 % complete.
17:44:23,245 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 90 % complete.
17:45:33,090 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 100 % complete.
21:05:05,786 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer 286 failed with error: could not deserialize; nested exception is org.hibernate.type.SerializationException: could not deserialize.
21:05:06,479 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery completed.
21:05:07,839 WARN [org.alfresco.repo.cache.TransactionalCache.org.alfresco.cache.qnameEntityTransactionalCache] Transactional update cache 'org.alfresco.cache.qnameEntityTransactionalCache' is full (500).
21:05:18,206 INFO [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Rebuilding indexes for 26 AVM Stores
21:05:18,207 INFO [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Rebuilding index for sitestore
21:05:18,401 INFO [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Reindex 0% complete
21:05:18,401 INFO [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Rebuilding index for project
21:05:18,620 INFO [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Rebuilding index for snapshots 0 to 772
…
21:06:44,034 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 04190000 Reindex failure for org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent
at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:291)
at org.alfresco.repo.node.index.IndexRecoveryBootstrapBean.onBootstrap(IndexRecoveryBootstrapBean.java:35)
at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
— The error occurred in alfresco/ibatis/#resource.dialect#/avm-common-SqlMap.xml.
— The error occurred while applying a result map.
— Check the alfresco.avm.result_AVMNodeProperty.
— Check the result mapping for the 'serializableValue' property.
— Cause: org.alfresco.ibatis.SerializableTypeHandlerCallback$DeserializationException: java.io.StreamCorruptedException: invalid stream header: C2ACC3AD; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/ibatis/#resource.dialect#/avm-common-SqlMap.xml.
— The error occurred while applying a result map.
— Check the alfresco.avm.result_AVMNodeProperty.
— Check the result mapping for the 'serializableValue' property.
— Cause: org.alfresco.ibatis.SerializableTypeHandlerCallback$DeserializationException: java.io.StreamCorruptedException: invalid stream header: C2ACC3AD
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:197)
at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:220)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:267)
…
05-20-2011 02:30 AM
mysql alfresco_utf8 < alfresco_latin1.sql
05-20-2011 02:51 AM
05-20-2011 03:55 AM
> mysql alfresco_utf8 < alfresco_utf8-2.sql
05-20-2011 04:14 AM
mysql -h host -u username -p password –default_character_set utf8 database < file.sql
since your file is now utf-8 encoded.
05-20-2011 04:33 AM
And please don't cross post. I've deleted them for you :!:Sorry about that is urgent question for us so that is the reason why I posted several times.
05-20-2011 04:42 AM
The only thing I can think of is that the conversion/import isn't correct after all. That during the reindexing Alfresco fails to read the database.
Have your tried to create a new repository (db+alf_data) that uses utf-8 and the connection string you are using? If all works well, then do an export of the database structure (excluding data) for that db and your converted db and compare them. Maybe you will find a difference there. If not, then there is something in the actual data.
What if you do a select in your converted db, does the data look correct then?
Some googling, with the importsince your file is now utf-8 encoded.mysql -h host -u username -p password –default_character_set utf8 database < file.sql
05-20-2011 04:50 AM
> mysql alfresco_utf8 < alfresco_utf8-2.sql
is importing using ISO8859-1 instead of UTF-8 (your data file is now in utf-8). Thats why I would suggest> mysql –default_character_set utf8 alfresco_utf8 < alfresco_utf8-2.sql
Other than that, I have no idea.
05-20-2011 04:59 AM
The only thing, as mentioned, is that the importis importing using ISO8859-1 instead of UTF-8 (your data file is now in utf-8). Thats why I would suggest> mysql alfresco_utf8 < alfresco_utf8-2.sql
Other than that, I have no idea.> mysql –default_character_set utf8 alfresco_utf8 < alfresco_utf8-2.sql
> mysql create database alfresco_utf8 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
05-23-2011 06:15 AM
> mysql –default_character_set utf8 alfresco_utf8 < alfresco_utf8-2.sql
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.