Bug #79389 rpl.rpl_change_master_crash_safe fails MTR's internal check
Submitted: 23 Nov 2015 23:34 Modified: 2 Feb 2016 17:22
Reporter: Anitha Gopi Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[23 Nov 2015 23:34] Anitha Gopi
Description:
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
rpl.rpl_change_master_crash_safe 'mix'   [ pass ]  15459

MTR's internal check of the test case 'rpl.rpl_change_master_crash_safe' 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 '/export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/check-mysqld_2.log'.
mysqltest: Results saved in '/export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/check-mysqld_2.result'.
mysqltest: Connecting to server localhost:13001 (socket /export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/mysqld.2.sock) as 'root', connection 'default', attempt 0 ...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/check-testcase.test' ...
mysqltest: ... Done processing test commands.
--- /export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/check-mysqld_2.result      2015-11-24 02:24:12.881092923 +0300
+++ /export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/check-mysqld_2.reject      2015-11-24 02:24:30.354011006 +0300
@@ -3082,6 +3082,6 @@
 mysql.time_zone_name   2268956709
 mysql.time_zone_transition     3895294076
 mysql.time_zone_transition_type        168184411
-mysql.user     50066167
+mysql.user     912223895
 Warnings:
 Error  1146    Table 'mysql.host' doesn't exist

mysqltest: Result length mismatch

not ok
safe_process[14065]: Child process: 14066, exit: 1

rpl.rpl_change_master_crash_safe 'row'   [ pass ]  15188

MTR's internal check of the test case 'rpl.rpl_change_master_crash_safe' 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 '/export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/check-mysqld_2.log'.
mysqltest: Results saved in '/export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/check-mysqld_2.result'.
mysqltest: Connecting to server localhost:13001 (socket /export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/mysqld.2.sock) as 'root', connection 'default', attempt 0 ...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/check-testcase.test' ...
mysqltest: ... Done processing test commands.
--- /export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/check-mysqld_2.result      2015-11-24 02:24:42.604966441 +0300
+++ /export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/check-mysqld_2.reject      2015-11-24 02:24:59.780910450 +0300
@@ -3082,6 +3082,6 @@
 mysql.time_zone_name   2268956709
 mysql.time_zone_transition     3895294076
 mysql.time_zone_transition_type        168184411
-mysql.user     50066167
+mysql.user     1667333973
 Warnings:
 Error  1146    Table 'mysql.host' doesn't exist

mysqltest: Result length mismatch

not ok
safe_process[14246]: Child process: 14247, exit: 1

rpl.rpl_change_master_crash_safe 'stmt'  [ pass ]  15148

MTR's internal check of the test case 'rpl.rpl_change_master_crash_safe' 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 '/export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/check-mysqld_2.log'.
mysqltest: Results saved in '/export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/check-mysqld_2.result'.
mysqltest: Connecting to server localhost:13001 (socket /export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/mysqld.2.sock) as 'root', connection 'default', attempt 0 ...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/check-testcase.test' ...
mysqltest: ... Done processing test commands.
--- /export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/check-mysqld_2.result      2015-11-24 02:25:12.039872382 +0300
+++ /export/home/tmp/agopi/repo/mysql/bld/mysql-test/var/tmp/check-mysqld_2.reject      2015-11-24 02:25:29.127820285 +0300
@@ -3082,6 +3082,6 @@
 mysql.time_zone_name   2268956709
 mysql.time_zone_transition     3895294076
 mysql.time_zone_transition_type        168184411
-mysql.user     50066167
+mysql.user     3352393367
 Warnings:
 Error  1146    Table 'mysql.host' doesn't exist

mysqltest: Result length mismatch

Failure is seen only on trunk. Test passes on 5.7

How to repeat:
 ./mtr rpl.rpl_change_master_crash_safe
[4 Feb 2016 0:30] Todd Farmer
Tests fixed.  No changelog entry required.
[18 Jun 2016 21:34] Omer Barnir
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0