Migration PostgreSQL nach MySQL

[msauer75]

Hallo zusammen,

ich versuche zur Zeit meine Alfresco 5.0.c Installation, die mit PostgreSQL laeuft, umzuziehen. Gleichzeitig will ich auch den Datenbank Server auf MySQL umstellen.
Ich habe jetzt auf meiner bestehenden Installation einen PG_DUMP erzeugt und diesen nach http://www.pukkapanel.com/guide29/convert-postgresql-dump-to-mysql in ein MySQL SQL File konvertiert. Dies konnte ich jetzt auf meinem neuen Server in die MySQL Datenbank ein lesen. Nachdem Starten des Tomcat7 konnte ich mich nicht mehr anmelden. Es kommt nur noch die Meldung "Ihre Authentifizierungsdaten wurden nicht erkannt oder Alfresco ist zurzeit nicht verfügbar.". In catalina.out konnte ich folgende Eintraege finden:

 2015-04-03 18:40:47,772  INFO  [alfresco.repo.admin] [localhost-startStop-1] Connected to database MySQL version 5.5.41-0ubuntu0.14.10.1 2015-04-03 18:40:52,372  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default] 2015-04-03 18:40:52,391  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete 2015-04-03 18:40:52,402  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V4.2-metadata-query-indexes 2015-04-03 18:40:56,689  INFO  [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor Repository Template Processor for extension ftl 2015-04-03 18:40:56,690  INFO  [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor Repository Script Processor for extension js 2015-04-03 18:40:57,873  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] 2015-04-03 18:40:57,897  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] complete 2015-04-03 18:40:57,925  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc:mysql://localhost/pfarrei_alf?useUnicode=yes&characterEncoding=UTF-8, UserName=pfarrei@localhost, MySQL Connector Java 2015-04-03 18:40:57,926  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect. 2015-04-03 18:40:58,326  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 234 potential problems, results written to: /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-alf_-5617404871001400472.tx 2015-04-03 18:40:58,490  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 369 potential problems, results written to: /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-jbpm_-620924991441690840.tx 2015-04-03 18:40:58,597  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 208 potential problems, results written to: /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-act_-7985090968661594782.tx 2015-04-03 18:40:58,977  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-alf_-8459165130986985667.xml.  2015-04-03 18:40:58,978  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-jbpm_-6816388499508662797.xml. 2015-04-03 18:40:58,978  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-act_-1630277546766940752.xml. 2015-04-03 18:40:59,061  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /tmp/tomcat7-tomcat7-tmp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-3854713294970287163.sql (Copied from classpath:alfresco/dbscripts/upgrade/4.1/o 2015-04-03 18:40:59,119  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /tmp/tomcat7-tomcat7-tmp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-7715120621097951750.sql (Generated). 2015-04-03 18:41:17,801  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /tmp/tomcat7-tomcat7-tmp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-1362012473289214311.sql (Copied from classpath:alfresco/dbscripts/create/org.hi 2015-04-03 18:41:26,010  ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed org.springframework.dao.DuplicateKeyException: ### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'patch.db-V4.0-Activiti-task-id-indexes' for key 'PRIMARY'### The error may involve alfresco.appliedpatch.insert_AppliedPatch-Inline### The error occurred while setting parameters### SQL: insert into alf_applied_patch             (                 id, description,                 fixes_from_schema, fixes_to_schema, target_schema,                 applied_to_schema, applied_on_date, applied_to_server,                 was_executed, succeeded, rep### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'patch.db-V4.0-Activiti-task-id-indexes' for key 'PRIMARY'; SQL []; Duplicate entry 'patch.db-V4.0-Activiti-task-id-indexes' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'patch.db-V4.0-Activiti-task-id-indexes' for key 'PRIMARY'        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)        at com.sun.proxy.$Proxy5.insert(Unknown Source)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Hat einer ein Tip fuer mich, wie ich den Fehler beheben kann?

Vielen Dank fuer Eure Hilfe.

gruss

martin

[msauer75]

Hallo,

solche foren finde ich immer wieder toll, bei denen man ueberhaupt keine Antwort auf Probleme bekommt. Gibt hier es denn niemanden, der bereit ist einem zu helfen?

gruss

msauer75