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

Assertion `mdl_key->length() == 3' failed in MDL_map::find_or_insert

    XMLWordPrintable

Details

    Description

      CREATE VIEW v AS select * from (select 'foo' AS a) sq;
      CREATE PROCEDURE p() ALTER TABLE v TRUNCATE PARTITION p;
      --error ER_PARTITION_MGMT_ON_NONPARTITIONED
      CALL p;
      --error ER_PARTITION_MGMT_ON_NONPARTITIONED
      CALL p;
       
      DROP PROCEDURE p;
      DROP VIEW v;
      

      10.11 b29d3779e42f1cf65b1bbe84876767122dcc76c8

      mariadbd: /data/bld/10.11-asan-ubsan/sql/mdl.cc:864: MDL_lock* MDL_map::find_or_insert(LF_PINS*, const MDL_key*): Assertion `mdl_key->length() == 3' failed.
      260209 23:35:45 [ERROR] /share8t/bld/10.11-asan-ubsan/sql/mariadbd got signal 6 ;
       
      #8  0x00007f77e1c45395 in __assert_fail_base (fmt=0x7f77e1db9a90 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x56133ba3aa60 "mdl_key->length() == 3", file=file@entry=0x56133ba39860 "/data/bld/release/bb-12.2-release-asan/sql/mdl.cc", line=line@entry=1577, function=function@entry=0x56133ba3aaa0 "tal_status MDL_map::try_acquire_lock(LF_PINS*, MDL_key*, MDL_ticket*, bool)") at ./assert/assert.c:92
      #9  0x00007f77e1c53eb2 in __GI___assert_fail (assertion=0x56133ba3aa60 "mdl_key->length() == 3", file=0x56133ba39860 "/data/bld/release/bb-12.2-release-asan/sql/mdl.cc", line=1577, function=0x56133ba3aaa0 "tal_status MDL_map::try_acquire_lock(LF_PINS*, MDL_key*, MDL_ticket*, bool)") at ./assert/assert.c:101
      #10 0x0000561339843d28 in MDL_map::try_acquire_lock (this=0x56133e202300 <mdl_locks>, pins=0x62c0000402b8, mdl_key=0x625000270018, ticket=0x6080000172a0, wait=true) at /data/bld/release/bb-12.2-release-asan/sql/mdl.cc:1577
      #11 0x0000561339847855 in MDL_context::try_acquire_lock_impl (this=0x62c0000c0438, mdl_request=0x62500026fff8, out_ticket=0x7f77d68ad610) at /data/bld/release/bb-12.2-release-asan/sql/mdl.cc:2741
      #12 0x000056133984870e in MDL_context::acquire_lock (this=0x62c0000c0438, mdl_request=0x62500026fff8, lock_wait_timeout=86400) at /data/bld/release/bb-12.2-release-asan/sql/mdl.cc:2895
      #13 0x000056133984a0d3 in MDL_context::acquire_locks (this=0x62c0000c0438, mdl_requests=0x7f77d68ad900, lock_wait_timeout=86400) at /data/bld/release/bb-12.2-release-asan/sql/mdl.cc:3132
      #14 0x00005613391495b7 in lock_table_names (thd=0x62c0000c0218, options=..., tables_start=0x62500025b9d8, tables_end=0x0, lock_wait_timeout=86400, flags=0) at /data/bld/release/bb-12.2-release-asan/sql/sql_base.cc:4501
      #15 0x000056133914a15f in open_tables (thd=0x62c0000c0218, options=..., start=0x7f77d68aded0, counter=0x7f77d68adec0, flags=0, prelocking_strategy=0x7f77d68addc0) at /data/bld/release/bb-12.2-release-asan/sql/sql_base.cc:4714
      #16 0x00005613391184dc in open_tables (thd=0x62c0000c0218, tables=0x7f77d68aded0, counter=0x7f77d68adec0, flags=0) at /data/bld/release/bb-12.2-release-asan/sql/sql_base.h:507
      #17 0x0000561339827e04 in Sql_cmd_alter_table_truncate_partition::execute (this=0x62500025c158, thd=0x62c0000c0218) at /data/bld/release/bb-12.2-release-asan/sql/sql_partition_admin.cc:888
      #18 0x00005613393317e3 in mysql_execute_command (thd=0x62c0000c0218, is_called_from_prepared_stmt=false) at /data/bld/release/bb-12.2-release-asan/sql/sql_parse.cc:5893
      #19 0x0000561339a36f6d in sp_instr_stmt::exec_core (this=0x62500025c1b0, thd=0x62c0000c0218, nextp=0x7f77d68af500) at /data/bld/release/bb-12.2-release-asan/sql/sp_instr.cc:1268
      #20 0x0000561339a322e0 in sp_lex_keeper::reset_lex_and_exec_core (this=0x62500025c1f0, thd=0x62c0000c0218, nextp=0x7f77d68af500, open_tables=false, instr=0x62500025c1b0, rerun_the_same_instr=false) at /data/bld/release/bb-12.2-release-asan/sql/sp_instr.cc:418
      #21 0x0000561339a33550 in sp_lex_keeper::validate_lex_and_exec_core (this=0x62500025c1f0, thd=0x62c0000c0218, nextp=0x7f77d68af500, open_tables=false, instr=0x62500025c1b0) at /data/bld/release/bb-12.2-release-asan/sql/sp_instr.cc:597
      #22 0x0000561339a366e3 in sp_instr_stmt::execute (this=0x62500025c1b0, thd=0x62c0000c0218, nextp=0x7f77d68af500) at /data/bld/release/bb-12.2-release-asan/sql/sp_instr.cc:1170
      #23 0x0000561339078ba3 in sp_head::execute (this=0x62500025a998, thd=0x62c0000c0218, merge_da_on_success=true) at /data/bld/release/bb-12.2-release-asan/sql/sp_head.cc:1294
      #24 0x000056133907f1cb in sp_head::execute_procedure (this=0x62500025a998, thd=0x62c0000c0218, args=0x62c0000c57e8) at /data/bld/release/bb-12.2-release-asan/sql/sp_head.cc:2331
      #25 0x000056133931c9dd in do_execute_sp (thd=0x62c0000c0218, sp=0x62500025a998) at /data/bld/release/bb-12.2-release-asan/sql/sql_parse.cc:3072
      #26 0x000056133931e864 in Sql_cmd_call::execute (this=0x62d0000f0500, thd=0x62c0000c0218) at /data/bld/release/bb-12.2-release-asan/sql/sql_parse.cc:3313
      #27 0x00005613393317e3 in mysql_execute_command (thd=0x62c0000c0218, is_called_from_prepared_stmt=false) at /data/bld/release/bb-12.2-release-asan/sql/sql_parse.cc:5893
      #28 0x000056133933eacf in mysql_parse (thd=0x62c0000c0218, rawbuf=0x62d0000f0438 "CALL p", length=6, parser_state=0x7f77d68b1a20) at /data/bld/release/bb-12.2-release-asan/sql/sql_parse.cc:7925
      #29 0x0000561339315645 in dispatch_command (command=COM_QUERY, thd=0x62c0000c0218, packet=0x6290002a3219 "CALL p", packet_length=6, blocking=true) at /data/bld/release/bb-12.2-release-asan/sql/sql_parse.cc:1896
      #30 0x0000561339312346 in do_command (thd=0x62c0000c0218, blocking=true) at /data/bld/release/bb-12.2-release-asan/sql/sql_parse.cc:1432
      #31 0x000056133981e69d in do_handle_one_connection (connect=0x6080000081b8, put_in_cache=true) at /data/bld/release/bb-12.2-release-asan/sql/sql_connect.cc:1503
      #32 0x000056133981e1fc in handle_one_connection (arg=0x608000008138) at /data/bld/release/bb-12.2-release-asan/sql/sql_connect.cc:1415
      #33 0x000056133a5a89cc in pfs_spawn_thread (arg=0x617000005f18) at /data/bld/release/bb-12.2-release-asan/storage/perfschema/pfs.cc:2198
      #34 0x00007f77e1ca81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #35 0x00007f77e1d2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      No obvious immediate problem on a non-debug build.
      The failure started happening after this commit in 10.11.16:

      commit 6fcd87ba4d37560fe63e2901315ed2983723ccb6
      Author: Aleksey Midenkov
      Date:   Sat Dec 20 19:56:08 2025 +0300
       
          MDEV-33985 Server crashes at Item_func_nextval::val_int
      

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              elenst Elena Stepanova
              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.