[BUG] MySQL crashes after an update = 8.4 #277
Assignees
Comments
|
I applied the fix mentioned. It resolved the authentication error. But it produces the following error and mysql keeps restarting until the container is killed.
Error message |
I have the same issue |
|
Hey @lahirumd , just delete the container in Docker Desktop, then empty the /data/ directory:
and then rebuild everything:
it worked for me. |
Awesome. You saved the day. This worked. Thanks a lot mate. |
|
Hi Guys, |
|
Hello, I am experiencing the same issue just now. Environment:
❯ docker --version
Docker version 26.1.1, build 4cf5afa
❯ docker-compose --version
Docker Compose version v2.27.0-desktop.2This is my services:
db:
image: mysql
restart: always
environment:
MYSQL_ROOT_PASSWORD: password
MYSQL_DATABASE: dbname
MYSQL_USER: dbuser
MYSQL_PASSWORD: dbuserpassword
ports:
- "13306:3306"
volumes:
- mysql_data:/var/lib/mysql
volumes:
mysql_data: {}These are the logs: ❯ docker-compose up --build
[+] Running 2/0
✔ Network net_default Created 0.0s
✔ Container db-1 Created 0.1s
Attaching to db-1
db-1 | 2024-06-01 00:48:23+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
db-1 | 2024-06-01 00:48:23+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
db-1 | 2024-06-01 00:48:23+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
db-1 | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
db-1 | 2024-06-01T00:48:23.963134Z 0 [System] [MY-015015] [Server] MySQL Server - start.
db-1 | 2024-06-01T00:48:24.205272Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1
db-1 | 2024-06-01T00:48:24.210209Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
db-1 | 2024-06-01T00:48:24.330816Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
db-1 | mysqld: Table 'mysql.plugin' doesn't exist
db-1 | 2024-06-01T00:48:24.384760Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
db-1 | 2024-06-01T00:48:24.384882Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
db-1 | 2024-06-01T00:48:24.385018Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
db-1 | 2024-06-01T00:48:24.385095Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
db-1 | 2024-06-01T00:48:24.385254Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
db-1 | 2024-06-01T00:48:24.385332Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
db-1 | 2024-06-01T00:48:24.385391Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
db-1 | 2024-06-01T00:48:24.385448Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
db-1 | 2024-06-01T00:48:24.410285Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
db-1 | 2024-06-01T00:48:24.474551Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
db-1 | 2024-06-01T00:48:24.479410Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
db-1 | 2024-06-01T00:48:24.479434Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
db-1 | 2024-06-01T00:48:24.481706Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
db-1 | 2024-06-01T00:48:24.481862Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
db-1 | 2024-06-01T00:48:24.481964Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
db-1 | 2024-06-01T00:48:24.481972Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
db-1 | 2024-06-01T00:48:24.482560Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
db-1 | 2024-06-01T00:48:24.482594Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual.
db-1 | 2024-06-01T00:48:24.482638Z 0 [ERROR] [MY-010119] [Server] Aborting
db-1 | 2024-06-01T00:48:26.033194Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.0) MySQL Community Server - GPL.
db-1 | 2024-06-01T00:48:26.033231Z 0 [System] [MY-015016] [Server] MySQL Server - end.
db-1 exited with code 1The suggested solution by @MHostinato didn't work as I don't have a data folder to remove. I will try downgrading. Thanks everyone for the comments and suggestions! |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Describe the bug
default-authentication-plugin=mysql_native_passwordconfiguration enabled by default in the Dockerfile for mysql8Which Branch / PHP Version are you using ?
php83Steps to reproduce
mysql8as databaseExpected behavior
Error message
This just repeats until I kill the container
Desktop (please complete the following information):
Windows26.0.0Additional context
The text was updated successfully, but these errors were encountered: