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

Server crashes in my_hash_first/name_hash_search after load_system_triggers

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • N/A
    • 13.1
    • Triggers
    • None
    • Q3/2026 Server Maintenance

    Description

      bb-13.0-MDEV-30645 a51f81628b0cc9b74d0b

      CREATE USER a1@localhost;
      GRANT SUPER ON *.* TO a1@localhost;
      GRANT SELECT ON test.* TO a1@localhost;
       
      --connect (c1, localhost, a1,, test)
      CREATE TRIGGER tr1 AFTER STARTUP SET @x = 1;
      --connection default
      --disconnect c1
       
      --source include/restart_mysqld.inc
       
      SELECT 1;
      DROP TRIGGER tr1;
      DROP USER a1@localhost;
      

      260616 14:52:56 [ERROR] /13.1/bld/sql/mariadbd got signal 11 ;
       
      Server version: 13.1.0-MariaDB-debug-log source revision: a51f81628b0cc9b74d0b436405fb42c3d6e104dc
       
      #5  <signal handler called>
      #6  0x00006371c073bfe0 in my_hash_first (hash=0x0, key=0x7fffcba63cf0 "a1", length=0xc, current_record=0x7fffcba63ca4) at /13.1/src/mysys/hash.c:261
      #7  0x00006371bf63d2aa in name_hash_search (name_hash=0x0, host=0x6371e37238a5 "localhost", ip=0x6371e3724450 "localhost", db=0x6371e3723ed0 "test", user=0x6371e37234a0 "a1", tname=0x6371e3723ee0 "tr1", exact=0x0, name_tolower=0x1) at /13.1/src/sql/sql_acl.cc:5850
      #8  0x00006371bf63d4e9 in routine_hash_search (host=0x6371e37238a5 "localhost", ip=0x6371e3724450 "localhost", db=0x6371e3723ed0 "test", user=0x6371e37234a0 "a1", tname=0x6371e3723ee0 "tr1", sph=0x6371c16c1370 <sp_handler_trigger>, exact=0x0) at /13.1/src/sql/sql_acl.cc:5882
      #9  0x00006371bf648b1c in check_grant_routine (thd=0x6371e37155e0, want_access=EXECUTE_ACL, procs=0x7fffcba645c0, sph=0x6371c16c1370 <sp_handler_trigger>, no_errors=0x0) at /13.1/src/sql/sql_acl.cc:9121
      #10 0x00006371bf76454a in check_routine_access (thd=0x6371e37155e0, want_access=EXECUTE_ACL, db=0x6371e3723088, name=0x6371e3723098, sph=0x6371c16c1370 <sp_handler_trigger>, no_errors=0x0) at /13.1/src/sql/sql_parse.cc:7153
      #11 0x00006371bf61392e in sp_head::check_execute_access (this=0x6371e3723060, thd=0x6371e37155e0) at /13.1/src/sql/sp_head.cc:1632
      #12 0x00006371bf61385f in set_routine_security_ctx (thd=0x6371e37155e0, sp=0x6371e3723060, save_ctx=0x7fffcba64db8) at /13.1/src/sql/sp_head.cc:1617
      #13 0x00006371bf6157c1 in sp_head::execute_procedure (this=0x6371e3723060, thd=0x6371e37155e0, args=(List<Item> *) 0x7fffcba650b0 0x0 Item's) at /13.1/src/sql/sp_head.cc:2323
      #14 0x00006371bfb65c6a in Sys_trigger::execute (this=0x6371e371edc0) at /13.1/src/sql/sql_sys_or_ddl_trigger.cc:776
      #15 0x00006371bfb66c59 in run_after_startup_triggers (bootstrap_or_noacl=0x0) at /13.1/src/sql/sql_sys_or_ddl_trigger.cc:1329
      #16 0x00006371bf54c784 in mysqld_main (argc=0x9f, argv=0x6371e2b4c430) at /13.1/src/sql/mysqld.cc:6424
      #17 0x00006371bf53e21d in main (argc=0x18, argv=0x7fffcba65338) at /13.1/src/sql/main.cc:34
      

      Attachments

        Issue Links

          Activity

            People

              shulga Dmitry Shulga
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.