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

Assertion `ret == false' failed in mysql_drop_sys_or_ddl_trigger

    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

      --connect (c1, localhost, root,,test)
      --connect (c2, localhost, root,,test)
       
      --connection default
      let $i= 300;
      while ($i)
      {
        CREATE OR REPLACE TRIGGER trg1 AFTER STARTUP SET @x=1;
       
        --connection c1
        --send DROP TRIGGER IF EXISTS trg1
       
        --connection c2
        --send DROP TRIGGER IF EXISTS trg1
       
        --connection c1
        --error 0,ER_TRG_DOES_NOT_EXIST
        --reap
        --connection c2
        --error 0,ER_TRG_DOES_NOT_EXIST
        --reap
       
        --connection default
        dec $i;
      }
       
      DROP TRIGGER IF EXISTS trg1;
      

      mariadbd: /src/sql/sql_sys_or_ddl_trigger.cc:749: bool mysql_drop_sys_or_ddl_trigger(THD*, bool*): Assertion `ret == false' failed.
      260616 14:20:20 [ERROR] /bld/sql/mariadbd got signal 6 ;
       
      Server version: 13.1.0-MariaDB-debug-log source revision: a51f81628b0cc9b74d0b436405fb42c3d6e104dc
       
      posix/raise.c:27(__GI_raise)[0x764e3ce4527e]
      stdlib/abort.c:81(__GI_abort)[0x764e3ce288ff]
      sql/sql_sys_or_ddl_trigger.cc:754(mysql_drop_sys_or_ddl_trigger(THD*, bool*))[0x5568a29e2d67]
      sql/sql_parse.cc:5765(mysql_execute_command(THD*, bool))[0x5568a29e9d21]
      sql/sql_parse.cc:7980(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5568a29d583d]
      sql/sql_parse.cc:1906(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5568a29d416c]
      sql/sql_parse.cc:1438(do_command(THD*, bool))[0x5568a2c25e55]
      sql/sql_connect.cc:1503(do_handle_one_connection(CONNECT*, bool))[0x5568a2c25bca]
      sql/sql_connect.cc:1417(handle_one_connection)[0x5568a32a0bfa]
      nptl/pthread_create.c:447(start_thread)[0x764e3ce9caa4]
      x86_64/clone3.S:80(clone3)[0x764e3cf29c6c]
       
      Query (0x6e4df8017240): DROP TRIGGER IF EXISTS trg1
      

      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.