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

Assertion `share->tmp_table == NO_TMP_TABLE' failed in get_schema_tables_record

    XMLWordPrintable

Details

    Description

      --source include/master-slave.inc
       
      --connection master
      CREATE TEMPORARY TABLE t1 (i int);
      CREATE  TABLE t2 SELECT  * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
       
      --sync_slave_with_master
       
      --connection master
      drop table t1,t2;
       
      --source include/rpl_end.inc
      

      10.3 b633b6a9d8278a3e0d9baaf8

       
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x00007f141ebe1535 in __GI_abort () at abort.c:79
      #6  0x00007f141ebe140f in __assert_fail_base (fmt=0x7f141ed43ee0 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x556b2c1af0d8 "share->tmp_table == NO_TMP_TABLE", file=0x556b2c1ada2d "/10.3/sql/sql_show.cc", line=5422, function=<optimized out>) at assert.c:92
      #7  0x00007f141ebef102 in __GI___assert_fail (assertion=0x556b2c1af0d8 "share->tmp_table == NO_TMP_TABLE", file=0x556b2c1ada2d "/10.3/sql/sql_show.cc", line=5422, function=0x556b2c1b1c40 <get_schema_tables_record(THD*, TABLE_LIST*, TABLE*, bool, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*)::__PRETTY_FUNCTION__> "int get_schema_tables_record(THD*, TABLE_LIST*, TABLE*, bool, const LEX_CSTRING*, const LEX_CSTRING*)") at assert.c:101
      #8  0x0000556b2b5aa0bf in get_schema_tables_record (thd=0x7f13b4001910, tables=0x7f13b407dc18, table=0x7f13b402acf8, res=false, db_name=0x7f13b4044ce8, table_name=0x7f13b4044640) at /10.3/sql/sql_show.cc:5422
      #9  0x0000556b2b5a7909 in fill_schema_table_by_open (thd=0x7f13b4001910, mem_root=0x7f14101f0eb0, is_show_fields_or_keys=false, table=0x7f13b402acf8, schema_table=0x556b2c9d9880 <schema_tables+1984>, orig_db_name=0x7f13b4044ce8, orig_table_name=0x7f13b4044640, open_tables_state_backup=0x7f14101f0f00, can_deadlock=true) at /10.3/sql/sql_show.cc:4657
      #10 0x0000556b2b5a927c in get_all_tables (thd=0x7f13b4001910, tables=0x7f13b400e3b0, cond=0x7f13b400ebd0) at /10.3/sql/sql_show.cc:5260
      #11 0x0000556b2b5ba4da in get_schema_tables_result (join=0x7f13b4010ae8, executed_place=PROCESSED_BY_JOIN_EXEC) at /10.3/sql/sql_show.cc:8872
      #12 0x0000556b2b54f5b3 in JOIN::exec_inner (this=0x7f13b4010ae8) at /10.3/sql/sql_select.cc:4079
      #13 0x0000556b2b54ebc8 in JOIN::exec (this=0x7f13b4010ae8) at /10.3/sql/sql_select.cc:3910
      #14 0x0000556b2b54fed5 in mysql_select (thd=0x7f13b4001910, tables=0x7f13b400e3b0, wild_num=1, fields=..., conds=0x7f13b400ebd0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2953054976, result=0x7f13b40109f0, unit=0x7f13b40057d8, select_lex=0x7f13b4005f60) at /10.3/sql/sql_select.cc:4315
      #15 0x0000556b2b541646 in handle_select (thd=0x7f13b4001910, lex=0x7f13b4005718, result=0x7f13b40109f0, setup_tables_done_option=0) at /10.3/sql/sql_select.cc:370
      #16 0x0000556b2b5ec7b1 in Sql_cmd_create_table_like::execute (this=0x7f13b400dbc0, thd=0x7f13b4001910) at /10.3/sql/sql_table.cc:11227
      #17 0x0000556b2b507e7b in mysql_execute_command (thd=0x7f13b4001910) at /10.3/sql/sql_parse.cc:6030
      #18 0x0000556b2b50d5e6 in mysql_parse (thd=0x7f13b4001910, rawbuf=0x7f13b402aafb "CREATE  TABLE t2 SELECT  * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'", length=81, parser_state=0x7f14101f2430, is_com_multi=false, is_next_command=false) at /10.3/sql/sql_parse.cc:7818
      #19 0x0000556b2b95a6c2 in Query_log_event::do_apply_event (this=0x7f13b4022cb0, rgi=0x7f13b4000ce0, query_arg=0x7f13b402aafb "CREATE  TABLE t2 SELECT  * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'", q_len_arg=81) at /10.3/sql/log_event.cc:5703
      #20 0x0000556b2b959577 in Query_log_event::do_apply_event (this=0x7f13b4022cb0, rgi=0x7f13b4000ce0) at /10.3/sql/log_event.cc:5381
      #21 0x0000556b2b4168ab in Log_event::apply_event (this=0x7f13b4022cb0, rgi=0x7f13b4000ce0) at /10.3/sql/log_event.h:1482
      #22 0x0000556b2b409a47 in apply_event_and_update_pos_apply (ev=0x7f13b4022cb0, thd=0x7f13b4001910, rgi=0x7f13b4000ce0, reason=0) at /10.3/sql/slave.cc:3914
      #23 0x0000556b2b40a05c in apply_event_and_update_pos (ev=0x7f13b4022cb0, thd=0x7f13b4001910, rgi=0x7f13b4000ce0) at /10.3/sql/slave.cc:4082
      #24 0x0000556b2b40a901 in exec_relay_log_event (thd=0x7f13b4001910, rli=0x556b2eea4cc8, serial_rgi=0x7f13b4000ce0) at /10.3/sql/slave.cc:4378
      #25 0x0000556b2b40e1fa in handle_slave_sql (arg=0x556b2eea3000) at /10.3/sql/slave.cc:5551
      #26 0x0000556b2c00ad21 in pfs_spawn_thread (arg=0x556b2edef590) at /10.3/storage/perfschema/pfs.cc:1869
      #27 0x00007f141f334fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486
      #28 0x00007f141ecb84cf in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      
      

      no visible effect on a non-debug build

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              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.