[MDEV-18390] [Draft] Server crashes in table_already_fk_prelocked Created: 2019-01-27  Updated: 2023-06-18  Resolved: 2023-06-18

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

bb-10.2-MDEV-18194 a5f05f498



 Description   

https://travis-ci.org/elenst/travis-tests/jobs/484496653 [2591 14 2]

bb-10.2-MDEV-18194 a5f05f498 non-debug

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

elenst-jira-refs 56fe47273 Toolbox: 572674def

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

Not reproducible right away, hitting various other bugs instead, especially MDEV-17595 and MDEV-18018.


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