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

rpl.bug62557 does not clean up after itself, failing rpl_master_pos_wait

Details

    • Bug
    • Status: Done
    • Low
    • Resolution: Fixed
    • 8.0.x, Not 5.6.x, Not 5.7.x
    • 8.0.15-6
    • None

    Description

      Intermittently

      190301 20:22:27 [ 17%] rpl.rpl_master_pos_wait 'mix'            w5  [ fail ]
              Test ended at 2019-03-01 20:22:27
      
      CURRENT_TEST: rpl.rpl_master_pos_wait
      --- /tmp/results/PS/mysql-test/suite/rpl/r/rpl_master_pos_wait.result	2019-03-01 14:46:52.000000000 +0300
      +++ /tmp/results/PS/mysql-test/var/5/log/rpl_master_pos_wait.reject	2019-03-01 23:22:27.586190818 +0300
      @@ -21,6 +21,65 @@
       NULL
       "*** must be empty ***"
       show slave status;
      +Slave_IO_State	
      +Master_Host	127.0.0.1
      +Master_User	root
      +Master_Port	13092
      +Connect_Retry	1
      +Master_Log_File	
      +Read_Master_Log_Pos	4
      +Relay_Log_File	
      +Relay_Log_Pos	0
      +Relay_Master_Log_File	
      +Slave_IO_Running	No
      +Slave_SQL_Running	No
      +Replicate_Do_DB	
      +Replicate_Ignore_DB	
      +Replicate_Do_Table	
      +Replicate_Ignore_Table	
      +Replicate_Wild_Do_Table	
      +Replicate_Wild_Ignore_Table	
      +Last_Errno	0
      +Last_Error	
      +Skip_Counter	0
      +Exec_Master_Log_Pos	0
      +Relay_Log_Space	0
      +Until_Condition	None
      +Until_Log_File	
      +Until_Log_Pos	0
      +Master_SSL_Allowed	No
      +Master_SSL_CA_File	
      +Master_SSL_CA_Path	
      +Master_SSL_Cert	
      +Master_SSL_Cipher	
      +Master_SSL_Key	
      +Seconds_Behind_Master	NULL
      +Master_SSL_Verify_Server_Cert	No
      +Last_IO_Errno	0
      +Last_IO_Error	
      +Last_SQL_Errno	0
      +Last_SQL_Error	
      +Replicate_Ignore_Server_Ids	
      +Master_Server_Id	0
      +Master_UUID	
      +Master_Info_File	mysql.slave_master_info
      +SQL_Delay	0
      +SQL_Remaining_Delay	NULL
      +Slave_SQL_Running_State	
      +Master_Retry_Count	86400
      +Master_Bind	
      +Last_IO_Error_Timestamp	
      +Last_SQL_Error_Timestamp	
      +Master_SSL_Crl	
      +Master_SSL_Crlpath	
      +Retrieved_Gtid_Set	
      +Executed_Gtid_Set	
      +Auto_Position	0
      +Replicate_Rewrite_DB	
      +Channel_Name	
      +Master_TLS_Version	
      +Master_public_key_path	
      +Get_master_public_key	0
       "*** must be NULL ***"
       select master_pos_wait('foo', 98);
       master_pos_wait('foo', 98)
      
      mysqltest: Result content mismatch
      

      Master server log has

      2019-03-01T20:22:17.386389Z 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''.
      

      This is likely caused by a previous testcase on the same run leaving slave configuration behind

      Attachments

        Activity

          People

            laurynas.biveinis Laurynas Biveinis (Inactive)
            laurynas.biveinis Laurynas Biveinis (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 2 hours, 40 minutes
                2h 40m

                Smart Checklist