Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL)
-
None
Description
E:\server\bld\mysql-test> perl .\mysql-test-run.pl innodb.instant_alter_limit --parallel=5
|
Found handle.exe version 4.22
|
Logging: E:/server/mysql-test/mariadb-test-run.pl innodb.instant_alter_limit --parallel=5
|
VS config: Debug
|
vardir: E:/server/bld/mysql-test/var
|
Checking leftover processes...
|
Removing old var directory...
|
Creating var directory 'E:/server/bld/mysql-test/var'...
|
Checking supported features...
|
MariaDB Version 10.6.8-MariaDB-debug
|
- SSL connections supported
|
- binaries are debug compiled
|
Collecting tests...
|
Installing system database...
|
|
==============================================================================
|
|
TEST WORKER RESULT TIME (ms) or COMMENT
|
--------------------------------------------------------------------------
|
|
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
|
worker[2] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039
|
worker[3] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059
|
worker[4] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079
|
worker[5] Using MTR_BUILD_THREAD 304, with reserved ports 16080..16099
|
innodb.instant_alter_limit '64k,innodb' w2 [ fail ]
|
Test ended at 2022-03-25 14:22:20
|
|
CURRENT_TEST: innodb.instant_alter_limit
|
mysqltest: At line 19: query 'ALTER TABLE t DROP b, DROP c, DROP d, DROP e,
|
ADD COLUMN b INT FIRST, ADD COLUMN c INT, ADD COLUMN d INT AFTER b,
|
ADD COLUMN e INT AFTER c, ALGORITHM=INSTANT' failed: ER_ERROR_ON_RENAME (1025): Error on rename of '.\test\#sql-alter-2db4-4' to '.\test\t' (errno: 13 "Permission denied")
|
|
The result from queries just before the failure was:
|
SET @old_instant=
|
(SELECT variable_value FROM information_schema.global_status
|
WHERE variable_name = 'innodb_instant_alter_column');
|
CREATE TABLE t(a INT PRIMARY KEY, b INT, c INT, d INT, e INT)
|
ENGINE=InnoDB;
|
INSERT INTO t VALUES(1,2,3,4,5);
|
SET innodb_strict_mode = OFF;
|
|
- saving 'E:/server/bld/mysql-test/var/2/log/innodb.instant_alter_limit-64k,innodb/' to 'E:/server/bld/mysql-test/var/log/innodb.instant_alter_limit-64k,innodb/'
|
|
Only 1 of 5 completed.
|
Attachments
Issue Links
- is part of
-
MDEV-30162 Fix occasional "Permission denied" on Windows causes by 3rd party software opening database files.
- Closed