You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
[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.
#267
Open
tinodesigns opened this issue
Feb 13, 2024
· 1 comment
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-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.
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.
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
The text was updated successfully, but these errors were encountered: