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

rpl.rpl_perfschema_applier_status_by_worker assertion failed on MacOS

    XMLWordPrintable

Details

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

    Description

      I see rpl.rpl_perfschema_applier_status_by_worker has assertion failed in recent builds on the branches 10.6, 10.11, 11.4, 11.8, 13.0, 12.3, main only on aarch64-macos architecture.

      {
          "builder_name": "aarch64-macos",
          "commit": "6b7cfb4d9ed6f287236898950f3124076614ad91",
          "branch": "10.6",
          "dt": "2026-07-31T12:43:07Z",
          "test_name": "rpl.rpl_perfschema_applier_status_by_worker",
          "test_variant": "mix",
          "info_text": "",
          "failure_text": "rpl.rpl_perfschema_applier_status_by_worker 'mix' w23 [ fail ]\n        Test ended at 2026-07-31 10:48:37\n\nCURRENT_TEST: rpl.rpl_perfschema_applier_status_by_worker\nmysqltest: In included file \"./include/assert.inc\": \nincluded from /Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/suite/rpl/t/rpl_perfschema_applier_status_by_worker.test at line 125:\nAt line 168: Test assertion failed in assertion.inc\n\nThe result from queries just before the failure was:\n< snip >\n\n**** SHOW BINLOG EVENTS on server_1 ****\nbinlog_name = 'master-bin.000001'\nSHOW BINLOG EVENTS IN 'master-bin.000001' LIMIT 200;\nLog_name\tPos\tEvent_type\tServer_id\tEnd_log_pos\tInfo\nmaster-bin.000001\t4\tFormat_desc\t1\t256\tServer ver: 10.6.28-MariaDB-log, Binlog ver: 4\nmaster-bin.000001\t256\tGtid_list\t1\t285\t[]\nmaster-bin.000001\t285\tBinlog_checkpoint\t1\t329\tmaster-bin.000001\nmaster-bin.000001\t329\tGtid\t1\t371\tGTID 0-1-1\nmaster-bin.000001\t371\tQuery\t1\t484\tuse `test`; CREATE TABLE t1 (a INT) ENGINE=InnoDB\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 slave;\nAssertion text: 'Value returned by PS table for worker_idle_time should be >= 1'\nAssertion condition: '\"0\" >= \"1\"'\nAssertion condition, interpolated: '\"0\" >= \"1\"'\nAssertion result: '0'\n\nMore results from queries before failure can be found in /Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/23/log/rpl_perfschema_applier_status_by_worker.log\n\n - saving '/Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/23/log/rpl.rpl_perfschema_applier_status_by_worker-mix/' to '/Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/log/rpl.rpl_perfschema_applier_status_by_worker-mix/'\n\nRetrying test rpl.rpl_perfschema_applier_status_by_worker, attempt(2/3)...\n"
        }
      

        {
          "builder_name": "aarch64-macos",
          "commit": "1bbe91facc0517a08e5af179e35d8eeaf532389e",
          "branch": "10.11",
          "dt": "2026-07-30T21:23:10Z",
          "test_name": "rpl.rpl_perfschema_applier_status_by_worker",
          "test_variant": "mix",
          "info_text": "",
          "failure_text": "rpl.rpl_perfschema_applier_status_by_worker 'mix' w24 [ fail ]\n        Test ended at 2026-07-30 19:28:38\n\nCURRENT_TEST: rpl.rpl_perfschema_applier_status_by_worker\nmysqltest: In included file \"./include/assert.inc\": \nincluded from /Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/suite/rpl/t/rpl_perfschema_applier_status_by_worker.test at line 125:\nAt line 168: Test assertion failed in assertion.inc\n\nThe result from queries just before the failure was:\n< snip >\n\n**** SHOW BINLOG EVENTS on server_1 ****\nbinlog_name = 'master-bin.000001'\nSHOW BINLOG EVENTS IN 'master-bin.000001' LIMIT 200;\nLog_name\tPos\tEvent_type\tServer_id\tEnd_log_pos\tInfo\nmaster-bin.000001\t4\tFormat_desc\t1\t256\tServer ver: 10.11.19-MariaDB-log, Binlog ver: 4\nmaster-bin.000001\t256\tGtid_list\t1\t285\t[]\nmaster-bin.000001\t285\tBinlog_checkpoint\t1\t329\tmaster-bin.000001\nmaster-bin.000001\t329\tGtid\t1\t371\tGTID 0-1-1\nmaster-bin.000001\t371\tQuery\t1\t484\tuse `test`; CREATE TABLE t1 (a INT) ENGINE=InnoDB\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 slave;\nAssertion text: 'Value returned by PS table for worker_idle_time should be >= 1'\nAssertion condition: '\"0\" >= \"1\"'\nAssertion condition, interpolated: '\"0\" >= \"1\"'\nAssertion result: '0'\n\nMore results from queries before failure can be found in /Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/24/log/rpl_perfschema_applier_status_by_worker.log\n\n - saving '/Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/24/log/rpl.rpl_perfschema_applier_status_by_worker-mix/' to '/Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/log/rpl.rpl_perfschema_applier_status_by_worker-mix/'\n\nRetrying test rpl.rpl_perfschema_applier_status_by_worker, attempt(2/3)...\n\n"
        }
      

      {
          "builder_name": "aarch64-macos",
          "commit": "08eeb6a417eb6ec683ae37ffe8c54b6ed0b56427",
          "branch": "11.4",
          "dt": "2026-07-28T15:15:32Z",
          "test_name": "rpl.rpl_perfschema_applier_status_by_worker",
          "test_variant": "mix",
          "info_text": "",
          "failure_text": "rpl.rpl_perfschema_applier_status_by_worker 'mix' w29 [ fail ]\n        Test ended at 2026-07-28 13:21:16\n\nCURRENT_TEST: rpl.rpl_perfschema_applier_status_by_worker\nmysqltest: In included file \"./include/assert.inc\": \nincluded from /Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/suite/rpl/t/rpl_perfschema_applier_status_by_worker.test at line 125:\nAt line 168: Test assertion failed in assertion.inc\n\nThe result from queries just before the failure was:\n< snip >\n\n**** SHOW BINLOG EVENTS on server_1 ****\nbinlog_name = 'master-bin.000001'\nSHOW BINLOG EVENTS IN 'master-bin.000001' LIMIT 200;\nLog_name\tPos\tEvent_type\tServer_id\tEnd_log_pos\tInfo\nmaster-bin.000001\t4\tFormat_desc\t1\t256\tServer ver: 11.4.13-MariaDB-log, Binlog ver: 4\nmaster-bin.000001\t256\tGtid_list\t1\t285\t[]\nmaster-bin.000001\t285\tBinlog_checkpoint\t1\t329\tmaster-bin.000001\nmaster-bin.000001\t329\tGtid\t1\t371\tGTID 0-1-1\nmaster-bin.000001\t371\tQuery\t1\t484\tuse `test`; CREATE TABLE t1 (a INT) ENGINE=InnoDB\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 slave;\nAssertion text: 'Value returned by PS table for worker_idle_time should be >= 1'\nAssertion condition: '\"0\" >= \"1\"'\nAssertion condition, interpolated: '\"0\" >= \"1\"'\nAssertion result: '0'\n\nMore results from queries before failure can be found in /Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/29/log/rpl_perfschema_applier_status_by_worker.log\n\n - saving '/Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/29/log/rpl.rpl_perfschema_applier_status_by_worker-mix/' to '/Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/log/rpl.rpl_perfschema_applier_status_by_worker-mix/'\n\nRetrying test rpl.rpl_perfschema_applier_status_by_worker, attempt(2/3)...\n"
        }
      

      {
          "builder_name": "aarch64-macos",
          "commit": "eaca80bf3208fb9657b7304b940a6726b4c86213",
          "branch": "11.8",
          "dt": "2026-07-29T13:44:48Z",
          "test_name": "rpl.rpl_perfschema_applier_status_by_worker",
          "test_variant": "mix",
          "info_text": "",
          "failure_text": "rpl.rpl_perfschema_applier_status_by_worker 'mix' w32 [ fail ]\n        Test ended at 2026-07-29 11:50:45\n\nCURRENT_TEST: rpl.rpl_perfschema_applier_status_by_worker\nmysqltest: In included file \"./include/assert.inc\": \nincluded from /Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/suite/rpl/t/rpl_perfschema_applier_status_by_worker.test at line 125:\nAt line 168: Test assertion failed in assertion.inc\n\nThe result from queries just before the failure was:\n< snip >\n\n**** SHOW BINLOG EVENTS on server_1 ****\nbinlog_name = 'master-bin.000001'\nSHOW BINLOG EVENTS IN 'master-bin.000001' LIMIT 200;\nLog_name\tPos\tEvent_type\tServer_id\tEnd_log_pos\tInfo\nmaster-bin.000001\t4\tFormat_desc\t1\t256\tServer ver: 11.8.9-MariaDB-log, Binlog ver: 4\nmaster-bin.000001\t256\tGtid_list\t1\t285\t[]\nmaster-bin.000001\t285\tBinlog_checkpoint\t1\t329\tmaster-bin.000001\nmaster-bin.000001\t329\tGtid\t1\t371\tGTID 0-1-1\nmaster-bin.000001\t371\tQuery\t1\t484\tuse `test`; CREATE TABLE t1 (a INT) ENGINE=InnoDB\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 slave;\nAssertion text: 'Value returned by PS table for worker_idle_time should be >= 1'\nAssertion condition: '\"0\" >= \"1\"'\nAssertion condition, interpolated: '\"0\" >= \"1\"'\nAssertion result: '0'\n\nMore results from queries before failure can be found in /Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/32/log/rpl_perfschema_applier_status_by_worker.log\n\n - saving '/Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/32/log/rpl.rpl_perfschema_applier_status_by_worker-mix/' to '/Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/log/rpl.rpl_perfschema_applier_status_by_worker-mix/'\n\nRetrying test rpl.rpl_perfschema_applier_status_by_worker, attempt(2/3)...\n"
        }
      

      {
          "builder_name": "aarch64-macos",
          "commit": "33240f3c96c3ced4698b33d2c6d51a520a1d9613",
          "branch": "12.3",
          "dt": "2026-07-30T13:20:25Z",
          "test_name": "rpl.rpl_perfschema_applier_status_by_worker",
          "test_variant": "mix",
          "info_text": "",
          "failure_text": "rpl.rpl_perfschema_applier_status_by_worker 'mix' w2 [ fail ]\n        Test ended at 2026-07-30 11:25:04\n\nCURRENT_TEST: rpl.rpl_perfschema_applier_status_by_worker\nmysqltest: In included file \"./include/assert.inc\": \nincluded from /Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/suite/rpl/t/rpl_perfschema_applier_status_by_worker.test at line 125:\nAt line 168: Test assertion failed in assertion.inc\n\nThe result from queries just before the failure was:\n< snip >\n\n**** SHOW BINLOG EVENTS on server_1 ****\nbinlog_name = 'master-bin.000001'\nSHOW BINLOG EVENTS IN 'master-bin.000001' LIMIT 200;\nLog_name\tPos\tEvent_type\tServer_id\tEnd_log_pos\tInfo\nmaster-bin.000001\t4\tFormat_desc\t1\t257\tServer ver: 12.3.3-MariaDB-log, Binlog ver: 4\nmaster-bin.000001\t257\tGtid_list\t1\t286\t[]\nmaster-bin.000001\t286\tBinlog_checkpoint\t1\t330\tmaster-bin.000001\nmaster-bin.000001\t330\tGtid\t1\t372\tGTID 0-1-1\nmaster-bin.000001\t372\tQuery\t1\t485\tuse `test`; CREATE TABLE t1 (a INT) ENGINE=InnoDB\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 slave;\nAssertion text: 'Value returned by PS table for worker_idle_time should be >= 1'\nAssertion condition: '\"0\" >= \"1\"'\nAssertion condition, interpolated: '\"0\" >= \"1\"'\nAssertion result: '0'\n\nMore results from queries before failure can be found in /Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/2/log/rpl_perfschema_applier_status_by_worker.log\n\n - saving '/Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/2/log/rpl.rpl_perfschema_applier_status_by_worker-mix/' to '/Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/log/rpl.rpl_perfschema_applier_status_by_worker-mix/'\n\nRetrying test rpl.rpl_perfschema_applier_status_by_worker, attempt(2/3)...\n"
        }
      

      {
          "builder_name": "aarch64-macos",
          "commit": "1a4bb1bbfde5fa17ba148cb62678902f11c66a1a",
          "branch": "13.0",
          "dt": "2026-07-30T18:13:17Z",
          "test_name": "rpl.rpl_perfschema_applier_status_by_worker",
          "test_variant": "mix",
          "info_text": "",
          "failure_text": "rpl.rpl_perfschema_applier_status_by_worker 'mix' w9 [ fail ]\n        Test ended at 2026-07-30 16:17:39\n\nCURRENT_TEST: rpl.rpl_perfschema_applier_status_by_worker\nmysqltest: In included file \"./include/assert.inc\": \nincluded from /Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/suite/rpl/t/rpl_perfschema_applier_status_by_worker.test at line 125:\nAt line 168: Test assertion failed in assertion.inc\n\nThe result from queries just before the failure was:\n< snip >\n\n**** SHOW BINLOG EVENTS on server_1 ****\nbinlog_name = 'master-bin.000001'\nSHOW BINLOG EVENTS IN 'master-bin.000001' LIMIT 200;\nLog_name\tPos\tEvent_type\tServer_id\tEnd_log_pos\tInfo\nmaster-bin.000001\t4\tFormat_desc\t1\t257\tServer ver: 13.0.2-MariaDB-log, Binlog ver: 4\nmaster-bin.000001\t257\tGtid_list\t1\t286\t[]\nmaster-bin.000001\t286\tBinlog_checkpoint\t1\t330\tmaster-bin.000001\nmaster-bin.000001\t330\tGtid\t1\t372\tGTID 0-1-1\nmaster-bin.000001\t372\tQuery\t1\t485\tuse `test`; CREATE TABLE t1 (a INT) ENGINE=InnoDB\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 slave;\nAssertion text: 'Value returned by PS table for worker_idle_time should be >= 1'\nAssertion condition: '\"0\" >= \"1\"'\nAssertion condition, interpolated: '\"0\" >= \"1\"'\nAssertion result: '0'\n\nMore results from queries before failure can be found in /Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/9/log/rpl_perfschema_applier_status_by_worker.log\n\n - saving '/Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/9/log/rpl.rpl_perfschema_applier_status_by_worker-mix/' to '/Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/log/rpl.rpl_perfschema_applier_status_by_worker-mix/'\n\nRetrying test rpl.rpl_perfschema_applier_status_by_worker, attempt(2/3)...\n"
        }
      

      {
          "builder_name": "aarch64-macos",
          "commit": "cded2b25e65853a75c2213cfe0832819832708bd",
          "branch": "main",
          "dt": "2026-07-28T06:23:23Z",
          "test_name": "rpl.rpl_perfschema_applier_status_by_worker",
          "test_variant": "mix",
          "info_text": "",
          "failure_text": "rpl.rpl_perfschema_applier_status_by_worker 'mix' w14 [ fail ]\n        Test ended at 2026-07-28 04:29:40\n\nCURRENT_TEST: rpl.rpl_perfschema_applier_status_by_worker\nmysqltest: In included file \"./include/assert.inc\": \nincluded from /Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/suite/rpl/t/rpl_perfschema_applier_status_by_worker.test at line 125:\nAt line 168: Test assertion failed in assertion.inc\n\nThe result from queries just before the failure was:\n< snip >\n\n**** SHOW BINLOG EVENTS on server_1 ****\nbinlog_name = 'master-bin.000001'\nSHOW BINLOG EVENTS IN 'master-bin.000001' LIMIT 200;\nLog_name\tPos\tEvent_type\tServer_id\tEnd_log_pos\tInfo\nmaster-bin.000001\t4\tFormat_desc\t1\t257\tServer ver: 13.1.0-MariaDB-log, Binlog ver: 4\nmaster-bin.000001\t257\tGtid_list\t1\t286\t[]\nmaster-bin.000001\t286\tBinlog_checkpoint\t1\t330\tmaster-bin.000001\nmaster-bin.000001\t330\tGtid\t1\t372\tGTID 0-1-1\nmaster-bin.000001\t372\tQuery\t1\t485\tuse `test`; CREATE TABLE t1 (a INT) ENGINE=InnoDB\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 slave;\nAssertion text: 'Value returned by PS table for worker_idle_time should be >= 1'\nAssertion condition: '\"0\" >= \"1\"'\nAssertion condition, interpolated: '\"0\" >= \"1\"'\nAssertion result: '0'\n\nMore results from queries before failure can be found in /Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/14/log/rpl_perfschema_applier_status_by_worker.log\n\n - saving '/Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/14/log/rpl.rpl_perfschema_applier_status_by_worker-mix/' to '/Users/ec2-user/buildbot/prod/aarch64-macos/build/mysql-test/var/log/rpl.rpl_perfschema_applier_status_by_worker-mix/'\n\nRetrying test rpl.rpl_perfschema_applier_status_by_worker, attempt(2/3)...\n"
        }
      

      Attachments

        Issue Links

          Activity

            People

              Gosselin Dave Gosselin
              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.