mirror of
https://github.com/MariaDB/server.git
synced 2025-02-04 21:02:17 +01: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.
102 lines
2.3 KiB
Text
102 lines
2.3 KiB
Text
# ==== Purpose ====
|
|
#
|
|
# functional test for open_binlog call using when
|
|
#
|
|
# flush log reset master/slave called
|
|
#
|
|
# ==== Related ====
|
|
#
|
|
# TXSQL feature 67 binlog rotate perf optimization
|
|
|
|
let $engine= myisam;
|
|
|
|
--source include/have_binlog_format_row.inc
|
|
--connect(conn1,localhost,root,,test)
|
|
|
|
reset master;
|
|
create database test_rotate_db;
|
|
use test_rotate_db;
|
|
--echo #currrent engine=$engine
|
|
# Create a new table
|
|
--replace_column 2 #
|
|
show binary logs;
|
|
--eval CREATE TABLE t1_$engine (c1 INT) ENGINE=$engine
|
|
--eval insert into t1_$engine values(0),(1)
|
|
|
|
# do batch flush and show
|
|
let $loop_times= 100;
|
|
--source include/show_master_status.inc
|
|
while ($loop_times) {
|
|
flush logs;
|
|
flush logs;
|
|
if ($loop_times < 5)
|
|
{
|
|
--source include/show_master_status.inc
|
|
if ($loop_times == 4)
|
|
{
|
|
--source include/show_binary_logs.inc
|
|
}
|
|
reset master;
|
|
}
|
|
if ($loop_times >= 5)
|
|
{
|
|
flush logs;
|
|
}
|
|
|
|
#
|
|
dec $loop_times;
|
|
--echo # left times= $loop_times
|
|
}
|
|
--echo # [engine=$engine] after first loop_times=$loop_times, show master logs results
|
|
--source include/show_binary_logs.inc
|
|
|
|
# do batch flush and show with restart mysql
|
|
--source include/show_master_status.inc
|
|
let $loop_times= 10;
|
|
while ($loop_times) {
|
|
flush logs;
|
|
flush logs;
|
|
--echo #begin to restart mysqld current loop_times=$loop_times
|
|
--source include/restart_mysqld.inc
|
|
#
|
|
dec $loop_times;
|
|
--echo # left restart times= $loop_times
|
|
}
|
|
--echo # [engine=$engine] after second loop_times=$loop_times, show master logs results
|
|
--source include/show_binary_logs.inc
|
|
|
|
|
|
# try to change the log-bin configs and restart
|
|
--echo # ======= now try to change the log-bin config for mysqld =======
|
|
--let $restart_parameters=--log-bin=new_log_bin
|
|
--echo #begin to restart mysqld
|
|
--source include/restart_mysqld.inc
|
|
--let $restart_parameters=
|
|
|
|
--source include/show_binary_logs.inc
|
|
let $loop_times= 10;
|
|
while ($loop_times) {
|
|
flush logs;
|
|
flush logs;
|
|
if ($loop_times < 5)
|
|
{
|
|
if ($loop_times == 4)
|
|
{
|
|
--source include/show_binary_logs.inc
|
|
}
|
|
reset master;
|
|
}
|
|
if ($loop_times >= 5)
|
|
{
|
|
flush logs;
|
|
}
|
|
|
|
#
|
|
dec $loop_times;
|
|
--echo # left times= $loop_times
|
|
}
|
|
--echo # [engine=$engine] after third loop_times=$loop_times, show master logs results
|
|
--source include/show_binary_logs.inc
|
|
|
|
##cleanup
|
|
drop database test_rotate_db;
|