Startseite › Foren › Hilfe bei Problemen › Fehler nach Server-Umzug / Backup
Verschlagwortet: Collation, mariadb, MySQL, UTF8, Zeichensatz
- Dieses Thema hat 2 Antworten sowie 2 Stimmen und wurde zuletzt vor vor 7 Monaten, 3 Wochen von bingo-ingo aktualisiert.
-
AutorBeiträge
-
1. April 2024 um 18:49 #6056bingo-ingoTeilnehmer
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 existBei 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 existGibt es Ideen?
Danke euch!
1. April 2024 um 18:52 #6058j-lawyer.orgAdministratorDas 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.org1. April 2024 um 20:09 #6059bingo-ingoTeilnehmerPrima, danke! Hat funktioniert!
-
AutorBeiträge
- Du musst angemeldet sein, um zu diesem Thema eine Antwort verfassen zu können.