Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.2.17
-
None
-
Gentoo 4.14.13, 2x E5-2620
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
- duplicates
-
MDEV-16060 InnoDB: Failing assertion: ut_strcmp(index->name, key->name)
- Closed
- relates to
-
MDEV-19037 Crashing on adding index / index name could not added again in same tablespace
- Closed