Details
-
Bug
-
Status: Stalled (View Workflow)
-
Blocker
-
Resolution: Unresolved
-
10.11
-
None
-
Not for Release Notes
Description
upgrade from mysql:5.7 in ci occurred a regression after 957ec8bba6ca616a6aeb5d53cdac9c17df938d4c
code: https://github.com/MariaDB/mariadb-docker/blob/master/docker-entrypoint.sh#L606-L615
docker volumne create m57
|
docker run --name m5701 --rm --publish 3306 -v m57:/var/lib/mysql:Z -e MYSQL_INITDB_SKIP_TZINFO=1 -e MYSQL_ROOT_PASSWORD=bob docker.io/library/mysql:5.7
|
...
|
2025-10-01T03:40:42.849417Z 0 [Note] Shutting down plugin 'binlog'
|
2025-10-01T03:40:42.850478Z 0 [Note] mysqld: Shutdown complete
|
Version: '5.7.44' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
|
2025-10-01T03:40:41.325586Z 0 [Note] Giving 0 client threads a chance to die gracefully
|
...
|
2025-10-01T03:40:42.849417Z 0 [Note] Shutting down plugin 'binlog'
|
2025-10-01T03:40:42.850478Z 0 [Note] mysqld: Shutdown complete
|
|
docker run -e MARIADB_AUTO_UPGRADE=1 -v m57:/var/lib/mysql:Z --user mysql quay.io/mariadb-foundation/mariadb-devel@sha256:189319d7417d9d5ee4eb509d1e156e1169e9dd44234ed11ee76ccd847f63d831 bash -x -v /usr/local/bin/docker-entrypoint.sh mariadbd
|
....
|
|
+ createHealthCheckUsers='CREATE USER IF NOT EXISTS healthcheck@'\''127.0.0.1'\'' IDENTIFIED BY '\''n"{6>f.QI>fX^_6"j/pc8R(ey$;&g"lE'\'';
|
SET PASSWORD FOR healthcheck@'\''127.0.0.1'\'' = PASSWORD('\''n"{6>f.QI>fX^_6"j/pc8R(ey$;&g"lE'\'');
|
GRANT USAGE ON *.* TO healthcheck@'\''127.0.0.1'\'';
|
CREATE USER IF NOT EXISTS healthcheck@'\''::1'\'' IDENTIFIED BY '\''n"{6>f.QI>fX^_6"j/pc8R(ey$;&g"lE'\'';
|
SET PASSWORD FOR healthcheck@'\''::1'\'' = PASSWORD('\''n"{6>f.QI>fX^_6"j/pc8R(ey$;&g"lE'\'');
|
GRANT USAGE ON *.* TO healthcheck@'\''::1'\'';
|
CREATE USER IF NOT EXISTS healthcheck@'\''localhost'\'' IDENTIFIED BY '\''n"{6>f.QI>fX^_6"j/pc8R(ey$;&g"lE'\'';
|
SET PASSWORD FOR healthcheck@'\''localhost'\'' = PASSWORD('\''n"{6>f.QI>fX^_6"j/pc8R(ey$;&g"lE'\'');
|
GRANT USAGE ON *.* TO healthcheck@'\''localhost'\'';'
|
+ docker_process_sql --dont-use-mysql-root-password --binary-mode
|
+ '[' --dont-use-mysql-root-password = --dont-use-mysql-root-password ']'
|
+ shift
|
+ MYSQL_PWD=
|
+ docker_exec_client --binary-mode
|
+ '[' -n '' ']'
|
+ mariadb --protocol=socket -uroot -hlocalhost --socket=/run/mariadb/mariadb.sock --binary-mode
|
2025-10-01 3:41:15 5 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
|
2025-10-01 3:41:15 5 [ERROR] Incorrect definition of table mysql.servers: expected column 'Host' at position 1 to have type varchar(, found type char(64).
|
2025-10-01 3:41:15 5 [ERROR] Incorrect definition of table mysql.servers: expected column 'Owner' at position 8 to have type varchar(, found type char(64).
|
--------------
|
FLUSH PRIVILEGES
|
--------------
|
|
ERROR 1728 (HY000) at line 5: Cannot load from mysql.servers. The table is probably corrupted
|
Used to work correctly - validated against mariadb:10.11.14 container.
not for release notes - regression never made it to public release.
Attachments
Issue Links
- is caused by
-
MDEV-35622 SEGV, ASAN use-after-poison when reading system table with less than expected number of columns
-
- Closed
-
- relates to
-
MDEV-36221 CREATE SERVER segfaults on wrong mysql.servers
-
- Confirmed
-