Hallo Community,
ich habe versucht meinen Mailcow-Server auf einen neuen Server zu Migrieren und bin dabei dem Tip von hier gefolgt:
https://mailcow.github.io/mailcow-dockerized-docs/i_u_m_migration/
und habe das backup and restore script dafür genutzt. Auf dem neuen Server habe ich ganz normal die Installation durchgeführt und dann das Restore Script gestartet. Es schien auch erfolgreich durchgelaufen zu sein. Doch wenn ich jetzt auf die Weboberfläche möchte, wird mir gesagt:
🐄 - we are on our way.
502
Ein Blick in die Logs verweist darauf das auf den SQL Server gewartet wird und der SQL Container gibt folgendes aus:
mysql-mailcow_1 | 2021-04-14 00:25:35+02:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.9+maria~focal started.
mysql-mailcow_1 | 2021-04-14 00:25:35+02:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql-mailcow_1 | 2021-04-14 00:25:35+02:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.9+maria~focal started.
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] mysqld (mysqld 10.5.9-MariaDB-1:10.5.9+maria~focal) starting as process 1 ...
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: Uses event mutexes
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: Number of pools: 1
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: Using Linux native AIO
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: Initializing buffer pool, total size = 25165824, chunk size = 25165824
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: Completed initialization of buffer pool
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: 128 rollback segments are active.
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: 10.5.9 started; log sequence number 928937; transaction id 1668
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] Server socket created on IP: '::'.
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] InnoDB: Buffer pool(s) load completed at 210414 0:25:36
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Warning] 'proxies_priv' entry '@% root@db2b6fe00f5e' ignored in --skip-name-resolve mode.
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
mysql-mailcow_1 | 2021-04-14 0:25:36 0 [Note] mysqld: ready for connections.
mysql-mailcow_1 | Version: '10.5.9-MariaDB-1:10.5.9+maria~focal' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
Also scheint doch irgendwas mit dem SQL Container nicht zu stimmen oder bei der Wiederherstellung ist etwas schief gelaufen oder habe ich etwas falsch gemacht? Auf jeden Fall bin ich überfragt was ich noch tun könnte. Eine erneute Wiederherstellung habe ich schon probiert. Leider ohne Erfolg.
Vielen Dank.
MfG Logibooze