Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7107

Sporadic test failure in multi_source.multisource

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0
    • Fix Version/s: 10.0.18
    • Component/s: Tests
    • Labels:

      Description

      Otto Kekäläinen reported an intermittent failure in multi_source.multisource:

      multi_source.multisource 'innodb_plugin' [ fail ]
              Test ended at 2014-11-13 00:11:10
      
      CURRENT_TEST: multi_source.multisource
      --- /home/timo/mariadb/mariadb-10.0/mysql-test/suite/multi_source/multisource.result	2014-09-02 14:10:56.673532000 +0300
      +++ /home/timo/mariadb/mariadb-10.0/mysql-test/suite/multi_source/multisource.reject	2014-11-13 00:11:09.600000000 +0200
      @@ -106,8 +106,8 @@
       create table db1.t3 (f1 int) engine=InnoDB;
       show all slaves status;
       Connection_name	Slave_SQL_State	Slave_IO_State	Master_Host	Master_User	Master_Port	Connect_Retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	Last_Error	Skip_Counter	Exec_Master_Log_Pos	Relay_Log_Space	Until_Condition	Until_Log_File	Until_Log_Pos	Master_SSL_Allowed	Master_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master	Master_SSL_Verify_Server_Cert	Last_IO_Errno	Last_IO_Error	Last_SQL_Errno	Last_SQL_Error	Replicate_Ignore_Server_Ids	Master_Server_Id	Master_SSL_Crl	Master_SSL_Crlpath	Using_Gtid	Gtid_IO_Pos	Retried_transactions	Max_relay_log_size	Executed_log_entries	Slave_received_heartbeats	Slave_heartbeat_period	Gtid_Slave_Pos
      -	Slave has read all relay log; waiting for the slave I/O thread to update it	Waiting for master to send event	127.0.0.1	root	MYPORT_2	60	master-bin.000001	921	mysqld-relay-bin.000002	1209	master-bin.000001	Yes	Yes							0		0	921	1507	None		0	No						0	No	0		0			2			No		0	1073741824	17	0	60.000	0-1-7
      -master1	Slave has read all relay log; waiting for the slave I/O thread to update it	Waiting for master to send event	127.0.0.1	root	MYPORT_1	60	master-bin.000002	740	mysqld-relay-bin-master1.000004	1028	master-bin.000002	Yes	Yes							0		0	740	1378	None		0	No						0	No	0		0			1			No		0	1073741824	37	0	60.000	0-1-7
      +	Slave has read all relay log; waiting for the slave I/O thread to update it	Waiting for master to send event	127.0.0.1	root	MYPORT_2	60	master-bin.000001	921	mysqld-relay-bin.000002	1209	master-bin.000001	Yes	Yes							0		0	921	1507	None		0	No						0	No	0		0			2			No		0	1073741824	17	1	60.000	0-1-7
      +master1	Slave has read all relay log; waiting for the slave I/O thread to update it	Waiting for master to send event	127.0.0.1	root	MYPORT_1	60	master-bin.000002	740	mysqld-relay-bin-master1.000004	1028	master-bin.000002	Yes	Yes							0		0	740	1378	None		0	No						0	No	0		0			1			No		0	1073741824	37	1	60.000	0-1-7
       select * from db1.t1;
       i	f1
       1	one
      

      Apparently, the heartbeat value needs to be masked, and the output needs to be sorted.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Hide
              elenst Elena Stepanova added a comment -

              http://lists.askmonty.org/pipermail/commits/2015-March/007543.html

              Kristian Nielsen,

              Could you please take a quick look at the patch?

              I don't expect you'll mind changes to the test itself, we discussed earlier that's how SHOW SLAVE STATUS should be handled; but please check if you're okay with the additions to show_slave_status.inc, or you would prefer a separate include file for SHOW ALL SLAVES STATUS instead.

              Thanks.

              Show
              elenst Elena Stepanova added a comment - http://lists.askmonty.org/pipermail/commits/2015-March/007543.html Kristian Nielsen , Could you please take a quick look at the patch? I don't expect you'll mind changes to the test itself, we discussed earlier that's how SHOW SLAVE STATUS should be handled; but please check if you're okay with the additions to show_slave_status.inc, or you would prefer a separate include file for SHOW ALL SLAVES STATUS instead. Thanks.
              Hide
              knielsen Kristian Nielsen added a comment -

              Looks fine, ok to push

              Show
              knielsen Kristian Nielsen added a comment - Looks fine, ok to push
              Show
              elenst Elena Stepanova added a comment - Pushed into 10.0: https://github.com/MariaDB/server/commit/ec16d1b62fb08b4dd3aa415a9bf717b5039a56cc

                People

                • Assignee:
                  elenst Elena Stepanova
                  Reporter:
                  elenst Elena Stepanova
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: