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.
349 lines
8.5 KiB
Text
349 lines
8.5 KiB
Text
|
|
--source include/no_protocol.inc
|
|
--source include/not_embedded.inc
|
|
|
|
call mtr.add_suppression("Optional native table 'performance_schema'.'processlist' has the wrong structure or is missing.");
|
|
call mtr.add_suppression("Column count of performance_schema.processlist is wrong. Expected 8, found 2. The table is probably corrupted");
|
|
|
|
--echo ##
|
|
--echo ## Verify fresh 5.7 instance
|
|
--echo ##
|
|
|
|
SELECT @@global.performance_schema_show_processlist;
|
|
|
|
SHOW CREATE TABLE performance_schema.processlist;
|
|
|
|
--echo ##
|
|
--echo ## Simulate old 5.7 instance
|
|
--echo ##
|
|
|
|
DROP TABLE performance_schema.processlist;
|
|
|
|
--error ER_NO_SUCH_TABLE
|
|
SHOW CREATE TABLE performance_schema.processlist;
|
|
|
|
let $restart_file= $MYSQLTEST_VARDIR/tmp/mysqld.1.expect;
|
|
--write_line wait $restart_file
|
|
--echo ##
|
|
--echo ## Server shutdown
|
|
--echo ##
|
|
--shutdown_server
|
|
--source include/wait_until_disconnected.inc
|
|
--echo ##
|
|
--echo ### Server restart
|
|
--echo ##
|
|
--exec echo "restart:">$restart_file
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
--echo ##
|
|
--echo ## Verify old 5.7 instance
|
|
--echo ##
|
|
|
|
SELECT @@global.performance_schema_show_processlist;
|
|
|
|
--error ER_NO_SUCH_TABLE
|
|
SHOW CREATE TABLE performance_schema.processlist;
|
|
|
|
--error ER_NO_SUCH_TABLE
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SHOW PROCESSLIST;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'ON';
|
|
|
|
--error ER_NO_SUCH_TABLE
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
--error ER_NO_SUCH_TABLE
|
|
SHOW PROCESSLIST;
|
|
|
|
--echo ##
|
|
--echo ## Perform broken upgrade (case 1)
|
|
--echo ##
|
|
|
|
CREATE TABLE performance_schema.processlist (a int, b int);
|
|
|
|
SHOW CREATE TABLE performance_schema.processlist;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'OFF';
|
|
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SHOW PROCESSLIST;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'ON';
|
|
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
--error ER_BAD_FIELD_ERROR
|
|
SHOW PROCESSLIST;
|
|
|
|
--write_line wait $restart_file
|
|
--echo ##
|
|
--echo ## Server shutdown
|
|
--echo ##
|
|
--shutdown_server
|
|
--source include/wait_until_disconnected.inc
|
|
--echo ##
|
|
--echo ### Server restart
|
|
--echo ##
|
|
--exec echo "restart:">$restart_file
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
SHOW CREATE TABLE performance_schema.processlist;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'OFF';
|
|
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SHOW PROCESSLIST;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'ON';
|
|
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
--error ER_BAD_FIELD_ERROR
|
|
SHOW PROCESSLIST;
|
|
|
|
--echo ##
|
|
--echo ## Perform broken upgrade (case 2)
|
|
--echo ##
|
|
|
|
DROP TABLE performance_schema.processlist;
|
|
CREATE TABLE performance_schema.processlist (
|
|
`ID` bigint(20) unsigned NOT NULL,
|
|
`USER` varchar(32) DEFAULT NULL,
|
|
`HOST` varchar(66) DEFAULT NULL,
|
|
`DB` varchar(64) DEFAULT NULL,
|
|
`COMMAND` varchar(16) DEFAULT NULL,
|
|
`TIME` bigint(20) DEFAULT NULL,
|
|
`STATE` varchar(64) DEFAULT NULL,
|
|
`INFO` longtext
|
|
);
|
|
|
|
SHOW CREATE TABLE performance_schema.processlist;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'OFF';
|
|
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SHOW PROCESSLIST;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'ON';
|
|
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
# Works and returns no data, innodb table is empty.
|
|
SHOW PROCESSLIST;
|
|
|
|
--write_line wait $restart_file
|
|
--echo ##
|
|
--echo ## Server shutdown
|
|
--echo ##
|
|
--shutdown_server
|
|
--source include/wait_until_disconnected.inc
|
|
--echo ##
|
|
--echo ### Server restart
|
|
--echo ##
|
|
--exec echo "restart:">$restart_file
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
SHOW CREATE TABLE performance_schema.processlist;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'OFF';
|
|
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SHOW PROCESSLIST;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'ON';
|
|
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
# Works and returns no data, innodb table is empty.
|
|
SHOW PROCESSLIST;
|
|
|
|
--echo ##
|
|
--echo ## Perform broken upgrade (case 3)
|
|
--echo ##
|
|
|
|
DROP TABLE performance_schema.processlist;
|
|
CREATE TABLE performance_schema.processlist
|
|
LIKE INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
SHOW CREATE TABLE performance_schema.processlist;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'OFF';
|
|
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SHOW PROCESSLIST;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'ON';
|
|
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
# Works and returns no data, innodb table is empty.
|
|
SHOW PROCESSLIST;
|
|
|
|
--write_line wait $restart_file
|
|
--echo ##
|
|
--echo ## Server shutdown
|
|
--echo ##
|
|
--shutdown_server
|
|
--source include/wait_until_disconnected.inc
|
|
--echo ##
|
|
--echo ### Server restart
|
|
--echo ##
|
|
--exec echo "restart:">$restart_file
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
SHOW CREATE TABLE performance_schema.processlist;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'OFF';
|
|
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SHOW PROCESSLIST;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'ON';
|
|
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
# Works and returns no data, innodb table is empty.
|
|
SHOW PROCESSLIST;
|
|
|
|
--echo ##
|
|
--echo ## Perform correct upgrade
|
|
--echo ##
|
|
|
|
DROP TABLE performance_schema.processlist;
|
|
CREATE TABLE performance_schema.processlist (
|
|
`ID` bigint(20) unsigned NOT NULL,
|
|
`USER` varchar(32) DEFAULT NULL,
|
|
`HOST` varchar(66) DEFAULT NULL,
|
|
`DB` varchar(64) DEFAULT NULL,
|
|
`COMMAND` varchar(16) DEFAULT NULL,
|
|
`TIME` bigint(20) DEFAULT NULL,
|
|
`STATE` varchar(64) DEFAULT NULL,
|
|
`INFO` longtext
|
|
) ENGINE = 'PERFORMANCE_SCHEMA';
|
|
|
|
SHOW CREATE TABLE performance_schema.processlist;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'OFF';
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SHOW PROCESSLIST;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'ON';
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SHOW PROCESSLIST;
|
|
|
|
--write_line wait $restart_file
|
|
--echo ##
|
|
--echo ## Server shutdown
|
|
--echo ##
|
|
--shutdown_server
|
|
--source include/wait_until_disconnected.inc
|
|
--echo ##
|
|
--echo ### Server restart
|
|
--echo ##
|
|
--exec echo "restart:">$restart_file
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
SHOW CREATE TABLE performance_schema.processlist;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'OFF';
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SHOW PROCESSLIST;
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'ON';
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM performance_schema.processlist;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
|
|
|
|
--replace_column 3 [HOST:PORT] 6 [TIME]
|
|
SHOW PROCESSLIST;
|
|
|
|
# Cleanup
|
|
|
|
SET GLOBAL performance_schema_show_processlist = 'OFF';
|
|
|