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

Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed in myisam/mi_open.c:67: test_if_reopen

    XMLWordPrintable

Details

    • 10.2.2-1

    Description

      CREATE TABLE t (i INT) ENGINE=MyISAM;
      CREATE TEMPORARY TABLE tmp LIKE t;
      ALTER TABLE tmp RENAME TO t;
       
      SELECT ( SELECT 1 FROM t a1, t a2 ) AS f1, ( SELECT 2 FROM t a3 ) AS f2 FROM DUAL;
      

      Stack trace from 10.2 commit b2ae32aafdd2787ad456f38833f630182ded25e8

      mysqld: /src/10.2/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed.
      160613  0:57:09 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f669b9e01d2 in __assert_fail () from /lib64/libc.so.6
      #8  0x00005628ab8c546d in test_if_reopen (filename=0x7f669dcac800 "/bld/10.2/mysql-test/var/tmp/mysqld.1/#sql3f1e_3_1.MYI") at /src/10.2/storage/myisam/mi_open.c:66
      #9  0x00005628ab8c5669 in mi_open (name=0x7f669219e158 "/bld/10.2/mysql-test/var/tmp/mysqld.1/#sql3f1e_3_1", mode=2, open_flags=82) at /src/10.2/storage/myisam/mi_open.c:117
      #10 0x00005628ab899a75 in ha_myisam::open (this=0x7f6691e24088, name=0x7f669219e158 "/bld/10.2/mysql-test/var/tmp/mysqld.1/#sql3f1e_3_1", mode=2, test_if_locked=18) at /src/10.2/storage/myisam/ha_myisam.cc:754
      #11 0x00005628ab3446d6 in handler::ha_open (this=0x7f6691e24088, table_arg=0x7f6691e3b470, name=0x7f669219e158 "/bld/10.2/mysql-test/var/tmp/mysqld.1/#sql3f1e_3_1", mode=2, test_if_locked=18) at /src/10.2/sql/handler.cc:2497
      #12 0x00005628ab1e4fe5 in open_table_from_share (thd=0x7f669202d630, share=0x7f669219dc70, alias=0x7f6692068aa0 "t", db_stat=7, prgflag=44, ha_open_flags=18, outparam=0x7f6691e3b470, is_create_table=false) at /src/10.2/sql/table.cc:2946
      #13 0x00005628ab2c6ecf in THD::open_temporary_table (this=0x7f669202d630, share=0x7f669219dc70, alias=0x7f6692068aa0 "t", open_in_engine=true) at /src/10.2/sql/temporary_tables.cc:1120
      #14 0x00005628ab2c5998 in THD::open_temporary_table (this=0x7f669202d630, tl=0x7f6692068ae8) at /src/10.2/sql/temporary_tables.cc:367
      #15 0x00005628ab2c5be5 in THD::open_temporary_tables (this=0x7f669202d630, tl=0x7f6692068490) at /src/10.2/sql/temporary_tables.cc:455
      #16 0x00005628ab0f49cc in mysql_execute_command (thd=0x7f669202d630) at /src/10.2/sql/sql_parse.cc:3270
      #17 0x00005628ab102708 in mysql_parse (thd=0x7f669202d630, rawbuf=0x7f66920677c8 "SELECT ( SELECT 1 FROM t a1, t a2 ) AS f1, ( SELECT 2 FROM t a3 ) AS f2 FROM DUAL", length=81, parser_state=0x7f669dcae9e0, is_com_multi=false, is_next_command=false) at /src/10.2/sql/sql_parse.cc:7729
      #18 0x00005628ab0f0b51 in dispatch_command (command=COM_QUERY, thd=0x7f669202d630, packet=0x7f669205b271 "SELECT ( SELECT 1 FROM t a1, t a2 ) AS f1, ( SELECT 2 FROM t a3 ) AS f2 FROM DUAL", packet_length=81, is_com_multi=false, is_next_command=false) at /src/10.2/sql/sql_parse.cc:1792
      #19 0x00005628ab0ef590 in do_command (thd=0x7f669202d630) at /src/10.2/sql/sql_parse.cc:1353
      #20 0x00005628ab225d31 in do_handle_one_connection (connect=0x7f669b484310) at /src/10.2/sql/sql_connect.cc:1358
      #21 0x00005628ab225abe in handle_one_connection (arg=0x7f669b484310) at /src/10.2/sql/sql_connect.cc:1264
      #22 0x00005628ab93e728 in pfs_spawn_thread (arg=0x7f66969c6ff0) at /src/10.2/storage/perfschema/pfs.cc:1862
      #23 0x00007f669d9290a4 in start_thread () from /lib64/libpthread.so.0
      #24 0x00007f669ba9704d in clone () from /lib64/libc.so.6
      

      Attachments

        Issue Links

          Activity

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              elenst Elena Stepanova
              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.