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

rpl.rpl_gtid_master_promote fails in buildbot

    Details

    • Sprint:
      5.5.55

      Description

      http://buildbot.askmonty.org/buildbot/builders/p8-trusty-bintar/builds/1/steps/test/logs/stdio

      rpl.rpl_gtid_master_promote 'innodb_plugin,stmt' w3 [ fail ]
              Test ended at 2016-06-22 22:07:46
       
      CURRENT_TEST: rpl.rpl_gtid_master_promote
      === SHOW MASTER STATUS ===
      ---- 1. ----
      File	master-bin.000001
      Position	3011
      Binlog_Do_DB	
      Binlog_Ignore_DB	
      ==========================
       
      === SHOW SLAVE STATUS ===
      ---- 1. ----
      Slave_IO_State	Waiting for master to send event
      Master_Host	127.0.0.1
      Master_User	root
      Master_Port	16001
      Connect_Retry	1
      Master_Log_File	slave-bin.000001
      Read_Master_Log_Pos	5167
      Relay_Log_File	mysqld-relay-bin.000002
      Relay_Log_Pos	846
      Relay_Master_Log_File	slave-bin.000001
      Slave_IO_Running	Yes
      Slave_SQL_Running	Yes
      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	1324
      Relay_Log_Space	3459
      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	356
      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	2
      Master_SSL_Crl	
      Master_SSL_Crlpath	
      Using_Gtid	Current_Pos
      Gtid_IO_Pos	1-2-9,0-1-3,3-2-9,2-2-9
      =========================
       
      === SHOW PROCESSLIST ===
      ---- 1. ----
      Id	4
      User	root
      Host	localhost:35889
      db	test
      Command	Query
      Time	0
      State	init
      Info	SHOW PROCESSLIST
      Progress	0.000
      ---- 2. ----
      Id	5
      User	root
      Host	localhost:35890
      db	test
      Command	Sleep
      Time	522
      State	
      Info	
      Progress	0.000
      ---- 3. ----
      Id	11
      User	system user
      Host	
      db	
      Command	Connect
      Time	301
      State	Waiting for master to send event
      Info	
      Progress	0.000
      ---- 4. ----
      Id	12
      User	system user
      Host	
      db	test
      Command	Connect
      Time	463
      State	update
      Info	INSERT INTO t1 VALUES (2)
      Progress	0.000
      ========================
       
      analyze: sync_with_master
      mysqltest: At line 205: sync_with_master failed: 'select master_pos_wait('slave-bin.000001', 5167, 300, '')' returned -1 indicating timeout after 300 seconds
       
      The result from queries just before the failure was:
      < snip >
      2	1
      2	3
      3	1
      3	3
      *** Now make 2 master and point 3,4,5 to the new master 2
      SET gtid_domain_id= 1;
      INSERT INTO t1 values (5);
      INSERT INTO t4 values (1,5);
      SET gtid_domain_id= 2;
      INSERT INTO t2 values (5);
      INSERT INTO t4 values (2,5);
      SET gtid_domain_id= 3;
      INSERT INTO t3 values (5);
      INSERT INTO t4 values (3,5);
      CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2;
      include/start_slave.inc
      CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2;
      include/start_slave.inc
      CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2;
      include/start_slave.inc
       
      More results from queries before failure can be found in /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/3/log/rpl_gtid_master_promote.log
      

      rpl.rpl_gtid_master_promote 'innodb_plugin,row' w2 [ fail ]  Found warnings/errors in server log file!
              Test ended at 2016-06-22 22:10:35
      line
      InnoDB: Warning: Writer thread is waiting this semaphore:
      ^ Found warnings in /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/2/log/mysqld.1.err
      ok
      
      

        Attachments

          Issue Links

            Activity

              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: