docker-compose-lamp
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.
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
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.