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

    XMLWordPrintable

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

            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.