Error on upgrade

[Cedric_REYMOND]

Hello Team,
I just upgraded from latest version and got the fatal error
Fatal Error - sorry this shouldn’t happen.
SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for mysql failed: Name or service not known

Looks like there is an error with the MySQL Db.
Does anyone else faced this issue?

Anyone knows how to fix it??

Thanks,
Cedric

Attaching to xibo_cms-web_1
, xibo_cms-db_1, xibo_cms-xmr_1, xibo_cms-memcached_1, xibo_cms-quickchart_1
cms-web_1         | Waiting for MySQL to start - max 300 seconds
cms-web_1         | MySQL started
cms-web_1         | Configuring MySQL cnf file
cms-web_1         | Updating settings.php
cms-web_1         | ERROR 2005 (HY000): Unknown MySQL server host 'mysql' (-2)
cms-web_1         | New install
cms-web_1         | Provisioning Database
cms-web_1         | ERROR 2005 (HY000): Unknown MySQL server host 'mysql' (-2)
cms-web_1         | Phinx by CakePHP - https://phinx.org.
cms-web_1         |
cms-web_1         | using config file /var/www/cms/phinx.php
cms-web_1         | using config parser php
cms-db_1          | 2023-12-04 09:57:53+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | 2023-12-04 09:57:56+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
cms-db_1          | 2023-12-04 09:57:57+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
cms-db_1          | 2023-12-04T09:57:57.706101Z 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.
cms-db_1          | 2023-12-04T09:57:57.708353Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
cms-db_1          | 2023-12-04T09:57:57.802715Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
cms-db_1          | 2023-12-04T09:57:57.802835Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db_1          | 2023-12-04T09:57:59.534842Z 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.38, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
cms-db_1          | 2023-12-04T09:57:59.534885Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-db_1          | 2023-12-04T09:57:59.969225Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
cms-db_1          | 2023-12-04T09:57:59.969483Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db_1          | 2023-12-04T09:57:59.969515Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db_1          | 2023-12-04T09:57:59.970012Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.
cms-db_1          | 2023-12-04 09:58:01+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | 2023-12-04 09:58:02+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
cms-db_1          | 2023-12-04 09:58:02+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
cms-db_1          | 2023-12-04T09:58:02.905065Z 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.
cms-db_1          | 2023-12-04T09:58:02.907251Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
cms-db_1          | 2023-12-04T09:58:03.112028Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
cms-db_1          | 2023-12-04T09:58:03.112128Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db_1          | 2023-12-04T09:58:04.573977Z 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.38, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
cms-db_1          | 2023-12-04T09:58:04.574019Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-db_1          | 2023-12-04T09:58:04.986296Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
cms-db_1          | 2023-12-04T09:58:04.993271Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db_1          | 2023-12-04T09:58:04.993319Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db_1          | 2023-12-04T09:58:04.994065Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.
cms-db_1          | 2023-12-04 09:58:06+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | 2023-12-04 09:58:06+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
cms-db_1          | 2023-12-04 09:58:06+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
cms-db_1          | 2023-12-04T09:58:07.286344Z 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.
cms-db_1          | 2023-12-04T09:58:07.288569Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
cms-db_1          | 2023-12-04T09:58:07.299481Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
cms-db_1          | 2023-12-04T09:58:07.299533Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db_1          | 2023-12-04T09:58:08.297469Z 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.38, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
cms-db_1          | 2023-12-04T09:58:08.297515Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-db_1          | 2023-12-04T09:58:08.676645Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
cms-db_1          | 2023-12-04T09:58:08.677342Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db_1          | 2023-12-04T09:58:08.677373Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db_1          | 2023-12-04T09:58:08.677898Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.
cms-db_1          | 2023-12-04 09:58:09+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | 2023-12-04 09:58:10+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
cms-db_1          | 2023-12-04 09:58:10+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
cms-db_1          | 2023-12-04T09:58:10.914351Z 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.
cms-db_1          | 2023-12-04T09:58:10.916628Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
cms-web_1         | using migration paths
cms-db_1          | 2023-12-04T09:58:10.927484Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
cms-db_1          | 2023-12-04T09:58:10.927591Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-web_1         |  - /var/www/cms/db/migrations
cms-memcached_1   | Signal handled: Terminated.
cms-memcached_1   | Signal handled: Terminated.
cms-db_1          | 2023-12-04T09:58:12.527367Z 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.38, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
cms-db_1          | 2023-12-04T09:58:12.527409Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-memcached_1   | Signal handled: Terminated.
cms-web_1         | warning no environment specified, defaulting to: production
cms-memcached_1   | Signal handled: Terminated.
cms-memcached_1   | Signal handled: Terminated.
cms-memcached_1   | Signal handled: Terminated.
cms-web_1         | using adapter mysql
cms-memcached_1   | Signal handled: Terminated.
cms-memcached_1   | Signal handled: Terminated.
cms-db_1          | 2023-12-04T09:58:12.933596Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
cms-db_1          | 2023-12-04T09:58:12.934454Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-memcached_1   | Signal handled: Terminated.
cms-memcached_1   | Signal handled: Terminated.
cms-db_1          | 2023-12-04T09:58:12.934606Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-web_1         | using database cms
cms-memcached_1   | Signal handled: Terminated.
cms-web_1         | ordering by creation time
cms-db_1          | 2023-12-04T09:58:12.936211Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.
cms-db_1          | 2023-12-04 09:58:14+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | 2023-12-04 09:58:15+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
cms-db_1          | 2023-12-04 09:58:15+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
cms-db_1          | 2023-12-04T09:58:15.845406Z 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.
cms-db_1          | 2023-12-04T09:58:15.847669Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
cms-db_1          | 2023-12-04T09:58:15.993827Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
cms-db_1          | 2023-12-04T09:58:15.993913Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db_1          | 2023-12-04T09:58:18.765620Z 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.38, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
cms-db_1          | 2023-12-04T09:58:18.765822Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-db_1          | 2023-12-04T09:58:19.191374Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
cms-db_1          | 2023-12-04T09:58:19.191997Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db_1          | 2023-12-04T09:58:19.192372Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db_1          | 2023-12-04T09:58:19.193793Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.
cms-db_1          | 2023-12-04 09:58:21+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | 2023-12-04 09:58:21+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
cms-db_1          | 2023-12-04 09:58:21+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
cms-db_1          | 2023-12-04T09:58:22.473131Z 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.
cms-db_1          | 2023-12-04T09:58:22.475394Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
cms-web_1         | PDOException: PDO::__construct(): php_network_getaddresses: getaddrinfo for mysql failed: Name or service not known in /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:86
cms-db_1          | 2023-12-04T09:58:22.485834Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
cms-web_1         | Stack trace:
cms-memcached_1   | Signal handled: Terminated.
cms-memcached_1   | Signal handled: Terminated.
cms-web_1         | #0 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(86): PDO->__construct()
cms-memcached_1   | Signal handled: Terminated.
cms-memcached_1   | Signal handled: Terminated.
cms-web_1         | #1 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/MysqlAdapter.php(158): Phinx\Db\Adapter\PdoAdapter->createPdoConnection()
cms-db_1          | 2023-12-04T09:58:22.485878Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db_1          | 2023-12-04T09:58:24.926859Z 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.38, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
cms-web_1         | #2 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(163): Phinx\Db\Adapter\MysqlAdapter->connect()
cms-memcached_1   | Signal handled: Terminated.
cms-db_1          | 2023-12-04T09:58:24.926908Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-web_1         | #3 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(226): Phinx\Db\Adapter\PdoAdapter->getConnection()
cms-db_1          | 2023-12-04T09:58:25.352037Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
cms-db_1          | 2023-12-04T09:58:25.353048Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db_1          | 2023-12-04T09:58:25.353141Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db_1          | 2023-12-04T09:58:25.354755Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.
cms-web_1         | #4 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(247): Phinx\Db\Adapter\PdoAdapter->query()
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Telemetry is enabled","time":"2022-06-07T15:16:56.150Z","v":0}
cms-quickchart_1  | Tue, 07 Jun 2022 15:16:56 GMT body-parser deprecated undefined extended: provide extended option at index.js:38:17
cms-db_1          | 2023-12-04 09:58:29+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Setting request timeout: 5000 ms","time":"2022-06-07T15:16:56.793Z","v":0}
cms-web_1         | #5 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(383): Phinx\Db\Adapter\PdoAdapter->fetchAll()
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"NODE_ENV: production","time":"2022-06-07T15:16:56.793Z","v":0}
cms-db_1          | 2023-12-04 09:58:29+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
cms-db_1          | 2023-12-04 09:58:29+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
cms-db_1          | 2023-12-04T09:58:30.184493Z 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.
cms-db_1          | 2023-12-04T09:58:30.186737Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
cms-db_1          | 2023-12-04T09:58:30.199599Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
cms-db_1          | 2023-12-04T09:58:30.200461Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db_1          | 2023-12-04T09:58:31.470824Z 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.38, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
cms-web_1         | #6 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(355): Phinx\Db\Adapter\PdoAdapter->getVersionLog()
cms-db_1          | 2023-12-04T09:58:31.470894Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-db_1          | 2023-12-04T09:58:31.899154Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
cms-db_1          | 2023-12-04T09:58:31.900732Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-web_1         | #7 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php(205): Phinx\Db\Adapter\PdoAdapter->getVersions()
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Listening on port 3400","time":"2022-06-07T15:16:56.793Z","v":0}
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Telemetry is enabled","time":"2022-07-11T15:15:19.814Z","v":0}
cms-db_1          | 2023-12-04T09:58:31.901094Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-quickchart_1  | Mon, 11 Jul 2022 15:15:30 GMT body-parser deprecated undefined extended: provide extended option at index.js:38:17
cms-web_1         | #8 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php(254): Phinx\Db\Adapter\AdapterWrapper->getVersions()
cms-db_1          | 2023-12-04T09:58:31.902430Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.
cms-db_1          | 2023-12-04 09:58:39+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | 2023-12-04 09:58:39+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Setting request timeout: 5000 ms","time":"2022-07-11T15:15:30.560Z","v":0}
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"NODE_ENV: production","time":"2022-07-11T15:15:30.560Z","v":0}
cms-web_1         | #9 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(315): Phinx\Migration\Manager\Environment->getVersions()
cms-web_1         | #10 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Console/Command/Migrate.php(122): Phinx\Migration\Manager->migrate()
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Listening on port 3400","time":"2022-07-11T15:15:30.561Z","v":0}
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Telemetry is enabled","time":"2022-08-02T14:09:13.118Z","v":0}
cms-quickchart_1  | Tue, 02 Aug 2022 14:09:16 GMT body-parser deprecated undefined extended: provide extended option at index.js:38:17
cms-xmr_1         | Operation not permitted (src/thread.cpp:269)
cms-db_1          | 2023-12-04 09:58:39+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Setting request timeout: 5000 ms","time":"2022-08-02T14:09:17.247Z","v":0}
cms-web_1         | #11 /var/www/cms/vendor/symfony/console/Command/Command.php(298): Phinx\Console\Command\Migrate->execute()
cms-web_1         | #12 /var/www/cms/vendor/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run()
cms-db_1          | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
cms-db_1          | 2023-12-04T09:58:39.901717Z 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.
cms-db_1          | 2023-12-04T09:58:39.903738Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
cms-web_1         | #13 /var/www/cms/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
cms-web_1         | #14 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Console/PhinxApplication.php(70): Symfony\Component\Console\Application->doRun()
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"NODE_ENV: production","time":"2022-08-02T14:09:17.247Z","v":0}
cms-db_1          | 2023-12-04T09:58:39.914050Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
cms-xmr_1         | Aborted (core dumped)
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Listening on port 3400","time":"2022-08-02T14:09:17.247Z","v":0}
cms-db_1          | 2023-12-04T09:58:39.914133Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-web_1         | #15 /var/www/cms/vendor/symfony/console/Application.php(171): Phinx\Console\PhinxApplication->doRun()
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Telemetry is enabled","time":"2022-09-02T08:22:12.593Z","v":0}
cms-db_1          | 2023-12-04T09:58:42.999341Z 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.38, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
cms-web_1         | #16 /var/www/cms/vendor/robmorgan/phinx/bin/phinx(28): Symfony\Component\Console\Application->run()
cms-quickchart_1  | Fri, 02 Sep 2022 08:22:15 GMT body-parser deprecated undefined extended: provide extended option at index.js:38:17
cms-xmr_1         | Operation not permitted (src/thread.cpp:269)
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Setting request timeout: 5000 ms","time":"2022-09-02T08:22:15.954Z","v":0}
cms-db_1          | 2023-12-04T09:58:42.999552Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-web_1         | #17 /var/www/cms/vendor/bin/phinx(119): include('...')
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"NODE_ENV: production","time":"2022-09-02T08:22:15.955Z","v":0}
cms-xmr_1         | Aborted (core dumped)
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Listening on port 3400","time":"2022-09-02T08:22:15.955Z","v":0}
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Telemetry is enabled","time":"2022-09-02T08:52:59.086Z","v":0}
cms-db_1          | 2023-12-04T09:58:43.411667Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
cms-web_1         | #18 {main}
cms-db_1          | 2023-12-04T09:58:43.412126Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db_1          | 2023-12-04T09:58:43.412288Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db_1          | 2023-12-04T09:58:43.413049Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.
cms-web_1         |
cms-quickchart_1  | Fri, 02 Sep 2022 08:53:03 GMT body-parser deprecated undefined extended: provide extended option at index.js:38:17
cms-xmr_1         | Operation not permitted (src/thread.cpp:269)
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Setting request timeout: 5000 ms","time":"2022-09-02T08:53:03.341Z","v":0}
cms-db_1          | 2023-12-04 09:58:56+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-web_1         | Next PDOException: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for mysql failed: Name or service not known in /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:86
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"NODE_ENV: production","time":"2022-09-02T08:53:03.341Z","v":0}
cms-xmr_1         | Aborted (core dumped)
cms-db_1          | 2023-12-04 09:58:57+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Listening on port 3400","time":"2022-09-02T08:53:03.342Z","v":0}
cms-web_1         | Stack trace:
cms-db_1          | 2023-12-04 09:58:57+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Received kill signal, shutting down gracefully.","time":"2022-10-06T09:56:38.783Z","v":0}
cms-web_1         | #0 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(86): PDO->__construct()
cms-db_1          | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
cms-db_1          | 2023-12-04T09:58:57.783390Z 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.
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Closed out remaining connections.","time":"2022-10-06T09:56:38.784Z","v":0}
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Telemetry is enabled","time":"2022-10-06T10:10:10.617Z","v":0}
cms-web_1         | #1 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/MysqlAdapter.php(158): Phinx\Db\Adapter\PdoAdapter->createPdoConnection()
cms-web_1         | #2 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(163): Phinx\Db\Adapter\MysqlAdapter->connect()
cms-quickchart_1  | Thu, 06 Oct 2022 10:10:12 GMT body-parser deprecated undefined extended: provide extended option at index.js:38:17
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Setting request timeout: 5000 ms","time":"2022-10-06T10:10:12.655Z","v":0}
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"NODE_ENV: production","time":"2022-10-06T10:10:12.655Z","v":0}
cms-web_1         | #3 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(226): Phinx\Db\Adapter\PdoAdapter->getConnection()
cms-web_1         | #4 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(247): Phinx\Db\Adapter\PdoAdapter->query()
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Listening on port 3400","time":"2022-10-06T10:10:12.655Z","v":0}
cms-xmr_1         | Operation not permitted (src/thread.cpp:269)
cms-db_1          | 2023-12-04T09:58:57.785705Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Received kill signal, shutting down gracefully.","time":"2022-10-06T10:13:57.752Z","v":0}
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Closed out remaining connections.","time":"2022-10-06T10:13:57.753Z","v":0}
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Telemetry is enabled","time":"2022-10-06T10:14:25.943Z","v":0}
cms-web_1         | #5 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(383): Phinx\Db\Adapter\PdoAdapter->fetchAll()
cms-db_1          | 2023-12-04T09:58:57.795644Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
cms-xmr_1         | Aborted (core dumped)
cms-quickchart_1  | Thu, 06 Oct 2022 10:14:26 GMT body-parser deprecated undefined extended: provide extended option at index.js:38:17
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Setting request timeout: 5000 ms","time":"2022-10-06T10:14:26.471Z","v":0}
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"NODE_ENV: production","time":"2022-10-06T10:14:26.471Z","v":0}
cms-web_1         | #6 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(355): Phinx\Db\Adapter\PdoAdapter->getVersionLog()
cms-db_1          | 2023-12-04T09:58:57.795676Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Listening on port 3400","time":"2022-10-06T10:14:26.471Z","v":0}
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Received kill signal, shutting down gracefully.","time":"2022-10-06T10:25:32.523Z","v":0}
cms-web_1         | #7 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php(205): Phinx\Db\Adapter\PdoAdapter->getVersions()
cms-db_1          | 2023-12-04T09:58:58.477626Z 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.38, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
cms-db_1          | 2023-12-04T09:58:58.477675Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-web_1         | #8 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php(254): Phinx\Db\Adapter\AdapterWrapper->getVersions()
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Closed out remaining connections.","time":"2022-10-06T10:25:32.525Z","v":0}
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Telemetry is enabled","time":"2022-10-06T10:28:08.521Z","v":0}
cms-quickchart_1  | Thu, 06 Oct 2022 10:28:15 GMT body-parser deprecated undefined extended: provide extended option at index.js:38:17
cms-quickchart_1  | {"name":"quickchart","hostname":"4e1279d35237","pid":1,"level":30,"msg":"Setting request timeout: 5000 ms","time":"2022-10-06T10:28:15.103Z","v":0}
cms-quickchart_1  |

[dan]

Can you describe what steps you took to upgrade?

Unknown MySQL server host ‘mysql’

By default the docker-compose file will create an alias “mysql” for the database container inside the docker network. If this host cannot be found either the DB container has failed to start, or there is something wrong with the configuration somewhere.

In your case it looks like MySQL crashed:

cms-db_1          | 2023-12-04 09:57:53+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | 2023-12-04 09:57:56+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
cms-db_1          | 2023-12-04 09:57:57+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
cms-db_1          | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
cms-db_1          | 2023-12-04T09:57:57.706101Z 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.
cms-db_1          | 2023-12-04T09:57:57.708353Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
cms-db_1          | 2023-12-04T09:57:57.802715Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
cms-db_1          | 2023-12-04T09:57:57.802835Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db_1          | 2023-12-04T09:57:59.534842Z 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.38, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
cms-db_1          | 2023-12-04T09:57:59.534885Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
cms-db_1          | 2023-12-04T09:57:59.969225Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
cms-db_1          | 2023-12-04T09:57:59.969483Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db_1          | 2023-12-04T09:57:59.969515Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db_1          | 2023-12-04T09:57:59.970012Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.

In this case what you’re likely have to do is to restore a backup of your database into a new MySQL 8.0 container. You’d down the containers, delete the contents of the shared/db folder (not the database backup), and then follow the instructions for moving to docker in the installation guide.

Obviously make sure you have a backup first!

Docker upgrade from 4.0.0 to 4.0.1 or 4.0.2 fails with mysql error

If you still can’t get it to work then I would take your pre-upgrade backup, dump the data with mysqldump, stop the containers, move shared/db to shared/db_old, and put your database dump as shared/backup/import.sql. Then do the upgrade, and your backup will be loaded in to a clean MySQL database and it should all be fine from there.

[Cedric_REYMOND]

Hello,
thanks for your help, but I have found the issue.
One partition is running out of space… and I can’t resize it for some reason.
I am builind a new ubuntu server, I am looking for the steps to migrate from one server to another.
Any advices are welcome.
I have restored current server to previous backup.
Thanks,
Cedric