mirror of
https://github.com/MariaDB/server.git
synced 2025-01-16 03:52:35 +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.
28 lines
782 B
Text
28 lines
782 B
Text
#
|
|
# MDEV-7656 init_file option does not allow changing passwords
|
|
#
|
|
--source include/not_embedded.inc
|
|
#enable view protocol after fix MDEV-29542
|
|
--source include/no_view_protocol.inc
|
|
|
|
create user foo@localhost;
|
|
|
|
select user,host,password from mysql.user where user='foo';
|
|
|
|
--write_file $MYSQLTEST_VARDIR/init.file
|
|
grant all on *.* to foo@localhost identified by 'test';
|
|
EOF
|
|
|
|
--enable_reconnect
|
|
|
|
--write_line wait $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
|
|
--shutdown_server
|
|
--source include/wait_until_disconnected.inc
|
|
|
|
--write_line "restart:--init-file=$MYSQLTEST_VARDIR/init.file " $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
|
|
--source include/wait_until_connected_again.inc
|
|
select user,host,password,plugin,authentication_string from mysql.user where user='foo';
|
|
|
|
drop user foo@localhost;
|