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

main.start_slave_until fails sporadically

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 12.3, 13.1, 13.2
    • None
    • Tests, MTR
    • None
    • Various CI platforms, various maintained versions containing the test (12.3 and up)

    Description

      CURRENT_TEST: main.start_slave_until
      mysqltest: At line 64: query 'START slave until MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=4' succeeded - should have failed with error ER_BAD_SLAVE (1200)...
       
      The result from queries just before the failure was:
      START slave until MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=4, MASTER_USE_GTID=NO, MASTER_DEMOTE_TO_SLAVE=1;
      ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'MASTER_USE_GTID=NO, MASTER_DEMOTE_TO_SLAVE=1' at line 1
      START slave until RELAY_LOG_FILE='master-bin.000001', RELAY_LOG_POS=4, MASTER_USE_GTID=NO, MASTER_DEMOTE_TO_SLAVE=1;
      ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'MASTER_USE_GTID=NO, MASTER_DEMOTE_TO_SLAVE=1' at line 1
      ER_BAD_SLAVE: Dummy error which should be treated as a passing test as this is a parser test not a logical one
      START slave until MASTER_LOG_FILE='master-bin.000001', RELAY_LOG_POS=4;
      ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
      START slave until RELAY_LOG_FILE='master-bin.000001', MASTER_LOG_POS=4;
      ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
      START slave until MASTER_LOG_FILE='master-bin.000001';
      ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
      START slave until RELAY_LOG_FILE='master-bin.000001';
      ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
      START slave until RELAY_LOG_POS=4;
      ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
      START slave until MASTER_LOG_POS=4;
      ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
      START slave until MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=4;
      

      Attachments

        Issue Links

          Activity

            People

              bnestere Brandon Nesterenko
              ParadoxV5 Jimmy Hú
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 10m
                  10m

                  Git Integration

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