I recently upgraded to 8.0.33. After the upgrade my database is no longer starting. I get the error below in the logs. I tried downgrading to 8.0.32 but it says that the database is to new for that version. Unfortunately I don't have a good backup of the information. Would anyone have any ideas on this? Mysql stops right after the error so I'm not able to do anything from inside of the container.
2023-05-24T23:32:48.686736Z 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.
2023-05-24T23:32:48.689268Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-05-24T23:32:48.689321Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.33) starting as process 1
2023-05-24T23:32:48.705577Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-05-24T23:32:49.534003Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-05-24T23:32:50.734792Z 4 [System] [MY-013381] [Server] Server upgrade from '80032' to '80033' started.
2023-05-24T23:33:46.203429Z 4 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'ALTER TABLE slave_worker_info STATS_PERSISTENT=0; ' failed with error code = 3664, error message = 'Failed to delete SDI 'mysql.slave_worker_info' in tablespace 'mysql'.'.
2023-05-24T23:33:46.223137Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server.
2023-05-24T23:33:46.223192Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-24T23:33:47.459875Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33) MySQL Community Server - GPL.
2023-05-24 18:32:47-05:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.33-1.el8 started.
2023-05-24 18:32:48-05:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-05-24 18:32:48-05:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.33-1.el8 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
I've encountered the same issue, were you able to fix it ?
[support] Bungy's docker repository
in Docker Containers
Posted
I've encountered the same issue, were you able to fix it ?