summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sys_vars/t/debug_dbug_func.test
blob: b4cd4aefd5e5f3f78031b022f55a901fc4100ef8 (plain)
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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
--source include/have_debug.inc

SET @old_debug = @@GLOBAL.debug;

#
# Bug#34678 @@debug variable's incremental mode
#

set debug_dbug= 'T';
select @@debug;
set debug_dbug= '+P';
select @@debug;
set debug_dbug= '-P';
select @@debug;

#
# Bug#38054: "SET SESSION debug" modifies @@global.debug variable
#

SELECT @@session.debug, @@global.debug;

SET SESSION debug_dbug= '';

SELECT @@session.debug, @@global.debug;

--echo #
--echo # Bug #52629: memory leak from sys_var_thd_dbug in 
--echo #  binlog.binlog_write_error
--echo #

SET GLOBAL debug_dbug='d,injecting_fault_writing';
SELECT @@global.debug;
SET GLOBAL debug_dbug='';
SELECT @@global.debug;

SET GLOBAL debug_dbug=@old_debug;

--echo #
--echo # Bug #56709: Memory leaks at running the 5.1 test suite
--echo # 

SET @old_local_debug = @@debug;

SET @@debug_dbug='d,foo';
SELECT @@debug;
SET @@debug_dbug='';
SELECT @@debug;

SET @@debug_dbug= @old_local_debug;

--echo End of 5.1 tests


--echo #
--echo # Bug#46165 server crash in dbug
--echo #

SET @old_globaldebug = @@global.debug;
SET @old_sessiondebug= @@session.debug;

--echo # Test 1 - Bug test case, single connection
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
eval SET GLOBAL  debug_dbug= '+O,$MYSQL_TMP_DIR/bug46165.1.trace';
SET SESSION debug_dbug= '-d:-t:-i';

SET GLOBAL  debug_dbug= '';
SET SESSION debug_dbug= '';

--echo # Test 2 - Bug test case, two connections
connection default;
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
eval SET GLOBAL  debug_dbug= '+O,$MYSQL_TMP_DIR/bug46165.2.trace';
SET SESSION debug_dbug= '-d:-t:-i';

connect (con1, localhost, root);
SET GLOBAL  debug_dbug= '';

connection default;
SET SESSION debug_dbug= '';
connection con1;
disconnect con1;
--source include/wait_until_disconnected.inc
connection default;
SET GLOBAL  debug_dbug= '';

--echo # Test 3 - Active session trace file on disconnect
connect (con1, localhost, root);
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
eval SET GLOBAL  debug_dbug= '+O,$MYSQL_TMP_DIR/bug46165.3.trace';
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
SELECT @@global.debug_dbug, @@session.debug_dbug;
SET SESSION debug_dbug= '+T';
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
SELECT @@global.debug_dbug, @@session.debug_dbug;
SET GLOBAL  debug_dbug= '';
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
SELECT @@global.debug_dbug, @@session.debug_dbug;
disconnect con1;
--source include/wait_until_disconnected.inc

--echo # Test 4 - Active session trace file on two connections
connection default;
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
eval SET GLOBAL  debug_dbug= '+O,$MYSQL_TMP_DIR/bug46165.4.trace';
SET SESSION debug_dbug= '-d:-t:-i';

connect (con1, localhost, root);
SET SESSION debug_dbug= '-d:-t:-i';
SET GLOBAL  debug_dbug= '';
SET SESSION debug_dbug= '';

connection default;
SET SESSION debug_dbug= '';
connection con1;
disconnect con1;
--source include/wait_until_disconnected.inc
connection default;

--echo # Test 5 - Different trace files
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
eval SET SESSION debug_dbug= '+O,$MYSQL_TMP_DIR/bug46165.5.trace';
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
eval SET SESSION debug_dbug= '+O,$MYSQL_TMP_DIR/bug46165.6.trace';
SET SESSION debug_dbug= '-O';

SET GLOBAL  debug_dbug= @old_globaldebug;
SET SESSION debug_dbug= @old_sessiondebug;