Docker character-set and collation-server problem after update

[chmat0s]

Hi,

I have problem, after automatic update by watchtower in docker mysql wont start.

Pull command:
docker run --name mysql-server-01 -it --network=zabbix-net -p 192.168.5.32:3306:3306 -v mysql-server-01:/var/lib/mysql -e MYSQL_DATABASE="zabbix" -e MYSQL_USER="zabbix" -e MYSQL_PASSWORD="secretpassword" -e MYSQL_ROOT_PASSWORD="secretpassword" -d mysql --character-set-server=utf8 --collation-server=utf8_bin --mysql_native_password=ON --restart always

Log:
2024-05-13 08:17:13+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
2024-05-13 08:17:13+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-05-13 08:17:13+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-05-13T08:17:13.750407Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-05-13T08:17:14.031302Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1
2024-05-13T08:17:14.032889Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-05-13T08:17:14.032895Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-05-13T08:17:14.038211Z 0 [Warning] [MY-010001] [Server] Can't create thread to handle bootstrap (errno: 1)
2024-05-13T08:17:14.038265Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-13T08:17:14.038279Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-13T08:17:14.039865Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.0) MySQL Community Server - GPL.
2024-05-13T08:17:14.039891Z 0 [System] [MY-015016] [Server] MySQL Server - end.

When I change pull command to
docker run --name mysql-server-01 -it --network=zabbix-net -p 192.168.5.32:3306:3306 -v mysql-server-01:/var/lib/mysql -e MYSQL_DATABASE="zabbix" -e MYSQL_USER="zabbix" -e MYSQL_PASSWORD="secretpassword" -e MYSQL_ROOT_PASSWORD="secretpassword" -d mysql --character-set-server=utf8mb4 --collation-server=utf8mb4_bin --mysql_native_password=ON --restart always

Mysql wont start too:
2024-05-13 08:57:11+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
2024-05-13 08:57:11+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-05-13 08:57:11+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-05-13T08:57:11.979599Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-05-13T08:57:12.256626Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1
2024-05-13T08:57:12.262892Z 0 [Warning] [MY-010001] [Server] Can't create thread to handle bootstrap (errno: 1)
2024-05-13T08:57:12.262953Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-05-13T08:57:12.262970Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-05-13T08:57:12.264710Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.0) MySQL Community Server - GPL.
2024-05-13T08:57:12.264734Z 0 [System] [MY-015016] [Server] MySQL Server - end.

[yosifkit]

Possibly #1058 (comment). You can also try mysql:8.4-oraclelinux8 to see if that runs correctly

[chmat0s]

Hi,
thank you very much! It is working!

[chmat0s]

Now is ok.