Debian Codegraph @

mysql-test/suite/wsrep/r/wsrep_variables_wsrep_off.result

raw
1 SELECT @@wsrep_on;
2 @@wsrep_on
3 0
4 SET @wsrep_debug_saved = @@global.wsrep_debug;
5 SET SESSION wsrep_trx_fragment_size=DEFAULT;
6 SELECT @@session.wsrep_trx_fragment_size;
7 @@session.wsrep_trx_fragment_size
8 0
9 SET GLOBAL wsrep_start_position='12345678-1234-1234-1234-123456789012:100';
10 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of '12345678-1234-1234-1234-123456789012:100'
11 SHOW WARNINGS;
12 Level Code Message
13 Warning 1231 Cannot set 'wsrep_start_position' because wsrep is switched off or provider is not loaded
14 Error 1231 Variable 'wsrep_start_position' can't be set to the value of '12345678-1234-1234-1234-123456789012:100'
15 SELECT @@global.wsrep_start_position;
16 @@global.wsrep_start_position
17 00000000-0000-0000-0000-000000000000:-1
18 SET GLOBAL wsrep_debug=1;
19 Warnings:
20 Warning 1231 Setting 'wsrep_debug' has no effect because wsrep is switched off
21 SELECT @@global.wsrep_debug;
22 @@global.wsrep_debug
23 NONE
24 SET GLOBAL wsrep_slave_threads=5;
25 ERROR HY000: WSREP (galera) not started
26 SELECT @@global.wsrep_slave_threads;
27 @@global.wsrep_slave_threads
28 1
29 SET GLOBAL wsrep_desync=1;
30 ERROR HY000: WSREP (galera) not started
31 SELECT @@global.wsrep_desync;
32 @@global.wsrep_desync
33 0
34 SET SESSION wsrep_trx_fragment_unit='rows';
35 ERROR 42000: Variable 'wsrep_trx_fragment_unit' can't be set to the value of 'rows'
36 SHOW WARNINGS;
37 Level Code Message
38 Warning 1231 Cannot set 'wsrep_trx_fragment_unit' because wsrep is switched off
39 Error 1231 Variable 'wsrep_trx_fragment_unit' can't be set to the value of 'rows'
40 SELECT @@session.wsrep_trx_fragment_unit;
41 @@session.wsrep_trx_fragment_unit
42 bytes