Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.7
-
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) |