mirror of
https://github.com/MariaDB/server.git
synced 2025-09-15 05:41:27 +03: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.
46 lines
1.5 KiB
Plaintext
46 lines
1.5 KiB
Plaintext
#
|
|
# Purpose:
|
|
# When the mysql.gtid_slave_pos table uses the InnoDB engine, and mysqld
|
|
# starts, it reads the table and begins a transaction. After mysqld reads the
|
|
# value, it should end the transaction and release all associated locks.
|
|
# The bug reported in DBAAS-7828 shows that when autocommit is off, the locks
|
|
# are not released, resulting in indefinite hangs on future attempts to change
|
|
# gtid_slave_pos. This test ensures its fix such that the locks are properly
|
|
# released.
|
|
#
|
|
# References:
|
|
# DBAAS-7828: Primary/replica: configuration change of "autocommit=0" can
|
|
# not be applied
|
|
#
|
|
|
|
--source include/have_innodb.inc
|
|
--source include/have_log_bin.inc
|
|
|
|
# Reading gtid_slave_pos table is format independent so just use one for
|
|
# reduced test time
|
|
--source include/have_binlog_format_row.inc
|
|
|
|
--let old_slave_pos_engine= query_get_value(SHOW TABLE STATUS FROM mysql LIKE 'gtid_slave_pos', Engine, 1)
|
|
|
|
# Use a transactional engine
|
|
ALTER TABLE mysql.gtid_slave_pos ENGINE=innodb;
|
|
|
|
--echo # Restart the server so mysqld reads the gtid_slave_pos using innodb
|
|
--write_line wait $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
--shutdown_server
|
|
--source include/wait_until_disconnected.inc
|
|
--write_line restart $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
--echo # Set gtid_slave_pos should not hang
|
|
SET GLOBAL gtid_slave_pos=@@gtid_binlog_pos;
|
|
COMMIT;
|
|
|
|
# Revert table type
|
|
--disable_query_log
|
|
--eval ALTER TABLE mysql.gtid_slave_pos ENGINE=$old_slave_pos_engine
|
|
--enable_query_log
|
|
|
|
RESET MASTER;
|