[MDEV-16764] Crash on delete from sql-versioned table with update trigger Created: 2018-07-16  Updated: 2019-10-29  Resolved: 2019-09-09

Status: Closed
Project: MariaDB Server
Component/s: Versioned Tables
Affects Version/s: 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Nikita Malyavin Assignee: Sergei Golubchik
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-16231 make DELETE use mysql_update() intern... Closed
Relates
relates to MDEV-16837 Trigger can't find table Confirmed

 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



 Comments   
Comment by Sergei Golubchik [ 2019-10-29 ]

Not applicable anymore. Caused by MDEV-16231 which was never pushed.

Generated at Thu Feb 08 08:31:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.