Assertion `v.v_indexes.empty()' failed in dict_table_t::instant_column

10.5.6 compiled with debug and ASAN

origin/10.5 938db04898ee9029421f5251751239255dd81c15 2020-09-03T16:40:42+03:00

suite/innodb/t/TBR-234.test

--------------------------------------------

--source include/have_innodb.inc

CREATE TABLE IF NOT EXISTS t4 (

    col_int INTEGER,

    col_text TEXT,

    col_int_g INTEGER GENERATED ALWAYS AS (col_int),

    col_text_g TEXT GENERATED ALWAYS AS (SUBSTR(col_text,1,499)) )

ENGINE = InnoDB ROW_FORMAT = Redundant  ;

ALTER TABLE t4 MODIFY COLUMN col_text TEXT NOT NULL ;

ALTER TABLE t4 ADD UNIQUE ( col_int_g ) ;

ALTER TABLE t4 MODIFY COLUMN col_text TEXT NULL ;

DROP TABLE t4;

./mtr --mem --suite=innodb TBR-234

...

mariadbd: storage/innobase/handler/handler0alter.cc:572: bool dict_table_t::instant_column(const dict_table_t&, const ulint*): Assertion `v.v_indexes.empty()' failed.

...

Query (0x62b0000a1238): ALTER TABLE t4 MODIFY COLUMN col_text TEXT NULL

Connection ID (thread ID): 4

Status: NOT_KILLED

Thread 1 (Thread 0x7f9c4b170300 (LWP 19070)):

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57

#1  0x0000557d93de28ed in my_write_core (sig=sig@entry=6) at mysys/stacktrace.c:424

#2  0x0000557d92611436 in handle_fatal_signal (sig=<optimized out>) at sql/signal_handler.cc:330

#3  <signal handler called>

#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51

#5  0x00007f9c59635f5d in __GI_abort () at abort.c:90

#6  0x00007f9c5962bf17 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x557d946ac000 "v.v_indexes.empty()", file=file@entry=0x557d9469fb60 "storage/innobase/handler/handler0alter.cc", line=line@entry=572, function=function@entry=0x557d946b4300 <dict_table_t::instant_column(dict_table_t const&, unsigned long const*)::__PRETTY_FUNCTION__> "bool dict_table_t::instant_column(const dict_table_t&, const ulint*)") at assert.c:92

#7  0x00007f9c5962bfc2 in __GI___assert_fail (assertion=assertion@entry=0x557d946ac000 "v.v_indexes.empty()", file=file@entry=0x557d9469fb60 "storage/innobase/handler/handler0alter.cc", line=line@entry=572, function=function@entry=0x557d946b4300 <dict_table_t::instant_column(dict_table_t const&, unsigned long const*)::__PRETTY_FUNCTION__> "bool dict_table_t::instant_column(const dict_table_t&, const ulint*)") at assert.c:101

#8  0x0000557d93299119 in dict_table_t::instant_column (this=0x6190000e1620, table=..., col_map=<optimized out>) at storage/innobase/handler/handler0alter.cc:572

#9  0x0000557d9329a7ef in ha_innobase_inplace_ctx::instant_column (this=this@entry=0x62b0000a3090) at storage/innobase/handler/handler0alter.cc:1051

#10 0x0000557d9329dc12 in innobase_instant_try (ha_alter_info=ha_alter_info@entry=0x7f9c4b1698e0, ctx=ctx@entry=0x62b0000a3090, altered_table=altered_table@entry=0x7f9c4b169e20, table=table@entry=0x6190000e7e98, trx=trx@entry=0x7f9c50d3cb90) at storage/innobase/handler/handler0alter.cc:5634

#11 0x0000557d932a2e29 in commit_try_norebuild (ha_alter_info=ha_alter_info@entry=0x7f9c4b1698e0, ctx=ctx@entry=0x62b0000a3090, altered_table=altered_table@entry=0x7f9c4b169e20, old_table=<optimized out>, trx=trx@entry=0x7f9c50d3cb90, table_name=<optimized out>) at storage/innobase/handler/handler0alter.cc:10198

#12 0x0000557d93270dcf in ha_innobase::commit_inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=<optimized out>, commit=<optimized out>) at storage/innobase/handler/handler0alter.cc:10919

#13 0x0000557d926401bb in handler::ha_commit_inplace_alter_table (this=0x61d000260cb8, altered_table=altered_table@entry=0x7f9c4b169e20, ha_alter_info=ha_alter_info@entry=0x7f9c4b1698e0, commit=commit@entry=true) at sql/handler.cc:4843

#14 0x0000557d92042267 in mysql_inplace_alter_table (thd=thd@entry=0x62b00009a218, table_list=0x62b0000a1370, table=table@entry=0x6190000e7e98, altered_table=<optimized out>, ha_alter_info=<optimized out>, target_mdl_request=<optimized out>, alter_ctx=<optimized out>) at sql/sql_table.cc:8040

#15 0x0000557d92078e3b in mysql_alter_table (thd=thd@entry=0x62b00009a218, new_db=<optimized out>, new_name=new_name@entry=0x62b00009f060, create_info=create_info@entry=0x7f9c4b16bae0, table_list=<optimized out>, table_list@entry=0x62b0000a1370, alter_info=alter_info@entry=0x7f9c4b16b9e0, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at sql/sql_table.cc:10570

#16 0x0000557d922266fd in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x62b00009a218) at sql/sql_alter.cc:534

#17 0x0000557d91d88c7d in mysql_execute_command (thd=thd@entry=0x62b00009a218) at sql/sql_parse.cc:5952

#18 0x0000557d91da10f5 in mysql_parse (thd=thd@entry=0x62b00009a218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f9c4b16e000, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at sql/sql_parse.cc:7994

#19 0x0000557d91d66522 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62b00009a218, packet=packet@entry=0x629000285219 "ALTER TABLE t4 MODIFY COLUMN col_text TEXT NULL ", packet_length=packet_length@entry=48, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at sql/sql_parse.cc:1867

#20 0x0000557d91d61367 in do_command (thd=0x62b00009a218) at sql/sql_parse.cc:1348

#21 0x0000557d9220b9e1 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x6080000027b8, put_in_cache=put_in_cache@entry=true) at sql/sql_connect.cc:1410

#22 0x0000557d9220ccac in handle_one_connection (arg=arg@entry=0x6080000027b8) at sql/sql_connect.cc:1312

#23 0x0000557d92f973fa in pfs_spawn_thread (arg=0x615000008c98) at storage/perfschema/pfs.cc:2201

#24 0x00007f9c5a4db7fc in start_thread (arg=0x7f9c4b170300) at pthread_create.c:465

#25 0x00007f9c59711b5f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95