Debian Codegraph @

mysql-test/suite/binlog/t/binlog_no_uniqfile_crash.test

raw
1 # ==== Purpose ====
2 #
3 # Test verifies that when RESET MASTER TO # command is supplied with binlog
4 # extension number greater than 2147483647 the command should report
5 # appropriate error and binary log should be disabled. It should not result in
6 # a crash.
7 #
8 # ==== Implementation ====
9 #
10 # Steps:
11 # 0 - Verify case with max binary log extension. Max value is '2147483647'
12 # 1 - Confirm that SHOW BINARY LOGS displays a binary log with '2147483647'
13 # 2 - Verify that events are successfully written into max extension file.
14 # 3 - Try to create a binary log with extension greater than max allowed
15 # value '2147483648', verify ER_NO_UNIQUE_LOGFILE error is reported.
16 # 4 - Execute CREATE DATABASE db2 statement and verify server dosn't crash.
17 # 5 - Execute SHOW BINARY LOG command and verify that it reports
18 # ER_NO_BINARY_LOGGING error.
19 # 6 - Restart the server and verify that databse 'db2' exists and it it not
20 # present in the binary log.
21 #
22 # ==== References ====
23 #
24 # MDEV-22451: SIGSEGV in __memmove_avx_unaligned_erms/memcpy from
25 # _my_b_write on CREATE after RESET MASTER
26 #
27 --source include/have_log_bin.inc
28
29 call mtr.add_suppression("Next log extension: 2147483647. Remaining log filename extensions: 0");
30 call mtr.add_suppression("Log filename extension number exhausted:.");
31 call mtr.add_suppression("Can't generate a unique log-filename");
32 call mtr.add_suppression("MYSQL_BIN_LOG::open failed to generate new file name.");
33 call mtr.add_suppression("Could not use master-bin for logging");
34
35
36 --echo "Test case verifies creation of binary log with max entension value."
37 RESET MASTER TO 2147483647;
38 --source include/show_binary_logs.inc
39
40 # Check error log for correct messages.
41 let $log_error_= `SELECT @@GLOBAL.log_error`;
42 if(!$log_error_)
43 {
44 # MySQL Server on windows is started with --console and thus
45 # does not know the location of its .err log, use default location
46 let $log_error_ = $MYSQLTEST_VARDIR/log/mysqld.1.err;
47 }
48
49 --let SEARCH_FILE=$log_error_
50 --let SEARCH_PATTERN=Next log extension: 2147483647. Remaining log filename extensions: 0.
51 --source include/search_pattern_in_file.inc
52
53 CREATE DATABASE db1;
54 --source include/show_binlog_events.inc
55
56 --error ER_NO_UNIQUE_LOGFILE
57 RESET MASTER TO 2147483648;
58
59 --let SEARCH_FILE=$log_error_
60 --let SEARCH_PATTERN=Turning logging off for the whole duration of the MariaDB server process
61 --source include/search_pattern_in_file.inc
62
63 --echo "Following CREATE DATABSE db2 command will not be present in binary log"
64 --echo "as binary log got closed due to ER_NO_UNIQUE_LOGFILE error."
65 CREATE DATABASE db2;
66
67
68 --echo "RESET MASTER command fails to generate a new binary log"
69 --echo "log-bin will be disabled and server needs to be restarted to"
70 --echo "re-enable the binary log."
71 --error ER_NO_BINARY_LOGGING
72 SHOW BINARY LOGS;
73
74 --source include/restart_mysqld.inc
75
76 --source include/show_binary_logs.inc
77 SHOW DATABASES LIKE 'db%';
78 --source include/show_binlog_events.inc
79
80 # Cleanup
81 DROP DATABASE db1;
82 DROP DATABASE db2;
83 --source include/show_binlog_events.inc