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

[Draft] Server crashed in ha_innobase::index_type

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.2(EOL), 10.4(EOL)
    • N/A
    • None
    • 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.

      Attachments

        Activity

          People

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