1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
#
# Bug#33038262: VARIOUS RACES IN PERSISTEN SYSTEM VARIABLE IMPLEMENTATION
#
SET @@debug='+d,check_intern_find_sys_var_lock';
SET PERSIST_ONLY sql_mode=DEFAULT;
SET PERSIST sql_mode=DEFAULT;
RESET PERSIST sql_mode;
RESET PERSIST;
SET @@debug='-d,check_intern_find_sys_var_lock';
# cleanup
# restart
#
# Bug #33830493: SET PERSIST statement is not atomic
#
SET PERSIST max_connections=42;
SET @@debug='+d,crash_after_open_persist_file';
SET PERSIST max_heap_table_size=887808, replica_net_timeout=160;
ERROR HY000: Lost connection to MySQL server during query
# restart
SELECT @@max_connections, @@max_heap_table_size, @@replica_net_timeout;
@@max_connections @@max_heap_table_size @@replica_net_timeout
42 16777216 60
SELECT variable_name FROM performance_schema.variables_info WHERE variable_source='PERSISTED';
variable_name
max_connections
SET @@debug='-d,crash_after_open_persist_file';
SET @@debug='+d,crash_after_write_persist_file';
SET PERSIST replica_net_timeout=160;
ERROR HY000: Lost connection to MySQL server during query
# restart
SELECT @@max_connections, @@max_heap_table_size, @@replica_net_timeout;
@@max_connections @@max_heap_table_size @@replica_net_timeout
42 16777216 60
SELECT variable_name FROM performance_schema.variables_info WHERE variable_source='PERSISTED';
variable_name
max_connections
SET @@debug='-d,crash_after_write_persist_file';
SET @@debug='+d,crash_after_close_persist_file';
SET PERSIST replica_net_timeout=124;
ERROR HY000: Lost connection to MySQL server during query
# restart
SELECT @@max_connections, @@max_heap_table_size, @@replica_net_timeout;
@@max_connections @@max_heap_table_size @@replica_net_timeout
42 16777216 124
SELECT variable_name FROM performance_schema.variables_info WHERE variable_source='PERSISTED';
variable_name
max_connections
replica_net_timeout
slave_net_timeout
SET @@debug='-d,crash_after_close_persist_file';
SET @@debug='+d,crash_after_rename_persist_file';
SET PERSIST replica_net_timeout=360;
ERROR HY000: Lost connection to MySQL server during query
# restart
SELECT @@max_connections, @@max_heap_table_size, @@replica_net_timeout;
@@max_connections @@max_heap_table_size @@replica_net_timeout
42 16777216 360
SELECT variable_name FROM performance_schema.variables_info WHERE variable_source='PERSISTED';
variable_name
max_connections
replica_net_timeout
slave_net_timeout
SET @@debug='-d,crash_after_rename_persist_file';
RESET PERSIST;
SET GLOBAL max_connections = default, replica_net_timeout = default, max_heap_table_size = default;
# restart:
|
