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

Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed upon SHOW TABLE STATUS after failed DDL

Details

    Description

      mysqld: 10.4/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
       
      180814 12:53:38 [ERROR] mysqld got signal 6 ;
      Server version: 10.4.0-MariaDB-debug-log
       
      stdlib/abort.c:91(__GI_abort)[0x7fb7bf7ce02a]
      assert/assert.c:92(__assert_fail_base)[0x7fb7bf7c4bd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fb7bf7c4c82]
      myisam/mi_open.c:68(test_if_reopen)[0x558c80bbe37b]
      myisam/mi_open.c:122(mi_open)[0x558c80bbe74a]
      myisam/ha_myisam.cc:782(ha_myisam::open(char const*, int, unsigned int))[0x558c80b4c7b3]
      sql/handler.cc:2684(handler::ha_open(TABLE*, char const*, int, unsigned int, st_mem_root*, List<String>*))[0x558c80476cdb]
      sql/ha_partition.cc:8422(ha_partition::open_read_partitions(char*, unsigned long))[0x558c8148da22]
      sql/ha_partition.cc:3588(ha_partition::open(char const*, int, unsigned int))[0x558c8146877d]
      sql/handler.cc:2684(handler::ha_open(TABLE*, char const*, int, unsigned int, st_mem_root*, List<String>*))[0x558c80476cdb]
      sql/table.cc:3499(open_table_from_share(THD*, TABLE_SHARE*, st_mysql_const_lex_string const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, List<String>*))[0x558c8002f7c1]
      sql/sql_base.cc:1953(open_table(THD*, TABLE_LIST*, Open_table_context*))[0x558c7fc466c8]
      sql/sql_base.cc:3554(open_and_process_table(THD*, LEX*, TABLE_LIST*, unsigned int*, unsigned int, Prelocking_strategy*, bool, Open_table_context*))[0x558c7fc4d668]
      sql/sql_base.cc:4074(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x558c7fc4ff84]
      sql/sql_base.h:248(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x558c7fc3e20d]
      sql/sql_base.cc:5012(open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int, unsigned int))[0x558c7fc54a84]
      sql/sql_base.cc:5062(open_tables_only_view_structure(THD*, TABLE_LIST*, bool))[0x558c7fc54ee8]
      sql/sql_show.cc:4573(fill_schema_table_by_open(THD*, st_mem_root*, bool, TABLE*, st_schema_table*, st_mysql_const_lex_string*, st_mysql_const_lex_string*, Open_tables_backup*, bool))[0x558c7ff1ebd8]
      sql/sql_show.cc:5099(get_all_tables(THD*, TABLE_LIST*, Item*))[0x558c7ff2118f]
      sql/sql_show.cc:8775(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x558c7ff50dd0]
      sql/sql_select.cc:4038(JOIN::exec_inner())[0x558c7fe4ce05]
      sql/sql_select.cc:3871(JOIN::exec())[0x558c7fe4b180]
      sql/sql_select.cc:4277(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x558c7fe4e50b]
      sql/sql_select.cc:382(handle_select(THD*, LEX*, select_result*, unsigned long))[0x558c7fe28c37]
      sql/sql_parse.cc:6546(execute_sqlcom_select(THD*, TABLE_LIST*))[0x558c7fdae861]
      sql/sql_parse.cc:3768(mysql_execute_command(THD*))[0x558c7fd9d074]
      sql/sql_parse.cc:8064(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558c7fdb6ca5]
      sql/sql_parse.cc:1849(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x558c7fd91dcb]
      sql/sql_parse.cc:1392(do_command(THD*))[0x558c7fd8ef63]
      sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x558c800df768]
      sql/sql_connect.cc:1309(handle_one_connection)[0x558c800df145]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fb7c04096ba]
      x86_64/clone.S:111(clone)[0x7fb7bf89e41d]
      

      See comments for further details.

      Attachments

        Issue Links

          Activity

            Please note that in the test case below the error upon trigger re-creation is already questionable. I just let it happen so that the test could hit further assertion failure which is unquestionable.

            CREATE TABLE t1 (a INT) ENGINE=MyISAM;
            CREATE TRIGGER tr AFTER UPDATE ON t1 FOR EACH ROW SET @x=1;
             
            CREATE TABLE t2 (b INT) ENGINE=MyISAM;
            CREATE ALGORITHM=MERGE VIEW v2 AS SELECT * FROM t2;
            LOCK TABLE v2 WRITE;
            --error ER_TRG_DOES_NOT_EXIST
            CREATE OR REPLACE TRIGGER tr BEFORE DELETE ON t2 FOR EACH ROW SET @x= 1;
            SHOW TABLE STATUS;
             
            # Cleanup
            UNLOCK TABLES;
            DROP VIEW v2;
            DROP TABLE t1, t2;
            

            10.1 d0116e10

            mysqld: /data/src/10.1/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
            190403 16:53:09 [ERROR] mysqld got signal 6 ;
             
            #7  0x00007fbb713bdee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
            #8  0x0000556e75564505 in test_if_reopen (filename=0x7fbb736542e0 "/dev/shm/var_auto_GdBe/mysqld.1/data/test/t2.MYI") at /data/src/10.1/storage/myisam/mi_open.c:66
            #9  0x0000556e7556471e in mi_open (name=0x7fbb68468360 "./test/t2", mode=2, open_flags=82) at /data/src/10.1/storage/myisam/mi_open.c:122
            #10 0x0000556e755384cd in ha_myisam::open (this=0x7fbb684b2088, name=0x7fbb68468360 "./test/t2", mode=2, test_if_locked=18) at /data/src/10.1/storage/myisam/ha_myisam.cc:754
            #11 0x0000556e75270cb8 in handler::ha_open (this=0x7fbb684b2088, table_arg=0x7fbb68483870, name=0x7fbb68468360 "./test/t2", mode=2, test_if_locked=18) at /data/src/10.1/sql/handler.cc:2534
            #12 0x0000556e7511eadc in open_table_from_share (thd=0x7fbb6a0d5070, share=0x7fbb68467e88, alias=0x7fbb6855ee68 "t2", db_stat=39, prgflag=44, ha_open_flags=18, outparam=0x7fbb68483870, is_create_table=false) at /data/src/10.1/sql/table.cc:2975
            #13 0x0000556e74fc2373 in open_table (thd=0x7fbb6a0d5070, table_list=0x7fbb6855ee70, ot_ctx=0x7fbb73655f80) at /data/src/10.1/sql/sql_base.cc:2585
            #14 0x0000556e74fc4c6f in open_and_process_table (thd=0x7fbb6a0d5070, lex=0x7fbb736561f0, tables=0x7fbb6855ee70, counter=0x7fbb7365604c, flags=1282, prelocking_strategy=0x7fbb73656050, has_prelocking_list=false, ot_ctx=0x7fbb73655f80) at /data/src/10.1/sql/sql_base.cc:4124
            #15 0x0000556e74fc5d0f in open_tables (thd=0x7fbb6a0d5070, options=..., start=0x7fbb73656030, counter=0x7fbb7365604c, flags=1282, prelocking_strategy=0x7fbb73656050) at /data/src/10.1/sql/sql_base.cc:4639
            #16 0x0000556e74fbd52a in open_tables (thd=0x7fbb6a0d5070, tables=0x7fbb73656030, counter=0x7fbb7365604c, flags=1282, prelocking_strategy=0x7fbb73656050) at /data/src/10.1/sql/sql_base.h:261
            #17 0x0000556e74fc760c in open_normal_and_derived_tables (thd=0x7fbb6a0d5070, tables=0x7fbb6855ee70, flags=1282, dt_phases=34) at /data/src/10.1/sql/sql_base.cc:5448
            #18 0x0000556e750bd74d in fill_schema_table_by_open (thd=0x7fbb6a0d5070, is_show_fields_or_keys=false, table=0x7fbb68501088, schema_table=0x556e7612f040 <schema_tables+1920>, orig_db_name=0x7fbb684487b8, orig_table_name=0x7fbb68448fe0, open_tables_state_backup=0x7fbb73657800, can_deadlock=true) at /data/src/10.1/sql/sql_show.cc:4282
            #19 0x0000556e750bee89 in get_all_tables (thd=0x7fbb6a0d5070, tables=0x7fbb68444880, cond=0x0) at /data/src/10.1/sql/sql_show.cc:4920
            #20 0x0000556e750cddc4 in get_schema_tables_result (join=0x7fbb68446900, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.1/sql/sql_show.cc:8278
            #21 0x0000556e7506d002 in JOIN::exec_inner (this=0x7fbb68446900) at /data/src/10.1/sql/sql_select.cc:2714
            #22 0x0000556e7506c6a9 in JOIN::exec (this=0x7fbb68446900) at /data/src/10.1/sql/sql_select.cc:2562
            #23 0x0000556e7506fc3f in mysql_select (thd=0x7fbb6a0d5070, rref_pointer_array=0x7fbb6a0d9560, tables=0x7fbb68444880, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2686716672, result=0x7fbb684468e0, unit=0x7fbb6a0d8bb8, select_lex=0x7fbb6a0d92b8) at /data/src/10.1/sql/sql_select.cc:3499
            #24 0x0000556e750652f8 in handle_select (thd=0x7fbb6a0d5070, lex=0x7fbb6a0d8af0, result=0x7fbb684468e0, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:388
            #25 0x0000556e75034cf3 in execute_sqlcom_select (thd=0x7fbb6a0d5070, all_tables=0x7fbb68444880) at /data/src/10.1/sql/sql_parse.cc:5945
            #26 0x0000556e7502b375 in mysql_execute_command (thd=0x7fbb6a0d5070) at /data/src/10.1/sql/sql_parse.cc:3042
            #27 0x0000556e75038937 in mysql_parse (thd=0x7fbb6a0d5070, rawbuf=0x7fbb68443088 "SHOW TABLE STATUS", length=17, parser_state=0x7fbb736591e0) at /data/src/10.1/sql/sql_parse.cc:7463
            #28 0x0000556e75027305 in dispatch_command (command=COM_QUERY, thd=0x7fbb6a0d5070, packet=0x7fbb6cbf9071 "SHOW TABLE STATUS", packet_length=17) at /data/src/10.1/sql/sql_parse.cc:1499
            #29 0x0000556e75026090 in do_command (thd=0x7fbb6a0d5070) at /data/src/10.1/sql/sql_parse.cc:1131
            #30 0x0000556e75161301 in do_handle_one_connection (thd_arg=0x7fbb6a0d5070) at /data/src/10.1/sql/sql_connect.cc:1330
            #31 0x0000556e75161065 in handle_one_connection (arg=0x7fbb6a0d5070) at /data/src/10.1/sql/sql_connect.cc:1242
            #32 0x0000556e7551fb14 in pfs_spawn_thread (arg=0x7fbb70839ef0) at /data/src/10.1/storage/perfschema/pfs.cc:1861
            #33 0x00007fbb732d9494 in start_thread (arg=0x7fbb7365a700) at pthread_create.c:333
            #34 0x00007fbb7147a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            

            elenst Elena Stepanova added a comment - Please note that in the test case below the error upon trigger re-creation is already questionable. I just let it happen so that the test could hit further assertion failure which is unquestionable. CREATE TABLE t1 (a INT ) ENGINE=MyISAM; CREATE TRIGGER tr AFTER UPDATE ON t1 FOR EACH ROW SET @x=1;   CREATE TABLE t2 (b INT ) ENGINE=MyISAM; CREATE ALGORITHM=MERGE VIEW v2 AS SELECT * FROM t2; LOCK TABLE v2 WRITE; --error ER_TRG_DOES_NOT_EXIST CREATE OR REPLACE TRIGGER tr BEFORE DELETE ON t2 FOR EACH ROW SET @x= 1; SHOW TABLE STATUS;   # Cleanup UNLOCK TABLES; DROP VIEW v2; DROP TABLE t1, t2; 10.1 d0116e10 mysqld: /data/src/10.1/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed. 190403 16:53:09 [ERROR] mysqld got signal 6 ;   #7 0x00007fbb713bdee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x0000556e75564505 in test_if_reopen (filename=0x7fbb736542e0 "/dev/shm/var_auto_GdBe/mysqld.1/data/test/t2.MYI") at /data/src/10.1/storage/myisam/mi_open.c:66 #9 0x0000556e7556471e in mi_open (name=0x7fbb68468360 "./test/t2", mode=2, open_flags=82) at /data/src/10.1/storage/myisam/mi_open.c:122 #10 0x0000556e755384cd in ha_myisam::open (this=0x7fbb684b2088, name=0x7fbb68468360 "./test/t2", mode=2, test_if_locked=18) at /data/src/10.1/storage/myisam/ha_myisam.cc:754 #11 0x0000556e75270cb8 in handler::ha_open (this=0x7fbb684b2088, table_arg=0x7fbb68483870, name=0x7fbb68468360 "./test/t2", mode=2, test_if_locked=18) at /data/src/10.1/sql/handler.cc:2534 #12 0x0000556e7511eadc in open_table_from_share (thd=0x7fbb6a0d5070, share=0x7fbb68467e88, alias=0x7fbb6855ee68 "t2", db_stat=39, prgflag=44, ha_open_flags=18, outparam=0x7fbb68483870, is_create_table=false) at /data/src/10.1/sql/table.cc:2975 #13 0x0000556e74fc2373 in open_table (thd=0x7fbb6a0d5070, table_list=0x7fbb6855ee70, ot_ctx=0x7fbb73655f80) at /data/src/10.1/sql/sql_base.cc:2585 #14 0x0000556e74fc4c6f in open_and_process_table (thd=0x7fbb6a0d5070, lex=0x7fbb736561f0, tables=0x7fbb6855ee70, counter=0x7fbb7365604c, flags=1282, prelocking_strategy=0x7fbb73656050, has_prelocking_list=false, ot_ctx=0x7fbb73655f80) at /data/src/10.1/sql/sql_base.cc:4124 #15 0x0000556e74fc5d0f in open_tables (thd=0x7fbb6a0d5070, options=..., start=0x7fbb73656030, counter=0x7fbb7365604c, flags=1282, prelocking_strategy=0x7fbb73656050) at /data/src/10.1/sql/sql_base.cc:4639 #16 0x0000556e74fbd52a in open_tables (thd=0x7fbb6a0d5070, tables=0x7fbb73656030, counter=0x7fbb7365604c, flags=1282, prelocking_strategy=0x7fbb73656050) at /data/src/10.1/sql/sql_base.h:261 #17 0x0000556e74fc760c in open_normal_and_derived_tables (thd=0x7fbb6a0d5070, tables=0x7fbb6855ee70, flags=1282, dt_phases=34) at /data/src/10.1/sql/sql_base.cc:5448 #18 0x0000556e750bd74d in fill_schema_table_by_open (thd=0x7fbb6a0d5070, is_show_fields_or_keys=false, table=0x7fbb68501088, schema_table=0x556e7612f040 <schema_tables+1920>, orig_db_name=0x7fbb684487b8, orig_table_name=0x7fbb68448fe0, open_tables_state_backup=0x7fbb73657800, can_deadlock=true) at /data/src/10.1/sql/sql_show.cc:4282 #19 0x0000556e750bee89 in get_all_tables (thd=0x7fbb6a0d5070, tables=0x7fbb68444880, cond=0x0) at /data/src/10.1/sql/sql_show.cc:4920 #20 0x0000556e750cddc4 in get_schema_tables_result (join=0x7fbb68446900, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.1/sql/sql_show.cc:8278 #21 0x0000556e7506d002 in JOIN::exec_inner (this=0x7fbb68446900) at /data/src/10.1/sql/sql_select.cc:2714 #22 0x0000556e7506c6a9 in JOIN::exec (this=0x7fbb68446900) at /data/src/10.1/sql/sql_select.cc:2562 #23 0x0000556e7506fc3f in mysql_select (thd=0x7fbb6a0d5070, rref_pointer_array=0x7fbb6a0d9560, tables=0x7fbb68444880, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2686716672, result=0x7fbb684468e0, unit=0x7fbb6a0d8bb8, select_lex=0x7fbb6a0d92b8) at /data/src/10.1/sql/sql_select.cc:3499 #24 0x0000556e750652f8 in handle_select (thd=0x7fbb6a0d5070, lex=0x7fbb6a0d8af0, result=0x7fbb684468e0, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:388 #25 0x0000556e75034cf3 in execute_sqlcom_select (thd=0x7fbb6a0d5070, all_tables=0x7fbb68444880) at /data/src/10.1/sql/sql_parse.cc:5945 #26 0x0000556e7502b375 in mysql_execute_command (thd=0x7fbb6a0d5070) at /data/src/10.1/sql/sql_parse.cc:3042 #27 0x0000556e75038937 in mysql_parse (thd=0x7fbb6a0d5070, rawbuf=0x7fbb68443088 "SHOW TABLE STATUS", length=17, parser_state=0x7fbb736591e0) at /data/src/10.1/sql/sql_parse.cc:7463 #28 0x0000556e75027305 in dispatch_command (command=COM_QUERY, thd=0x7fbb6a0d5070, packet=0x7fbb6cbf9071 "SHOW TABLE STATUS", packet_length=17) at /data/src/10.1/sql/sql_parse.cc:1499 #29 0x0000556e75026090 in do_command (thd=0x7fbb6a0d5070) at /data/src/10.1/sql/sql_parse.cc:1131 #30 0x0000556e75161301 in do_handle_one_connection (thd_arg=0x7fbb6a0d5070) at /data/src/10.1/sql/sql_connect.cc:1330 #31 0x0000556e75161065 in handle_one_connection (arg=0x7fbb6a0d5070) at /data/src/10.1/sql/sql_connect.cc:1242 #32 0x0000556e7551fb14 in pfs_spawn_thread (arg=0x7fbb70839ef0) at /data/src/10.1/storage/perfschema/pfs.cc:1861 #33 0x00007fbb732d9494 in start_thread (arg=0x7fbb7365a700) at pthread_create.c:333 #34 0x00007fbb7147a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

            Here is another test case, which doesn't involve triggers or views:

            CREATE TABLE t1 (a INT) ENGINE=MyISAM;
            LOCK TABLE t1 WRITE;
            --error ER_BAD_FIELD_ERROR
            ALTER TABLE t1 ADD b INT, LOCK=EXCLUSIVE, ORDER BY x;
            SHOW TABLE STATUS;
             
            # Cleanup
            UNLOCK TABLES;
            DROP TABLE t1;
            

            10.1 15f06559

            mysqld: /data/src/10.1/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
            190505  1:06:22 [ERROR] mysqld got signal 6 ;
             
            #6  0x00007fd2d3447e67 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5620de65d458 "strcmp(share->unique_file_name,filename) || share->last_version", file=file@entry=0x5620de65d430 "/data/src/10.1/storage/myisam/mi_open.c", line=line@entry=67, function=function@entry=0x5620de65d6b8 <__PRETTY_FUNCTION__.13726> "test_if_reopen") at assert.c:92
            #7  0x00007fd2d3447f12 in __GI___assert_fail (assertion=0x5620de65d458 "strcmp(share->unique_file_name,filename) || share->last_version", file=0x5620de65d430 "/data/src/10.1/storage/myisam/mi_open.c", line=67, function=0x5620de65d6b8 <__PRETTY_FUNCTION__.13726> "test_if_reopen") at assert.c:101
            #8  0x00005620de09d9c7 in test_if_reopen (filename=0x7fd2d4e6c2a0 "/data/bld/10.1-debug/mysql-test/var/mysqld.1/data/test/t1.MYI") at /data/src/10.1/storage/myisam/mi_open.c:66
            #9  0x00005620de09dbe0 in mi_open (name=0x7fd2ca865d60 "./test/t1", mode=2, open_flags=82) at /data/src/10.1/storage/myisam/mi_open.c:122
            #10 0x00005620de0717f7 in ha_myisam::open (this=0x7fd2ca8ae888, name=0x7fd2ca865d60 "./test/t1", mode=2, test_if_locked=18) at /data/src/10.1/storage/myisam/ha_myisam.cc:754
            #11 0x00005620dddeb874 in handler::ha_open (this=0x7fd2ca8ae888, table_arg=0x7fd2ca880a70, name=0x7fd2ca865d60 "./test/t1", mode=2, test_if_locked=18) at /data/src/10.1/sql/handler.cc:2535
            #12 0x00005620ddc99146 in open_table_from_share (thd=0x7fd2cc7cd070, share=0x7fd2ca865888, alias=0x7fd2ca8fff60 "t1", db_stat=39, prgflag=44, ha_open_flags=18, outparam=0x7fd2ca880a70, is_create_table=false) at /data/src/10.1/sql/table.cc:2975
            #13 0x00005620ddb3c580 in open_table (thd=0x7fd2cc7cd070, table_list=0x7fd2ca9de270, ot_ctx=0x7fd2d4e6df40) at /data/src/10.1/sql/sql_base.cc:2585
            #14 0x00005620ddb3efab in open_and_process_table (thd=0x7fd2cc7cd070, tables=0x7fd2ca9de270, counter=0x7fd2d4e6e054, flags=1282, prelocking_strategy=0x7fd2d4e6e058, has_prelocking_list=false, ot_ctx=0x7fd2d4e6df40) at /data/src/10.1/sql/sql_base.cc:4162
            #15 0x00005620ddb3ffb9 in open_tables (thd=0x7fd2cc7cd070, options=..., start=0x7fd2d4e6e040, counter=0x7fd2d4e6e054, sroutine_to_open_list=0x7fd2d4e6e288, flags=1282, prelocking_strategy=0x7fd2d4e6e058) at /data/src/10.1/sql/sql_base.cc:4648
            #16 0x00005620ddb376f2 in open_tables (thd=0x7fd2cc7cd070, options=..., tables=0x7fd2d4e6e040, counter=0x7fd2d4e6e054, flags=1282, prelocking_strategy=0x7fd2d4e6e058) at /data/src/10.1/sql/sql_base.h:264
            #17 0x00005620ddb37743 in open_tables (thd=0x7fd2cc7cd070, tables=0x7fd2d4e6e040, counter=0x7fd2d4e6e054, flags=1282, prelocking_strategy=0x7fd2d4e6e058) at /data/src/10.1/sql/sql_base.h:272
            #18 0x00005620ddb4187d in open_normal_and_derived_tables (thd=0x7fd2cc7cd070, tables=0x7fd2ca9de270, flags=1282, dt_phases=34) at /data/src/10.1/sql/sql_base.cc:5459
            #19 0x00005620ddc379d2 in fill_schema_table_by_open (thd=0x7fd2cc7cd070, is_show_fields_or_keys=false, table=0x7fd2ca9dc088, schema_table=0x5620ded019a0 <schema_tables+1920>, orig_db_name=0x7fd2ca8ff8d8, orig_table_name=0x7fd2ca8fff00, open_tables_state_backup=0x7fd2d4e6f800, can_deadlock=true) at /data/src/10.1/sql/sql_show.cc:4278
            #20 0x00005620ddc3915e in get_all_tables (thd=0x7fd2cc7cd070, tables=0x7fd2ca8fb880, cond=0x0) at /data/src/10.1/sql/sql_show.cc:4924
            #21 0x00005620ddc47efb in get_schema_tables_result (join=0x7fd2ca8fd900, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.1/sql/sql_show.cc:8280
            #22 0x00005620ddbe7600 in JOIN::exec_inner (this=0x7fd2ca8fd900) at /data/src/10.1/sql/sql_select.cc:2714
            #23 0x00005620ddbe6cab in JOIN::exec (this=0x7fd2ca8fd900) at /data/src/10.1/sql/sql_select.cc:2562
            #24 0x00005620ddbea239 in mysql_select (thd=0x7fd2cc7cd070, rref_pointer_array=0x7fd2cc7d1560, tables=0x7fd2ca8fb880, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2686716672, result=0x7fd2ca8fd8e0, unit=0x7fd2cc7d0bb8, select_lex=0x7fd2cc7d12b8) at /data/src/10.1/sql/sql_select.cc:3499
            #25 0x00005620ddbdf923 in handle_select (thd=0x7fd2cc7cd070, lex=0x7fd2cc7d0af0, result=0x7fd2ca8fd8e0, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:376
            #26 0x00005620ddbaf0f2 in execute_sqlcom_select (thd=0x7fd2cc7cd070, all_tables=0x7fd2ca8fb880) at /data/src/10.1/sql/sql_parse.cc:5951
            #27 0x00005620ddba5453 in mysql_execute_command (thd=0x7fd2cc7cd070) at /data/src/10.1/sql/sql_parse.cc:3038
            #28 0x00005620ddbb2d6b in mysql_parse (thd=0x7fd2cc7cd070, rawbuf=0x7fd2ca8fa088 "SHOW TABLE STATUS", length=17, parser_state=0x7fd2d4e711e0) at /data/src/10.1/sql/sql_parse.cc:7469
            #29 0x00005620ddba1465 in dispatch_command (command=COM_QUERY, thd=0x7fd2cc7cd070, packet=0x7fd2ce7f0071 "SHOW TABLE STATUS", packet_length=17) at /data/src/10.1/sql/sql_parse.cc:1499
            #30 0x00005620ddba0223 in do_command (thd=0x7fd2cc7cd070) at /data/src/10.1/sql/sql_parse.cc:1131
            #31 0x00005620ddcdb745 in do_handle_one_connection (thd_arg=0x7fd2cc7cd070) at /data/src/10.1/sql/sql_connect.cc:1330
            #32 0x00005620ddcdb48b in handle_one_connection (arg=0x7fd2cc7cd070) at /data/src/10.1/sql/sql_connect.cc:1242
            #33 0x00005620de10ea8c in pfs_spawn_thread (arg=0x7fd2d2c39c70) at /data/src/10.1/storage/perfschema/pfs.cc:1861
            #34 0x00007fd2d4aee4a4 in start_thread (arg=0x7fd2d4e72700) at pthread_create.c:456
            #35 0x00007fd2d3504d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
            

            elenst Elena Stepanova added a comment - Here is another test case, which doesn't involve triggers or views: CREATE TABLE t1 (a INT ) ENGINE=MyISAM; LOCK TABLE t1 WRITE; --error ER_BAD_FIELD_ERROR ALTER TABLE t1 ADD b INT , LOCK=EXCLUSIVE, ORDER BY x; SHOW TABLE STATUS;   # Cleanup UNLOCK TABLES; DROP TABLE t1; 10.1 15f06559 mysqld: /data/src/10.1/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed. 190505 1:06:22 [ERROR] mysqld got signal 6 ;   #6 0x00007fd2d3447e67 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5620de65d458 "strcmp(share->unique_file_name,filename) || share->last_version", file=file@entry=0x5620de65d430 "/data/src/10.1/storage/myisam/mi_open.c", line=line@entry=67, function=function@entry=0x5620de65d6b8 <__PRETTY_FUNCTION__.13726> "test_if_reopen") at assert.c:92 #7 0x00007fd2d3447f12 in __GI___assert_fail (assertion=0x5620de65d458 "strcmp(share->unique_file_name,filename) || share->last_version", file=0x5620de65d430 "/data/src/10.1/storage/myisam/mi_open.c", line=67, function=0x5620de65d6b8 <__PRETTY_FUNCTION__.13726> "test_if_reopen") at assert.c:101 #8 0x00005620de09d9c7 in test_if_reopen (filename=0x7fd2d4e6c2a0 "/data/bld/10.1-debug/mysql-test/var/mysqld.1/data/test/t1.MYI") at /data/src/10.1/storage/myisam/mi_open.c:66 #9 0x00005620de09dbe0 in mi_open (name=0x7fd2ca865d60 "./test/t1", mode=2, open_flags=82) at /data/src/10.1/storage/myisam/mi_open.c:122 #10 0x00005620de0717f7 in ha_myisam::open (this=0x7fd2ca8ae888, name=0x7fd2ca865d60 "./test/t1", mode=2, test_if_locked=18) at /data/src/10.1/storage/myisam/ha_myisam.cc:754 #11 0x00005620dddeb874 in handler::ha_open (this=0x7fd2ca8ae888, table_arg=0x7fd2ca880a70, name=0x7fd2ca865d60 "./test/t1", mode=2, test_if_locked=18) at /data/src/10.1/sql/handler.cc:2535 #12 0x00005620ddc99146 in open_table_from_share (thd=0x7fd2cc7cd070, share=0x7fd2ca865888, alias=0x7fd2ca8fff60 "t1", db_stat=39, prgflag=44, ha_open_flags=18, outparam=0x7fd2ca880a70, is_create_table=false) at /data/src/10.1/sql/table.cc:2975 #13 0x00005620ddb3c580 in open_table (thd=0x7fd2cc7cd070, table_list=0x7fd2ca9de270, ot_ctx=0x7fd2d4e6df40) at /data/src/10.1/sql/sql_base.cc:2585 #14 0x00005620ddb3efab in open_and_process_table (thd=0x7fd2cc7cd070, tables=0x7fd2ca9de270, counter=0x7fd2d4e6e054, flags=1282, prelocking_strategy=0x7fd2d4e6e058, has_prelocking_list=false, ot_ctx=0x7fd2d4e6df40) at /data/src/10.1/sql/sql_base.cc:4162 #15 0x00005620ddb3ffb9 in open_tables (thd=0x7fd2cc7cd070, options=..., start=0x7fd2d4e6e040, counter=0x7fd2d4e6e054, sroutine_to_open_list=0x7fd2d4e6e288, flags=1282, prelocking_strategy=0x7fd2d4e6e058) at /data/src/10.1/sql/sql_base.cc:4648 #16 0x00005620ddb376f2 in open_tables (thd=0x7fd2cc7cd070, options=..., tables=0x7fd2d4e6e040, counter=0x7fd2d4e6e054, flags=1282, prelocking_strategy=0x7fd2d4e6e058) at /data/src/10.1/sql/sql_base.h:264 #17 0x00005620ddb37743 in open_tables (thd=0x7fd2cc7cd070, tables=0x7fd2d4e6e040, counter=0x7fd2d4e6e054, flags=1282, prelocking_strategy=0x7fd2d4e6e058) at /data/src/10.1/sql/sql_base.h:272 #18 0x00005620ddb4187d in open_normal_and_derived_tables (thd=0x7fd2cc7cd070, tables=0x7fd2ca9de270, flags=1282, dt_phases=34) at /data/src/10.1/sql/sql_base.cc:5459 #19 0x00005620ddc379d2 in fill_schema_table_by_open (thd=0x7fd2cc7cd070, is_show_fields_or_keys=false, table=0x7fd2ca9dc088, schema_table=0x5620ded019a0 <schema_tables+1920>, orig_db_name=0x7fd2ca8ff8d8, orig_table_name=0x7fd2ca8fff00, open_tables_state_backup=0x7fd2d4e6f800, can_deadlock=true) at /data/src/10.1/sql/sql_show.cc:4278 #20 0x00005620ddc3915e in get_all_tables (thd=0x7fd2cc7cd070, tables=0x7fd2ca8fb880, cond=0x0) at /data/src/10.1/sql/sql_show.cc:4924 #21 0x00005620ddc47efb in get_schema_tables_result (join=0x7fd2ca8fd900, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.1/sql/sql_show.cc:8280 #22 0x00005620ddbe7600 in JOIN::exec_inner (this=0x7fd2ca8fd900) at /data/src/10.1/sql/sql_select.cc:2714 #23 0x00005620ddbe6cab in JOIN::exec (this=0x7fd2ca8fd900) at /data/src/10.1/sql/sql_select.cc:2562 #24 0x00005620ddbea239 in mysql_select (thd=0x7fd2cc7cd070, rref_pointer_array=0x7fd2cc7d1560, tables=0x7fd2ca8fb880, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2686716672, result=0x7fd2ca8fd8e0, unit=0x7fd2cc7d0bb8, select_lex=0x7fd2cc7d12b8) at /data/src/10.1/sql/sql_select.cc:3499 #25 0x00005620ddbdf923 in handle_select (thd=0x7fd2cc7cd070, lex=0x7fd2cc7d0af0, result=0x7fd2ca8fd8e0, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:376 #26 0x00005620ddbaf0f2 in execute_sqlcom_select (thd=0x7fd2cc7cd070, all_tables=0x7fd2ca8fb880) at /data/src/10.1/sql/sql_parse.cc:5951 #27 0x00005620ddba5453 in mysql_execute_command (thd=0x7fd2cc7cd070) at /data/src/10.1/sql/sql_parse.cc:3038 #28 0x00005620ddbb2d6b in mysql_parse (thd=0x7fd2cc7cd070, rawbuf=0x7fd2ca8fa088 "SHOW TABLE STATUS", length=17, parser_state=0x7fd2d4e711e0) at /data/src/10.1/sql/sql_parse.cc:7469 #29 0x00005620ddba1465 in dispatch_command (command=COM_QUERY, thd=0x7fd2cc7cd070, packet=0x7fd2ce7f0071 "SHOW TABLE STATUS", packet_length=17) at /data/src/10.1/sql/sql_parse.cc:1499 #30 0x00005620ddba0223 in do_command (thd=0x7fd2cc7cd070) at /data/src/10.1/sql/sql_parse.cc:1131 #31 0x00005620ddcdb745 in do_handle_one_connection (thd_arg=0x7fd2cc7cd070) at /data/src/10.1/sql/sql_connect.cc:1330 #32 0x00005620ddcdb48b in handle_one_connection (arg=0x7fd2cc7cd070) at /data/src/10.1/sql/sql_connect.cc:1242 #33 0x00005620de10ea8c in pfs_spawn_thread (arg=0x7fd2d2c39c70) at /data/src/10.1/storage/perfschema/pfs.cc:1861 #34 0x00007fd2d4aee4a4 in start_thread (arg=0x7fd2d4e72700) at pthread_create.c:456 #35 0x00007fd2d3504d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
            alice Alice Sherepa added a comment -

            I am getting the same assertion with BACKUP STAGE BLOCK_COMMIT on 10.5:

            10.5 05fa4558e0e82302ece981dea

            mysqld: /10.5/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
            200731 16:10:30 [ERROR] mysqld got signal 6 ;
             
            myisam/mi_open.c:68(test_if_reopen)[0x55750d023bd8]
            myisam/mi_open.c:122(mi_open)[0x55750cfa325d]
            myisam/ha_myisam.cc:807(ha_myisam::open(char const*, int, unsigned int))[0x55750bc0557c]
            sql/handler.cc:2977(handler::ha_open(TABLE*, char const*, int, unsigned int, st_mem_root*, List<String>*))[0x55750b7682f0]
            sql/table.cc:4196(open_table_from_share(THD*, TABLE_SHARE*, st_mysql_const_lex_string const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, List<String>*))[0x55750b286728]
            sql/sql_base.cc:607(flush_tables(THD*, flush_tables_type))[0x55750ba615f0]
            sql/backup.cc:257(backup_block_ddl(THD*))[0x55750ba609f3]
            sql/backup.cc:113(run_backup_stage(THD*, backup_stages))[0x55750b431c1c]
            sql/sql_parse.cc:5109(mysql_execute_command(THD*))[0x55750b4453af]
            sql/sql_parse.cc:7993(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55750b41be4a]
            sql/sql_parse.cc:1869(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55750b4186c8]
            sql/sql_parse.cc:1347(do_command(THD*))[0x55750b846aba]
            sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x55750b846413]
            sql/sql_connect.cc:1314(handle_one_connection)[0x55750c50aee7]
            nptl/pthread_create.c:463(start_thread)[0x7f811ae6a6db]
            x86_64/clone.S:97(clone)[0x7f811a050a3f]
             
            Query (0x62b0000e72a8): BACKUP STAGE BLOCK_COMMIT
            

            alice Alice Sherepa added a comment - I am getting the same assertion with BACKUP STAGE BLOCK_COMMIT on 10.5: 10.5 05fa4558e0e82302ece981dea mysqld: /10.5/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed. 200731 16:10:30 [ERROR] mysqld got signal 6 ;   myisam/mi_open.c:68(test_if_reopen)[0x55750d023bd8] myisam/mi_open.c:122(mi_open)[0x55750cfa325d] myisam/ha_myisam.cc:807(ha_myisam::open(char const*, int, unsigned int))[0x55750bc0557c] sql/handler.cc:2977(handler::ha_open(TABLE*, char const*, int, unsigned int, st_mem_root*, List<String>*))[0x55750b7682f0] sql/table.cc:4196(open_table_from_share(THD*, TABLE_SHARE*, st_mysql_const_lex_string const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, List<String>*))[0x55750b286728] sql/sql_base.cc:607(flush_tables(THD*, flush_tables_type))[0x55750ba615f0] sql/backup.cc:257(backup_block_ddl(THD*))[0x55750ba609f3] sql/backup.cc:113(run_backup_stage(THD*, backup_stages))[0x55750b431c1c] sql/sql_parse.cc:5109(mysql_execute_command(THD*))[0x55750b4453af] sql/sql_parse.cc:7993(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55750b41be4a] sql/sql_parse.cc:1869(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55750b4186c8] sql/sql_parse.cc:1347(do_command(THD*))[0x55750b846aba] sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x55750b846413] sql/sql_connect.cc:1314(handle_one_connection)[0x55750c50aee7] nptl/pthread_create.c:463(start_thread)[0x7f811ae6a6db] x86_64/clone.S:97(clone)[0x7f811a050a3f]   Query (0x62b0000e72a8): BACKUP STAGE BLOCK_COMMIT

            USE test;
            SET SQL_MODE='';
            CREATE TABLE t (a INT PRIMARY KEY) ENGINE=MyISAM;
            LOCK TABLE t WRITE;
            CREATE TRIGGER t AFTER DELETE ON t FOR EACH ROW SET @log:= concat(@log, "(AFTER_DELETE: old=(id=", old.id, ", data=", old.data,"))");
            SHOW TABLE STATUS LIKE 't';
            

            Leads to:

            10.4.15 eae968f62d285de97ed607c87bc131cd863d5d03 (Debug)

            mysqld: /test/10.4_dbg/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
            

            10.4.15 eae968f62d285de97ed607c87bc131cd863d5d03 (Debug)

            Core was generated by `/test/MD110820-mariadb-10.4.15-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.
            Program terminated with signal SIGABRT, Aborted.
            #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
                at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
            [Current thread is 1 (Thread 0x14866ece1700 (LWP 1231945))]
            (gdb) bt
            #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
            #1  0x00005625e4a3c8a6 in my_write_core (sig=sig@entry=6) at /test/10.4_dbg/mysys/stacktrace.c:482
            #2  0x00005625e41b8cdc in handle_fatal_signal (sig=6) at /test/10.4_dbg/sql/signal_handler.cc:343
            #3  <signal handler called>
            #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
            #5  0x000014866cf788b1 in __GI_abort () at abort.c:79
            #6  0x000014866cf6842a in __assert_fail_base (fmt=0x14866d0efa38 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5625e4e1a070 "strcmp(share->unique_file_name,filename) || share->last_version", file=file@entry=0x5625e4e1a048 "/test/10.4_dbg/storage/myisam/mi_open.c", line=line@entry=67, function=function@entry=0x5625e4e1a170 <__PRETTY_FUNCTION__.17079> "test_if_reopen") at assert.c:92
            #7  0x000014866cf684a2 in __GI___assert_fail (assertion=assertion@entry=0x5625e4e1a070 "strcmp(share->unique_file_name,filename) || share->last_version", file=file@entry=0x5625e4e1a048 "/test/10.4_dbg/storage/myisam/mi_open.c", line=line@entry=67, function=function@entry=0x5625e4e1a170 <__PRETTY_FUNCTION__.17079> "test_if_reopen") at assert.c:101
            #8  0x00005625e48f7de0 in test_if_reopen (filename=filename@entry=0x14866ecd7a80 "/test/MD110820-mariadb-10.4.15-linux-x86_64-dbg/data/test/t.MYI") at /test/10.4_dbg/storage/myisam/mi_open.c:66
            #9  0x00005625e48fa614 in mi_open (name=0x148647cbbc18 "./test/t", mode=2, open_flags=open_flags@entry=82) at /test/10.4_dbg/storage/myisam/mi_open.c:122
            #10 0x00005625e48d6847 in ha_myisam::open (this=0x148647c7a888, name=<optimized out>, mode=<optimized out>, test_if_locked=18) at /test/10.4_dbg/storage/myisam/ha_myisam.cc:807
            #11 0x00005625e41c0104 in handler::ha_open (this=0x148647c7a888, table_arg=table_arg@entry=0x148647d2f070, name=0x148647cbbc18 "./test/t", mode=mode@entry=2, test_if_locked=test_if_locked@entry=18, mem_root=mem_root@entry=0x0, partitions_to_open=0x0) at /test/10.4_dbg/sql/handler.cc:2782
            #12 0x00005625e4004d39 in open_table_from_share (thd=thd@entry=0x148647c15070, share=share@entry=0x148647cbb688, alias=alias@entry=0x148647d26110, db_stat=db_stat@entry=33, prgflag=prgflag@entry=8, ha_open_flags=18, outparam=<optimized out>, is_create_table=<optimized out>, partitions_to_open=<optimized out>) at /test/10.4_dbg/sql/table.cc:3981
            #13 0x00005625e3e84a04 in open_table (thd=thd@entry=0x148647c15070, table_list=table_list@entry=0x148647d260c8, ot_ctx=ot_ctx@entry=0x14866ecd9bf0) at /test/10.4_dbg/sql/sql_base.cc:2083
            #14 0x00005625e3e89070 in open_and_process_table (ot_ctx=0x14866ecd9bf0, has_prelocking_list=false, prelocking_strategy=0x14866ecd9c88, flags=1346, counter=0x14866ecd9c84, tables=0x148647d260c8, thd=0x148647c15070) at /test/10.4_dbg/sql/sql_base.cc:3893
            #15 open_tables (thd=thd@entry=0x148647c15070, options=@0x14866ecdb3c8: {m_options = DDL_options_st::OPT_NONE}, start=start@entry=0x14866ecd9c78, counter=counter@entry=0x14866ecd9c84, flags=flags@entry=1346, prelocking_strategy=prelocking_strategy@entry=0x14866ecd9c88) at /test/10.4_dbg/sql/sql_base.cc:4365
            #16 0x00005625e3e8a54a in open_tables (prelocking_strategy=0x14866ecd9c88, flags=1346, counter=0x14866ecd9c84, tables=0x14866ecd9c78, thd=0x148647c15070) at /test/10.4_dbg/sql/sql_base.h:258
            #17 open_normal_and_derived_tables (thd=thd@entry=0x148647c15070, tables=<optimized out>, tables@entry=0x148647d260c8, flags=1346, dt_phases=dt_phases@entry=35) at /test/10.4_dbg/sql/sql_base.cc:5332
            #18 0x00005625e3e8a702 in open_tables_only_view_structure (thd=thd@entry=0x148647c15070, table_list=table_list@entry=0x148647d260c8, can_deadlock=can_deadlock@entry=true) at /test/10.4_dbg/sql/sql_base.cc:5383
            #19 0x00005625e3f8b30a in fill_schema_table_by_open (thd=thd@entry=0x148647c15070, mem_root=mem_root@entry=0x14866ecdbb00, is_show_fields_or_keys=is_show_fields_or_keys@entry=false, table=table@entry=0x148647cf9088, schema_table=schema_table@entry=0x5625e55d3e20 <schema_tables+2048>, orig_db_name=orig_db_name@entry=0x148647c73000, orig_table_name=0x148647d21fc8, open_tables_state_backup=0x14866ecdbb50, can_deadlock=true) at /test/10.4_dbg/sql/sql_show.cc:4669
            #20 0x00005625e3fa0eec in get_all_tables (thd=0x148647c15070, tables=0x148647c6edb0, cond=<optimized out>) at /test/10.4_dbg/sql/sql_show.cc:5307
            #21 0x00005625e3fa2d63 in get_schema_tables_result (join=join@entry=0x148647c711e8, executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at /test/10.4_dbg/sql/sql_show.cc:8949
            #22 0x00005625e3f826dd in JOIN::exec_inner (this=this@entry=0x148647c711e8) at /test/10.4_dbg/sql/sql_select.cc:4430
            #23 0x00005625e3f8304d in JOIN::exec (this=this@entry=0x148647c711e8) at /test/10.4_dbg/sql/sql_select.cc:4255
            #24 0x00005625e3f813f3 in mysql_select (thd=thd@entry=0x148647c15070, tables=<optimized out>, wild_num=0, fields=@0x148647c198d8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x148647c6d6f8, last = 0x148647c6ed70, elements = 20}, <No data fields>}, conds=0x0, og_num=<optimized out>, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2686716672, result=0x148647c711c0, unit=0x148647c18f98, select_lex=0x148647c19790) at /test/10.4_dbg/sql/sql_select.cc:4687
            #25 0x00005625e3f8171e in handle_select (thd=thd@entry=0x148647c15070, lex=lex@entry=0x148647c18ed8, result=result@entry=0x148647c711c0, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.4_dbg/sql/sql_select.cc:410
            #26 0x00005625e3efa3c6 in execute_sqlcom_select (thd=thd@entry=0x148647c15070, all_tables=0x148647c6edb0) at /test/10.4_dbg/sql/sql_parse.cc:6355
            #27 0x00005625e3f0579a in mysql_execute_command (thd=thd@entry=0x148647c15070) at /test/10.4_dbg/sql/sql_parse.cc:3889
            #28 0x00005625e3f10090 in mysql_parse (thd=thd@entry=0x148647c15070, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14866ece0460, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:7896
            #29 0x00005625e3f12920 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x148647c15070, packet=packet@entry=0x148647c57071 "SHOW TABLE STATUS LIKE 't'", packet_length=packet_length@entry=26, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:1834
            #30 0x00005625e3f1635b in do_command (thd=0x148647c15070) at /test/10.4_dbg/sql/sql_parse.cc:1352
            #31 0x00005625e40428b6 in do_handle_one_connection (connect=connect@entry=0x14866b835790) at /test/10.4_dbg/sql/sql_connect.cc:1412
            #32 0x00005625e40429d6 in handle_one_connection (arg=0x14866b835790) at /test/10.4_dbg/sql/sql_connect.cc:1316
            #33 0x000014866dedf6db in start_thread (arg=0x14866ece1700) at pthread_create.c:463
            #34 0x000014866d059a3f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
            

            Bug confirmed present in:
            MariaDB: 10.1.47 (dbg), 10.2.34 (dbg), 10.3.25 (dbg), 10.4.15 (dbg)

            Bug confirmed not present in:
            MariaDB: 10.1.47 (opt), 10.2.34 (opt), 10.3.25 (opt), 10.4.15 (opt), 10.5.6 (dbg), 10.5.6 (opt)
            MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)

            Roel Roel Van de Paar added a comment - USE test; SET SQL_MODE=''; CREATE TABLE t (a INT PRIMARY KEY) ENGINE=MyISAM; LOCK TABLE t WRITE; CREATE TRIGGER t AFTER DELETE ON t FOR EACH ROW SET @log:= concat(@log, "(AFTER_DELETE: old=(id=", old.id, ", data=", old.data,"))"); SHOW TABLE STATUS LIKE 't'; Leads to: 10.4.15 eae968f62d285de97ed607c87bc131cd863d5d03 (Debug) mysqld: /test/10.4_dbg/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed. 10.4.15 eae968f62d285de97ed607c87bc131cd863d5d03 (Debug) Core was generated by `/test/MD110820-mariadb-10.4.15-linux-x86_64-dbg/bin/mysqld --no-defaults --core'. Program terminated with signal SIGABRT, Aborted. #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 [Current thread is 1 (Thread 0x14866ece1700 (LWP 1231945))] (gdb) bt #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 #1 0x00005625e4a3c8a6 in my_write_core (sig=sig@entry=6) at /test/10.4_dbg/mysys/stacktrace.c:482 #2 0x00005625e41b8cdc in handle_fatal_signal (sig=6) at /test/10.4_dbg/sql/signal_handler.cc:343 #3 <signal handler called> #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51 #5 0x000014866cf788b1 in __GI_abort () at abort.c:79 #6 0x000014866cf6842a in __assert_fail_base (fmt=0x14866d0efa38 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5625e4e1a070 "strcmp(share->unique_file_name,filename) || share->last_version", file=file@entry=0x5625e4e1a048 "/test/10.4_dbg/storage/myisam/mi_open.c", line=line@entry=67, function=function@entry=0x5625e4e1a170 <__PRETTY_FUNCTION__.17079> "test_if_reopen") at assert.c:92 #7 0x000014866cf684a2 in __GI___assert_fail (assertion=assertion@entry=0x5625e4e1a070 "strcmp(share->unique_file_name,filename) || share->last_version", file=file@entry=0x5625e4e1a048 "/test/10.4_dbg/storage/myisam/mi_open.c", line=line@entry=67, function=function@entry=0x5625e4e1a170 <__PRETTY_FUNCTION__.17079> "test_if_reopen") at assert.c:101 #8 0x00005625e48f7de0 in test_if_reopen (filename=filename@entry=0x14866ecd7a80 "/test/MD110820-mariadb-10.4.15-linux-x86_64-dbg/data/test/t.MYI") at /test/10.4_dbg/storage/myisam/mi_open.c:66 #9 0x00005625e48fa614 in mi_open (name=0x148647cbbc18 "./test/t", mode=2, open_flags=open_flags@entry=82) at /test/10.4_dbg/storage/myisam/mi_open.c:122 #10 0x00005625e48d6847 in ha_myisam::open (this=0x148647c7a888, name=<optimized out>, mode=<optimized out>, test_if_locked=18) at /test/10.4_dbg/storage/myisam/ha_myisam.cc:807 #11 0x00005625e41c0104 in handler::ha_open (this=0x148647c7a888, table_arg=table_arg@entry=0x148647d2f070, name=0x148647cbbc18 "./test/t", mode=mode@entry=2, test_if_locked=test_if_locked@entry=18, mem_root=mem_root@entry=0x0, partitions_to_open=0x0) at /test/10.4_dbg/sql/handler.cc:2782 #12 0x00005625e4004d39 in open_table_from_share (thd=thd@entry=0x148647c15070, share=share@entry=0x148647cbb688, alias=alias@entry=0x148647d26110, db_stat=db_stat@entry=33, prgflag=prgflag@entry=8, ha_open_flags=18, outparam=<optimized out>, is_create_table=<optimized out>, partitions_to_open=<optimized out>) at /test/10.4_dbg/sql/table.cc:3981 #13 0x00005625e3e84a04 in open_table (thd=thd@entry=0x148647c15070, table_list=table_list@entry=0x148647d260c8, ot_ctx=ot_ctx@entry=0x14866ecd9bf0) at /test/10.4_dbg/sql/sql_base.cc:2083 #14 0x00005625e3e89070 in open_and_process_table (ot_ctx=0x14866ecd9bf0, has_prelocking_list=false, prelocking_strategy=0x14866ecd9c88, flags=1346, counter=0x14866ecd9c84, tables=0x148647d260c8, thd=0x148647c15070) at /test/10.4_dbg/sql/sql_base.cc:3893 #15 open_tables (thd=thd@entry=0x148647c15070, options=@0x14866ecdb3c8: {m_options = DDL_options_st::OPT_NONE}, start=start@entry=0x14866ecd9c78, counter=counter@entry=0x14866ecd9c84, flags=flags@entry=1346, prelocking_strategy=prelocking_strategy@entry=0x14866ecd9c88) at /test/10.4_dbg/sql/sql_base.cc:4365 #16 0x00005625e3e8a54a in open_tables (prelocking_strategy=0x14866ecd9c88, flags=1346, counter=0x14866ecd9c84, tables=0x14866ecd9c78, thd=0x148647c15070) at /test/10.4_dbg/sql/sql_base.h:258 #17 open_normal_and_derived_tables (thd=thd@entry=0x148647c15070, tables=<optimized out>, tables@entry=0x148647d260c8, flags=1346, dt_phases=dt_phases@entry=35) at /test/10.4_dbg/sql/sql_base.cc:5332 #18 0x00005625e3e8a702 in open_tables_only_view_structure (thd=thd@entry=0x148647c15070, table_list=table_list@entry=0x148647d260c8, can_deadlock=can_deadlock@entry=true) at /test/10.4_dbg/sql/sql_base.cc:5383 #19 0x00005625e3f8b30a in fill_schema_table_by_open (thd=thd@entry=0x148647c15070, mem_root=mem_root@entry=0x14866ecdbb00, is_show_fields_or_keys=is_show_fields_or_keys@entry=false, table=table@entry=0x148647cf9088, schema_table=schema_table@entry=0x5625e55d3e20 <schema_tables+2048>, orig_db_name=orig_db_name@entry=0x148647c73000, orig_table_name=0x148647d21fc8, open_tables_state_backup=0x14866ecdbb50, can_deadlock=true) at /test/10.4_dbg/sql/sql_show.cc:4669 #20 0x00005625e3fa0eec in get_all_tables (thd=0x148647c15070, tables=0x148647c6edb0, cond=<optimized out>) at /test/10.4_dbg/sql/sql_show.cc:5307 #21 0x00005625e3fa2d63 in get_schema_tables_result (join=join@entry=0x148647c711e8, executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at /test/10.4_dbg/sql/sql_show.cc:8949 #22 0x00005625e3f826dd in JOIN::exec_inner (this=this@entry=0x148647c711e8) at /test/10.4_dbg/sql/sql_select.cc:4430 #23 0x00005625e3f8304d in JOIN::exec (this=this@entry=0x148647c711e8) at /test/10.4_dbg/sql/sql_select.cc:4255 #24 0x00005625e3f813f3 in mysql_select (thd=thd@entry=0x148647c15070, tables=<optimized out>, wild_num=0, fields=@0x148647c198d8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x148647c6d6f8, last = 0x148647c6ed70, elements = 20}, <No data fields>}, conds=0x0, og_num=<optimized out>, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2686716672, result=0x148647c711c0, unit=0x148647c18f98, select_lex=0x148647c19790) at /test/10.4_dbg/sql/sql_select.cc:4687 #25 0x00005625e3f8171e in handle_select (thd=thd@entry=0x148647c15070, lex=lex@entry=0x148647c18ed8, result=result@entry=0x148647c711c0, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.4_dbg/sql/sql_select.cc:410 #26 0x00005625e3efa3c6 in execute_sqlcom_select (thd=thd@entry=0x148647c15070, all_tables=0x148647c6edb0) at /test/10.4_dbg/sql/sql_parse.cc:6355 #27 0x00005625e3f0579a in mysql_execute_command (thd=thd@entry=0x148647c15070) at /test/10.4_dbg/sql/sql_parse.cc:3889 #28 0x00005625e3f10090 in mysql_parse (thd=thd@entry=0x148647c15070, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14866ece0460, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:7896 #29 0x00005625e3f12920 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x148647c15070, packet=packet@entry=0x148647c57071 "SHOW TABLE STATUS LIKE 't'", packet_length=packet_length@entry=26, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:1834 #30 0x00005625e3f1635b in do_command (thd=0x148647c15070) at /test/10.4_dbg/sql/sql_parse.cc:1352 #31 0x00005625e40428b6 in do_handle_one_connection (connect=connect@entry=0x14866b835790) at /test/10.4_dbg/sql/sql_connect.cc:1412 #32 0x00005625e40429d6 in handle_one_connection (arg=0x14866b835790) at /test/10.4_dbg/sql/sql_connect.cc:1316 #33 0x000014866dedf6db in start_thread (arg=0x14866ece1700) at pthread_create.c:463 #34 0x000014866d059a3f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Bug confirmed present in: MariaDB: 10.1.47 (dbg), 10.2.34 (dbg), 10.3.25 (dbg), 10.4.15 (dbg) Bug confirmed not present in: MariaDB: 10.1.47 (opt), 10.2.34 (opt), 10.3.25 (opt), 10.4.15 (opt), 10.5.6 (dbg), 10.5.6 (opt) MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)

            Another testcase leads to a slightly different stack on latest 10.4 debug build.
            Unique id

            strcmp(share->unique_file_name,filename) || share->last_version|SIGABRT|test_if_reopen|mi_create|ha_myisam::create|handler::ha_create
            

            SET SQL_MODE='';
            SET SESSION storage_engine='MyISAM';
            CREATE TABLE t (a INT,b INT,KEY(a));
            INSERT INTO t VALUES (0,0);
            INSERT DELAYED INTO t VALUES (mod (0,0),'test0');
            CREATE TABLE t0 (a INT,b BLOB,UNIQUE (b)) IGNORE AS SELECT * FROM t;
            CREATE TABLE t0 (a INT);
            

            Leads to:

            10.4.30 6966d7fe4b7ccfb2b7d16ca4d7d5ab08234fa9ec (Debug)

            mariadbd: /test/10.4_dbg/storage/myisam/mi_open.c:66: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
            

            10.4.30 6966d7fe4b7ccfb2b7d16ca4d7d5ab08234fa9ec (Debug)

            Core was generated by `/test/MD220523-mariadb-10.4.30-linux-x86_64-dbg/bin/mariadbd --no-defaults --co'.
            Program terminated with signal SIGABRT, Aborted.
            #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
            [Current thread is 1 (Thread 0x14cb9018c700 (LWP 873459))]
            (gdb) bt
            #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
            #1  0x000014cb92651859 in __GI_abort () at abort.c:79
            #2  0x000014cb92651729 in __assert_fail_base (fmt=0x14cb927e7588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55c3a6951ff8 "strcmp(share->unique_file_name,filename) || share->last_version", file=0x55c3a6951fd0 "/test/10.4_dbg/storage/myisam/mi_open.c", line=66, function=<optimized out>) at assert.c:92
            #3  0x000014cb92662fd6 in __GI___assert_fail (assertion=assertion@entry=0x55c3a6951ff8 "strcmp(share->unique_file_name,filename) || share->last_version", file=file@entry=0x55c3a6951fd0 "/test/10.4_dbg/storage/myisam/mi_open.c", line=line@entry=66, function=function@entry=0x55c3a69520a8 <__PRETTY_FUNCTION__.18678> "test_if_reopen") at assert.c:101
            #4  0x000055c3a65143b4 in test_if_reopen (filename=filename@entry=0x14cb901864c0 "/test/MD220523-mariadb-10.4.30-linux-x86_64-dbg/data/test/t0.MYI") at /test/10.4_dbg/storage/myisam/mi_open.c:66
            #5  0x000055c3a65090fc in mi_create (name=0x14cb90187390 "./test/t0", keys=keys@entry=0, keydefs=keydefs@entry=0x14cb28080358, columns=columns@entry=2, recinfo=recinfo@entry=0x14cb28080298, uniques=uniques@entry=0, uniquedefs=0x0, ci=0x14cb90187350, flags=0) at /test/10.4_dbg/storage/myisam/mi_create.c:639
            #6  0x000055c3a64f90a7 in ha_myisam::create (this=<optimized out>, name=0x14cb90189480 "./test/t0", table_arg=<optimized out>, ha_create_info=<optimized out>) at /test/10.4_dbg/storage/myisam/ha_myisam.cc:2319
            #7  0x000055c3a5d65c79 in handler::ha_create (this=0x14cb2807fb30, name=0x14cb90189480 "./test/t0", form=form@entry=0x14cb901876c0, info_arg=info_arg@entry=0x14cb90189850) at /test/10.4_dbg/sql/handler.cc:4837
            #8  0x000055c3a5d6683f in ha_create_table (thd=thd@entry=0x14cb28000d28, path=path@entry=0x14cb90189480 "./test/t0", db=0x14cb28012c98 "test", table_name=0x14cb28012570 "t0", create_info=create_info@entry=0x14cb90189850, frm=frm@entry=0x14cb90189470) at /test/10.4_dbg/sql/handler.cc:5305
            #9  0x000055c3a5b9aa15 in create_table_impl (thd=thd@entry=0x14cb28000d28, orig_db=@0x14cb280125c0: {str = 0x14cb28012c98 "test", length = 4}, orig_table_name=@0x14cb280125d0: {str = 0x14cb28012570 "t0", length = 2}, db=@0x14cb280125c0: {str = 0x14cb28012c98 "test", length = 4}, table_name=@0x14cb280125d0: {str = 0x14cb28012570 "t0", length = 2}, path=path@entry=0x14cb90189480 "./test/t0", options={m_options = DDL_options_st::OPT_NONE}, create_info=0x14cb90189850, alter_info=0x14cb90189790, create_table_mode=0, is_trans=0x14cb90189707, key_info=0x14cb90189468, key_count=0x14cb90189464, frm=0x14cb90189470) at /test/10.4_dbg/sql/sql_table.cc:5183
            #10 0x000055c3a5b9ada3 in mysql_create_table_no_lock (thd=thd@entry=0x14cb28000d28, db=db@entry=0x14cb280125c0, table_name=table_name@entry=0x14cb280125d0, create_info=create_info@entry=0x14cb90189850, alter_info=alter_info@entry=0x14cb90189790, is_trans=is_trans@entry=0x14cb90189707, create_table_mode=0, table_list=0x14cb280125a8) at /test/10.4_dbg/sql/sql_table.cc:5267
            #11 0x000055c3a5b9b0d5 in mysql_create_table (thd=thd@entry=0x14cb28000d28, create_table=create_table@entry=0x14cb280125a8, create_info=create_info@entry=0x14cb90189850, alter_info=alter_info@entry=0x14cb90189790) at /test/10.4_dbg/sql/sql_table.cc:5416
            #12 0x000055c3a5b9ca6e in Sql_cmd_create_table_like::execute (this=<optimized out>, thd=0x14cb28000d28) at /test/10.4_dbg/sql/sql_table.cc:11823
            #13 0x000055c3a5ae3ec3 in mysql_execute_command (thd=thd@entry=0x14cb28000d28) at /test/10.4_dbg/sql/sql_parse.cc:6216
            #14 0x000055c3a5ae6247 in mysql_parse (thd=thd@entry=0x14cb28000d28, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14cb9018b3b0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:8008
            #15 0x000055c3a5ae8d62 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14cb28000d28, packet=packet@entry=0x14cb28019509 "CREATE TABLE t0 (a INT)", packet_length=packet_length@entry=23, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_class.h:1231
            #16 0x000055c3a5aeb58d in do_command (thd=0x14cb28000d28) at /test/10.4_dbg/sql/sql_parse.cc:1378
            #17 0x000055c3a5c083d7 in do_handle_one_connection (connect=<optimized out>) at /test/10.4_dbg/sql/sql_connect.cc:1420
            #18 0x000055c3a5c08493 in handle_one_connection (arg=<optimized out>) at /test/10.4_dbg/sql/sql_connect.cc:1324
            #19 0x000014cb92b62609 in start_thread (arg=<optimized out>) at pthread_create.c:477
            #20 0x000014cb9274e133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
            

            Bug confirmed present in:
            MariaDB: 10.4.30 (dbg)

            Bug (or feature/syntax) confirmed not present in:
            MariaDB: 10.4.30 (opt), 10.5.21 (dbg), 10.5.21 (opt), 10.6.14 (dbg), 10.6.14 (opt), 10.8.8 (dbg), 10.8.8 (opt), 10.9.7 (dbg), 10.9.7 (opt), 10.10.5 (dbg), 10.10.5 (opt), 10.11.4 (dbg), 10.11.4 (opt), 11.0.2 (dbg), 11.0.2 (opt), 11.1.0 (dbg), 11.1.0 (opt)

            ramesh Ramesh Sivaraman added a comment - Another testcase leads to a slightly different stack on latest 10.4 debug build. Unique id strcmp(share->unique_file_name,filename) || share->last_version|SIGABRT|test_if_reopen|mi_create|ha_myisam::create|handler::ha_create SET SQL_MODE= '' ; SET SESSION storage_engine= 'MyISAM' ; CREATE TABLE t (a INT ,b INT , KEY (a)); INSERT INTO t VALUES (0,0); INSERT DELAYED INTO t VALUES (mod (0,0), 'test0' ); CREATE TABLE t0 (a INT ,b BLOB, UNIQUE (b)) IGNORE AS SELECT * FROM t; CREATE TABLE t0 (a INT ); Leads to: 10.4.30 6966d7fe4b7ccfb2b7d16ca4d7d5ab08234fa9ec (Debug) mariadbd: /test/10.4_dbg/storage/myisam/mi_open.c:66: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed. 10.4.30 6966d7fe4b7ccfb2b7d16ca4d7d5ab08234fa9ec (Debug) Core was generated by `/test/MD220523-mariadb-10.4.30-linux-x86_64-dbg/bin/mariadbd --no-defaults --co'. Program terminated with signal SIGABRT, Aborted. #0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 [Current thread is 1 (Thread 0x14cb9018c700 (LWP 873459))] (gdb) bt #0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 #1 0x000014cb92651859 in __GI_abort () at abort.c:79 #2 0x000014cb92651729 in __assert_fail_base (fmt=0x14cb927e7588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55c3a6951ff8 "strcmp(share->unique_file_name,filename) || share->last_version", file=0x55c3a6951fd0 "/test/10.4_dbg/storage/myisam/mi_open.c", line=66, function=<optimized out>) at assert.c:92 #3 0x000014cb92662fd6 in __GI___assert_fail (assertion=assertion@entry=0x55c3a6951ff8 "strcmp(share->unique_file_name,filename) || share->last_version", file=file@entry=0x55c3a6951fd0 "/test/10.4_dbg/storage/myisam/mi_open.c", line=line@entry=66, function=function@entry=0x55c3a69520a8 <__PRETTY_FUNCTION__.18678> "test_if_reopen") at assert.c:101 #4 0x000055c3a65143b4 in test_if_reopen (filename=filename@entry=0x14cb901864c0 "/test/MD220523-mariadb-10.4.30-linux-x86_64-dbg/data/test/t0.MYI") at /test/10.4_dbg/storage/myisam/mi_open.c:66 #5 0x000055c3a65090fc in mi_create (name=0x14cb90187390 "./test/t0", keys=keys@entry=0, keydefs=keydefs@entry=0x14cb28080358, columns=columns@entry=2, recinfo=recinfo@entry=0x14cb28080298, uniques=uniques@entry=0, uniquedefs=0x0, ci=0x14cb90187350, flags=0) at /test/10.4_dbg/storage/myisam/mi_create.c:639 #6 0x000055c3a64f90a7 in ha_myisam::create (this=<optimized out>, name=0x14cb90189480 "./test/t0", table_arg=<optimized out>, ha_create_info=<optimized out>) at /test/10.4_dbg/storage/myisam/ha_myisam.cc:2319 #7 0x000055c3a5d65c79 in handler::ha_create (this=0x14cb2807fb30, name=0x14cb90189480 "./test/t0", form=form@entry=0x14cb901876c0, info_arg=info_arg@entry=0x14cb90189850) at /test/10.4_dbg/sql/handler.cc:4837 #8 0x000055c3a5d6683f in ha_create_table (thd=thd@entry=0x14cb28000d28, path=path@entry=0x14cb90189480 "./test/t0", db=0x14cb28012c98 "test", table_name=0x14cb28012570 "t0", create_info=create_info@entry=0x14cb90189850, frm=frm@entry=0x14cb90189470) at /test/10.4_dbg/sql/handler.cc:5305 #9 0x000055c3a5b9aa15 in create_table_impl (thd=thd@entry=0x14cb28000d28, orig_db=@0x14cb280125c0: {str = 0x14cb28012c98 "test", length = 4}, orig_table_name=@0x14cb280125d0: {str = 0x14cb28012570 "t0", length = 2}, db=@0x14cb280125c0: {str = 0x14cb28012c98 "test", length = 4}, table_name=@0x14cb280125d0: {str = 0x14cb28012570 "t0", length = 2}, path=path@entry=0x14cb90189480 "./test/t0", options={m_options = DDL_options_st::OPT_NONE}, create_info=0x14cb90189850, alter_info=0x14cb90189790, create_table_mode=0, is_trans=0x14cb90189707, key_info=0x14cb90189468, key_count=0x14cb90189464, frm=0x14cb90189470) at /test/10.4_dbg/sql/sql_table.cc:5183 #10 0x000055c3a5b9ada3 in mysql_create_table_no_lock (thd=thd@entry=0x14cb28000d28, db=db@entry=0x14cb280125c0, table_name=table_name@entry=0x14cb280125d0, create_info=create_info@entry=0x14cb90189850, alter_info=alter_info@entry=0x14cb90189790, is_trans=is_trans@entry=0x14cb90189707, create_table_mode=0, table_list=0x14cb280125a8) at /test/10.4_dbg/sql/sql_table.cc:5267 #11 0x000055c3a5b9b0d5 in mysql_create_table (thd=thd@entry=0x14cb28000d28, create_table=create_table@entry=0x14cb280125a8, create_info=create_info@entry=0x14cb90189850, alter_info=alter_info@entry=0x14cb90189790) at /test/10.4_dbg/sql/sql_table.cc:5416 #12 0x000055c3a5b9ca6e in Sql_cmd_create_table_like::execute (this=<optimized out>, thd=0x14cb28000d28) at /test/10.4_dbg/sql/sql_table.cc:11823 #13 0x000055c3a5ae3ec3 in mysql_execute_command (thd=thd@entry=0x14cb28000d28) at /test/10.4_dbg/sql/sql_parse.cc:6216 #14 0x000055c3a5ae6247 in mysql_parse (thd=thd@entry=0x14cb28000d28, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14cb9018b3b0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:8008 #15 0x000055c3a5ae8d62 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14cb28000d28, packet=packet@entry=0x14cb28019509 "CREATE TABLE t0 (a INT)", packet_length=packet_length@entry=23, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_class.h:1231 #16 0x000055c3a5aeb58d in do_command (thd=0x14cb28000d28) at /test/10.4_dbg/sql/sql_parse.cc:1378 #17 0x000055c3a5c083d7 in do_handle_one_connection (connect=<optimized out>) at /test/10.4_dbg/sql/sql_connect.cc:1420 #18 0x000055c3a5c08493 in handle_one_connection (arg=<optimized out>) at /test/10.4_dbg/sql/sql_connect.cc:1324 #19 0x000014cb92b62609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #20 0x000014cb9274e133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Bug confirmed present in: MariaDB: 10.4.30 (dbg) Bug (or feature/syntax) confirmed not present in: MariaDB: 10.4.30 (opt), 10.5.21 (dbg), 10.5.21 (opt), 10.6.14 (dbg), 10.6.14 (opt), 10.8.8 (dbg), 10.8.8 (opt), 10.9.7 (dbg), 10.9.7 (opt), 10.10.5 (dbg), 10.10.5 (opt), 10.11.4 (dbg), 10.11.4 (opt), 11.0.2 (dbg), 11.0.2 (opt), 11.1.0 (dbg), 11.1.0 (opt)

            People

              sanja Oleksandr Byelkin
              alice Alice Sherepa
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.