2022-07-21 20:29:32 0x2ab31fd10700 InnoDB: Assertion failure in file /local/p4clients/pkgbuild-B8mzg/workspace/src/RDSMariaDB/storage/innobase/trx/trx0trx.cc line 918
|
InnoDB: Failing assertion: trx->lock.table_locks.empty()
|
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 mariadbd startup, there may be
|
InnoDB: corruption in the InnoDB tablespace. Please refer to
|
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
|
InnoDB: about forcing recovery.
|
220721 20:29:32 [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.
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
Server version: 10.6.5-MariaDB
|
key_buffer_size=4096
|
read_buffer_size=262144
|
max_used_connections=4
|
max_threads=10002
|
thread_count=5
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 23289949 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x2acbc600f258
|
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...
|
stack_bottom = 0x2ab31fd0e5b8 thread_stack 0x40000
|
Can't start addr2line
|
/rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x2e)[0x5582024733ae]
|
/rdsdbbin/mysql/bin/mysqld(handle_fatal_signal+0x51b)[0x558201c6d78b]
|
/lib64/libpthread.so.0(+0xf100)[0x2ab320ad9100]
|
/lib64/libc.so.6(gsignal+0x37)[0x2ab320d1b5f7]
|
/lib64/libc.so.6(abort+0x148)[0x2ab320d1cce8]
|
/rdsdbbin/mysql/bin/mysqld(+0x74bf8a)[0x55820196ff8a]
|
/rdsdbbin/mysql/bin/mysqld(+0x10b5f81)[0x5582022d9f81]
|
/rdsdbbin/mysql/bin/mysqld(+0x1025d54)[0x558202249d54]
|
/rdsdbbin/mysql/bin/mysqld(+0x10260a0)[0x55820224a0a0]
|
/rdsdbbin/mysql/bin/mysqld(+0x105b81c)[0x55820227f81c]
|
/rdsdbbin/mysql/bin/mysqld(+0xf91454)[0x5582021b5454]
|
/rdsdbbin/mysql/bin/mysqld(+0xf9f0bd)[0x5582021c30bd]
|
/rdsdbbin/mysql/bin/mysqld(_Z18mysql_rename_tableP10handlertonPK25st_mysql_const_lex_stringS3_S3_S3_P34st_mysql_const_unsigned_lex_stringj+0x160)[0x558201af07a0]
|
/rdsdbbin/mysql/bin/mysqld(_Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P14HA_CREATE_INFOP10TABLE_LISTP10Alter_infojP8st_orderbb+0x54e1)[0x558201afc7c1]
|
/rdsdbbin/mysql/bin/mysqld(_ZN19Sql_cmd_alter_table7executeEP3THD+0x3c9)[0x558201b5d929]
|
/rdsdbbin/mysql/bin/mysqld(_Z21mysql_execute_commandP3THDb+0x2b1d)[0x558201a6768d]
|
/rdsdbbin/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x1c9)[0x558201a6b139]
|
/rdsdbbin/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjb+0xcea)[0x558201a622da]
|
/rdsdbbin/mysql/bin/mysqld(_Z10do_commandP3THDb+0xf7)[0x558201a61417]
|
/rdsdbbin/mysql/bin/mysqld(_Z24do_handle_one_connectionP7CONNECTb+0x3c3)[0x558201b58ed3]
|
/rdsdbbin/mysql/bin/mysqld(handle_one_connection+0x34)[0x558201b591f4]
|
/rdsdbbin/mysql/bin/mysqld(+0xf0f2fc)[0x5582021332fc]
|
/lib64/libpthread.so.0(+0x7dc5)[0x2ab320ad1dc5]
|
/lib64/libc.so.6(clone+0x6d)[0x2ab320ddcc9d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x2acbc604fd70): ALTER TABLE `x`.`y` ENGINE=InnoDB, ALGORITHM=COPY
|
|
Connection ID (thread ID): 109723
|
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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off
|
|
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
|
information that should help you find out what is causing the crash.
|
Writing a core file...
|
Working directory at /rdsdbdata/db
|
Resource Limits:
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size unlimited unlimited bytes
|
Max core file size 0 unlimited bytes
|
Max resident set unlimited unlimited bytes
|
Max processes unlimited unlimited processes
|
Max open files 1048576 1048576 files
|
Max locked memory 65536 65536 bytes
|
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 509814 509814 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Max realtime timeout unlimited unlimited us
|
Core pattern: /rdsdbdata/tmp/core-%e-%p
|