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

wsrep configurations active even when wsrep is not used

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2.7
    • Fix Version/s: 10.2.10
    • Component/s: wsrep
    • Labels:
      None

      Description

      Folks,

      I run a master with two slaves replication cluster with MariaDB Server with wsrep API not configured as I don't need that. Today, I see the below message on the logs of one of the slaves:

      2018-04-09 19:00:08 139783001421568 [ERROR] InnoDB: WSREP: referenced FK check fail: 15 index customers_contactcon_contract_id_f8f50ac2_fk_customers table tools/customers_contactcontract
      

      The wsrep API is like below currently:

      +---------------------------------+-----------------------------------------+
      | Variable_name                   | Value                                   |
      +---------------------------------+-----------------------------------------+
      | wsrep_osu_method                | TOI                                     |
      | wsrep_auto_increment_control    | ON                                      |
      | wsrep_causal_reads              | OFF                                     |
      | wsrep_certify_nonpk             | ON                                      |
      | wsrep_cluster_address           |                                         |
      | wsrep_cluster_name              | my_wsrep_cluster                        |
      | wsrep_convert_lock_to_trx       | OFF                                     |
      | wsrep_data_home_dir             | /var/lib/mysql/                         |
      | wsrep_dbug_option               |                                         |
      | wsrep_debug                     | OFF                                     |
      | wsrep_desync                    | OFF                                     |
      | wsrep_dirty_reads               | OFF                                     |
      | wsrep_drupal_282555_workaround  | OFF                                     |
      | wsrep_forced_binlog_format      | NONE                                    |
      | wsrep_gtid_domain_id            | 0                                       |
      | wsrep_gtid_mode                 | OFF                                     |
      | wsrep_load_data_splitting       | ON                                      |
      | wsrep_log_conflicts             | OFF                                     |
      | wsrep_max_ws_rows               | 0                                       |
      | wsrep_max_ws_size               | 2147483647                              |
      | wsrep_mysql_replication_bundle  | 0                                       |
      | wsrep_node_address              |                                         |
      | wsrep_node_incoming_address     | AUTO                                    |
      | wsrep_node_name                 | mdbe-05                                 |
      | wsrep_notify_cmd                |                                         |
      | wsrep_on                        | OFF                                     |
      | wsrep_patch_version             | wsrep_25.19                             |
      | wsrep_provider                  | none                                    |
      | wsrep_provider_options          |                                         |
      | wsrep_recover                   | OFF                                     |
      | wsrep_replicate_myisam          | OFF                                     |
      | wsrep_restart_slave             | OFF                                     |
      | wsrep_retry_autocommit          | 1                                       |
      | wsrep_slave_fk_checks           | ON                                      |
      | wsrep_slave_uk_checks           | OFF                                     |
      | wsrep_slave_threads             | 1                                       |
      | wsrep_sst_auth                  |                                         |
      | wsrep_sst_donor                 |                                         |
      | wsrep_sst_donor_rejects_queries | OFF                                     |
      | wsrep_sst_method                | rsync                                   |
      | wsrep_sst_receive_address       | AUTO                                    |
      | wsrep_start_position            | 00000000-0000-0000-0000-000000000000:-1 |
      | wsrep_sync_wait                 | 0                                       |
      +---------------------------------+-----------------------------------------+
      
      

      It seems the variabvles above set to ON is in effect even if the wsrep or galera api is not being used or disabled.

      My question, is that correct to say?

      In any case, I just entered the below to avoid to seeing this confusing message again.

      mdbe-05 [(none)]> set global wsrep_slave_fk_checks=0;
      Query OK, 0 rows affected (0.00 sec)
       
      mdbe-05 [(none)]> set global wsrep_certify_nonpk=0;
      Query OK, 0 rows affected (0.00 sec)
       
      mdbe-05 [(none)]> set global wsrep_auto_increment_control=0;
      Query OK, 0 rows affected (0.00 sec)
      

        Attachments

          Activity

            People

            Assignee:
            sachin.setiya.007 Sachin Setiya
            Reporter:
            wagnerbianchi Wagner Bianchi
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: