Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37777

upgrade from MySQL 5.7 regression, mysql.servers invalid structure

    XMLWordPrintable

Details

    • 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

          Activity

            People

              serg Sergei Golubchik
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.