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

Assertion `table->versioned() == m_prebuilt->table->versioned()' failed in ha_innobase::open

    XMLWordPrintable

    Details

      Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 ( 
        pk INT,
        i INT,
        v INT AS (t) VIRTUAL,
        t INT,
        PRIMARY KEY(pk)
      ) ENGINE=InnoDB WITH SYSTEM VERSIONING;
      ALTER TABLE t1 DROP SYSTEM VERSIONING;
       
      # Cleanup
      DROP TABLE t1;
      

      10.4 3bdd93c10a

      mysqld: /data/src/10.4/storage/innobase/handler/ha_innodb.cc:6347: virtual int ha_innobase::open(const char*, int, uint): Assertion `table->versioned() == m_prebuilt->table->versioned()' failed.
      190102 23:21:58 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fe34d1d8ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x00005642b37103cb in ha_innobase::open (this=0x7fe2f4139d28, name=0x7fe2f4063b70 "./test/t1") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:6347
      #9  0x00005642b33e4d7f in handler::ha_open (this=0x7fe2f4139d28, table_arg=0x7fe2f4132e20, name=0x7fe2f4063b70 "./test/t1", mode=2, test_if_locked=18, mem_root=0x0, partitions_to_open=0x0) at /data/src/10.4/sql/handler.cc:2720
      #10 0x00005642b31e57b9 in open_table_from_share (thd=0x7fe2f4000b00, share=0x7fe2f4063628, alias=0x7fe2f40150d8, db_stat=33, prgflag=8, ha_open_flags=18, outparam=0x7fe2f4132e20, is_create_table=false, partitions_to_open=0x0) at /data/src/10.4/sql/table.cc:3509
      #11 0x00005642b3037873 in open_table (thd=0x7fe2f4000b00, table_list=0x7fe2f4015090, ot_ctx=0x7fe34810d3a0) at /data/src/10.4/sql/sql_base.cc:2031
      #12 0x00005642b31a9d26 in mysql_inplace_alter_table (thd=0x7fe2f4000b00, table_list=0x7fe2f4015090, table=0x0, altered_table=0x7fe2f40642b0, ha_alter_info=0x7fe34810dbc0, inplace_supported=HA_ALTER_INPLACE_COPY_LOCK, target_mdl_request=0x7fe34810dcf0, alter_ctx=0x7fe34810e8e0) at /data/src/10.4/sql/sql_table.cc:7628
      #13 0x00005642b31af9f5 in mysql_alter_table (thd=0x7fe2f4000b00, new_db=0x7fe2f40051c8, new_name=0x7fe2f4005598, create_info=0x7fe34810f4d0, table_list=0x7fe2f4015090, alter_info=0x7fe34810f410, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:9690
      #14 0x00005642b323a077 in Sql_cmd_alter_table::execute (this=0x7fe2f40156d0, thd=0x7fe2f4000b00) at /data/src/10.4/sql/sql_alter.cc:497
      #15 0x00005642b30d7319 in mysql_execute_command (thd=0x7fe2f4000b00) at /data/src/10.4/sql/sql_parse.cc:6302
      #16 0x00005642b30dc244 in mysql_parse (thd=0x7fe2f4000b00, rawbuf=0x7fe2f4014f98 "ALTER TABLE t1 DROP SYSTEM VERSIONING", length=37, parser_state=0x7fe348110600, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8104
      #17 0x00005642b30c946e in dispatch_command (command=COM_QUERY, thd=0x7fe2f4000b00, packet=0x7fe2f400b421 "ALTER TABLE t1 DROP SYSTEM VERSIONING", packet_length=37, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1851
      #18 0x00005642b30c7e92 in do_command (thd=0x7fe2f4000b00) at /data/src/10.4/sql/sql_parse.cc:1396
      #19 0x00005642b32340ba in do_handle_one_connection (connect=0x5642b73a77d0) at /data/src/10.4/sql/sql_connect.cc:1402
      #20 0x00005642b3233e3e in handle_one_connection (arg=0x5642b73a77d0) at /data/src/10.4/sql/sql_connect.cc:1308
      #21 0x00005642b36f317a in pfs_spawn_thread (arg=0x5642b73a2770) at /data/src/10.4/storage/perfschema/pfs.cc:1862
      #22 0x00007fe34ec94494 in start_thread (arg=0x7fe348111700) at pthread_create.c:333
      #23 0x00007fe34d29593f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Not reproducible on 10.3.

        Attachments

          Activity

            People

            Assignee:
            marko Marko Mäkelä
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: