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

Sever crashes in store_trigger_metadata after 2nd execution of ps with create system trigger

    XMLWordPrintable

Details

    • Q3/2026 Server Maintenance

    Description

      PREPARE stmt FROM 'CREATE TRIGGER tr1 AFTER STARTUP SET @x=1';
      EXECUTE stmt;
      DROP TRIGGER tr1;
      EXECUTE stmt;
      

      260618 12:54:44 [ERROR] /bld/sql/mariadbd got signal 11 ;
       
      Server version: 13.1.0-MariaDB-asan-debug-log source revision: a51f81628b0cc9b74d0b436405fb42c3d6e104dc
       
      Thread pointer: 0x52c0001e0220
      stack_bottom = 0x710cb4def000 thread_stack 0xb00000
      libc_sigaction.c:0(__restore_rt)[0x790cce445330]
      sql/sql_sys_or_ddl_trigger.cc:135(store_trigger_metadata(THD*, LEX*, TABLE*, sp_head*, st_trg_chistics const&, unsigned long long))[0x5fab1e7aab67]
      sql/sql_parse.cc:5734(mysql_execute_command(THD*, bool))[0x5fab1df25865]
      sql/sql_prepare.cc:5367(Prepared_statement::execute(String*, bool, select_result*, Server_side_cursor**))[0x5fab1dfa9ced]
      sql/sql_prepare.cc:4725(Prepared_statement::execute_loop(String*, bool, select_result*, Server_side_cursor**, InstrSlice const&, unsigned char*, unsigned char*))[0x5fab1dfaffd7]
      sql/sql_prepare.cc:3656(mysql_sql_stmt_execute(THD*, Lex_ident_sys const&, char const*, bool, select_result*, Server_side_cursor**))[0x5fab1dfb0f08]
      sql/sql_prepare.cc:3672(mysql_sql_stmt_execute(THD*))[0x5fab1dfb1464]
      sql/sql_parse.cc:4008(mysql_execute_command(THD*, bool))[0x5fab1df1aef1]
      sql/sql_parse.cc:7980(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5fab1df28798]
      sql/sql_parse.cc:1904(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5fab1df2c54d]
      sql/sql_parse.cc:1438(do_command(THD*, bool))[0x5fab1df312e7]
      sql/sql_connect.cc:1503(do_handle_one_connection(CONNECT*, bool))[0x5fab1e3fa19d]
      sql/sql_connect.cc:1415(handle_one_connection)[0x5fab1e3fa683]
      asan/asan_interceptors.cpp:234(asan_thread_start(void*))[0x790ccf45ea42]
      nptl/pthread_create.c:447(start_thread)[0x790cce49caa4]
       
      Query (0x52d00017c4f0): CREATE TRIGGER tr1 AFTER STARTUP SET @x=1
      

      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:

                Time Tracking

                  Estimated:
                  Original Estimate - 3d
                  3d
                  Remaining:
                  Remaining Estimate - 3d
                  3d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.