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

Assertion `!param->got_error' failed in Table_triggers_list::change_table_name

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6, 10.7(EOL)
    • 10.6
    • None
    • None

    Description

      CREATE TABLE t1 ( pk int);
      CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW INSERT INTO db.t SELECT SLEEP(0.05)  ; 
       
      RENAME TABLE t1 TO t2, tx TO db.tx;
      

      10.6 3480c3f95b27c8f3e6f4ecbe6

       
      mariadbd: /10.6/src/sql/sql_trigger.cc:2349: static bool Table_triggers_list::change_table_name(THD*, TRIGGER_RENAME_PARAM*, const LEX_CSTRING*, const LEX_CSTRING*, const LEX_CSTRING*, const LEX_CSTRING*, const LEX_CSTRING*): Assertion `!param->got_error' failed.
      211111 14:02:41 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.6.6-MariaDB-debug-log
       
      ??:0(__assert_fail)[0x7f0b9ba39f36]
      sql/sql_trigger.cc:2354(Table_triggers_list::change_table_name(THD*, TRIGGER_RENAME_PARAM*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*))[0x556d496bc84c]
      sql/ddl_log.cc:1214(rename_triggers(THD*, st_ddl_log_entry*, bool))[0x556d496ee386]
      sql/ddl_log.cc:1442(ddl_log_execute_action(THD*, st_mem_root*, st_ddl_log_entry*))[0x556d496f0131]
      sql/ddl_log.cc:2411(ddl_log_execute_entry_no_lock(THD*, unsigned int))[0x556d496f637f]
      sql/ddl_log.cc:2922(ddl_log_revert(THD*, st_ddl_log_state*))[0x556d496f9583]
      sql/sql_rename.cc:202(mysql_rename_tables(THD*, TABLE_LIST*, bool, bool))[0x556d4945d651]
      sql/sql_parse.cc:4328(mysql_execute_command(THD*, bool))[0x556d493e2dbe]
      sql/sql_parse.cc:8030(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556d493fd5b0]
      sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556d493d3671]
      sql/sql_parse.cc:1404(do_command(THD*, bool))[0x556d493d0395]
      sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x556d49836e43]
      sql/sql_connect.cc:1314(handle_one_connection)[0x556d498366cf]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x556d4a5562a9]
      nptl/pthread_create.c:478(start_thread)[0x7f0b9bf52609]
      ??:0(clone)[0x7f0b9bb25293]
       
      Query (0x62b0000c42a8): RENAME TABLE t1 TO t2, tx TO db.tx
      
      

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.