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

rpl.rpl_delayed_slave failed for test assertion 'Status should be 'Waiting until MASTER_DELAY...''

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.7, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8
    • 10.4, 10.5, 10.6
    • Replication, Tests
    • None

    Description

      https://buildbot.mariadb.org/#/builders/208/builds/4366/steps/6/logs/stdio
      10.7 01bb003a3
      amd64-ubuntu-1804

      [Revision hash: 01bb003a3a0864c3e7f140816cc681890d0fc988]
       
      rpl.rpl_delayed_slave 'nonparallel,stmt' w4 [ fail ]
              Test ended at 2022-02-23 19:53:59
       
      CURRENT_TEST: rpl.rpl_delayed_slave
      mysqltest: In included file "./include/rpl_assert.inc": 
      included from /buildbot/amd64-ubuntu-1804-bigtest/build/mysql-test/suite/rpl/include/delayed_slave_wait_on_query.inc at line 39:
      included from /buildbot/amd64-ubuntu-1804-bigtest/build/mysql-test/suite/rpl/t/rpl_delayed_slave.test at line 262:
      At line 109: Test assertion failed in rpl_assertion.inc
       
      The result from queries just before the failure was:
      < snip >
      master-bin.000001	2242	Query	1	2315	COMMIT
      master-bin.000001	2315	Gtid	1	2357	BEGIN GTID 0-1-9
      master-bin.000001	2357	Query	1	2466	use `test`; INSERT INTO t1 VALUES ('Syncing slave', 5)
      master-bin.000001	2466	Query	1	2539	COMMIT
      master-bin.000001	2539	Gtid	1	2581	BEGIN GTID 0-1-10
      master-bin.000001	2581	Query	1	2692	use `test`; INSERT INTO t1 VALUES (delay_on_slave(1), 6)
      master-bin.000001	2692	Query	1	2765	COMMIT
      master-bin.000001	2765	Gtid	1	2807	BEGIN GTID 0-1-11
      master-bin.000001	2807	Query	1	2934	use `test`; INSERT INTO t1 VALUES ('stop slave and start slave: DML', 7)
      master-bin.000001	2934	Query	1	3007	COMMIT
       
      **** SHOW RELAYLOG EVENTS on server_1 ****
      relaylog_name = 'No such row'
      SHOW RELAYLOG EVENTS IN 'No such row';
      Log_name	Pos	Event_type	Server_id	End_log_pos	Info
      connection slave;
      Assertion text: 'Status should be 'Waiting until MASTER_DELAY...''
      Assertion condition: '"[SHOW SLAVE STATUS, Slave_SQL_Running_State, 1]" LIKE "Waiting until MASTER_DELAY%"'
      Assertion condition, interpolated: '"Slave has read all relay log; waiting for more updates" LIKE "Waiting until MASTER_DELAY%"'
      Assertion result: '0'
      

      The fail appears to usually end up as retry-pass, and is intermittent.

      Attachments

        Issue Links

          Activity

            People

              angelique.sklavounos Angelique Sklavounos (Inactive)
              angelique.sklavounos Angelique Sklavounos (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.