AnsweredAssumed Answered

Migration PostgreSQL nach MySQL

Question asked by msauer75 on Apr 3, 2015
Latest reply on Apr 11, 2015 by 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

Outcomes