[MDEV-23764] Slave crashes in ha_storage_engine_is_enabled upon rename of view Created: 2020-09-19  Updated: 2023-11-27  Resolved: 2020-10-24

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.5
Fix Version/s: 10.5.7

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None


 Description   

repeatable on 10.5, with InnoDB/MyIsam, row/stmt

--source include/master-slave.inc
 
--connection master
CREATE TABLE t1 ( id int );
INSERT INTO t1	VALUES (1),(2),(3); #not important
CREATE VIEW v1 AS SELECT * FROM t1;
 
RENAME  TABLE v1 TO tmp, tmp TO v1;
 
--sync_slave_with_master
select * from v1;
 
--connection master
DROP VIEW v1;
DROP TABLE t1;
--source include/rpl_end.inc

10.5 ccbe6bb6fc3cbe31e74404

#3  <signal handler called>
#4  0x000055bf675d4ec1 in ha_storage_engine_is_enabled (db_type=0x1) at /10.5/sql/handler.h:5096
#5  0x000055bf675d6ef0 in ha_checktype (thd=0x7fb550001bb8, hton=0x1, no_substitute=true) at /10.5/sql/handler.cc:353
#6  0x000055bf675e8545 in ha_check_if_updates_are_ignored (thd=0x7fb550001bb8, hton=0x1, op=0x55bf6801013b "RENAME") at /10.5/sql/handler.cc:5932
#7  0x000055bf672b3627 in do_rename (thd=0x7fb550001bb8, ren_table=0x7fb55000db00, new_db=0x7fb55000e1f8, new_table_name=0x7fb55000e208, new_table_alias=0x7fb55000e228, skip_error=false, if_exists=false, force_if_exists=0x7fb5942d9c6d) at /10.5/sql/sql_rename.cc:306
#8  0x000055bf672b3ad9 in rename_tables (thd=0x7fb550001bb8, table_list=0x7fb55000db00, skip_error=false, if_exists=false, force_if_exists=0x7fb5942d9c6d) at /10.5/sql/sql_rename.cc:423
#9  0x000055bf672b3093 in mysql_rename_tables (thd=0x7fb550001bb8, table_list=0x7fb55000db00, silent=false, if_exists=false) at /10.5/sql/sql_rename.cc:158
#10 0x000055bf67282de5 in mysql_execute_command (thd=0x7fb550001bb8) at /10.5/sql/sql_parse.cc:4314
#11 0x000055bf6728f6db in mysql_parse (thd=0x7fb550001bb8, rawbuf=0x7fb55002e283 "RENAME  TABLE v1 TO tmp, tmp TO v1", length=34, parser_state=0x7fb5942da3f0, is_com_multi=false, is_next_command=false) at /10.5/sql/sql_parse.cc:7994
#12 0x000055bf6773ce7f in Query_log_event::do_apply_event (this=0x7fb55002e0b8, rgi=0x7fb550000cf0, query_arg=0x7fb55002e283 "RENAME  TABLE v1 TO tmp, tmp TO v1", q_len_arg=34) at /10.5/sql/log_event_server.cc:1906
#13 0x000055bf6773bd2f in Query_log_event::do_apply_event (this=0x7fb55002e0b8, rgi=0x7fb550000cf0) at /10.5/sql/log_event_server.cc:1581
#14 0x000055bf6717f93b in Log_event::apply_event (this=0x7fb55002e0b8, rgi=0x7fb550000cf0) at /10.5/sql/log_event.h:1498
#15 0x000055bf671723d8 in apply_event_and_update_pos_apply (ev=0x7fb55002e0b8, thd=0x7fb550001bb8, rgi=0x7fb550000cf0, reason=0) at /10.5/sql/slave.cc:4004
#16 0x000055bf671729ad in apply_event_and_update_pos (ev=0x7fb55002e0b8, thd=0x7fb550001bb8, rgi=0x7fb550000cf0) at /10.5/sql/slave.cc:4166
#17 0x000055bf671732e6 in exec_relay_log_event (thd=0x7fb550001bb8, rli=0x55bf6a387ed8, serial_rgi=0x7fb550000cf0) at /10.5/sql/slave.cc:4483
#18 0x000055bf67176c5b in handle_slave_sql (arg=0x55bf6a386210) at /10.5/sql/slave.cc:5660
#19 0x000055bf6795b8cd in pfs_spawn_thread (arg=0x7fb5541ac118) at /10.5/storage/perfschema/pfs.cc:2201
#20 0x00007fb59bd70fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486
#21 0x00007fb59b3794cf in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
 
 
Query (0x7f20e802e283): RENAME  TABLE v1 TO tmp, tmp TO v1


Generated at Thu Feb 08 09:24:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.