Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-7225

The test `rpl_gtid.rpl_reset_master_kill` fails sporadically on Jenkins

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 8.0.20-11
    • Fix Version/s: None
    • Component/s: None

      Description

       

      The test rpl_gtid.rpl_reset_master_kill fails on Jenkins with below error.

      [  2%] rpl_gtid.rpl_reset_master_kill 'mix'     w4  [ fail ]
              Test ended at 2020-08-04 11:28:08
      MTR's internal check of the test case 'rpl_gtid.rpl_reset_master_kill' 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: Results saved in '/home/venki/work/ps/6990/bld/mysql-test/var/4/tmp/check-mysqld_1.result'.
      mysqltest: Logging to '/home/venki/work/ps/6990/bld/mysql-test/var/4/tmp/check-mysqld_1.log'.
      mysqltest: Connecting to server localhost:13060 (socket /home/venki/work/ps/6990/bld/mysql-test/var/tmp/4/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.
      --- /home/venki/work/ps/6990/bld/mysql-test/var/4/tmp/check-mysqld_1.result	2020-08-04 08:58:05.963912013 +0300
      +++ /home/venki/work/ps/6990/bld/mysql-test/var/4/tmp/check-mysqld_1.reject	2020-08-04 08:58:07.867900312 +0300
      @@ -1010,7 +1010,7 @@
       windowing_use_high_precision	ON
       VARIABLE_NAME	VARIABLE_VALUE
       VARIABLE_NAME	VARIABLE_VALUE
      -debug_sync	ON - signals: ''
      +debug_sync	ON - signals: 'kill_gtid_state_clear'
       CATALOG_NAME	SCHEMA_NAME	DEFAULT_CHARACTER_SET_NAME	DEFAULT_COLLATION_NAME	SQL_PATH	DEFAULT_ENCRYPTION
       def	information_schema	utf8	utf8_general_ci	NULL	NO
       def	mtr	utf8mb4	utf8mb4_0900_ai_ci	NULL	NOmysqltest: Result content mismatch
      

       

      How to repeat:

      ./mtr rpl_reset_master_kill{,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,} --mem --parallel=12 --repeat=3

       

      Suggested fix:

      diff --git a/mysql-test/suite/rpl_gtid/r/rpl_reset_master_kill.result b/mysql-test/suite/rpl_gtid/r/rpl_reset_master_kill.result
      index 40041e9ecec..cf6e1dc64cc 100644
      --- a/mysql-test/suite/rpl_gtid/r/rpl_reset_master_kill.result
      +++ b/mysql-test/suite/rpl_gtid/r/rpl_reset_master_kill.result
      @@ -3,5 +3,6 @@ CALL mtr.add_suppression('The transaction owned GTID is already in the gtid_exec
       CREATE TABLE t1(c1 int);
       RESET MASTER;
       ERROR HY000: Lost connection to MySQL server during query
      +SET DEBUG_SYNC = 'RESET';
       DROP TABLE t1;
       # Removing debug point 'wait_for_kill_gtid_state_clear' from @@GLOBAL.debug
      diff --git a/mysql-test/suite/rpl_gtid/t/rpl_reset_master_kill.test b/mysql-test/suite/rpl_gtid/t/rpl_reset_master_kill.test
      index 7fb59f6fbc6..1cc39cd58f6 100644
      --- a/mysql-test/suite/rpl_gtid/t/rpl_reset_master_kill.test
      +++ b/mysql-test/suite/rpl_gtid/t/rpl_reset_master_kill.test
      @@ -42,6 +42,7 @@ SET DEBUG_SYNC='now SIGNAL kill_gtid_state_clear';
       
       # 4. Now DROP TABLE t1(any DDL)
       --connection default
      +SET DEBUG_SYNC = 'RESET';
       DROP TABLE t1;
       --source include/remove_debug_point.inc
       
      

       

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              venkatesh.prasad Venkatesh Prasad
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: