[MDEV-16945] main.ctype_upgrade failed in buildbot, error upon mysql_upgrade Created: 2018-08-11  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.2, 10.5
Fix Version/s: 10.5

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Aleksey Midenkov
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-5241 Collation incompatibilities with MySQ... Closed

 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



 Comments   
Comment by Aleksey Midenkov [ 2019-07-08 ]

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

Generated at Thu Feb 08 08:32:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.