Debian Codegraph @

mysql-test/suite/innodb/r/bug37645185.result

raw
1 #
2 # Bug #37645185: Improve redo log related error log messages
3 #
4 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+.");
5 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.");
6 '#-------------------------------------------------------------------------#'
7 ## Disable REDO_LOG to verify the wrn_msg ER_IB_WRN_REDO_DISABLED_INFO
8 ALTER INSTANCE DISABLE INNODB REDO_LOG;
9 Pattern "InnoDB redo logging is disabled. All data could be lost in case of a server crash. Current lsn is" found
10 ALTER INSTANCE ENABLE INNODB REDO_LOG;
11 SHOW GLOBAL STATUS LIKE 'Innodb_redo_log_enabled';
12 Variable_name Value
13 Innodb_redo_log_enabled ON
14 '#-------------------------------------------------------------------------#'
15 mysql -e "SHOW ENGINE INNODB STATUS"
16 Grepping InnoDB status for Log capacity
17 Pattern "Log capacity" found
18 Grepping InnoDB status for Log capacity used
19 Pattern "Log capacity used" found
20 mysql -e "SELECT VARIABLE_NAME FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE 'innodb_redo_log_%';"
21 Grepping InnoDB status for innodb_redo_log_capacity
22 Pattern "innodb_redo_log_capacity" found