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

rpl.rpl_gtid_crash fails due to salve Failed to sync with master

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11, 11.4, 11.8, 13.0
    • None
    • Replication, Tests, MTR
    • None

    Description

      Recent builds see rpl.rpl_gtid_crash fails due to salve Failed to sync with master.

      {
          "builder_name": "s390x-ubuntu-2204-debug",
          "commit": "f41aca23bf030f285a21edc963119db32681ac72",
          "branch": "10.11",
          "dt": "2026-06-30T01:28:00Z",
          "test_name": "rpl.rpl_gtid_crash",
          "test_variant": "stmt",
          "info_text": "",
          "failure_text": "rpl.rpl_gtid_crash 'stmt'                w12 [ fail ]\n        Test ended at 2026-06-29 23:35:35\n\nCURRENT_TEST: rpl.rpl_gtid_crash\nmysqltest: In included file \"./include/sync_with_master_gtid.inc\": \nincluded from /home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/suite/rpl/t/rpl_gtid_crash.test at line 189:\nAt line 45: Failed to sync with master\n\nThe result from queries just before the failure was:\n< snip >\n2\n3\n*** Test crashing slave at various points and check that it recovers crash-safe. ***\ninclude/stop_slave.inc\nSET GLOBAL debug_dbug=\"+d,inject_crash_before_write_rpl_slave_state\";\nSTART SLAVE;\nconnection server_1;\nINSERT INTO t1 VALUES (4);\ninclude/save_master_gtid.inc\nconnection server_2;\ninclude/sync_with_master_gtid.inc\ninclude/stop_slave.inc\nSTART SLAVE;\nSET GLOBAL debug_dbug=\"+d,crash_commit_before\";\nconnection server_1;\nINSERT INTO t1 VALUES (5);\ninclude/save_master_gtid.inc\nconnection server_2;\ninclude/sync_with_master_gtid.inc\nTimeout in master_gtid_wait('0-1-3,1-1-2,2-1-1', 120), current slave GTID position is: 0-1-2,1-1-2,2-1-1.\n\nMore results from queries before failure can be found in /home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/var/12/log/rpl_gtid_crash.log\n\n - saving '/home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/var/12/log/rpl.rpl_gtid_crash-stmt/' to '/home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/var/log/rpl.rpl_gtid_crash-stmt/'\n\nRetrying test rpl.rpl_gtid_crash, attempt(2/3)...\n"
        }
      

      {
          "builder_name": "s390x-ubuntu-2204-debug",
          "commit": "7a8776a92e5f88cad4fb8a7c8ff8caa4def3e107",
          "branch": "11.4",
          "dt": "2026-07-04T18:53:00Z",
          "test_name": "rpl.rpl_gtid_crash",
          "test_variant": "stmt",
          "info_text": "",
          "failure_text": "rpl.rpl_gtid_crash 'stmt'                w13 [ fail ]\n        Test ended at 2026-07-04 17:03:40\n\nCURRENT_TEST: rpl.rpl_gtid_crash\nmysqltest: In included file \"./include/sync_with_master_gtid.inc\": \nincluded from /home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/suite/rpl/t/rpl_gtid_crash.test at line 189:\nAt line 45: Failed to sync with master\n\nThe result from queries just before the failure was:\n< snip >\n2\n3\n*** Test crashing slave at various points and check that it recovers crash-safe. ***\ninclude/stop_slave.inc\nSET GLOBAL debug_dbug=\"+d,inject_crash_before_write_rpl_slave_state\";\nSTART SLAVE;\nconnection server_1;\nINSERT INTO t1 VALUES (4);\ninclude/save_master_gtid.inc\nconnection server_2;\ninclude/sync_with_master_gtid.inc\ninclude/stop_slave.inc\nSTART SLAVE;\nSET GLOBAL debug_dbug=\"+d,crash_commit_before\";\nconnection server_1;\nINSERT INTO t1 VALUES (5);\ninclude/save_master_gtid.inc\nconnection server_2;\ninclude/sync_with_master_gtid.inc\nTimeout in master_gtid_wait('0-1-3,1-1-2,2-1-1', 120), current slave GTID position is: 0-1-2,1-1-2,2-1-1.\n\nMore results from queries before failure can be found in /home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/var/13/log/rpl_gtid_crash.log\n\n - saving '/home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/var/13/log/rpl.rpl_gtid_crash-stmt/' to '/home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/var/log/rpl.rpl_gtid_crash-stmt/'\n\nRetrying test rpl.rpl_gtid_crash, attempt(2/3)...\n\n"
        }
      

      {
          "builder_name": "x86-debian-12-fulltest-debug",
          "commit": "232e3da164d21bfac9c3702eaf5c15bc55453a18",
          "branch": "11.8",
          "dt": "2026-06-30T14:24:26Z",
          "test_name": "rpl.rpl_gtid_crash",
          "test_variant": "row",
          "info_text": "",
          "failure_text": "rpl.rpl_gtid_crash 'row'                 w20 [ fail ]\n        Test ended at 2026-06-30 12:31:06\n\nCURRENT_TEST: rpl.rpl_gtid_crash\nmysqltest: In included file \"./include/sync_with_master_gtid.inc\": \nincluded from /home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/suite/rpl/t/rpl_gtid_crash.test at line 189:\nAt line 45: Failed to sync with master\n\nThe result from queries just before the failure was:\n< snip >\n2\n3\n*** Test crashing slave at various points and check that it recovers crash-safe. ***\ninclude/stop_slave.inc\nSET GLOBAL debug_dbug=\"+d,inject_crash_before_write_rpl_slave_state\";\nSTART SLAVE;\nconnection server_1;\nINSERT INTO t1 VALUES (4);\ninclude/save_master_gtid.inc\nconnection server_2;\ninclude/sync_with_master_gtid.inc\ninclude/stop_slave.inc\nSTART SLAVE;\nSET GLOBAL debug_dbug=\"+d,crash_commit_before\";\nconnection server_1;\nINSERT INTO t1 VALUES (5);\ninclude/save_master_gtid.inc\nconnection server_2;\ninclude/sync_with_master_gtid.inc\nTimeout in master_gtid_wait('0-1-3,1-1-2,2-1-1', 120), current slave GTID position is: 0-1-1,1-1-2,2-1-1.\n\nMore results from queries before failure can be found in /home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/20/log/rpl_gtid_crash.log\n\n - saving '/home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/20/log/rpl.rpl_gtid_crash-row/' to '/home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/log/rpl.rpl_gtid_crash-row/'\n\nRetrying test rpl.rpl_gtid_crash, attempt(2/3)...\n"
        }
      

      {
          "builder_name": "x86-debian-12-fulltest-debug",
          "commit": "1a4bb1bbfde5fa17ba148cb62678902f11c66a1a",
          "branch": "13.0",
          "dt": "2026-07-30T18:03:57Z",
          "test_name": "rpl.rpl_gtid_crash",
          "test_variant": "row",
          "info_text": "",
          "failure_text": "rpl.rpl_gtid_crash 'row'                 w5 [ fail ]\n        Test ended at 2026-07-30 16:11:26\n\nCURRENT_TEST: rpl.rpl_gtid_crash\nmysqltest: In included file \"./include/sync_with_master_gtid.inc\": \nincluded from /home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/suite/rpl/t/rpl_gtid_crash.test at line 190:\nAt line 46: Failed to sync with master\n\nThe result from queries just before the failure was:\n< snip >\nLog_name\tPos\tEvent_type\tServer_id\tEnd_log_pos\tInfo\nmaster-bin.000004\t4\tFormat_desc\t1\t257\tServer ver: 13.0.2-MariaDB-debug-log, Binlog ver: 4\nmaster-bin.000004\t257\tGtid_list\t1\t332\t[0-1-1,1-1-2,2-1-1]\nmaster-bin.000004\t332\tBinlog_checkpoint\t1\t376\tmaster-bin.000004\nmaster-bin.000004\t376\tGtid\t1\t418\tBEGIN GTID 0-1-2\nmaster-bin.000004\t418\tAnnotate_rows\t1\t0\tINSERT INTO t1 VALUES (4)\nmaster-bin.000004\t466\tTable_map\t1\t0\ttable_id: 18 (test.t1)\nmaster-bin.000004\t511\tWrite_rows_v1\t1\t0\ttable_id: 18 flags: STMT_END_F\nmaster-bin.000004\t549\tXid\t1\t580\tCOMMIT /* xid=22 */\nmaster-bin.000004\t580\tGtid\t1\t622\tBEGIN GTID 0-1-3\nmaster-bin.000004\t622\tAnnotate_rows\t1\t0\tINSERT INTO t1 VALUES (5)\nmaster-bin.000004\t670\tTable_map\t1\t0\ttable_id: 18 (test.t1)\nmaster-bin.000004\t715\tWrite_rows_v1\t1\t0\ttable_id: 18 flags: STMT_END_F\nmaster-bin.000004\t753\tXid\t1\t784\tCOMMIT /* xid=61 */\n\n**** SHOW RELAYLOG EVENTS on server_1 ****\nrelaylog_name = 'No such row'\nSHOW RELAYLOG EVENTS IN 'No such row' LIMIT 200;\nLog_name\tPos\tEvent_type\tServer_id\tEnd_log_pos\tInfo\nconnection server_2;\n\nMore results from queries before failure can be found in /home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/5/log/rpl_gtid_crash.log\n\n - saving '/home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/5/log/rpl.rpl_gtid_crash-row/' to '/home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/log/rpl.rpl_gtid_crash-row/'\n\nRetrying test rpl.rpl_gtid_crash, attempt(2/3)...\n"
        }
      

      {
          "builder_name": "x86-debian-12-fulltest-debug",
          "commit": "bd366d81b80aa65fc76ec570fa0bf218a996853b",
          "branch": "main",
          "dt": "2026-07-01T14:01:19Z",
          "test_name": "rpl.rpl_gtid_crash",
          "test_variant": "mix",
          "info_text": "",
          "failure_text": "rpl.rpl_gtid_crash 'mix'                 w20 [ fail ]\n        Test ended at 2026-07-01 12:06:16\n\nCURRENT_TEST: rpl.rpl_gtid_crash\nmysqltest: In included file \"./include/sync_with_master_gtid.inc\": \nincluded from /home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/suite/rpl/t/rpl_gtid_crash.test at line 190:\nAt line 46: Failed to sync with master\n\nThe result from queries just before the failure was:\n< snip >\n\n**** SHOW BINLOG EVENTS on server_1 ****\nbinlog_name = 'master-bin.000004'\nSHOW BINLOG EVENTS IN 'master-bin.000004' LIMIT 200;\nLog_name\tPos\tEvent_type\tServer_id\tEnd_log_pos\tInfo\nmaster-bin.000004\t4\tFormat_desc\t1\t257\tServer ver: 13.1.0-MariaDB-debug-log, Binlog ver: 4\nmaster-bin.000004\t257\tGtid_list\t1\t332\t[0-1-1,1-1-2,2-1-1]\nmaster-bin.000004\t332\tBinlog_checkpoint\t1\t376\tmaster-bin.000004\nmaster-bin.000004\t376\tGtid\t1\t418\tBEGIN GTID 0-1-2\nmaster-bin.000004\t418\tQuery\t1\t0\tuse `test`; INSERT INTO t1 VALUES (4)\nmaster-bin.000004\t510\tXid\t1\t541\tCOMMIT /* xid=22 */\nmaster-bin.000004\t541\tGtid\t1\t583\tBEGIN GTID 0-1-3\nmaster-bin.000004\t583\tQuery\t1\t0\tuse `test`; INSERT INTO t1 VALUES (5)\nmaster-bin.000004\t675\tXid\t1\t706\tCOMMIT /* xid=61 */\n\n**** SHOW RELAYLOG EVENTS on server_1 ****\nrelaylog_name = 'No such row'\nSHOW RELAYLOG EVENTS IN 'No such row' LIMIT 200;\nLog_name\tPos\tEvent_type\tServer_id\tEnd_log_pos\tInfo\nconnection server_2;\n\nMore results from queries before failure can be found in /home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/20/log/rpl_gtid_crash.log\n\n - saving '/home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/20/log/rpl.rpl_gtid_crash-mix/' to '/home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/log/rpl.rpl_gtid_crash-mix/'\n\nRetrying test rpl.rpl_gtid_crash, attempt(2/3)...\n"
        }
      

      Attachments

        Issue Links

          Activity

            People

              bnestere Brandon Nesterenko
              susil.behera Susil Behera
              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.