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

GTT: Assertion `file->trn == trn' failed in ha_maria::start_stmt on Aria ANALYZE TABLE

    XMLWordPrintable

Details

    Description

      SET sql_mode='', enforce_storage_engine=Aria;
      CREATE GLOBAL TEMPORARY TABLE t1 (c INT);
      CREATE GLOBAL TEMPORARY TABLE t2 (c INT);
      LOCK TABLES t2 WRITE,t1 WRITE;
      CREATE OR REPLACE GLOBAL TEMPORARY TABLE t2 SELECT 0 t1;
      ANALYZE TABLE t2;
      

      Leads to:

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

      mariadbd: /test/bb-12.2-nikita-global-tmp_dbg/storage/maria/ha_maria.cc:3053: virtual int ha_maria::start_stmt(THD *, thr_lock_type): Assertion `file->trn == trn' failed.
      

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

      Core was generated by `/test/MDEV-35915_v10_MD311225-mariadb-12.2.0-linux-x86_64-dbg/bin/mariadbd --no'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
       
      [Current thread is 1 (LWP 2756843)]
      (gdb) bt
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
      #3  0x00007c99d2a4526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x00007c99d2a288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x00007c99d2a2881b in __assert_fail_base (fmt=0x7c99d2bd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x62d20702df11 "file->trn == trn", file=file@entry=0x62d206fcaae3 "/test/bb-12.2-nikita-global-tmp_dbg/storage/maria/ha_maria.cc", line=line@entry=3053, function=function@entry=0x62d2070913fe "virtual int ha_maria::start_stmt(THD *, thr_lock_type)") at ./assert/assert.c:94
      #6  0x00007c99d2a3b507 in __assert_fail (assertion=0x62d20702df11 "file->trn == trn", file=0x62d206fcaae3 "/test/bb-12.2-nikita-global-tmp_dbg/storage/maria/ha_maria.cc", line=3053, function=0x62d2070913fe "virtual int ha_maria::start_stmt(THD *, thr_lock_type)") at ./assert/assert.c:103
      #7  0x000062d2080518a0 in ha_maria::start_stmt (this=0x7c98a4036b28, thd=0x7c98a4000d58, lock_type=TL_READ_NO_INSERT)at /test/bb-12.2-nikita-global-tmp_dbg/storage/maria/ha_maria.cc:3053
      #8  0x000062d207af0026 in check_lock_and_start_stmt (thd=0x7c98a4000d58, prelocking_ctx=0x7c98a4005080, table_list=0x7c98a4019f40)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_base.cc:5532
      #9  0x000062d207aefaee in lock_tables (thd=0x7c98a4000d58, tables=0x7c98a4019f40, count=1, flags=0)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_base.cc:6122
      #10 0x000062d207af019f in open_and_lock_tables (thd=0x7c98a4000d58, options=@0x7c98a4006734: {m_options = DDL_options_st::OPT_NONE}, tables=0x7c98a4019f40, derived=true, flags=0, prelocking_strategy=0x7c99cbf64800)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_base.cc:5765
      #11 0x000062d20797280e in open_and_lock_tables (thd=0x7c98a4000d58, tables=0x7c98a4019f40, derived=true, flags=0)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_base.h:544
      #12 0x000062d207e52a21 in open_only_one_table (thd=0x7c98a4000d58, table=0x7c98a4019f40, repair_table_use_frm=false, is_view_operator_func=false)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_admin.cc:436
      #13 0x000062d207e4df64 in mysql_admin_table (thd=0x7c98a4000d58, tables=0x7c98a4019f40, check_opt=0x7c98a40064d0, operator_name=0x62d2089ec7e8 <msg_analyze>, lock_type=TL_READ_NO_INSERT, org_open_for_modify=true, no_errors_from_open=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(class handler * const, class THD *, HA_CHECK_OPT *)) 0x62d207809d30 <handler::ha_analyze(THD*, st_ha_check_opt*)>, view_operator_func=0x0, is_cmd_replicated=true)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_admin.cc:653
      #14 0x000062d207e51716 in Sql_cmd_analyze_table::execute (this=0x7c98a401a678, thd=0x7c98a4000d58)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_admin.cc:1659
      #15 0x000062d207c5192b in mysql_execute_command (thd=0x7c98a4000d58, is_called_from_prepared_stmt=false)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_parse.cc:5879
      #16 0x000062d207c42b98 in mysql_parse (thd=0x7c98a4000d58, rawbuf=0x7c98a4019e80 "ANALYZE TABLE t2", length=16, parser_state=0x7c99cbf67a10)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_parse.cc:7912
      #17 0x000062d207c40379 in dispatch_command (command=COM_QUERY, thd=0x7c98a4000d58, packet=0x7c98a400b1f9 "", packet_length=16, blocking=true) at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_parse.cc:1898
      #18 0x000062d207c4361a in do_command (thd=0x7c98a4000d58, blocking=true)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_parse.cc:1437
      #19 0x000062d207e3601e in do_handle_one_connection (connect=0x62d20a959118, put_in_cache=true)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_connect.cc:1414
      #20 0x000062d207e35e01 in handle_one_connection (arg=0x62d20a9e14d8)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_connect.cc:1326
      #21 0x00007c99d2a9ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #22 0x00007c99d2b29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Testcase is MTR and CLI compatible.

      Attachments

        Issue Links

          Activity

            People

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