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

Slave crashes in ha_storage_engine_is_enabled upon rename of view

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.5
    • 10.5.7
    • Replication
    • 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
      
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.