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

slave_skip_errors ddl_exist_errors Not Picked up

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.5.12
    • Fix Version/s: None
    • Component/s: Configuration
    • Labels:
      None
    • Environment:
      When setting slave_skip_errors to include or exclusively to ddl_exist_errors, the correct error codes/names are not picked up.

      Description

      When setting slave_skip_errors to include or exclusively to ddl_exist_errors, the correct error codes/names are not picked up.

      $ grep skip /etc/my.cnf
      skip-slave-start = '1'
      slave_skip_errors = 'ddl_exist_errors'
      

      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 6
      Server version: 10.5.12-MariaDB Source distribution
       
      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]> show global variables like '%skip%';
      +----------------------------------+-----------+
      | Variable_name                    | Value     |
      +----------------------------------+-----------+
      | replicate_events_marked_for_skip | REPLICATE |
      | skip_external_locking            | ON        |
      | skip_name_resolve                | OFF       |
      | skip_networking                  | OFF       |
      | skip_show_database               | OFF       |
      | slave_skip_errors                | OFF       |
      | sql_slave_skip_counter           | 0         |
      +----------------------------------+-----------+
      7 rows in set (0.001 sec)
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            dotmanila Jervin R
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration