# # wsrep_desync # call mtr.add_suppression("WSREP: SET desync failed 9 for schema: test, query: SET @@global.wsrep_desync=ON"); # save the initial value SET @wsrep_desync_global_saved = @@global.wsrep_desync; # default SELECT @@global.wsrep_desync; @@global.wsrep_desync 0 # scope SELECT @@session.wsrep_desync; ERROR HY000: Variable 'wsrep_desync' is a GLOBAL variable SET @@global.wsrep_desync=OFF; SELECT @@global.wsrep_desync; @@global.wsrep_desync 0 SET @@global.wsrep_desync=ON; Got one of the listed errors SELECT @@global.wsrep_desync; @@global.wsrep_desync 0 # valid values SET @@global.wsrep_desync='OFF'; SELECT @@global.wsrep_desync; @@global.wsrep_desync 0 SET @@global.wsrep_desync=ON; Got one of the listed errors SELECT @@global.wsrep_desync; @@global.wsrep_desync 0 SET @@global.wsrep_desync=default; SELECT @@global.wsrep_desync; @@global.wsrep_desync 0 # invalid values SET @@global.wsrep_desync=NULL; ERROR 42000: Variable 'wsrep_desync' can't be set to the value of 'NULL' SET @@global.wsrep_desync='junk'; ERROR 42000: Variable 'wsrep_desync' can't be set to the value of 'junk' # restore the initial value SET @@global.wsrep_desync = @wsrep_desync_global_saved; # End of test