1
###########################################################################
3
# This file contains test for (2) test suite.
5
# Consult WL#2789 for more information.
7
###########################################################################
9
--source suite/im/t/im_check_env.inc
11
let $UTIL=$MYSQL_TEST_DIR/suite/im/t;
13
###########################################################################
16
# Check 'SHOW INSTANCE OPTIONS' command.
18
# Since configuration of an mysqld-instance contains directories, we should
19
# completely ignore the second column (values) in order to make the test
20
# case produce the same results on different installations;
21
# TODO: ignore values of only directory-specific options.
24
--replace_column 2 VALUE
25
SHOW INSTANCE OPTIONS mysqld1;
27
--replace_column 2 VALUE
28
SHOW INSTANCE OPTIONS mysqld2;
31
# Before checking log files, we should start the second instance (mysqld2) to
32
# give it a chance to create log files.
35
START INSTANCE mysqld2;
36
--exec $UTIL/wait_for_process.sh $IM_MYSQLD2_PATH_PID 30 started im_utils
38
STOP INSTANCE mysqld2;
39
--exec $UTIL/wait_for_process.sh $IM_MYSQLD2_PATH_PID 30 stopped im_utils
42
# Check 'SHOW LOG FILES' command:
43
# - check that log files of both offline and online instances are accessible;
44
# - since placement of the log files is installation-specific, we should
45
# ignore it in comparisson;
46
# - also, we should ignore log file size, since it may depend on the version
50
--replace_column 2 PATH 3 FILE_SIZE
51
SHOW mysqld1 LOG FILES;
53
--replace_column 2 PATH 3 FILE_SIZE
54
SHOW mysqld2 LOG FILES;
57
# Check 'SHOW LOG' command:
58
# - check that all three kinds of logs are available for both offline and
60
# - we should ignore the value, because it is very specific and depends on
61
# many factors; we only check that Instance Manager is able to provide log
65
# mysqld1 (online) w/o the optional argument.
67
--replace_column 1 LOG_DATA
68
SHOW mysqld1 LOG ERROR 10;
70
--replace_column 1 LOG_DATA
71
SHOW mysqld1 LOG SLOW 10;
73
--replace_column 1 LOG_DATA
74
SHOW mysqld1 LOG GENERAL 10;
76
# mysqld1 (online) with the optional argument.
78
--replace_column 1 LOG_DATA
79
SHOW mysqld1 LOG ERROR 10, 2;
81
--replace_column 1 LOG_DATA
82
SHOW mysqld1 LOG SLOW 10, 2;
84
--replace_column 1 LOG_DATA
85
SHOW mysqld1 LOG GENERAL 10, 2;
87
# mysqld2 (offline) w/o the optional argument.
89
--replace_column 1 LOG_DATA
90
SHOW mysqld2 LOG ERROR 10;
92
--replace_column 1 LOG_DATA
93
SHOW mysqld2 LOG SLOW 10;
95
--replace_column 1 LOG_DATA
96
SHOW mysqld2 LOG GENERAL 10;
98
# mysqld2 (offline) with the optional argument.
100
--replace_column 1 LOG_DATA
101
SHOW mysqld2 LOG ERROR 10, 2;
103
--replace_column 1 LOG_DATA
104
SHOW mysqld2 LOG SLOW 10, 2;
106
--replace_column 1 LOG_DATA
107
SHOW mysqld2 LOG GENERAL 10, 2;