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

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

    Details

    • Type: Bug
    • Status: Pending Release
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: 8.0, Not 5.6, Not 5.7
    • Fix Version/s: 8.0.15-6
    • Component/s: None
    • Labels:

      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

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                laurynas.biveinis Laurynas Biveinis
                Reporter:
                laurynas.biveinis Laurynas Biveinis
              • 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