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

GTT: Aria gets error HA_ERR_CRASHED_ON_USAGE after TRUNCATE

    XMLWordPrintable

Details

    • Not for Release Notes

    Description

      SET sql_mode='',max_session_mem_used=8192,autocommit=0,enforce_storage_engine=Aria;
      CREATE GLOBAL TEMPORARY TABLE t (c INT);
      SELECT * FROM t;
      LOCK TABLES t WRITE;
      SELECT * FROM t;
      TRUNCATE t;
      LOCK TABLE t WRITE;
      

      Leads to:

      MDEV-35915-v10 CS 12.2.0 2ef81706c8c4782b2f8a45a05ac90377403de2e1 (Optimized, Clang 21.1.3-20250923) Build 31/12/2025

      2026-01-05 17:04:35 4 [ERROR] mariadbd: Got error '145 "Table was marked as crashed and should be repaired"' for './test/t'
      2026-01-05 17:04:35 4 [Warning] Checking table:   './test/t' 
      

      No related UBSAN/ASAN issues observed. Not repeatable with MyISAM.

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              Roel Roel Van de Paar
              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.