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

Thread hang on CoR where the original table is a GTT

    XMLWordPrintable

Details

    • Not for Release Notes
    • Q4/2025 Server Maintenance

    Description

      CREATE GLOBAL TEMPORARY TABLE t (c INT) ON COMMIT PRESERVE ROWS;
      INSERT t VALUES (1);
      CREATE OR REPLACE TABLE t (c INT);
      

      Leads to a thread hang:

      MDEV-35915 ES 11.8.3-1 267fc98bf48033db5cf8b3bbffd9d3aea4e9ea8e (Debug, Clang) Build 31/07/2025

      11.8.3-dbg>SHOW PROCESSLIST;
      +----+------+-----------+------+---------+------+----------+-----------------------------------+----------+
      | Id | User | Host      | db   | Command | Time | State    | Info                              | Progress |
      +----+------+-----------+------+---------+------+----------+-----------------------------------+----------+
      |  4 | root | localhost | test | Query   |  631 |          | CREATE OR REPLACE TABLE t (c INT) |    0.000 |
      |  6 | root | localhost | test | Query   |    0 | starting | SHOW PROCESSLIST                  |    0.000 |
      +----+------+-----------+------+---------+------+----------+-----------------------------------+----------+
      2 rows in set (0.000 sec)
      

      Present on ES 11.8 dbg/opt and CS 12.0 dbg/opt in the MDEV-35915 patch v1.

      Note: this will also make mariadb-admin shutdown hang significantly (CTRL+c will not work, needs kill -9).

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.