# # Test that rows in ndb_binlog_index referencing binlog files # which does not exists are removed when MySQL Server starts. # # 1. Add rows to create references ten different binlog files # 2. Save copies of rows for the three first binlog files # 3. Purge first five binlog files # 4. Restore to three saved rows # 5. Add rows NOT referencing any binlog files, these rows # are identified by 'File' column containing the text "Test" # 6. Restart the MySQL Server # 7. Wait until there are only the expected number of rows in ndb_binlog_index # 8. Show the expected rows. # -- source include/have_ndb.inc -- source include/have_binlog_format_mixed_or_row.inc # Ignore the warning generated by ndbcluster's binlog thread # when mysqld is restarted --disable_query_log ONCE call mtr.add_suppression("mysqld startup An incident event has been written"); # Binlogging must be on SHOW VARIABLES LIKE 'log_bin'; SHOW VARIABLES LIKE 'ndb_log_bin'; RESET MASTER; --echo # Find physical binlog file name format as it varies between platforms CREATE TABLE check_binlog_name (a int primary key) engine = NDB; INSERT INTO check_binlog_name VALUES (1); DROP TABLE check_binlog_name; let $binlog_name = `SELECT SUBSTRING(File, 1, LENGTH(File)-LENGTH('.000001')) FROM mysql.ndb_binlog_index ORDER BY epoch LIMIT 1`; #echo binlog_name: $binlog_name; RESET MASTER; --echo # 1. Insert to create referencing rows CREATE TABLE t1 (a int PRIMARY KEY) ENGINE=ndb; let $i = 1; let $files = 10; while ($i <= $files) { eval INSERT INTO t1 VALUES ($i); # Rotate to new binlog file FLUSH LOGS; inc $i; } DROP TABLE t1; --echo # 2. Save copies of the three first rows CREATE TEMPORARY TABLE save_rows_from_binlog_index AS SELECT * FROM mysql.ndb_binlog_index ORDER BY epoch LIMIT 3; --echo # 3. Purge first five binlog files PURGE BINARY LOGS TO 'binlog.000006'; --echo # 4. Restore saved rows, these should be removed during restart INSERT INTO mysql.ndb_binlog_index SELECT * FROM save_rows_from_binlog_index; --echo # 5. Insert rows which will be removed insert into mysql.ndb_binlog_index values (9, 'Test.000001', 20, 0, 0, 0, 0, 0, 0, 0, 0, 'Next file'), (9, 'Test.000001', 21, 0, 0, 0, 0, 0, 0, 0, 0, 'Next file'), (9, 'Test.000001', 22, 0, 0, 0, 0, 0, 0, 0, 0, 'Next file'), (9, './Test.000002', 23, 0, 0, 0, 0, 0, 0, 0, 0, 'Next file'), (9, './Test.000002', 24, 0, 0, 0, 0, 0, 0, 0, 0, 'Next file'), (9, '/home/a/b/c/d/e/f/Test.000004', 25, 0, 0, 0, 0, 0, 0, 0, 0, 'Next file'), (9, 'c:\\Progra~1\\WinAmp\\Skins\\Test.000005', 26, 0, 0, 0, 0, 0, 0, 0, 0, 'Next file'), (9, './Test.000006/', 27, 0, 0, 0, 0, 0, 0, 0, 0, 'Next file'); --source include/show_binary_logs.inc --replace_result $binlog_name binlog SELECT DISTINCT(File) FROM mysql.ndb_binlog_index; --echo # 6. Restart let $mysqld_name=mysqld.1.1; --source include/restart_mysqld.inc --source include/ndb_not_readonly.inc --echo # 7. Wait for 5 rows let $wait_condition= SELECT COUNT(File) = 5 FROM mysql.ndb_binlog_index; --source include/wait_condition.inc --echo # 8. Show that referenced rows are still there --replace_result $binlog_name binlog SELECT DISTINCT(File) FROM mysql.ndb_binlog_index; RESET MASTER;