[MDEV-15831] wsrep configurations active even when wsrep is not used Created: 2018-04-09  Updated: 2018-04-09  Resolved: 2018-04-09

Status: Closed
Project: MariaDB Server
Component/s: wsrep
Affects Version/s: 10.2.7
Fix Version/s: 10.2.10

Type: Bug Priority: Major
Reporter: Wagner Bianchi (Inactive) Assignee: Sachin Setiya (Inactive)
Resolution: Fixed Votes: 0
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)



 Comments   
Comment by Wagner Bianchi (Inactive) [ 2018-04-09 ]

It's fixed at https://jira.mariadb.org/browse/MDEV-14001

Comment by Wagner Bianchi (Inactive) [ 2018-04-09 ]

https://jira.mariadb.org/browse/MDEV-14001

Generated at Thu Feb 08 08:24:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.