[MDEV-18389] [Draft] Server crashed in ha_innobase::index_type Created: 2019-01-27  Updated: 2023-06-19  Resolved: 2023-06-19

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2, 10.4
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 a5f05f498874b35a66e4562028c2e6f56f76e517 non-debug



 Description   

https://travis-ci.org/elenst/travis-tests/jobs/484496657 [2591 18 3]

bb-10.2-MDEV-18194 a5f05f498874b35a66e4562028c2e6f56f76e517 non-debug

...
2019-01-25 23:43:44 140402286876416 [ERROR] InnoDB: Failed to load table '`test`.`#sql-1cd1_e`' which has a foreign key constraint with table '`test`.`E`'.
2019-01-25 23:43:44 140402286876416 [ERROR] Cannot find index idx_25 in InnoDB index dictionary.
2019-01-25 23:43:44 140402286876416 [ERROR] InnoDB indexes are inconsistent with what defined in .frm for table ./test/E
2019-01-25 23:43:44 140402286876416 [ERROR] InnoDB could not find key no 14 with name idx_25 from dict cache for table test/E
2019-01-25 23:43:44 140402286876416 [ERROR] InnoDB: Table test/E contains 15 indexes inside InnoDB, which is different from the number of indexes 15 defined in the MariaDB  Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html
2019-01-25 23:43:44 140402286573312 [ERROR] Cannot find index idx_25 in InnoDB index dictionary.
2019-01-25 23:43:44 140402286573312 [ERROR] InnoDB indexes are inconsistent with what defined in .frm for table ./test/E
2019-01-25 23:43:44 140402286573312 [ERROR] InnoDB could not find key no 14 with name idx_25 from dict cache for table test/E
2019-01-25 23:43:44 140402286573312 [ERROR] InnoDB: Table test/E contains 15 indexes inside InnoDB, which is different from the number of indexes 15 defined in the MariaDB  Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html
2019-01-25 23:43:44 140402285360896 [ERROR] Cannot find index idx_25 in InnoDB index dictionary.
2019-01-25 23:43:44 140402285360896 [ERROR] InnoDB indexes are inconsistent with what defined in .frm for table ./test/E
2019-01-25 23:43:44 140402285360896 [ERROR] InnoDB could not find key no 14 with name idx_25 from dict cache for table test/E
2019-01-25 23:43:44 140402285360896 [ERROR] InnoDB: Table test/E contains 15 indexes inside InnoDB, which is different from the number of indexes 15 defined in the MariaDB  Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html
2019-01-25 23:43:44 140402286876416 [ERROR] Cannot find index idx_25 in InnoDB index dictionary.
2019-01-25 23:43:44 140402286876416 [ERROR] InnoDB indexes are inconsistent with what defined in .frm for table ./test/E
2019-01-25 23:43:44 140402286876416 [ERROR] InnoDB could not find key no 14 with name idx_25 from dict cache for table test/E
2019-01-25 23:43:44 140402286876416 [ERROR] InnoDB: Table test/E contains 15 indexes inside InnoDB, which is different from the number of indexes 15 defined in the MariaDB  Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html
2019-01-25 23:43:44 140402286876416 [ERROR] Cannot find index idx_25 in InnoDB index dictionary.
2019-01-25 23:43:44 140402286876416 [ERROR] InnoDB indexes are inconsistent with what defined in .frm for table ./test/E
2019-01-25 23:43:44 140402286876416 [ERROR] InnoDB could not find key no 14 with name idx_25 from dict cache for table test/E
2019-01-25 23:43:44 140402286876416 [ERROR] InnoDB: Table test/E contains 15 indexes inside InnoDB, which is different from the number of indexes 15 defined in the MariaDB  Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html
2019-01-25 23:43:44 140402286876416 [ERROR] Cannot find index idx_25 in InnoDB index dictionary.
2019-01-25 23:43:44 140402286876416 [ERROR] InnoDB indexes are inconsistent with what defined in .frm for table ./test/E
2019-01-25 23:43:44 140402286876416 [ERROR] InnoDB could not find key no 14 with name idx_25 from dict cache for table test/E
2019-01-25 23:43:44 140402286876416 [ERROR] InnoDB: Table test/E contains 15 indexes inside InnoDB, which is different from the number of indexes 15 defined in the MariaDB  Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html
2019-01-25 23:43:44 140402286270208 [ERROR] Cannot find index idx_25 in InnoDB index dictionary.
2019-01-25 23:43:44 140402286270208 [ERROR] InnoDB indexes are inconsistent with what defined in .frm for table ./test/E
2019-01-25 23:43:44 140402286270208 [ERROR] InnoDB could not find key no 14 with name idx_25 from dict cache for table test/E
2019-01-25 23:43:44 140402286270208 [ERROR] InnoDB: Table test/E contains 15 indexes inside InnoDB, which is different from the number of indexes 15 defined in the MariaDB  Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html
2019-01-25 23:43:45 140402285967104 [ERROR] InnoDB could not find key no 14 with name idx_25 from dict cache for table test/E
190125 23:43:45 [ERROR] mysqld got signal 11 ;

#3  <signal handler called>
#4  0x000056221170b170 in ha_innobase::index_type (this=<optimized out>, keynr=<optimized out>) at /home/travis/src/storage/innobase/handler/ha_innodb.cc:5357
#5  0x00005622114776f4 in get_schema_stat_record (thd=0x7fb1c8000a88, tables=<optimized out>, table=0x7fb1c80916e0, res=<optimized out>, db_name=0x7fb1f4612a30, table_name=0x7fb1f4612ab0) at /home/travis/src/sql/sql_show.cc:6276
#6  0x000056221146f788 in fill_schema_table_by_open (thd=thd@entry=0x7fb1c8000a88, is_show_fields_or_keys=is_show_fields_or_keys@entry=true, table=table@entry=0x7fb1c80916e0, schema_table=schema_table@entry=0x56221227a220 <schema_tables+1856>, orig_db_name=orig_db_name@entry=0x7fb1f4612a30, orig_table_name=orig_table_name@entry=0x7fb1f4612ab0, open_tables_state_backup=0x7fb1f4612a50, can_deadlock=false) at /home/travis/src/sql/sql_show.cc:4401
#7  0x00005622114801b0 in get_all_tables (thd=0x7fb1c8000a88, tables=0x7fb1c8010a90, cond=<optimized out>) at /home/travis/src/sql/sql_show.cc:4889
#8  0x0000562211481c9f in get_schema_tables_result (join=join@entry=0x7fb1c80124d0, executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at /home/travis/src/sql/sql_show.cc:8382
#9  0x0000562211469476 in JOIN::exec_inner (this=this@entry=0x7fb1c80124d0) at /home/travis/src/sql/sql_select.cc:3587
#10 0x0000562211469af9 in JOIN::exec (this=this@entry=0x7fb1c80124d0) at /home/travis/src/sql/sql_select.cc:3418
#11 0x0000562211469c3e in mysql_select (thd=thd@entry=0x7fb1c8000a88, tables=0x7fb1c8010a90, wild_num=<optimized out>, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=552440433408, result=0x7fb1c80124b0, unit=0x7fb1c80044a8, select_lex=0x7fb1c8004be0) at /home/travis/src/sql/sql_select.cc:3818
#12 0x000056221146a57e in handle_select (thd=thd@entry=0x7fb1c8000a88, lex=lex@entry=0x7fb1c80043e0, result=result@entry=0x7fb1c80124b0, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/travis/src/sql/sql_select.cc:376
#13 0x0000562211369886 in execute_sqlcom_select (thd=thd@entry=0x7fb1c8000a88, all_tables=0x7fb1c8010a90) at /home/travis/src/sql/sql_parse.cc:6481
#14 0x000056221141e5dc in mysql_execute_command (thd=thd@entry=0x7fb1c8000a88) at /home/travis/src/sql/sql_parse.cc:3487
#15 0x000056221142082d in mysql_parse (thd=0x7fb1c8000a88, rawbuf=<optimized out>, length=46, parser_state=0x7fb1f4616260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /home/travis/src/sql/sql_parse.cc:8015
#16 0x0000562211423464 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fb1c8000a88, packet=packet@entry=0x7fb1c8006dc9 "SHOW INDEXES FROM `E`  /* QNO 991 CON_ID 16 */ ", packet_length=packet_length@entry=47, 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 0x0000562211423d4f in do_command (thd=0x7fb1c8000a88) at /home/travis/src/sql/sql_parse.cc:1379
#18 0x00005622114e1ea4 in do_handle_one_connection (connect=connect@entry=0x5622130dfad8) at /home/travis/src/sql/sql_connect.cc:1335
#19 0x00005622114e2014 in handle_one_connection (arg=0x5622130dfad8) at /home/travis/src/sql/sql_connect.cc:1241
#20 0x00007fb1f7b1c6ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0

elenst-jira-refs 56fe47273 Toolbox: 572674d

perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1548459773 --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/engines/innodb/full_text_search.yy --scenario=Restart

Not reproducible right away.



 Comments   
Comment by Elena Stepanova [ 2019-01-31 ]

Another occurrence: https://dev.azure.com/elenst/MariaDB%20tests/_build/results?buildId=304 (test003)

Comment by Elena Stepanova [ 2019-02-07 ]

Another occurrence on 10.4: https://dev.azure.com/elenst/MariaDB%20tests/_build/results?buildId=705 [test003]

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