1# 2# wsrep_desync 3# 4call mtr.add_suppression("WSREP: SET desync failed 9 for schema: test, query: SET @@global.wsrep_desync=ON"); 5# save the initial value 6SET @wsrep_desync_global_saved = @@global.wsrep_desync; 7# default 8SELECT @@global.wsrep_desync; 9@@global.wsrep_desync 100 11 12# scope 13SELECT @@session.wsrep_desync; 14ERROR HY000: Variable 'wsrep_desync' is a GLOBAL variable 15SET @@global.wsrep_desync=OFF; 16SELECT @@global.wsrep_desync; 17@@global.wsrep_desync 180 19SET @@global.wsrep_desync=ON; 20Got one of the listed errors 21SELECT @@global.wsrep_desync; 22@@global.wsrep_desync 230 24 25# valid values 26SET @@global.wsrep_desync='OFF'; 27SELECT @@global.wsrep_desync; 28@@global.wsrep_desync 290 30SET @@global.wsrep_desync=ON; 31Got one of the listed errors 32SELECT @@global.wsrep_desync; 33@@global.wsrep_desync 340 35SET @@global.wsrep_desync=default; 36SELECT @@global.wsrep_desync; 37@@global.wsrep_desync 380 39 40# invalid values 41SET @@global.wsrep_desync=NULL; 42ERROR 42000: Variable 'wsrep_desync' can't be set to the value of 'NULL' 43SET @@global.wsrep_desync='junk'; 44ERROR 42000: Variable 'wsrep_desync' can't be set to the value of 'junk' 45 46# restore the initial value 47SET @@global.wsrep_desync = @wsrep_desync_global_saved; 48# End of test 49