Debian Codegraph @

mysql-test/suite/innodb/t/bug37645185.test

raw
1 --echo #
2 --echo # Bug #37645185: Improve redo log related error log messages
3 --echo #
4
5 --disable_warnings
6 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is disabled. All data could be lost in case of a server crash. Current lsn is \\d+.");
7 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is enabled. Data is now safe and can be recovered in case of a server crash.");
8
9 --echo '#-------------------------------------------------------------------------#'
10 --echo ## Disable REDO_LOG to verify the wrn_msg ER_IB_WRN_REDO_DISABLED_INFO
11
12 # Check error_log message after REDO_LOG disable
13 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
14 ALTER INSTANCE DISABLE INNODB REDO_LOG;
15 --let SEARCH_PATTERN= InnoDB redo logging is disabled. All data could be lost in case of a server crash. Current lsn is
16 --source include/search_pattern.inc
17
18 # REDO_LOG enable
19 ALTER INSTANCE ENABLE INNODB REDO_LOG;
20 SHOW GLOBAL STATUS LIKE 'Innodb_redo_log_enabled';
21 --enable_warnings
22
23
24 --echo '#-------------------------------------------------------------------------#'
25
26 --let $innodb_status= $MYSQL_TMP_DIR/innodb_status
27 --echo mysql -e "SHOW ENGINE INNODB STATUS"
28 --exec $MYSQL -e "SHOW ENGINE INNODB STATUS" > $innodb_status
29
30 --let SEARCH_FILE=$innodb_status
31 --let SEARCH_PATTERN=Log capacity
32 --echo Grepping InnoDB status for $SEARCH_PATTERN
33 --source include/search_pattern.inc
34
35 --let SEARCH_FILE=$innodb_status
36 --let SEARCH_PATTERN=Log capacity used
37 --echo Grepping InnoDB status for $SEARCH_PATTERN
38 --source include/search_pattern.inc
39 --remove_file $innodb_status
40
41 --let $innodb_status= $MYSQL_TMP_DIR/innodb_status
42 --echo mysql -e "SELECT VARIABLE_NAME FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE 'innodb_redo_log_%';"
43 --exec $MYSQL -e "SELECT VARIABLE_NAME FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE 'innodb_redo_log_%';" > $innodb_status
44
45 --let SEARCH_FILE=$innodb_status
46 --let SEARCH_PATTERN=innodb_redo_log_capacity
47 --echo Grepping InnoDB status for $SEARCH_PATTERN
48 --source include/search_pattern.inc
49 --remove_file $innodb_status