mirror of
https://github.com/MariaDB/server.git
synced 2025-02-05 13:22: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.
43 lines
1.2 KiB
Text
43 lines
1.2 KiB
Text
#
|
|
# GCF-832 SR: mysql.wsrep_streaming_log table remains populated on all nodes after crash
|
|
# followed by immediate recovery
|
|
#
|
|
--source include/galera_cluster.inc
|
|
--source include/have_debug_sync.inc
|
|
|
|
--connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
|
|
# Save original auto_increment_offset values.
|
|
--let $node_1=node_1
|
|
--let $node_2=node_2
|
|
--let $node_3=node_3
|
|
--source ../galera/include/auto_increment_offset_save.inc
|
|
|
|
--connection node_2
|
|
SET GLOBAL debug_dbug="d,crash_last_fragment_commit_after_fragment_removal";
|
|
|
|
--let $_expect_file_name= `select regexp_replace(@@tmpdir, '^.*/','')`
|
|
--let $_expect_file_name= $MYSQLTEST_VARDIR/tmp/$_expect_file_name.expect
|
|
--write_line wait $_expect_file_name
|
|
|
|
CREATE TABLE t1 (f1 VARCHAR(30)) ENGINE=InnoDB;
|
|
|
|
SET AUTOCOMMIT=OFF;
|
|
SET SESSION wsrep_trx_fragment_size=1;
|
|
START TRANSACTION;
|
|
|
|
INSERT INTO t1 VALUES ('primary'),('primary'),('primary'),('primary'),('primary');
|
|
--error 2013
|
|
COMMIT;
|
|
|
|
--source include/start_mysqld.inc
|
|
|
|
--connection node_1
|
|
SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
|
|
|
|
--connection node_2
|
|
--enable_reconnect
|
|
SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
|
|
|
|
DROP TABLE t1;
|
|
|
|
--source ../galera/include/auto_increment_offset_restore.inc
|