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

ERROR 1114 Stored Procedure/Create Temporary Table



      I am attempting to move to the MariaDB 10.2 line for my production application. Previously my upgrade to 10.2 was blocked by MDEV-14857. Now in 10.2.13 this issue has been resolved, however I am running into a new problem. I have a nightly job that runs in a stored procedure that fails in MariaDB 10.2.13. The error I am getting is below:

      ERROR 1114 (HY000): The table '#sql-daf_13' is fulldone

      I realize that this error is normally due to a configuration issue, however look at the end of the error string, it says "done" after full.

      I have narrowed down the issue using the following reproduction steps:

      1. I have uploaded a sql script to ftp.askmonty.org/private called brycejlowe-permtest.sql
      2. Install MariaDB 10.2.13 and source in the file, it creates a schema called scratch and a table called permtest1 which has about 422,000 rows in it.
      3. Execute the following statements against that table:

        CREATE TEMPORARY TABLE scratch.temptest1 LIKE scratch.permtest1;
        INSERT INTO scratch.temptest1 SELECT * FROM scratch.permtest1;
        CREATE TEMPORARY TABLE scratch.temptest2 SELECT * FROM scratch.temptest1;
        ALTER TABLE scratch.temptest2 ADD INDEX `part`(`Part_no`);

      The result in MariaDB 10.2.8 through 10.2.12 is a temporary table scratch.temptest2 with an index called part. However the result in 10.2.13 is the error:





            • Assignee:
              brycejlowe Bryce Lowe
            • Votes:
              0 Vote for this issue
              3 Start watching this issue


              • Created: