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

Assertion failure in file ha_innodb.cc line 9690, Failing assertion: ut_strcmp(index->name, key->name) == 0

    XMLWordPrintable

    Details

      Description

      2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610613581568 [ERROR] InnoDB: Index for key no 1 mysql name axcfgrtys_axcfgrtypr_lorzutc_id_cd08a4ed_fk_lorzutcs_ Inno
      DB name lorzutc_id for table datbas/#sql-3ea1_2650bebf
      2019-03-06 16:15:11 140610613581568 [Note] InnoDB: Index for key no 1 mysql name axcfgrtys_axcfgrtypr_lorzutc_id_cd08a4ed_fk_lorzutcs_ InnoD
      B name PRIMARY for table datbas/#sql-3ea1_2650bebf
      2019-03-06 16:15:11 140610613581568 [Note] InnoDB: Index for key no 1 mysql name axcfgrtys_axcfgrtypr_lorzutc_id_cd08a4ed_fk_lorzutcs_ InnoD
      B name lorzutc_id for table datbas/#sql-3ea1_2650bebf
      2019-03-06 16:15:11 0x7fe275ac9700 InnoDB: Assertion failure in file /var/tmp/portage/dev-db/mariadb-10.2.17/work/mysql/storage/innobase/han
      dler/ha_innodb.cc line 9690
      InnoDB: Failing assertion: ut_strcmp(index->name, key->name) == 0
      InnoDB: We intentionally generate a memory trap.
      InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
      InnoDB: If you get repeated assertion failures or crashes, even
      InnoDB: immediately after the mysqld startup, there may be
      InnoDB: corruption in the InnoDB tablespace. Please refer to
      InnoDB: https://mariadb.com/kb/en/library/xtradbinnodb-recovery-modes/
      InnoDB: about forcing recovery.
      190306 16:15:11 [ERROR] mysqld got signal 6 ;
      This could be because you hit a bug. It is also possible that this binary
      or one of the libraries it was linked against is corrupt, improperly built,
      or misconfigured. This error can also be caused by malfunctioning hardware.

      Server version: 10.2.17-MariaDB-log
      key_buffer_size=134217728
      read_buffer_size=524288
      max_used_connections=382
      max_threads=1502
      thread_count=310

      Thread pointer: 0x7fe1b8312118
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      stack_bottom = 0x7fe275ac8e78 thread_stack 0x49000
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
      2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'

      /usr/sbin/mysqld(my_print_stacktrace+0x29)[0x5586cc507889]
      /usr/sbin/mysqld(handle_fatal_signal+0x57b)[0x5586cc04e81b]
      /lib64/libpthread.so.0(+0x14180)[0x7fe5e06d6180]
      /lib64/libc.so.6(gsignal+0x110)[0x7fe5df1a6f90]
      /lib64/libc.so.6(abort+0x1c7)[0x7fe5df1a8ae7]
      /usr/sbin/mysqld(+0x3fed44)[0x5586cbe49d44]
      /usr/sbin/mysqld(+0x773bfb)[0x5586cc1bebfb]
      /usr/sbin/mysqld(+0x77bed3)[0x5586cc1c6ed3]
      /usr/sbin/mysqld(+0x77dbb7)[0x5586cc1c8bb7]
      /usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcij+0x2a)[0x5586cc05250a]
      /usr/sbin/mysqld(_Z21open_table_from_shareP3THDP11TABLE_SHAREPKcjjjP5TABLEb+0x7de)[0x5586cbf88bae]
      /usr/sbin/mysqld(_ZN3THD20open_temporary_tableEP15TMP_TABLE_SHAREPKcb+0x5d)[0x5586cbfffffd]
      /usr/sbin/mysqld(_ZN3THD25create_and_open_tmp_tableEP10handlertonP34st_mysql_const_unsigned_lex_stringPKcS5_S5_b+0x32)[0x5586cc001c02]
      /usr/sbin/mysqld(_Z17mysql_alter_tableP3THDPcS1_P14HA_CREATE_INFOP10TABLE_LISTP10Alter_infojP8st_orderb+0x3794)[0x5586cbf69d04]
      /usr/sbin/mysqld(_ZN19Sql_cmd_alter_table7executeEP3THD+0x50c)[0x5586cbfaea4c]
      /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0xccf)[0x5586cbee919f]
      /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x289)[0x5586cbeef869]
      /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x101e)[0x5586cbef0f4e]
      /usr/sbin/mysqld(_Z10do_commandP3THD+0xdf)[0x5586cbef257f]
      /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x204)[0x5586cbfabea4]
      /usr/sbin/mysqld(handle_one_connection+0x34)[0x5586cbfabf74]
      /lib64/libpthread.so.0(+0x792a)[0x7fe5e06c992a]
      /lib64/libc.so.6(clone+0x3f)[0x7fe5df27361f]

      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7fe1b86f67d0): is an invalid pointer
      Connection ID (thread ID): 642825919
      Status: NOT_KILLED

      Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on

      The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
      information that should help you find out what is causing the crash.

      We think the query pointer is invalid, but we will try to print it anyway.
      Query: ALTER TABLE `axcfgrtys_axcfgrtyprlorzutcasde` ADD CONSTRAINT `axcfgrtys_axcfgrtypr_lorzutc_id_cd08a4ed_fk_lorzutcs_` FOREIGN KEY (`lorzutc_id`) REFERENCES `lorzutcs_lorzutc` (`id`)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              svoj Sergey Vojtovich
              Reporter:
              mike_z Mikhail Zheltukhin
              Votes:
              0 Vote for this issue
              Watchers:
              9 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.