Xibo-cms-db not starting anymore after update

To be completed by the original poster:

CMS Version

4.0.10

Installation Method

Docker

Operating System

Windows 11

Issue

I have upgraded my Xibo version to the latest 4.0.10 and somehow my Xibo-cms-db-1 isn’t starting anymore. Please find the error logs below. I have already tried to restart my computer or roll back to a previous version but the issue persists. Also updating Docker itself doesn’t resolve the issue.

2024-04-11 17:10:12 2024-04-11T15:10:12.232384Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-04-11 17:10:12 2024-04-11T15:10:12.808275Z 1 [ERROR] [MY-012526] [InnoDB] Upgrade is not supported after a crash or shutdown with innodb_fast_shutdown = 2. This redo log was created with MySQL 5.7.41, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-04-11 17:10:12 2024-04-11T15:10:12.808357Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-04-11 17:10:13 2024-04-11T15:10:13.135314Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-04-11 17:10:13 2024-04-11T15:10:13.135554Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-04-11 17:10:13 2024-04-11T15:10:13.135613Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-04-11 17:10:13 2024-04-11T15:10:13.136547Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.
2024-04-11 17:10:15 2024-04-11T15:10:15.922553Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-04-11 17:10:15 2024-04-11T15:10:15.931391Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
2024-04-11 17:10:15 2024-04-11T15:10:15.936094Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
2024-04-11 17:10:15 2024-04-11T15:10:15.947487Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-04-11 17:10:16 2024-04-11T15:10:16.435377Z 1 [ERROR] [MY-012526] [InnoDB] Upgrade is not supported after a crash or shutdown with innodb_fast_shutdown = 2. This redo log was created with MySQL 5.7.41, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-04-11 17:10:16 2024-04-11T15:10:16.435462Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-04-11 17:10:16 2024-04-11T15:10:16.762605Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-04-11 17:10:16 2024-04-11T15:10:16.763577Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-04-11 17:10:16 2024-04-11T15:10:16.763711Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-04-11 17:10:16 2024-04-11T15:10:16.765223Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.
2024-04-11 17:10:21 2024-04-11T15:10:21.431904Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-04-11 17:10:21 2024-04-11T15:10:21.437779Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
2024-04-11 17:10:21 2024-04-11T15:10:21.443181Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
2024-04-11 17:10:21 2024-04-11T15:10:21.454751Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-04-11 17:10:21 2024-04-11T15:10:21.903828Z 1 [ERROR] [MY-012526] [InnoDB] Upgrade is not supported after a crash or shutdown with innodb_fast_shutdown = 2. This redo log was created with MySQL 5.7.41, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-04-11 17:10:21 2024-04-11T15:10:21.903875Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-04-11 17:10:22 2024-04-11T15:10:22.266736Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-04-11 17:10:22 2024-04-11T15:10:22.267005Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-04-11 17:10:22 2024-04-11T15:10:22.267041Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-04-11 17:10:22 2024-04-11T15:10:22.268024Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.
2024-04-11 17:10:29 2024-04-11 15:10:29+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-04-11 17:10:29 2024-04-11 15:10:29+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
2024-04-11 17:10:29 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-04-11 17:10:30 2024-04-11T15:10:30.050955Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-04-11 17:10:30 2024-04-11T15:10:30.058585Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
2024-04-11 17:10:30 2024-04-11T15:10:30.064926Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
2024-04-11 17:10:30 2024-04-11T15:10:30.075991Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-04-11 17:10:30 2024-04-11T15:10:30.588034Z 1 [ERROR] [MY-012526] [InnoDB] Upgrade is not supported after a crash or shutdown with innodb_fast_shutdown = 2. This redo log was created with MySQL 5.7.41, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-04-11 17:10:30 2024-04-11T15:10:30.588082Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-04-11 17:10:30 2024-04-11T15:10:30.937285Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-04-11 17:10:30 2024-04-11T15:10:30.937541Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-04-11 17:10:30 2024-04-11T15:10:30.937598Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-04-11 17:10:30 2024-04-11T15:10:30.938845Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)```
  1. Roll back to your previous version
  2. Perform a slow shutdown (by setting innodb_fast_shutdown=0)
  3. Upgrade then

You can also take a dump of your mysql data and then delete ib_logfile0 and ib_logfile1 as described on http://dev.mysql.com/doc/refman/8.0/en/upgrading.html

Hi,

Thanks for your reply. My cms-db-1 keeps restarting so I can’t SSH into the container to change the value of innodb_fast_shutdown. Is there anything else I can do?