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

Crash on delete from sql-versioned table with update trigger

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.3(EOL)
    • N/A
    • Versioned Tables
    • None

    Description

      create or replace table t1 (pk int primary key, x int) with system versioning;
      create or replace trigger tr1upd after update on t1 for each row call log('UPD');
      insert into t1 values(1,1);
      delete from t1;
      

      mysqld: ../sql/sql_trigger.cc:2193: bool Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool): Assertion `trigger_table->pos_in_table_list->trg_event_map & static_cast<uint>(1 << static_cast<int>(event))' failed.
       
      /home/foo/src/mariadb/bld/sql/mysqld(my_print_stacktrace+0x4f)[0x55c0f54ab349]
      mysys/stacktrace.c:269(my_print_stacktrace)[0x55c0f4cc5cc0]
      sigaction.c:0(__restore_rt)[0x7f2a13758a80]
      :0(__GI_raise)[0x7f2a10c4086b]
      :0(__GI_abort)[0x7f2a10c2b40e]
      loadmsgcat.c:0(_nl_load_domain.cold.0)[0x7f2a10c2b2e0]
      :0(__GI___assert_fail)[0x7f2a10c39112]
      /home/foo/src/mariadb/bld/sql/mysqld(_ZN19Table_triggers_list16process_triggersEP3THD14trg_event_type20trg_action_time_typeb+0x1ca)[0x55c0f4abd1e8]
      sql/sql_trigger.cc:2195(Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool))[0x55c0f4acbaf0]
      sql/sql_update.cc:925(mysql_update_inner(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, bool, unsigned long long*, unsigned long long*))[0x55c0f4e71ee8]
      sql/sql_delete.cc:361(mysql_delete(THD*, TABLE_LIST*, Item*, SQL_I_List<st_order>*, unsigned long long, unsigned long long, select_result*))[0x55c0f49d0e35]
      sql/sql_parse.cc:4917(mysql_execute_command(THD*))[0x55c0f49db2f7]
      sql/sql_parse.cc:8077(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c0f49c8033]
      sql/sql_parse.cc:1849(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c0f49c6a43]
      sql/sql_parse.cc:1391(do_command(THD*))[0x55c0f4b33dda]
      sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x55c0f4b33b42]
      pthread_create.c:0(start_thread)[0x7f2a1374e075]
      :0(__GI___clone)[0x7f2a10d0253f]
      

      original issue: https://github.com/tempesta-tech/mariadb/issues/517

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              nikitamalyavin Nikita Malyavin
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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