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

rpl.rpl_semi_sync_slave_enabled_consistent Fails with Error Condition Reached

    XMLWordPrintable

Details

    Description

      rpl.rpl_semi_sync_slave_enabled_consistent fails occasionally with

      rpl.rpl_semi_sync_slave_enabled_consistent 'row' w21 [ fail ]
              Test ended at 2024-03-18 15:28:48
      CURRENT_TEST: rpl.rpl_semi_sync_slave_enabled_consistent
      mysqltest: In included file "./include/wait_for_slave_param.inc":
      included from ./include/wait_for_slave_sql_to_stop.inc at line 47:
      included from ./include/wait_for_slave_to_stop.inc at line 34:
      included from ./include/stop_slave.inc at line 84:
      included from /home/buildbot/amd64-ubuntu-2004-debug/build/mysql-test/suite/rpl/t/rpl_semi_sync_slave_enabled_consistent.test at line 68:
      

      In the error log, in can be seen this is due to the SQL thread trying to stop while having non-transactional changes:

      2024-03-18 15:28:45 71 [Warning] Slave SQL: Request to stop slave SQL Thread received while applying a group that has non-transactional changes; waiting for completion of the group ... , Gtid 0-1-4, Internal MariaDB error code: 0
      2024-03-18 15:28:47 71 [ERROR] Slave SQL: Fatal error: ... Slave SQL Thread stopped with incomplete event group having non-transactional changes. If the group consists solely of row-based events, you can try to restart the slave with --slave-exec-mode=IDEMPOTENT, which ignores duplicate key, key not found, and similar errors (see documentation for details). Gtid 0-1-4, Internal MariaDB error code: 1593
      

      The test itself doesn't have any transactions directly, but it can be seen that this is from trying to replicate test suppressions:

      The result from queries just before the failure was:
      < snip >
      master-bin.000001 805 Annotate_rows 1 970 INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'could not queue event from master' COLLATE 'latin1_swedish_ci'))
      master-bin.000001 970 Table_map 1 1031  table_id: 91 (mtr.test_suppressions)
      master-bin.000001 1031  Write_rows_v1 1 1099  table_id: 91 flags: STMT_END_F
      master-bin.000001 1099  Query 1 1171  COMMIT
      master-bin.000001 1171  Gtid  1 1213  BEGIN GTID 0-1-3
      master-bin.000001 1213  Annotate_rows 1 1403  INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'Semisync ack receiver.*error reading communication packets' COLLATE 'latin1_swedish_ci'))
      master-bin.000001 1403  Table_map 1 1464  table_id: 92 (mtr.test_suppressions)
      master-bin.000001 1464  Write_rows_v1 1 1557  table_id: 92 flags: STMT_END_F
      master-bin.000001 1557  Query 1 1629  COMMIT
      master-bin.000001 1629  Gtid  1 1671  BEGIN GTID 0-1-4
      master-bin.000001 1671  Annotate_rows 1 1835  INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'Semisync ack receiver got hangup' COLLATE 'latin1_swedish_ci'))
      master-bin.000001 1835  Table_map 1 1896  table_id: 93 (mtr.test_suppressions)
      master-bin.000001 1896  Write_rows_v1 1 1963  table_id: 93 flags: STMT_END_F
      master-bin.000001 1963  Query 1 2035  COMMIT
      
      

      Attachments

        Activity

          People

            bnestere Brandon Nesterenko
            bnestere Brandon Nesterenko
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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