mysqld: /home/vsts/src/storage/innobase/trx/trx0purge.cc:268: void trx_purge_add_undo_to_history(const trx_t*, trx_undo_t*&, mtr_t*): Assertion `srv_undo_sources || trx->undo_no == 0 || (!purge_sys.enabled() && (srv_is_being_started || trx_rollback_is_active || srv_force_recovery >= SRV_FORCE_NO_BACKGROUND)) || ((trx->mysql_thd || trx->internal) && srv_fast_shutdown)' failed.
|
190718 2:48:46 [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.4.7-MariaDB-debug-log
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=7
|
max_threads=153
|
thread_count=10
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467838 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
Thread pointer: 0x7f7558001f20
|
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 = 0x7f755d213ec0 thread_stack 0x49000
|
/home/vsts/server/bin/mysqld(my_print_stacktrace+0x40)[0x5582815082f5]
|
/home/vsts/server/bin/mysqld(handle_fatal_signal+0x3ae)[0x558280d320ad]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f757d86c390]
|
linux/raise.c:54(__GI_raise)[0x7f757c9be428]
|
stdlib/abort.c:91(__GI_abort)[0x7f757c9c002a]
|
assert/assert.c:92(__assert_fail_base)[0x7f757c9b6bd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f757c9b6c82]
|
/home/vsts/server/bin/mysqld(+0xf50434)[0x55828115f434]
|
trx/trx0purge.cc:278(trx_purge_add_undo_to_history(trx_t const*, trx_undo_t*&, mtr_t*))[0x55828118560f]
|
trx/trx0trx.cc:1100(trx_write_serialisation_history(trx_t*, mtr_t*))[0x558281187147]
|
trx/trx0trx.cc:1528(trx_commit_low(trx_t*, mtr_t*))[0x5582811872a7]
|
trx/trx0trx.cc:1582(trx_commit(trx_t*))[0x5582811876e8]
|
trx/trx0trx.cc:1724(trx_commit_for_mysql(trx_t*))[0x5582812e6e73]
|
fts/fts0sql.cc:276(fts_sql_commit(trx_t*))[0x5582812d946c]
|
fts/fts0opt.cc:1806(fts_optimize_words(fts_optimize_t*, dict_index_t*, fts_string_t*))[0x5582812d9bc5]
|
fts/fts0opt.cc:1995(fts_optimize_index(fts_optimize_t*, dict_index_t*))[0x5582812da52d]
|
fts/fts0opt.cc:2292(fts_optimize_indexes(fts_optimize_t*))[0x5582812da8e1]
|
fts/fts0opt.cc:2469(fts_optimize_table(dict_table_t*))[0x558280f7aa9e]
|
handler/ha_innodb.cc:14455(ha_innobase::optimize(THD*, st_ha_check_opt*))[0x558280d407d7]
|
sql/handler.cc:4460(handler::ha_optimize(THD*, st_ha_check_opt*))[0x558280b80360]
|
sql/sql_admin.cc:806(mysql_admin_table(THD*, TABLE_LIST*, st_ha_check_opt*, char const*, thr_lock_type, bool, bool, unsigned int, int (*)(THD*, TABLE_LIST*, st_ha_check_opt*), int (handler::*)(THD*, st_ha_check_opt*), int (*)(THD*, TABLE_LIST*, st_ha_check_opt*)))[0x558280b8278a]
|
sql/sql_parse.cc:6098(mysql_execute_command(THD*))[0x558280a01917]
|
sql/sql_parse.cc:7908(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558280a06bce]
|
sql/sql_parse.cc:1845(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5582809f2e3c]
|
sql/sql_parse.cc:1360(do_command(THD*))[0x5582809f1556]
|
sql/sql_connect.cc:1404(do_handle_one_connection(CONNECT*))[0x558280b6b880]
|
sql/sql_connect.cc:1307(handle_one_connection)[0x558280b6b5a9]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f757d8626ba]
|
x86_64/clone.S:111(clone)[0x7f757ca9041d]
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f75580130f8): OPTIMIZE TABLE fti_t5 /* QNO 782 CON_ID 16 */
|
Connection ID (thread ID): 16
|
Status: KILL_SERVER
|
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
|
ML13.test