mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +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.
58 lines
1.7 KiB
Text
58 lines
1.7 KiB
Text
# The test verifies that the FLUSH TABLES WITH READ LOCK does not
|
|
# time out if it needs to wait for another MDL lock for short duration
|
|
# during SST donation.
|
|
|
|
--source include/galera_cluster.inc
|
|
--source include/have_debug.inc
|
|
--source include/have_debug_sync.inc
|
|
|
|
--let $node_1 = node_1
|
|
--let $node_2 = node_2
|
|
--source include/auto_increment_offset_save.inc
|
|
|
|
--let $galera_connection_name = node_1_ctrl
|
|
--let $galera_server_number = 1
|
|
--source include/galera_connect.inc
|
|
|
|
#
|
|
# Run UPDATE on node_1 and make it block before table locks are taken.
|
|
# This should block FTWRL.
|
|
#
|
|
--connection node_1
|
|
CREATE TABLE t1 (f1 INT PRIMARY KEY, f2 INT);
|
|
INSERT INTO t1 VALUES (1, 1);
|
|
SET DEBUG_SYNC = "before_lock_tables_takes_lock SIGNAL sync_point_reached WAIT_FOR sync_point_continue";
|
|
--send UPDATE t1 SET f2 = 2 WHERE f1 = 1
|
|
|
|
--connection node_1_ctrl
|
|
SET DEBUG_SYNC = "now WAIT_FOR sync_point_reached";
|
|
|
|
#
|
|
# Restart node_2, force SST.
|
|
#
|
|
--connection node_2
|
|
--source include/shutdown_mysqld.inc
|
|
--remove_file $MYSQLTEST_VARDIR/mysqld.2/data/grastate.dat
|
|
# Restart without waiting. The UPDATE should block FTWRL on node_1,
|
|
# so the SST cannot be completed and node_2 cannot join before
|
|
# UPDATE connection is signalled to continue.
|
|
--write_line "restart:$start_mysqld_params" $_expect_file_name
|
|
# If the bug is present, FTWRL times out on node_1 in couple of
|
|
# seconds and node_2 fails to join.
|
|
--sleep 10
|
|
|
|
--connection node_1_ctrl
|
|
SET DEBUG_SYNC = "now SIGNAL sync_point_continue";
|
|
|
|
--connection node_1
|
|
--reap
|
|
SET DEBUG_SYNC = "RESET";
|
|
|
|
--connection node_2
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
--connection node_1
|
|
DROP TABLE t1;
|
|
|
|
--source include/auto_increment_offset_restore.inc
|