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
|
-- source include/have_ndb.inc
# Test involves flushing binlog by sending SIGHUP signal using kill linux cmd to mysqld
--source include/not_windows.inc
--let MYSQLD_LOG= $MYSQL_TMP_DIR/sighup_test.log
--let $restart_parameters=restart:--log-error=$MYSQLD_LOG
--replace_result $MYSQLD_LOG MYSQLD_LOG
let $mysqld_name=mysqld.1.1;
--source include/restart_mysqld.inc
let MYSQLD_PIDFILE= `SELECT @@pid_file;`;
--echo #
--echo # Trigger problem reported by "Bug#32357856 SIGHUP CAUSES CRASH IN
--echo # CACHED TABLE DEF CLOSE" by creating and using a NDB table in order
--echo # to have it be added to open table cache and then closed by SIGHUP
--echo #
CREATE TABLE t1 (a int PRIMARY KEY) ENGINE = NDB;
SELECT * FROM t1;
--echo #
--echo # Flush the log by sending SIGHUP from perl script.
--echo #
--perl
use strict;
use warnings;
my $filename = $ENV{"MYSQLD_PIDFILE"} or die("pidfile not set");
my $pid;
my $wait_cnt=60;
open(FILE, "$filename") or die "cannot open file $filename";
while(<FILE>) {
$pid = $_;
}
close(FILE);
rename $ENV{"MYSQLD_LOG"}, $ENV{"MYSQLD_LOG"}.".1";
kill 'HUP', $pid or die "could not kill $pid: $!";
while (! -e $ENV{"MYSQLD_LOG"}) {
if($wait_cnt==0) { die "timedout waiting for error log to be flushed"; }
sleep 1;
$wait_cnt--;
}
EOF
--echo # Check that both files still exists
--file_exists $MYSQLD_LOG
--file_exists $MYSQLD_LOG.1
DROP TABLE t1;
call mtr.add_suppression("mysqld startup An incident event has been written");
--echo # CLEAN UP
--echo # Restore default settings
--let $restart_parameters = restart:
--source include/restart_mysqld.inc
--remove_file $MYSQLD_LOG
--remove_file $MYSQLD_LOG.1
|
