mirror of
https://github.com/MariaDB/server.git
synced 2025-07-08 04:18:14 +02:00
061adae9a2
On Windows systems, occurrences of ERROR_SHARING_VIOLATION due to conflicting share modes between processes accessing the same file can result in CreateFile failures. mysys' my_open() already incorporates a workaround by implementing wait/retry logic on Windows. But this does not help if files are opened using shell redirection like mysqltest traditionally did it, i.e via --echo exec "some text" > output_file In such cases, it is cmd.exe, that opens the output_file, and it won't do any sharing-violation retries. This commit addresses the issue by introducing a new built-in command, 'write_line', in mysqltest. This new command serves as a brief alternative to 'write_file', with a single line output, that also resolves variables like "exec" would. Internally, this command will use my_open(), and therefore retry-on-error logic. Hopefully this will eliminate the very sporadic "can't open file because it is used by another process" error on CI.
278 lines
7.8 KiB
HTML
278 lines
7.8 KiB
HTML
#
|
|
# This include file is used by more than one test suite
|
|
# (currently binlog and binlog_encryption).
|
|
# Please check all dependent tests after modifying it
|
|
#
|
|
|
|
#
|
|
# testing of purging of binary log files bug#18199/Bug#18453
|
|
#
|
|
source include/have_log_bin.inc;
|
|
source include/not_embedded.inc;
|
|
# Don't test this under valgrind, memory leaks will occur
|
|
--source include/not_valgrind.inc
|
|
source include/have_debug.inc;
|
|
# Avoid CrashReporter popup on Mac
|
|
--source include/not_crashrep.inc
|
|
call mtr.add_suppression('Attempting backtrace');
|
|
call mtr.add_suppression('MYSQL_BIN_LOG::purge_logs failed to process registered files that would be purged.');
|
|
call mtr.add_suppression('MYSQL_BIN_LOG::open failed to sync the index file');
|
|
call mtr.add_suppression('Turning logging off for the whole duration of the MySQL server process.');
|
|
call mtr.add_suppression('Could not use .*');
|
|
call mtr.add_suppression('MYSQL_BIN_LOG::purge_logs failed to clean registers before purging logs.');
|
|
flush tables;
|
|
|
|
SET @saved_dbug = @@SESSION.debug_dbug;
|
|
|
|
RESET MASTER;
|
|
|
|
let $MYSQLD_DATADIR= `select @@datadir`;
|
|
let $INDEX=$MYSQLD_DATADIR/master-bin.index;
|
|
|
|
#
|
|
# testing purge binary logs TO
|
|
#
|
|
|
|
flush logs;
|
|
flush logs;
|
|
flush logs;
|
|
|
|
source include/show_binary_logs.inc;
|
|
remove_file $MYSQLD_DATADIR/master-bin.000001;
|
|
flush tables;
|
|
|
|
# there must be a warning with file names
|
|
replace_regex /\.[\\\/]master/master/;
|
|
--source include/wait_for_binlog_checkpoint.inc
|
|
purge binary logs TO 'master-bin.000004';
|
|
|
|
--echo *** must show a list starting from the 'TO' argument of PURGE ***
|
|
source include/show_binary_logs.inc;
|
|
|
|
#
|
|
# testing purge binary logs BEFORE
|
|
#
|
|
|
|
reset master;
|
|
|
|
flush logs;
|
|
flush logs;
|
|
flush logs;
|
|
remove_file $MYSQLD_DATADIR/master-bin.000001;
|
|
|
|
--echo *** must be a warning master-bin.000001 was not found ***
|
|
let $date=`select NOW() + INTERVAL 1 MINUTE`;
|
|
--disable_query_log
|
|
replace_regex /\.[\\\/]master/master/;
|
|
--source include/wait_for_binlog_checkpoint.inc
|
|
eval purge binary logs BEFORE '$date';
|
|
--enable_query_log
|
|
|
|
--echo *** must show one record, of the active binlog, left in the index file after PURGE ***
|
|
source include/show_binary_logs.inc;
|
|
|
|
#
|
|
# testing a fatal error
|
|
# Turning a binlog file into a directory must be a portable setup
|
|
#
|
|
|
|
reset master;
|
|
|
|
flush logs;
|
|
flush logs;
|
|
flush logs;
|
|
|
|
remove_file $MYSQLD_DATADIR/master-bin.000001;
|
|
mkdir $MYSQLD_DATADIR/master-bin.000001;
|
|
|
|
--source include/wait_for_binlog_checkpoint.inc
|
|
--error ER_BINLOG_PURGE_FATAL_ERR
|
|
purge binary logs TO 'master-bin.000002';
|
|
replace_regex /\.[\\\/]master/master/;
|
|
show warnings;
|
|
rmdir $MYSQLD_DATADIR/master-bin.000001;
|
|
--disable_warnings
|
|
reset master;
|
|
--enable_warnings
|
|
|
|
--echo # crash_purge_before_update_index
|
|
flush logs;
|
|
|
|
--write_line restart $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
SET SESSION debug_dbug="+d,crash_purge_before_update_index";
|
|
--source include/wait_for_binlog_checkpoint.inc
|
|
--error 2013
|
|
purge binary logs TO 'master-bin.000002';
|
|
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
file_exists $MYSQLD_DATADIR/master-bin.000001;
|
|
file_exists $MYSQLD_DATADIR/master-bin.000002;
|
|
file_exists $MYSQLD_DATADIR/master-bin.000003;
|
|
--chmod 0644 $INDEX
|
|
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
-- eval SET @index=LOAD_FILE('$index')
|
|
-- replace_regex /\.[\\\/]master/master/
|
|
SELECT @index;
|
|
|
|
--echo # crash_purge_non_critical_after_update_index
|
|
flush logs;
|
|
|
|
--write_line restart $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
SET SESSION debug_dbug="+d,crash_purge_non_critical_after_update_index";
|
|
--source include/wait_for_binlog_checkpoint.inc
|
|
--error 2013
|
|
purge binary logs TO 'master-bin.000004';
|
|
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
--error 1
|
|
file_exists $MYSQLD_DATADIR/master-bin.000001;
|
|
--error 1
|
|
file_exists $MYSQLD_DATADIR/master-bin.000002;
|
|
--error 1
|
|
file_exists $MYSQLD_DATADIR/master-bin.000003;
|
|
--chmod 0644 $INDEX
|
|
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
-- eval SET @index=LOAD_FILE('$index')
|
|
-- replace_regex /\.[\\\/]master/master/
|
|
SELECT @index;
|
|
|
|
--echo # crash_purge_critical_after_update_index
|
|
flush logs;
|
|
|
|
--write_line restart $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
SET SESSION debug_dbug="+d,crash_purge_critical_after_update_index";
|
|
--source include/wait_for_binlog_checkpoint.inc
|
|
--error 2013
|
|
purge binary logs TO 'master-bin.000006';
|
|
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
--error 1
|
|
file_exists $MYSQLD_DATADIR/master-bin.000004;
|
|
--error 1
|
|
file_exists $MYSQLD_DATADIR/master-bin.000005;
|
|
file_exists $MYSQLD_DATADIR/master-bin.000006;
|
|
file_exists $MYSQLD_DATADIR/master-bin.000007;
|
|
--error 1
|
|
file_exists $MYSQLD_DATADIR/master-bin.000008;
|
|
--chmod 0644 $INDEX
|
|
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
-- eval SET @index=LOAD_FILE('$index')
|
|
-- replace_regex /\.[\\\/]master/master/
|
|
SELECT @index;
|
|
|
|
--echo # crash_create_non_critical_before_update_index
|
|
--write_line restart $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
SET SESSION debug_dbug="+d,crash_create_non_critical_before_update_index";
|
|
--error 2013
|
|
flush logs;
|
|
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
file_exists $MYSQLD_DATADIR/master-bin.000008;
|
|
--error 1
|
|
file_exists $MYSQLD_DATADIR/master-bin.000009;
|
|
--chmod 0644 $INDEX
|
|
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
-- eval SET @index=LOAD_FILE('$index')
|
|
-- replace_regex /\.[\\\/]master/master/
|
|
SELECT @index;
|
|
|
|
--echo # crash_create_critical_before_update_index
|
|
--write_line restart $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
SET SESSION debug_dbug="+d,crash_create_critical_before_update_index";
|
|
--error 2013
|
|
flush logs;
|
|
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
file_exists $MYSQLD_DATADIR/master-bin.000009;
|
|
--error 1
|
|
file_exists $MYSQLD_DATADIR/master-bin.000010;
|
|
--error 1
|
|
file_exists $MYSQLD_DATADIR/master-bin.000011;
|
|
--chmod 0644 $INDEX
|
|
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
-- eval SET @index=LOAD_FILE('$index')
|
|
-- replace_regex /\.[\\\/]master/master/
|
|
SELECT @index;
|
|
|
|
--echo # crash_create_after_update_index
|
|
--write_line restart $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
SET SESSION debug_dbug="+d,crash_create_after_update_index";
|
|
--error 2013
|
|
flush logs;
|
|
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
file_exists $MYSQLD_DATADIR/master-bin.000010;
|
|
file_exists $MYSQLD_DATADIR/master-bin.000011;
|
|
--chmod 0644 $INDEX
|
|
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
-- eval SET @index=LOAD_FILE('$index')
|
|
-- replace_regex /\.[\\\/]master/master/
|
|
SELECT @index;
|
|
|
|
--echo #
|
|
--echo # This should put the server in unsafe state and stop
|
|
--echo # accepting any command. If we inject a fault at this
|
|
--echo # point and continue the execution the server crashes.
|
|
--echo #
|
|
|
|
--chmod 0644 $INDEX
|
|
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
-- eval SET @index=LOAD_FILE('$index')
|
|
-- replace_regex /\.[\\\/]master/master/
|
|
SELECT @index;
|
|
|
|
--echo # fault_injection_registering_index
|
|
SET SESSION debug_dbug="+d,fault_injection_registering_index";
|
|
-- replace_regex /\.[\\\/]master/master/
|
|
-- error ER_CANT_OPEN_FILE
|
|
flush logs;
|
|
|
|
--chmod 0644 $INDEX
|
|
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
-- eval SET @index=LOAD_FILE('$index')
|
|
-- replace_regex /\.[\\\/]master/master/
|
|
SELECT @index;
|
|
|
|
--source include/restart_mysqld.inc
|
|
|
|
--chmod 0644 $INDEX
|
|
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
-- eval SET @index=LOAD_FILE('$index')
|
|
-- replace_regex /\.[\\\/]master/master/
|
|
SELECT @index;
|
|
|
|
--echo # fault_injection_updating_index
|
|
SET SESSION debug_dbug="+d,fault_injection_updating_index";
|
|
-- replace_regex /\.[\\\/]master/master/
|
|
-- error ER_CANT_OPEN_FILE
|
|
flush logs;
|
|
|
|
--chmod 0644 $INDEX
|
|
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
-- eval SET @index=LOAD_FILE('$index')
|
|
-- replace_regex /\.[\\\/]master/master/
|
|
SELECT @index;
|
|
|
|
--source include/restart_mysqld.inc
|
|
|
|
--chmod 0644 $INDEX
|
|
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
|
|
-- eval SET @index=LOAD_FILE('$index')
|
|
-- replace_regex /\.[\\\/]master/master/
|
|
SELECT @index;
|
|
|
|
SET @@SESSION.debug_dbug = @saved_dbug;
|
|
|
|
--echo End of tests
|