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

GTT: "errno: 0 "Internal error/check" on CoR ... LIKE under lock

    XMLWordPrintable

Details

    • Not for Release Notes
    • Q4/2025 Server Development

    Description

      This is likely the same core issue as MDEV-37720.

      CREATE GLOBAL TEMPORARY TABLE t1 (c INT) ENGINE=InnoDB;
      CREATE TABLE t2 (c INT) ENGINE=InnoDB;
      LOCK TABLES t1 WRITE, t2 WRITE;
      CREATE OR REPLACE GLOBAL TEMPORARY TABLE t1 LIKE t2;
      

      Leads to:

      MDEV-35915-8 CS 12.2.0 c7ea08421d34fa7d45e27919a869ade968bd88c4 (Optimized, Clang 21.1.3-20250923) Build 20/10/2025

      12.2.0-opt>CREATE OR REPLACE GLOBAL TEMPORARY TABLE t1 LIKE t2;
      ERROR 1005 (HY000): Can't create table `test`.`t1` (errno: 0 "Internal error/check (Not system error)")
      

      This does not happen for TT:

      CREATE TEMPORARY TABLE t1 (c INT) ENGINE=InnoDB;
      CREATE TABLE t2 (c INT) ENGINE=InnoDB;
      LOCK TABLES t1 WRITE, t2 WRITE;
      CREATE OR REPLACE TEMPORARY TABLE t1 LIKE t2;
      

      Which works fine:

      MDEV-35915-8 CS 12.2.0 c7ea08421d34fa7d45e27919a869ade968bd88c4 (Optimized, Clang 21.1.3-20250923) Build 20/10/2025

      12.2.0-opt>CREATE OR REPLACE TEMPORARY TABLE t1 LIKE t2;
      Query OK, 0 rows affected (0.000 sec)
      

      Besides fixing the bug, please also improve the ERROR 1005 to be a user-friendly/understandable error.

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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