Docker mysql will not start after power failure

[JDdoesIT]

Somehow my UPS faulted during a power outage, and after I got the host back online I cannot get the container to start. The logs are below.

 

Quote

2023-11-08T01:32:47.413873Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2023-11-08T01:32:47.416507Z 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-11-08T01:32:47.416798Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.2.0) initializing of server in progress as process 80
2023-11-08T01:32:47.420144Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2023-11-08T01:32:47.420152Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2023-11-08T01:32:47.420218Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-11-08T01:32:47.420410Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.2.0)  MySQL Community Server - GPL.
2023-11-08T01:32:47.420730Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
2023-11-08T02:59:10.910757Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2023-11-08T02:59:10.913298Z 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-11-08T02:59:10.913489Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.2.0) initializing of server in progress as process 79
2023-11-08T02:59:10.916749Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2023-11-08T02:59:10.916756Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2023-11-08T02:59:10.916814Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-11-08T02:59:10.917011Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.2.0)  MySQL Community Server - GPL.
2023-11-08T02:59:10.917323Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
2023-11-07 19:32:46-06:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
2023-11-07 19:32:47-06:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-11-07 19:32:47-06:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
2023-11-07 19:32:47-06:00 [Note] [Entrypoint]: Initializing database files
2023-11-07 20:59:06-06:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
2023-11-07 20:59:10-06:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-11-07 20:59:10-06:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
2023-11-07 20:59:10-06:00 [Note] [Entrypoint]: Initializing database files

 

[Frank1940]

You should be posting this in the support thread for MySQL...