| 1 |
call mtr.add_suppression("Next log extension: 2147483647. Remaining log filename extensions: 0"); |
| 2 |
call mtr.add_suppression("Log filename extension number exhausted:."); |
| 3 |
call mtr.add_suppression("Can't generate a unique log-filename"); |
| 4 |
call mtr.add_suppression("MYSQL_BIN_LOG::open failed to generate new file name."); |
| 5 |
call mtr.add_suppression("Could not use master-bin for logging"); |
| 6 |
"Test case verifies creation of binary log with max entension value." |
| 7 |
RESET MASTER TO 2147483647; |
| 8 |
show binary logs; |
| 9 |
Log_name File_size |
| 10 |
master-bin.2147483647 # |
| 11 |
FOUND 1 /Next log extension: 2147483647. Remaining log filename extensions: 0./ in mysqld.1.err |
| 12 |
CREATE DATABASE db1; |
| 13 |
include/show_binlog_events.inc |
| 14 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 15 |
master-bin.2147483647 # Gtid # # GTID #-#-# |
| 16 |
master-bin.2147483647 # Query # # CREATE DATABASE db1 |
| 17 |
RESET MASTER TO 2147483648; |
| 18 |
ERROR HY000: Can't generate a unique log-filename master-bin.(1-999) |
| 19 |
FOUND 1 /Turning logging off for the whole duration of the MariaDB server process/ in mysqld.1.err |
| 20 |
"Following CREATE DATABSE db2 command will not be present in binary log" |
| 21 |
"as binary log got closed due to ER_NO_UNIQUE_LOGFILE error." |
| 22 |
CREATE DATABASE db2; |
| 23 |
"RESET MASTER command fails to generate a new binary log" |
| 24 |
"log-bin will be disabled and server needs to be restarted to" |
| 25 |
"re-enable the binary log." |
| 26 |
SHOW BINARY LOGS; |
| 27 |
ERROR HY000: You are not using binary logging |
| 28 |
# restart |
| 29 |
show binary logs; |
| 30 |
Log_name File_size |
| 31 |
master-bin.000001 # |
| 32 |
SHOW DATABASES LIKE 'db%'; |
| 33 |
Database (db%) |
| 34 |
db1 |
| 35 |
db2 |
| 36 |
include/show_binlog_events.inc |
| 37 |
DROP DATABASE db1; |
| 38 |
DROP DATABASE db2; |
| 39 |
include/show_binlog_events.inc |
| 40 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 41 |
master-bin.000001 # Gtid # # GTID #-#-# |
| 42 |
master-bin.000001 # Query # # DROP DATABASE db1 |
| 43 |
master-bin.000001 # Gtid # # GTID #-#-# |
| 44 |
master-bin.000001 # Query # # DROP DATABASE db2 |