Details
Description
$ ./mtr main.upgrade_MDEV-19650
|
Logging: /var/tmp/portage/dev-db/mariadb-10.5.7/work/mysql/mysql-test/mysql-test-run.pl main.upgrade_MDEV-19650
|
vardir: /var/tmp/portage/dev-db/mariadb-10.5.7/work/mariadb-10.5.7_build/mysql-test/var
|
Checking leftover processes...
|
Removing old var directory...
|
Creating var directory '/var/tmp/portage/dev-db/mariadb-10.5.7/work/mariadb-10.5.7_build/mysql-test/var'...
|
Checking supported features...
|
MariaDB Version 10.5.7-MariaDB
|
- SSL connections supported
|
Collecting tests...
|
Installing system database...
|
|
==============================================================================
|
|
TEST RESULT TIME (ms) or COMMENT
|
--------------------------------------------------------------------------
|
|
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
|
main.upgrade_MDEV-19650 [ pass ] 203
|
|
MTR's internal check of the test case 'main.upgrade_MDEV-19650' failed.
|
This means that the test case does not preserve the state that existed
|
before the test case was executed. Most likely the test case did not
|
do a proper clean-up. It could also be caused by the previous test run
|
by this thread, if the server wasn't restarted.
|
This is the diff of the states of the servers before and after the
|
test case was executed:
|
mysqltest: Logging to '/var/tmp/portage/dev-db/mariadb-10.5.7/work/mariadb-10.5.7_build/mysql-test/var/tmp/check-mysqld_1.log'.
|
mysqltest: Results saved in '/var/tmp/portage/dev-db/mariadb-10.5.7/work/mariadb-10.5.7_build/mysql-test/var/tmp/check-mysqld_1.result'.
|
mysqltest: Connecting to server localhost:16000 (socket /var/tmp/portage/dev-db/mariadb-10.5.7/work/mariadb-10.5.7_build/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ...
|
mysqltest: ... Connected.
|
mysqltest: Start processing test commands from './include/check-testcase.test' ...
|
mysqltest: ... Done processing test commands.
|
--- /var/tmp/portage/dev-db/mariadb-10.5.7/work/mariadb-10.5.7_build/mysql-test/var/tmp/check-mysqld_1.result 2020-11-09 17:37:18.467067549 -0000
|
+++ /var/tmp/portage/dev-db/mariadb-10.5.7/work/mariadb-10.5.7_build/mysql-test/var/tmp/check-mysqld_1.reject 2020-11-09 17:37:18.710405616 -0000
|
@@ -727,37 +727,37 @@
|
mysql.user Host 1 '' NO char 60 180 NULL NULL utf8 utf8_bin char(60)
|
mysql.user User 2 '' NO char 80 240 NULL NULL utf8 utf8_bin char(80)
|
mysql.user Password 3 NULL YES longtext 4294967295 4294967295 NULL NULL utf8mb4 utf8mb4_bin longtext
|
-mysql.user Select_priv 4 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Insert_priv 5 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Update_priv 6 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Delete_priv 7 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Create_priv 8 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Drop_priv 9 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Reload_priv 10 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Shutdown_priv 11 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Process_priv 12 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user File_priv 13 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Grant_priv 14 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user References_priv 15 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Index_priv 16 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Alter_priv 17 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Show_db_priv 18 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Super_priv 19 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Create_tmp_table_priv 20 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Lock_tables_priv 21 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Execute_priv 22 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Repl_slave_priv 23 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Repl_client_priv 24 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Create_view_priv 25 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Show_view_priv 26 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Create_routine_priv 27 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Alter_routine_priv 28 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Create_user_priv 29 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Event_priv 30 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Trigger_priv 31 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Create_tablespace_priv 32 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user Delete_history_priv 33 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user ssl_type 34 NULL YES varchar 9 27 NULL NULL utf8 utf8_general_ci varchar(9)
|
+mysql.user Select_priv 4 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Insert_priv 5 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Update_priv 6 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Delete_priv 7 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Create_priv 8 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Drop_priv 9 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Reload_priv 10 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Shutdown_priv 11 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Process_priv 12 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user File_priv 13 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Grant_priv 14 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user References_priv 15 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Index_priv 16 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Alter_priv 17 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Show_db_priv 18 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Super_priv 19 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Create_tmp_table_priv 20 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Lock_tables_priv 21 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Execute_priv 22 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Repl_slave_priv 23 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Repl_client_priv 24 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Create_view_priv 25 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Show_view_priv 26 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Create_routine_priv 27 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Alter_routine_priv 28 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Create_user_priv 29 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Event_priv 30 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Trigger_priv 31 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Create_tablespace_priv 32 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user Delete_history_priv 33 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user ssl_type 34 NULL YES varchar 9 9 NULL NULL latin1 latin1_swedish_ci varchar(9)
|
mysql.user ssl_cipher 35 '' NO longtext 4294967295 4294967295 NULL NULL utf8mb4 utf8mb4_bin longtext
|
mysql.user x509_issuer 36 '' NO longtext 4294967295 4294967295 NULL NULL utf8mb4 utf8mb4_bin longtext
|
mysql.user x509_subject 37 '' NO longtext 4294967295 4294967295 NULL NULL utf8mb4 utf8mb4_bin longtext
|
@@ -767,8 +767,8 @@
|
mysql.user max_user_connections 41 0 NO bigint NULL NULL 19 0 NULL NULL bigint(21)
|
mysql.user plugin 42 '' NO longtext 4294967295 4294967295 NULL NULL utf8mb4 utf8mb4_bin longtext
|
mysql.user authentication_string 43 '' NO longtext 4294967295 4294967295 NULL NULL utf8mb4 utf8mb4_bin longtext
|
-mysql.user password_expired 44 '' NO varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
-mysql.user is_role 45 NULL YES varchar 1 3 NULL NULL utf8 utf8_general_ci varchar(1)
|
+mysql.user password_expired 44 '' NO varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
+mysql.user is_role 45 NULL YES varchar 1 1 NULL NULL latin1 latin1_swedish_ci varchar(1)
|
mysql.user default_role 46 '' NO longtext 4294967295 4294967295 NULL NULL utf8mb4 utf8mb4_bin longtext
|
mysql.user max_statement_time 47 0.000000 NO decimal NULL NULL 12 6 NULL NULL decimal(12,6)
|
EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUEINTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
|
|
mysqltest: Result length mismatch
|
|
not ok
|
|
--------------------------------------------------------------------------
|
The servers were restarted 0 times
|
Spent 0.203 of 2 seconds executing testcases
|
|
Check of testcase failed for: main.upgrade_MDEV-19650
|
|
Completed: All 1 tests were successful.
|
Attachments
Issue Links
- relates to
-
MDEV-25096 main.upgrade_MDEV-19650 test failure: Result content mismatch
- Closed
-
MDEV-24177 main.sp2 test fails: Result length mismatch
- Closed