[Draft] Server crashes in table_already_fk_prelocked

2019-01-25 23:10:05 139809848370944 [ERROR] InnoDB: In ALTER TABLE `test`.`oltp2` has or is referenced in foreign key constraints which are not compatible with the new table definition.

2019-01-25 23:10:05 139809848674048 [ERROR] InnoDB: In ALTER TABLE `test`.`oltp2` has or is referenced in foreign key constraints which are not compatible with the new table definition.

2019-01-25 23:10:05 139809848370944 [ERROR] InnoDB: In ALTER TABLE `test`.`oltp2` has or is referenced in foreign key constraints which are not compatible with the new table definition.

2019-01-25 23:10:05 139809847158528 [ERROR] InnoDB: Operating system error number 17 in a file operation.

2019-01-25 23:10:05 139809847158528 [ERROR] InnoDB: Error number 17 means 'File exists'

2019-01-25 23:10:05 139809847158528 [ERROR] InnoDB: Cannot create file './test/#sql-15b0_13.ibd'

2019-01-25 23:10:05 139809847158528 [ERROR] InnoDB: Operating system error number 17 in a file operation.

2019-01-25 23:10:05 139809847158528 [ERROR] InnoDB: Error number 17 means 'File exists'

2019-01-25 23:10:05 139809847158528 [ERROR] InnoDB: Cannot create file './test/#sql-15b0_13.ibd'

2019-01-25 23:10:05 139809848370944 [ERROR] InnoDB: In ALTER TABLE `test`.`oltp2` has or is referenced in foreign key constraints which are not compatible with the new table definition.

190125 23:10:05 [ERROR] mysqld got signal 11 ;

#3  <signal handler called>

#4  table_already_fk_prelocked (tl=0x1, db=0x7f27bc0872a0, table=0x7f27bc0872b8, lock_type=lock_type@entry=TL_READ_NO_INSERT) at /home/travis/src/sql/sql_base.cc:4261

#5  0x00005602ba90fde7 in mysql_alter_table (thd=thd@entry=0x7f27bc000a88, new_db=<optimized out>, new_name=<optimized out>, create_info=create_info@entry=0x7f280458da80, table_list=table_list@entry=0x7f27bc070dd0, alter_info=alter_info@entry=0x7f280458d9d0, order_num=0, order=0x0, ignore=false) at /home/travis/src/sql/sql_table.cc:9549

#6  0x00005602ba956b4c in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7f27bc000a88) at /home/travis/src/sql/sql_alter.cc:329

#7  0x00005602ba88ac57 in mysql_execute_command (thd=0x7f27bc000a88) at /home/travis/src/sql/sql_parse.cc:6228

#8  0x00005602bab11214 in sp_instr_stmt::exec_core (this=0x7f27bc071638, thd=<optimized out>, nextp=0x7f280458f8d4) at /home/travis/src/sql/sp_head.cc:3246

#9  0x00005602bab16f37 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f27bc071678, thd=thd@entry=0x7f27bc000a88, nextp=nextp@entry=0x7f280458f8d4, open_tables=open_tables@entry=false, instr=instr@entry=0x7f27bc071638) at /home/travis/src/sql/sp_head.cc:3009

#10 0x00005602bab17564 in sp_instr_stmt::execute (this=0x7f27bc071638, thd=0x7f27bc000a88, nextp=0x7f280458f8d4) at /home/travis/src/sql/sp_head.cc:3162

#11 0x00005602bab13d6b in sp_head::execute (this=this@entry=0x7f27bc06fe00, thd=thd@entry=0x7f27bc000a88, merge_da_on_success=merge_da_on_success@entry=true) at /home/travis/src/sql/sp_head.cc:1327

#12 0x00005602bab1533a in sp_head::execute_procedure (this=0x7f27bc06fe00, thd=thd@entry=0x7f27bc000a88, args=0x7f27bc0051e0) at /home/travis/src/sql/sp_head.cc:2116

#13 0x00005602ba883004 in do_execute_sp (thd=thd@entry=0x7f27bc000a88, sp=<optimized out>) at /home/travis/src/sql/sql_parse.cc:2915

#14 0x00005602ba88ae32 in mysql_execute_command (thd=thd@entry=0x7f27bc000a88) at /home/travis/src/sql/sql_parse.cc:5838

#15 0x00005602ba89282d in mysql_parse (thd=0x7f27bc000a88, rawbuf=<optimized out>, length=37, parser_state=0x7f2804591260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /home/travis/src/sql/sql_parse.cc:8015

#16 0x00005602ba895464 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f27bc000a88, packet=packet@entry=0x7f27bc006dc9 "CALL sp_5590 /* QNO 2396 CON_ID 15 */ ", packet_length=packet_length@entry=38, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/travis/src/sql/sql_parse.cc:1826

#17 0x00005602ba895d4f in do_command (thd=0x7f27bc000a88) at /home/travis/src/sql/sql_parse.cc:1379

#18 0x00005602ba953ea4 in do_handle_one_connection (connect=connect@entry=0x5602bd3b5a98) at /home/travis/src/sql/sql_connect.cc:1335

#19 0x00005602ba954014 in handle_one_connection (arg=0x5602bd3b5a98) at /home/travis/src/sql/sql_connect.cc:1241

#20 0x00007f28102ab6ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0

#21 0x00007f280f74041d in clone () from /lib/x86_64-linux-gnu/libc.so.6

perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1548457779 --reporters=Backtrace,ErrorLog,Deadlock --engine=InnoDB --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/foreign_keys.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/sql_mode.yy --mysqld=--log_output=FILE --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/mariadb/oltp-transactional.yy --gendata=conf/mariadb/oltp.zz --scenario=MariaBackupIncremental