Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28178

Windows : sporadic ER_ERROR_ON_RENAME .. (errno: 13 "Permission denied") with Windows Defender

    XMLWordPrintable

    Details

      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

          Activity

            People

            Assignee:
            wlad Vladislav Vaintroub
            Reporter:
            wlad Vladislav Vaintroub
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.