[MDEV-18122] Assertion `table->versioned() == m_prebuilt->table->versioned()' failed in ha_innobase::open Created: 2019-01-02  Updated: 2019-01-25  Resolved: 2019-01-25

Status: Closed
Project: MariaDB Server
Component/s: Versioned Tables, Virtual Columns
Affects Version/s: 10.4
Fix Version/s: 10.4.2

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: affects-tests


 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.


Generated at Thu Feb 08 08:41:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.