[MDEV-14744] Assertion `table->versioned() == m_prebuilt->table->versioned()' failed in ha_innobase::open Created: 2017-12-22  Updated: 2017-12-28  Resolved: 2017-12-27

Status: Closed
Project: MariaDB Server
Component/s: Full-text Search, Storage Engine - InnoDB, Versioned Tables
Affects Version/s: N/A
Fix Version/s: 10.3.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Eugene Kosov (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

--source include/have_innodb.inc
 
CREATE OR REPLACE TABLE t1 (c TEXT) ENGINE=InnoDB WITH SYSTEM VERSIONING;
ALTER TABLE t1 ADD FULLTEXT KEY (c);
 
# Cleanup
DROP TABLE t1;

bb-10.3-temporal e6c5eb5c583b2

mysqld: /data/src/bb-10.3-temporal/storage/innobase/handler/ha_innodb.cc:6560: virtual int ha_innobase::open(const char*, int, uint): Assertion `table->versioned() == m_prebuilt->table->versioned()' failed.
171222 15:36:17 [ERROR] mysqld got signal 6 ;
 
#7  0x00007f3c1568bee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x000055a73e6b2169 in ha_innobase::open (this=0x7f3bc000c268, name=0x7f3bc009fb68 "./test/t1") at /data/src/bb-10.3-temporal/storage/innobase/handler/ha_innodb.cc:6560
#9  0x000055a73e38210a in handler::ha_open (this=0x7f3bc000c268, table_arg=0x7f3bc006dd10, name=0x7f3bc009fb68 "./test/t1", mode=2, test_if_locked=18, mem_root=0x0) at /data/src/bb-10.3-temporal/sql/handler.cc:2679
#10 0x000055a73e1aa49b in open_table_from_share (thd=0x7f3bc0000b00, share=0x7f3bc009f4f8, alias=0x7f3bc0014d38 "t1", db_stat=33, prgflag=8, ha_open_flags=18, outparam=0x7f3bc006dd10, is_create_table=false) at /data/src/bb-10.3-temporal/sql/table.cc:3465
#11 0x000055a73e013ce9 in open_table (thd=0x7f3bc0000b00, table_list=0x7f3bc0014d40, ot_ctx=0x7f3c100f7a80) at /data/src/bb-10.3-temporal/sql/sql_base.cc:1907
#12 0x000055a73e170e1c in mysql_inplace_alter_table (thd=0x7f3bc0000b00, table_list=0x7f3bc0014d40, table=0x0, altered_table=0x7f3bc006f8d0, ha_alter_info=0x7f3c100f8270, inplace_supported=HA_ALTER_INPLACE_SHARED_LOCK_AFTER_PREPARE, target_mdl_request=0x7f3c100f83e0, alter_ctx=0x7f3c100f9070) at /data/src/bb-10.3-temporal/sql/sql_table.cc:7653
#13 0x000055a73e176635 in mysql_alter_table (thd=0x7f3bc0000b00, new_db=0x7f3bc0015370 "test", new_name=0x0, create_info=0x7f3c100f9c90, table_list=0x7f3bc0014d40, alter_info=0x7f3c100f9be0, order_num=0, order=0x0, ignore=false) at /data/src/bb-10.3-temporal/sql/sql_table.cc:9669
#14 0x000055a73e1ff667 in Sql_cmd_alter_table::execute (this=0x7f3bc0015438, thd=0x7f3bc0000b00) at /data/src/bb-10.3-temporal/sql/sql_alter.cc:331
#15 0x000055a73e0a181a in mysql_execute_command (thd=0x7f3bc0000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:6261
#16 0x000055a73e0a6358 in mysql_parse (thd=0x7f3bc0000b00, rawbuf=0x7f3bc0014c48 "ALTER TABLE t1 ADD FULLTEXT KEY (c)", length=35, parser_state=0x7f3c100fb5f0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:7991
#17 0x000055a73e093af9 in dispatch_command (command=COM_QUERY, thd=0x7f3bc0000b00, packet=0x7f3bc01200b1 "ALTER TABLE t1 ADD FULLTEXT KEY (c)", packet_length=35, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1825
#18 0x000055a73e09252d in do_command (thd=0x7f3bc0000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1370
#19 0x000055a73e1fa1dc in do_handle_one_connection (connect=0x55a742741990) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420
#20 0x000055a73e1f9f69 in handle_one_connection (arg=0x55a742741990) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326
#21 0x000055a73e694b92 in pfs_spawn_thread (arg=0x55a7427e43b0) at /data/src/bb-10.3-temporal/storage/perfschema/pfs.cc:1863
#22 0x00007f3c17362494 in start_thread (arg=0x7f3c100fc700) at pthread_create.c:333
#23 0x00007f3c1574893f in clone () from /lib/x86_64-linux-gnu/libc.so.6



 Comments   
Comment by Eugene Kosov (Inactive) [ 2017-12-27 ]

Fixed here https://github.com/MariaDB/server/commit/0ab3e01e7220a604e64bba15b765973de088f1cc

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