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

main.ctype_upgrade failed in buildbot, error upon mysql_upgrade

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.2(EOL), 10.5
    • 10.5
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/win32-debug/builds/9799

      main.ctype_upgrade 'innodb'              w4 [ fail ]
              Test ended at 2018-07-30 14:20:16
       
      CURRENT_TEST: main.ctype_upgrade
      mysqltest: At line 177: exec of 'D:\win32-debug\build\client\Debug\mysql_upgrade.exe --defaults-file=D:/win32-debug/build/mysql-test/var/4/my.cnf --force 2>&1' failed, error: 1, status: 1, errno: 0
      Output from before failure:
      Phase 1/7: Checking and upgrading mysql database
      Processing databases
      mysql
      mysql.column_stats                                 OK
      mysql.columns_priv                                 OK
      mysql.db                                           OK
      mysql.event                                        OK
      mysql.func                                         OK
      mysql.gtid_slave_pos                               OK
      mysql.help_category                                OK
      mysql.help_keyword                                 OK
      mysql.help_relation                                OK
      mysql.help_topic                                   OK
      mysql.host                                         OK
      mysql.index_stats                                  OK
      mysql.innodb_index_stats                           OK
      mysql.innodb_table_stats                           OK
      mysql.plugin                                       OK
      mysql.proc                                         OK
      mysql.procs_priv                                   OK
      mysql.proxies_priv                                 OK
      mysql.roles_mapping                                OK
      mysql.servers                                      OK
      mysql.table_stats                                  OK
      mysql.tables_priv                                  OK
      mysql.time_zone                                    OK
      mysql.time_zone_leap_second                        OK
      mysql.time_zone_name                               OK
      mysql.time_zone_transition                         OK
      mysql.time_zone_transition_type                    OK
      mysql.user                                         OK
      Phase 2/7: Installing used storage engines... Skipped
      Phase 3/7: Fixing views
      Phase 4/7: Running 'mysql_fix_privilege_tables'
       
       
       
      The result from queries just before the failure was:
      < snip >
      mtr
      mtr.global_suppressions                            OK
      mtr.test_suppressions                              OK
      performance_schema
      test
      test.maria050313_ucs2_croatian_ci_def              Needs upgrade
      test.maria050313_utf8_croatian_ci                  Needs upgrade
      test.maria050533_xxx_croatian_ci                   Needs upgrade
      test.maria100004_xxx_croatian_ci                   Needs upgrade
      test.mysql050614_xxx_croatian_ci                   OK
       
      Repairing tables
      test.maria050313_ucs2_croatian_ci_def              OK
      test.maria050313_utf8_croatian_ci                  OK
      test.maria050533_xxx_croatian_ci                   OK
      test.maria100004_xxx_croatian_ci                   OK
      Phase 7/7: Running 'FLUSH PRIVILEGES'
      OK
      # Running mysql_upgrade for the second time
      # This should report OK for all tables
       
      More results from queries before failure can be found in D:\win32-debug\build\mysql-test\var\4\log\ctype_upgrade.log
      

      Attachments

        Issue Links

          Activity

            http://buildbot.askmonty.org/buildbot/builders/win32-packages/builds/14093

            --- D:/win32-packages/build/src/mysql-test/main/ctype_upgrade.result	2019-07-08 06:30:13.000000000 +0000
            +++ D:\win32-packages\build\src\mysql-test\main\ctype_upgrade.reject	2019-07-08 07:03:03.855237800 +0000
            @@ -264,24 +264,6 @@
             Phase 4/7: Running 'mysql_fix_privilege_tables'
             Phase 5/7: Fixing table and database names
             Phase 6/7: Checking and upgrading tables
            -Processing databases
            -information_schema
            -mtr
            -mtr.global_suppressions                            OK
            -mtr.test_suppressions                              OK
            -performance_schema
            -test
            -test.maria050313_ucs2_croatian_ci_def              Needs upgrade
            -test.maria050313_utf8_croatian_ci                  Needs upgrade
            -test.maria050533_xxx_croatian_ci                   Needs upgrade
            -test.maria100004_xxx_croatian_ci                   Needs upgrade
            -test.mysql050614_xxx_croatian_ci                   OK
            -
            -Repairing tables
            -test.maria050313_ucs2_croatian_ci_def              OK
            -test.maria050313_utf8_croatian_ci                  OK
            -test.maria050533_xxx_croatian_ci                   OK
            -test.maria100004_xxx_croatian_ci                   OK
            

            2019-07-08  7:03:01 83 [ERROR] mysqld.exe: Table rebuild required. Please do "ALTER TABLE `test.maria050313_utf8_croatian_ci` FORCE" or dump/reload to fix it!
            2019-07-08  7:03:01 83 [ERROR] mysqld.exe: Table rebuild required. Please do "ALTER TABLE `test.maria050313_ucs2_croatian_ci_def` FORCE" or dump/reload to fix it!
            2019-07-08  7:03:01 83 [ERROR] mysqld.exe: Table rebuild required. Please do "ALTER TABLE `test.maria100004_xxx_croatian_ci` FORCE" or dump/reload to fix it!
            

            Error code: ER_TABLE_NEEDS_REBUILD
            Related to: MDEV-5241

            Case:

            --echo #
            --echo # Checking mysql_upgrade
            --echo #
            --copy_file std_data/ctype_upgrade/maria050313_utf8_croatian_ci.frm $MYSQLD_DATADIR/test/maria050313_utf8_croatian_ci.frm
            --copy_file std_data/ctype_upgrade/maria050313_utf8_croatian_ci.MYD $MYSQLD_DATADIR/test/maria050313_utf8_croatian_ci.MYD
            --copy_file std_data/ctype_upgrade/maria050313_utf8_croatian_ci.MYI $MYSQLD_DATADIR/test/maria050313_utf8_croatian_ci.MYI
             
            --copy_file std_data/ctype_upgrade/maria050313_ucs2_croatian_ci_def.frm $MYSQLD_DATADIR/test/maria050313_ucs2_croatian_ci_def.frm
            --copy_file std_data/ctype_upgrade/maria050313_ucs2_croatian_ci_def.MYD $MYSQLD_DATADIR/test/maria050313_ucs2_croatian_ci_def.MYD
            --copy_file std_data/ctype_upgrade/maria050313_ucs2_croatian_ci_def.MYI $MYSQLD_DATADIR/test/maria050313_ucs2_croatian_ci_def.MYI
             
            --copy_file std_data/ctype_upgrade/maria050533_xxx_croatian_ci.frm $MYSQLD_DATADIR/test/maria050533_xxx_croatian_ci.frm
            --copy_file std_data/ctype_upgrade/maria050533_xxx_croatian_ci.MYD $MYSQLD_DATADIR/test/maria050533_xxx_croatian_ci.MYD
            --copy_file std_data/ctype_upgrade/maria050533_xxx_croatian_ci.MYI $MYSQLD_DATADIR/test/maria050533_xxx_croatian_ci.MYI
             
            --copy_file std_data/ctype_upgrade/maria100004_xxx_croatian_ci.frm $MYSQLD_DATADIR/test/maria100004_xxx_croatian_ci.frm
            --copy_file std_data/ctype_upgrade/maria100004_xxx_croatian_ci.MYD $MYSQLD_DATADIR/test/maria100004_xxx_croatian_ci.MYD
            --copy_file std_data/ctype_upgrade/maria100004_xxx_croatian_ci.MYI $MYSQLD_DATADIR/test/maria100004_xxx_croatian_ci.MYI
             
            --copy_file std_data/ctype_upgrade/mysql050614_xxx_croatian_ci.frm $MYSQLD_DATADIR/test/mysql050614_xxx_croatian_ci.frm
            --copy_file std_data/ctype_upgrade/mysql050614_xxx_croatian_ci.MYD $MYSQLD_DATADIR/test/mysql050614_xxx_croatian_ci.MYD
            --copy_file std_data/ctype_upgrade/mysql050614_xxx_croatian_ci.MYI $MYSQLD_DATADIR/test/mysql050614_xxx_croatian_ci.MYI
             
            --echo # Running mysql_upgrade
            --exec $MYSQL_UPGRADE 2>&1
            

            midenok Aleksey Midenkov added a comment - http://buildbot.askmonty.org/buildbot/builders/win32-packages/builds/14093 --- D:/win32-packages/build/src/mysql-test/main/ctype_upgrade.result 2019-07-08 06:30:13.000000000 +0000 +++ D:\win32-packages\build\src\mysql-test\main\ctype_upgrade.reject 2019-07-08 07:03:03.855237800 +0000 @@ -264,24 +264,6 @@ Phase 4/7: Running 'mysql_fix_privilege_tables' Phase 5/7: Fixing table and database names Phase 6/7: Checking and upgrading tables -Processing databases -information_schema -mtr -mtr.global_suppressions OK -mtr.test_suppressions OK -performance_schema -test -test.maria050313_ucs2_croatian_ci_def Needs upgrade -test.maria050313_utf8_croatian_ci Needs upgrade -test.maria050533_xxx_croatian_ci Needs upgrade -test.maria100004_xxx_croatian_ci Needs upgrade -test.mysql050614_xxx_croatian_ci OK - -Repairing tables -test.maria050313_ucs2_croatian_ci_def OK -test.maria050313_utf8_croatian_ci OK -test.maria050533_xxx_croatian_ci OK -test.maria100004_xxx_croatian_ci OK 2019-07-08 7:03:01 83 [ERROR] mysqld.exe: Table rebuild required. Please do "ALTER TABLE `test.maria050313_utf8_croatian_ci` FORCE" or dump/reload to fix it! 2019-07-08 7:03:01 83 [ERROR] mysqld.exe: Table rebuild required. Please do "ALTER TABLE `test.maria050313_ucs2_croatian_ci_def` FORCE" or dump/reload to fix it! 2019-07-08 7:03:01 83 [ERROR] mysqld.exe: Table rebuild required. Please do "ALTER TABLE `test.maria100004_xxx_croatian_ci` FORCE" or dump/reload to fix it! Error code: ER_TABLE_NEEDS_REBUILD Related to: MDEV-5241 Case: --echo # --echo # Checking mysql_upgrade --echo # --copy_file std_data/ctype_upgrade/maria050313_utf8_croatian_ci.frm $MYSQLD_DATADIR/test/maria050313_utf8_croatian_ci.frm --copy_file std_data/ctype_upgrade/maria050313_utf8_croatian_ci.MYD $MYSQLD_DATADIR/test/maria050313_utf8_croatian_ci.MYD --copy_file std_data/ctype_upgrade/maria050313_utf8_croatian_ci.MYI $MYSQLD_DATADIR/test/maria050313_utf8_croatian_ci.MYI   --copy_file std_data/ctype_upgrade/maria050313_ucs2_croatian_ci_def.frm $MYSQLD_DATADIR/test/maria050313_ucs2_croatian_ci_def.frm --copy_file std_data/ctype_upgrade/maria050313_ucs2_croatian_ci_def.MYD $MYSQLD_DATADIR/test/maria050313_ucs2_croatian_ci_def.MYD --copy_file std_data/ctype_upgrade/maria050313_ucs2_croatian_ci_def.MYI $MYSQLD_DATADIR/test/maria050313_ucs2_croatian_ci_def.MYI   --copy_file std_data/ctype_upgrade/maria050533_xxx_croatian_ci.frm $MYSQLD_DATADIR/test/maria050533_xxx_croatian_ci.frm --copy_file std_data/ctype_upgrade/maria050533_xxx_croatian_ci.MYD $MYSQLD_DATADIR/test/maria050533_xxx_croatian_ci.MYD --copy_file std_data/ctype_upgrade/maria050533_xxx_croatian_ci.MYI $MYSQLD_DATADIR/test/maria050533_xxx_croatian_ci.MYI   --copy_file std_data/ctype_upgrade/maria100004_xxx_croatian_ci.frm $MYSQLD_DATADIR/test/maria100004_xxx_croatian_ci.frm --copy_file std_data/ctype_upgrade/maria100004_xxx_croatian_ci.MYD $MYSQLD_DATADIR/test/maria100004_xxx_croatian_ci.MYD --copy_file std_data/ctype_upgrade/maria100004_xxx_croatian_ci.MYI $MYSQLD_DATADIR/test/maria100004_xxx_croatian_ci.MYI   --copy_file std_data/ctype_upgrade/mysql050614_xxx_croatian_ci.frm $MYSQLD_DATADIR/test/mysql050614_xxx_croatian_ci.frm --copy_file std_data/ctype_upgrade/mysql050614_xxx_croatian_ci.MYD $MYSQLD_DATADIR/test/mysql050614_xxx_croatian_ci.MYD --copy_file std_data/ctype_upgrade/mysql050614_xxx_croatian_ci.MYI $MYSQLD_DATADIR/test/mysql050614_xxx_croatian_ci.MYI   --echo # Running mysql_upgrade --exec $MYSQL_UPGRADE 2>&1

            People

              midenok Aleksey Midenkov
              elenst Elena Stepanova
              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.