Fehler nach Server-Umzug / Backup


Startseite Foren Hilfe bei Problemen Fehler nach Server-Umzug / Backup

Verschlagwortet: , , , ,

3 Beiträge anzeigen - 1 bis 3 (von insgesamt 3)
  • Autor
    Beiträge
  • #6056
    bingo-ingo
    Teilnehmer

    Hallo,

    beim einspielen eines Backups (neuer Server) erhielt ich folgenden Fehler zum Schluss:

    ERROR 1273 (HY000) at line 936 in file: ‚/home/backups/jlawyerdb-dump.sql‘: Unknown collation: ‚utf8mb4_0900_ai_ci‘
    ERROR 1146 (42S02) at line 956 in file: ‚/home/backups/jlawyerdb-dump.sql‘: Table ‚jlawyerdb.flyway_schema_history‘ doesn’t exist
    ERROR 1146 (42S02) at line 957 in file: ‚/home/backups/jlawyerdb-dump.sql‘: Table ‚jlawyerdb.flyway_schema_history‘ doesn’t exist
    ERROR 1146 (42S02) at line 958 in file: ‚/home/backups/jlawyerdb-dump.sql‘: Table ‚jlawyerdb.flyway_schema_history‘ doesn’t exist
    ERROR 1146 (42S02) at line 959 in file: ‚/home/backups/jlawyerdb-dump.sql‘: Table ‚jlawyerdb.flyway_schema_history‘ doesn’t exist

    Bei der Anmeldung behauptet der Server die Version 1.9.1.0 zu haben. Ist aber aktuell 🙂

    Logfile sieht okay aus:

    2024-04-01 14:50:30,057 ERROR [com.jdimension.jlawyer.services.SingletonService] (Timer-6) observed directory does not exist
    2024-04-01 14:50:40,057 ERROR [com.jdimension.jlawyer.services.SingletonService] (Timer-6) observed directory does not exist
    2024-04-01 14:50:50,058 ERROR [com.jdimension.jlawyer.services.SingletonService] (Timer-6) observed directory does not exist
    2024-04-01 14:51:00,058 ERROR [com.jdimension.jlawyer.services.SingletonService] (Timer-6) observed directory does not exist
    2024-04-01 14:51:10,051 INFO [com.jdimension.jlawyer.timer.IterativeBackupTask] (Timer-4) backup task is starting
    2024-04-01 14:51:10,054 INFO [com.jdimension.jlawyer.timer.IterativeBackupTask] (Timer-4) backup mode: on
    2024-04-01 14:51:10,055 INFO [com.jdimension.jlawyer.timer.IterativeBackupTask] (Timer-4) encryption is enabled
    2024-04-01 14:51:10,057 ERROR [com.jdimension.jlawyer.services.SingletonService] (Timer-6) observed directory does not exist
    2024-04-01 14:51:10,066 INFO [com.jdimension.jlawyer.timer.IterativeBackupTask] (Timer-4) backup not scheduled for hour 14
    2024-04-01 14:51:20,058 ERROR [com.jdimension.jlawyer.services.SingletonService] (Timer-6) observed directory does not exist
    2024-04-01 14:51:30,058 ERROR [com.jdimension.jlawyer.services.SingletonService] (Timer-6) observed directory does not exist
    2024-04-01 14:51:40,057 ERROR [com.jdimension.jlawyer.services.SingletonService] (Timer-6) observed directory does not exist
    2024-04-01 14:51:50,057 ERROR [com.jdimension.jlawyer.services.SingletonService] (Timer-6) observed directory does not exist
    2024-04-01 14:51:54,060 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-3) Creating Service {http://RSVPortal.adesso.de/KanzleiService/}KanzleiService from WSDL: https://www.j-lawyer.org/downloads/wsdl-1.8.0/KanzleiService.wsdl
    2024-04-01 14:51:54,621 INFO [org.apache.cxf.common.jaxb.JAXBUtils] (default task-3) Failed to create MinimumEscapeHandler
    2024-04-01 14:51:54,888 INFO [com.jdimension.jlawyer.fax.SipgateAPI] (default task-2) Requesting Sipgate balance information
    2024-04-01 14:51:59,316 INFO [org.jboss.ejb.client] (default task-3) JBoss EJB Client version 4.0.44.Final
    2024-04-01 14:51:59,419 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-2) Creating Service {http://RSVPortal.adesso.de/KanzleiService/}KanzleiService from WSDL: https://www.j-lawyer.org/downloads/wsdl-1.8.0/KanzleiService.wsdl
    2024-04-01 14:51:59,717 INFO [org.apache.cxf.common.jaxb.JAXBUtils] (default task-2) Failed to create MinimumEscapeHandler
    2024-04-01 14:52:00,057 ERROR [com.jdimension.jlawyer.services.SingletonService] (Timer-6) observed directory does not exist
    2024-04-01 14:52:00,119 INFO [org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean] (default task-3) Creating Service {http://RSVPortal.adesso.de/KanzleiService/}KanzleiService from WSDL: https://www.j-lawyer.org/downloads/wsdl-1.8.0/KanzleiService.wsdl
    2024-04-01 14:52:00,364 INFO [org.apache.cxf.common.jaxb.JAXBUtils] (default task-3) Failed to create MinimumEscapeHandler
    2024-04-01 14:52:10,057 ERROR [com.jdimension.jlawyer.services.SingletonService] (Timer-6) observed directory does not exist
    2024-04-01 14:52:20,057 ERROR [com.jdimension.jlawyer.services.SingletonService] (Timer-6) observed directory does not exist

    Gibt es Ideen?

    Danke euch!

    #6058
    j-lawyer.org
    Administrator

    Das passiert wenn man von einer MySQL in eine MariaDB importiert, oder ein so großer Versionssprung der Datenbank vorliegt, dass ein bisher genutzer Zeichensatz nicht mehr unterstützt wird.

    > https://tecadmin.net/resolved-unknown-collation-utf8mb4_0900_ai_ci/

    VG
    Jens / j-lawyer.org

    #6059
    bingo-ingo
    Teilnehmer

    Prima, danke! Hat funktioniert!

3 Beiträge anzeigen - 1 bis 3 (von insgesamt 3)
  • Du musst angemeldet sein, um zu diesem Thema eine Antwort verfassen zu können.