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

TRUNCATE on temporary table causes ER_GET_ERRNO and "Could not remove temporary table" in the log

    XMLWordPrintable

    Details

      Description

      It appears that innodb_safe_truncate makes TRUNCATE unsafe:

      --source include/have_innodb.inc
       
      CREATE TEMPORARY TABLE t1 (a INT) ENGINE=InnoDB;
      ALTER TABLE t1 ENCRYPTED=NO;
      TRUNCATE t1;
      

      10.2 861038f2e with default innodb_safe_truncate=ON

      CURRENT_TEST: bug.temp3
      mysqltest: At line 5: query 'TRUNCATE t1' failed: 1030: Got error 140 "Wrong create options" from storage engine InnoDB
      

      2018-12-01 13:41:46 140647973488384 [Warning] Could not remove temporary table: '/data/bld/10.2/mysql-test/var/tmp/mysqld.1/#sql769d_9_1', error: 2
      

      There is no warning/error with innodb_safe_truncate=OFF

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                marko Marko Mäkelä
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: