Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
Description
--source include/have_innodb.inc
|
create table t1 (i int, vc serial as (i)) engine=InnoDB; |
show create table t1; |
2016-12-15 23:21:09 0x7f96aa3a9300 InnoDB: Assertion failure in thread 140285077787392 in file ha_innodb.cc line 6755
|
InnoDB: Failing assertion: !((field)->vcol_info && !(field)->stored_in_db())
|
|
#6 0x00007f96a99a55bc in ut_dbg_assertion_failed (expr=expr@entry=0x7f96a9e0cfd8 "!((field)->vcol_info && !(field)->stored_in_db())", file=file@entry=0x7f96a9e07690 "/data/src/10.2/storage/innobase/handler/ha_innodb.cc", line=line@entry=6755) at /data/src/10.2/storage/innobase/ut/ut0dbg.cc:67
|
#7 0x00007f96a97b2303 in ha_innobase::innobase_initialize_autoinc (this=this@entry=0x7f966109c888) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:6755
|
#8 0x00007f96a97b369c in ha_innobase::open (this=0x7f966109c888, name=<optimized out>, mode=<optimized out>, test_if_locked=<optimized out>) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:7214
|
#9 0x00007f96a95a8d5d in handler::ha_open (this=0x7f966109c888, table_arg=table_arg@entry=0x7f9661132870, name=0x7f96610e3b90 "./test/t1", mode=mode@entry=2, test_if_locked=test_if_locked@entry=18) at /data/src/10.2/sql/handler.cc:2500
|
#10 0x00007f96a948eb3c in open_table_from_share (thd=thd@entry=0x7f9661016070, share=share@entry=0x7f96610e3688, alias=<optimized out>, db_stat=db_stat@entry=33, prgflag=prgflag@entry=8, ha_open_flags=18, outparam=0x7f9661132870, is_create_table=false) at /data/src/10.2/sql/table.cc:3277
|
#11 0x00007f96a936ac45 in open_table (thd=thd@entry=0x7f9661016070, table_list=table_list@entry=0x7f9661060160, ot_ctx=ot_ctx@entry=0x7f96aa3a52b0) at /data/src/10.2/sql/sql_base.cc:1860
|
#12 0x00007f96a936da2d in open_and_process_table (ot_ctx=0x7f96aa3a52b0, has_prelocking_list=false, prelocking_strategy=0x7f96aa3a5360, flags=1024, counter=0x7f96aa3a535c, tables=0x7f9661060160, lex=0x7f9661019a80, thd=0x7f9661016070) at /data/src/10.2/sql/sql_base.cc:3397
|
#13 open_tables (thd=thd@entry=0x7f9661016070, options=..., start=start@entry=0x7f96aa3a5348, counter=counter@entry=0x7f96aa3a535c, flags=flags@entry=1024, prelocking_strategy=prelocking_strategy@entry=0x7f96aa3a5360) at /data/src/10.2/sql/sql_base.cc:3910
|
#14 0x00007f96a943268c in open_tables (flags=1024, counter=0x7f96aa3a535c, tables=0x7f96aa3a5348, thd=0x7f9661016070) at /data/src/10.2/sql/sql_base.h:462
|
#15 mysqld_show_create_get_fields (thd=thd@entry=0x7f9661016070, table_list=table_list@entry=0x7f9661060160, field_list=field_list@entry=0x7f96aa3a5630, buffer=buffer@entry=0x7f96aa3a5650) at /data/src/10.2/sql/sql_show.cc:1164
|
#16 0x00007f96a9433594 in mysqld_show_create (thd=thd@entry=0x7f9661016070, table_list=table_list@entry=0x7f9661060160) at /data/src/10.2/sql/sql_show.cc:1259
|
#17 0x00007f96a93c34a5 in mysql_execute_command (thd=thd@entry=0x7f9661016070) at /data/src/10.2/sql/sql_parse.cc:4121
|
#18 0x00007f96a93ca2d2 in mysql_parse (thd=thd@entry=0x7f9661016070, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f96aa3a7910, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:7790
|
#19 0x00007f96a93cc55b in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f9661016070, packet=packet@entry=0x7f9661054071 "show create table t1", packet_length=packet_length@entry=20, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:1799
|
#20 0x00007f96a93cf08d in do_command (thd=0x7f9661016070) at /data/src/10.2/sql/sql_parse.cc:1359
|
#21 0x00007f96a94bcf4a in do_handle_one_connection (connect=connect@entry=0x7f96a645ff70) at /data/src/10.2/sql/sql_connect.cc:1354
|
#22 0x00007f96a94bd133 in handle_one_connection (arg=0x7f96a645ff70) at /data/src/10.2/sql/sql_connect.cc:1260
|
#23 0x00007f96a8abe0a4 in start_thread (arg=0x7f96aa3a9300) at pthread_create.c:309
|
#24 0x00007f96a72de87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
No crash on release build.
Attachments
Issue Links
- relates to
-
MDEV-5800 indexes on virtual (not materialized) columns
- Closed
Also fails on bb-10.2-monty as of 349d69e2e, only there the CREATE TABLE itself causes the assertion failure:
2017-01-02 14:56:09 0x7f86dbc97300 InnoDB: Assertion failure in file /data/src/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc line 14284
InnoDB: Failing assertion: !((ai)->vcol_info && !(ai)->stored_in_db())
#6 0x00007f86db264eba in ut_dbg_assertion_failed (expr=0x7f86db73b9a8 "!((ai)->vcol_info && !(ai)->stored_in_db())", file=0x7f86db735a38 "/data/src/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc", line=14284) at /data/src/bb-10.2-monty/storage/innobase/ut/ut0dbg.cc:59
#7 0x00007f86db047bc6 in create_table_info_t::create_table_update_dict (this=0x7f86dbc91f50) at /data/src/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc:14284
#8 0x00007f86db047f75 in ha_innobase::create (this=0x7f86918bb888, name=0x7f86dbc94f50 "./test/t1", form=0x7f86dbc92740, create_info=0x7f86dbc95550) at /data/src/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc:14396
#9 0x00007f86dadfe8e0 in handler::ha_create (this=0x7f86918bb888, name=0x7f86dbc94f50 "./test/t1", form=0x7f86dbc92740, info_arg=0x7f86dbc95550) at /data/src/bb-10.2-monty/sql/handler.cc:4362
#10 0x00007f86dadff7eb in ha_create_table (thd=0x7f8691816070, path=0x7f86dbc94f50 "./test/t1", db=0x7f8691860790 "test", table_name=0x7f8691860150 "t1", create_info=0x7f86dbc95550, frm=0x7f86dbc94f40) at /data/src/bb-10.2-monty/sql/handler.cc:4733
#11 0x00007f86daca23d6 in rea_create_table (thd=0x7f8691816070, frm=0x7f86dbc94f40, path=0x7f86dbc94f50 "./test/t1", db=0x7f8691860790 "test", table_name=0x7f8691860150 "t1", create_info=0x7f86dbc95550, file=0x7f8691860f90, no_ha_create_table=false) at /data/src/bb-10.2-monty/sql/unireg.cc:419
#12 0x00007f86dac52660 in create_table_impl (thd=0x7f8691816070, orig_db=0x7f8691860790 "test", orig_table_name=0x7f8691860150 "t1", db=0x7f8691860790 "test", table_name=0x7f8691860150 "t1", path=0x7f86dbc94f50 "./test/t1", options=..., create_info=0x7f86dbc95550, alter_info=0x7f86dbc954a0, create_table_mode=0, is_trans=0x7f86dbc951ae, key_info=0x7f86dbc94f30, key_count=0x7f86dbc94f24, frm=0x7f86dbc94f40) at /data/src/bb-10.2-monty/sql/sql_table.cc:4870
#13 0x00007f86dac52c49 in mysql_create_table_no_lock (thd=0x7f8691816070, db=0x7f8691860790 "test", table_name=0x7f8691860150 "t1", create_info=0x7f86dbc95550, alter_info=0x7f86dbc954a0, is_trans=0x7f86dbc951ae, create_table_mode=0) at /data/src/bb-10.2-monty/sql/sql_table.cc:4981
#14 0x00007f86dac52ebd in mysql_create_table (thd=0x7f8691816070, create_table=0x7f8691860188, create_info=0x7f86dbc95550, alter_info=0x7f86dbc954a0) at /data/src/bb-10.2-monty/sql/sql_table.cc:5044
#15 0x00007f86dab8ddee in mysql_execute_command (thd=0x7f8691816070) at /data/src/bb-10.2-monty/sql/sql_parse.cc:3921
#16 0x00007f86dab9a828 in mysql_parse (thd=0x7f8691816070, rawbuf=0x7f8691860088 "create table t1 (i int, vc serial as (i))", length=41, parser_state=0x7f86dbc95e20, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-monty/sql/sql_parse.cc:7839
#17 0x00007f86dab883ee in dispatch_command (command=COM_QUERY, thd=0x7f8691816070, packet=0x7f8691854071 "create table t1 (i int, vc serial as (i))", packet_length=41, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-monty/sql/sql_parse.cc:1799
#18 0x00007f86dab86dc8 in do_command (thd=0x7f8691816070) at /data/src/bb-10.2-monty/sql/sql_parse.cc:1359
#19 0x00007f86daccec5a in do_handle_one_connection (connect=0x7f86d785ff70) at /data/src/bb-10.2-monty/sql/sql_connect.cc:1354
#20 0x00007f86dacce9e7 in handle_one_connection (arg=0x7f86d785ff70) at /data/src/bb-10.2-monty/sql/sql_connect.cc:1260
#21 0x00007f86da1bb0a4 in start_thread (arg=0x7f86dbc97300) at pthread_create.c:309
#22 0x00007f86d816887d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111