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

Assertion `table->s->table_category == TABLE_CATEGORY_SYSTEM || table->s->table_category == TABLE_CATEGORY_STATISTICS' failed in bool open_system_tables_for_read(THD *, TABLE_LIST *)

    XMLWordPrintable

Details

    • Not for Release Notes

    Description

      CREATE OR REPLACE GLOBAL TEMPORARY TABLE mysql.help_topic (help_topic_id INT UNSIGNED,name CHAR);
      HELP '';
      

      Leads to

      MDEV-35915 CS 12.2.0 7893fa4606c84166e855d57ad9b4e79cf5885aca (Debug, Clang 18.1.3-11) Build 24/10/2025

      mariadbd: /test/mtest/MDEV-35915/12.2_dbg/sql/sql_base.cc:9827: bool open_system_tables_for_read(THD *, TABLE_LIST *): Assertion `table->s->table_category == TABLE_CATEGORY_SYSTEM || table->s->table_category == TABLE_CATEGORY_STATISTICS' failed.
      

      MDEV-35915 CS 12.2.0 7893fa4606c84166e855d57ad9b4e79cf5885aca (Debug, Clang 18.1.3-11) Build 24/10/2025

      Core was generated by `/test/mtest/MDEV-35915/MD241025-mariadb-12.2.0-linux-x86_64-dbg/bin/mariadbd --'.
      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 3868339)]
      (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  0x00007e82f464527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x00007e82f46288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x00007e82f462881b in __assert_fail_base (fmt=0x7e82f47d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x56b2519e4e1d "table->s->table_category == TABLE_CATEGORY_SYSTEM || table->s->table_category == TABLE_CATEGORY_STATISTICS", file=file@entry=0x56b2519e30a9 "/test/mtest/MDEV-35915/12.2_dbg/sql/sql_base.cc", line=line@entry=9827, function=function@entry=0x56b2519e4de7 "bool open_system_tables_for_read(THD *, TABLE_LIST *)") at ./assert/assert.c:96
      #6  0x00007e82f463b517 in __assert_fail (assertion=0x56b2519e4e1d "table->s->table_category == TABLE_CATEGORY_SYSTEM || table->s->table_category == TABLE_CATEGORY_STATISTICS", file=0x56b2519e30a9 "/test/mtest/MDEV-35915/12.2_dbg/sql/sql_base.cc", line=9827, function=0x56b2519e4de7 "bool open_system_tables_for_read(THD *, TABLE_LIST *)") at ./assert/assert.c:105
      #7  0x000056b2508a3b26 in open_system_tables_for_read (thd=0x7e6408000d58, table_list=0x7e82f02f4120)at /test/mtest/MDEV-35915/12.2_dbg/sql/sql_base.cc:9826
      #8  0x000056b250fc3dc2 in mysqld_help_internal (thd=0x7e6408000d58, mask=0x7e6408019ef0 "")at /test/mtest/MDEV-35915/12.2_dbg/sql/sql_help.cc:973
      #9  0x000056b250fc3c2f in mysqld_help (thd=0x7e6408000d58, mask=0x7e6408019ef0 "")at /test/mtest/MDEV-35915/12.2_dbg/sql/sql_help.cc:1114
      #10 0x000056b250960a33 in mysql_execute_command (thd=0x7e6408000d58, is_called_from_prepared_stmt=false)at /test/mtest/MDEV-35915/12.2_dbg/sql/sql_parse.cc:3992
      #11 0x000056b250958b54 in mysql_parse (thd=0x7e6408000d58, rawbuf=0x7e6408019e80 "HELP ''", length=7, parser_state=0x7e82f02f8a10)at /test/mtest/MDEV-35915/12.2_dbg/sql/sql_parse.cc:7895
      #12 0x000056b250955f28 in dispatch_command (command=COM_QUERY, thd=0x7e6408000d58, packet=0x7e640800b1f9 "HELP ''", packet_length=7, blocking=true) at /test/mtest/MDEV-35915/12.2_dbg/sql/sql_parse.cc:1882
      #13 0x000056b250959703 in do_command (thd=0x7e6408000d58, blocking=true)at /test/mtest/MDEV-35915/12.2_dbg/sql/sql_parse.cc:1421
      #14 0x000056b250b47cc9 in do_handle_one_connection (connect=0x56b275ac46d8, put_in_cache=true)at /test/mtest/MDEV-35915/12.2_dbg/sql/sql_connect.cc:1414
      #15 0x000056b250b47a6e in handle_one_connection (arg=0x56b275bac518)at /test/mtest/MDEV-35915/12.2_dbg/sql/sql_connect.cc:1326
      #16 0x00007e82f469caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #17 0x00007e82f4729c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: