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

Test main.mysql_upgrade seems unstable

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.5
    • 10.6
    • Tests
    • None

    Description

      During normal build on Gentoo Linux, main.mysql_upgrade is often failing. But when running test manually, it is passing:

      main.mysql_upgrade 'innodb'              w24 [ fail ]
              Test ended at 2021-11-14 19:49:22
       
      CURRENT_TEST: main.mysql_upgrade
      --- /var/tmp/portage/dev-db/mariadb-10.6.5/work/mysql/mysql-test/main/mysql_upgrade.result      2021-11-05 21:03:29.000000000 +0100
      +++ /var/tmp/portage/dev-db/mariadb-10.6.5/work/mysql/mysql-test/main/mysql_upgrade.reject      2021-11-14 19:49:21.729287406 +0100
      @@ -1706,7 +1706,6 @@
       root   N
       root   N
       root   N
      -root   N
       aRole  Y
       DROP ROLE aRole;
       #
      @@ -1961,7 +1960,7 @@
       # mysql_upgrade --force --silent 2>&1
       select count(*) from mysql.global_priv;
       count(*)
      -5
      +4
       drop table mysql.global_priv;
       rename table mysql.global_priv_bak to mysql.global_priv;
       #
       
      mysqltest: Result length mismatch
       
       - saving '/var/tmp/portage/dev-db/mariadb-10.6.5/temp/var-tests/24/log/main.mysql_upgrade-innodb/' to '/var/tmp/portage/dev-db/mariadb-10.6.5/temp/var-tests/log/main.mysql_upgrade-innodb/'
      ***Warnings generated in error logs during shutdown after running tests: main.mysql_upgrade
       
      2021-11-14 19:49:17 88 [ERROR] Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
      2021-11-14 19:49:17 104 [Warning] InnoDB: Table mysql.innodb_table_stats has length mismatch in the column name table_name. Please run mariadb-upgrade
      2021-11-14 19:49:17 104 [Warning] InnoDB: Table mysql.innodb_index_stats has length mismatch in the column name table_name. Please run mariadb-upgrade
      2021-11-14 19:49:18 124 [Warning] InnoDB: Table mysql.innodb_table_stats has length mismatch in the column name table_name. Please run mariadb-upgrade
      2021-11-14 19:49:18 124 [Warning] InnoDB: Table mysql.innodb_index_stats has length mismatch in the column name table_name. Please run mariadb-upgrade
      

      Attachments

        1. var-log.tar.xz
          1.34 MB
        2. build.log
          2.87 MB

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              whissi Thomas Deutschmann
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.