docker-compose-lamp icon indicating copy to clipboard operation
docker-compose-lamp copied to clipboard

[BUG] MYSQL not starting - it says it has files in data folder, even when I clean it out --initialize specified but the data directory has files in it. Aborting.

Open tinodesigns opened this issue 1 year ago • 1 comments

Here is the full log of the error. It basically just try to restart constantly but is coming up with the same error. If I manually delete the folder it recreates it (with the auto.cnf) and gives back the same error:

2024-02-13 03:51:24+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.3.0-1.el8 started.

2024-02-13 03:51:25+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'

2024-02-13 03:51:25+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.3.0-1.el8 started.

2024-02-13 03:51:25+00:00 [Note] [Entrypoint]: Initializing database files

2024-02-13T03:51:25.913150Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.

2024-02-13T03:51:25.917781Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.

2024-02-13T03:51:25.917819Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.3.0) initializing of server in progress as process 80

2024-02-13T03:51:25.922590Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.

2024-02-13T03:51:25.922615Z 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.

2024-02-13T03:51:25.923161Z 0 [ERROR] [MY-010119] [Server] Aborting

2024-02-13T03:51:25.924244Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.

which Branch / PHP Version are you using ? php83

Steps to reproduce

Expected behavior well it should work without mysql constantly trying to restart.

docker -v Docker version 25.0.2, build 29cf629

tinodesigns avatar Feb 13 '24 03:02 tinodesigns

I was able to resolve this by resetting my whole system. Raspberrypi OS Lite on a raspy 4, with OMV and docker. Not sure why this came up, I assume it were some permission issues.

Anyway it is currently working fine. If this comes back I might post it here, hopefully with more details.

tinodesigns avatar Feb 17 '24 14:02 tinodesigns