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

test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed upon select from I_S

    Details

    • Sprint:
      10.0.34

      Description

      CREATE TABLE t1 (i INT) ENGINE=MyISAM;
      LOCK TABLE t1 WRITE;
      OPTIMIZE TABLE t1;
      SELECT * FROM INFORMATION_SCHEMA.TABLES;
       
      # Cleanup
      DROP TABLE t1;
      

      10.0 4496fd71f47e

      mysqld: /data/src/10.0/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
      180110 20:12:22 [ERROR] mysqld got signal 6 ;
       
      Query (0x7f7b60cfa088): SELECT * FROM INFORMATION_SCHEMA.TABLES
      Connection ID (thread ID): 3
      Status: NOT_KILLED
      

      #7  0x00007fbb782f9ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x0000557ed9b0b679 in test_if_reopen (filename=0x7fbb72562ef0 "/data/bld/10.3/mysql-test/var/mysqld.1/data/test/t1.MYI") at /data/src/10.3/storage/myisam/mi_open.c:66
      #9  0x0000557ed9b0b892 in mi_open (name=0x7fbb60035898 "./test/t1", mode=2, open_flags=82) at /data/src/10.3/storage/myisam/mi_open.c:122
      #10 0x0000557ed9adeb91 in ha_myisam::open (this=0x7fbb60051098, name=0x7fbb60035898 "./test/t1", mode=2, test_if_locked=18) at /data/src/10.3/storage/myisam/ha_myisam.cc:782
      #11 0x0000557ed93c889e in handler::ha_open (this=0x7fbb60051098, table_arg=0x7fbb60050470, name=0x7fbb60035898 "./test/t1", mode=2, test_if_locked=18, mem_root=0x0) at /data/src/10.3/sql/handler.cc:2645
      #12 0x0000557ed91fce98 in open_table_from_share (thd=0x7fbb60000b00, share=0x7fbb60035378, alias=0x7fbb60048340 "t1", db_stat=33, prgflag=8, ha_open_flags=18, outparam=0x7fbb60050470, is_create_table=false) at /data/src/10.3/sql/table.cc:3365
      #14 0x0000557ed9073063 in open_and_process_table (thd=0x7fbb60000b00, lex=0x7fbb72564ee0, tables=0x7fbb60048348, counter=0x7fbb72564ccc, flags=1346, prelocking_strategy=0x7fbb72564cd0, has_prelocking_list=false, ot_ctx=0x7fbb72564c00) at /data/src/10.3/sql/sql_base.cc:3467
      #15 0x0000557ed907422e in open_tables (thd=0x7fbb60000b00, options=..., start=0x7fbb72564cb0, counter=0x7fbb72564ccc, flags=1346, prelocking_strategy=0x7fbb72564cd0) at /data/src/10.3/sql/sql_base.cc:3987
      #16 0x0000557ed906c8be in open_tables (thd=0x7fbb60000b00, tables=0x7fbb72564cb0, counter=0x7fbb72564ccc, flags=1346, prelocking_strategy=0x7fbb72564cd0) at /data/src/10.3/sql/sql_base.h:238
      #17 0x0000557ed9076211 in open_normal_and_derived_tables (thd=0x7fbb60000b00, tables=0x7fbb60048348, flags=1346, dt_phases=35) at /data/src/10.3/sql/sql_base.cc:4930
      #18 0x0000557ed90763ea in open_tables_only_view_structure (thd=0x7fbb60000b00, table_list=0x7fbb60048348, can_deadlock=true) at /data/src/10.3/sql/sql_base.cc:4987
      #19 0x0000557ed918fb8b in fill_schema_table_by_open (thd=0x7fbb60000b00, mem_root=0x7fbb725666c0, is_show_fields_or_keys=false, table=0x7fbb60084168, schema_table=0x557eda63f800 <schema_tables+1920>, orig_db_name=0x7fbb6001ab10, orig_table_name=0x7fbb60044480, open_tables_state_backup=0x7fbb72566700, can_deadlock=true) at /data/src/10.3/sql/sql_show.cc:4502
      #20 0x0000557ed91914e2 in get_all_tables (thd=0x7fbb60000b00, tables=0x7fbb60014d80, cond=0x0) at /data/src/10.3/sql/sql_show.cc:5151
      #21 0x0000557ed91a1342 in get_schema_tables_result (join=0x7fbb60016ce8, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.3/sql/sql_show.cc:8519
      #22 0x0000557ed913cf4c in JOIN::exec_inner (this=0x7fbb60016ce8) at /data/src/10.3/sql/sql_select.cc:3600
      #23 0x0000557ed913c5f0 in JOIN::exec (this=0x7fbb60016ce8) at /data/src/10.3/sql/sql_select.cc:3431
      #24 0x0000557ed913d831 in mysql_select (thd=0x7fbb60000b00, tables=0x7fbb60014d80, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2686716672, result=0x7fbb60016cc8, unit=0x7fbb60004838, select_lex=0x7fbb60004f70) at /data/src/10.3/sql/sql_select.cc:3835
      #25 0x0000557ed9131824 in handle_select (thd=0x7fbb60000b00, lex=0x7fbb60004770, result=0x7fbb60016cc8, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:375
      #26 0x0000557ed90fcfc5 in execute_sqlcom_select (thd=0x7fbb60000b00, all_tables=0x7fbb60014d80) at /data/src/10.3/sql/sql_parse.cc:6511
      #27 0x0000557ed90f3759 in mysql_execute_command (thd=0x7fbb60000b00) at /data/src/10.3/sql/sql_parse.cc:3744
      #28 0x0000557ed91008f8 in mysql_parse (thd=0x7fbb60000b00, rawbuf=0x7fbb60014b58 "SELECT * FROM INFORMATION_SCHEMA.TABLES", length=39, parser_state=0x7fbb72568610, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7968
      #29 0x0000557ed90ee26d in dispatch_command (command=COM_QUERY, thd=0x7fbb60000b00, packet=0x7fbb6011ecd1 "SELECT * FROM INFORMATION_SCHEMA.TABLES", packet_length=39, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1825
      #30 0x0000557ed90ecca1 in do_command (thd=0x7fbb60000b00) at /data/src/10.3/sql/sql_parse.cc:1369
      #31 0x0000557ed9245cf4 in do_handle_one_connection (connect=0x557edcd30100) at /data/src/10.3/sql/sql_connect.cc:1401
      #32 0x0000557ed9245a81 in handle_one_connection (arg=0x557edcd30100) at /data/src/10.3/sql/sql_connect.cc:1307
      #33 0x0000557ed96d5cda in pfs_spawn_thread (arg=0x557edcd4c930) at /data/src/10.3/storage/perfschema/pfs.cc:1863
      #34 0x00007fbb79fd0494 in start_thread (arg=0x7fbb72569700) at pthread_create.c:333
      #35 0x00007fbb783b693f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Reproducible with 10.0 - 10.3.
      Not reproducible with 5.5.
      No obvious effect on a non-debug build.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: