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

InnoDB: Failing assertion: !((field)->vcol_info && !(field)->stored_in_db())

Details

    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

          Activity

            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
            

            elenst Elena Stepanova added a comment - 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

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.