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