Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
10.4.13
-
redhat 8+MariaDB 10.4.13
Description
airflow搭建好后,初始化数据时,MariaDB出现直接重启,系统日志为:
Jul 14 19:27:32 dsjdbc kernel: mysqld[29850]: segfault at 32100000000 ip 00007f43a3dada9f sp 00007f42b55aa3d0 error 4 in libgcc_s-8-20190507.so.1[7f43a3d9e000+17000] |
Jul 14 19:27:32 dsjdbc kernel: Code: 09 c1 84 d2 78 e5 c6 85 72 01 00 00 01 4e 8d 04 0b 41 0f b6 44 24 01 49 83 c4 01 e9 64 fd ff ff 0f 1f 00 49 8b 85 98 00 00 00 <80> 38 48 75 9c 48 ba c7 c0 0f 00 00 00 0f 05 48 39 50 01 75 8c 49 |
MariaDB日志为:
200714 19:27:32 [ERROR] mysqld got signal 11 ; |
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.13-MariaDB-log |
key_buffer_size=268435456 |
read_buffer_size=1048576 |
max_used_connections=24 |
max_threads=514 |
thread_count=20 |
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1327480 K bytes of memory |
Hope that's ok; if not, decrease some variables in the equation. |
|
Thread pointer: 0x7fa8d4000c08 |
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 = 0x7fa8fd144e80 thread_stack 0x49000 |
2020-07-14 19:27:32 0 [Note] WSREP: (8d49802c-9a42, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://21.144.233.44:4567 |
/usr/local/mysql/bin/mysqld(my_print_stacktrace+0x2e)[0x55da3ff6ae2e] |
/usr/local/mysql/bin/mysqld(handle_fatal_signal+0x30f)[0x55da3f97bb3f] |
/lib64/libpthread.so.0(+0x12dc0)[0x7fa8fceb1dc0] |
/usr/local/mysql/bin/mysqld(_ZN12Item_func_in7cleanupEv+0x37)[0x55da3faa9b07] |
/usr/local/mysql/bin/mysqld(_ZN11Query_arena10free_itemsEv+0x30)[0x55da3f727280] |
/usr/local/mysql/bin/mysqld(_ZN3THD19cleanup_after_queryEv+0x5c)[0x55da3f72957c] |
/usr/local/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x20c)[0x55da3f779e4c] |
/usr/local/mysql/bin/mysqld(_ZN15Query_log_event14do_apply_eventEP14rpl_group_infoPKcj+0x8f4)[0x55da3fa7b864] |
/usr/local/mysql/bin/mysqld(_Z18wsrep_apply_eventsP3THDP14Relay_log_infoPKvm+0x23d)[0x55da3f8efe4d] |
/usr/local/mysql/bin/mysqld(_ZN27Wsrep_high_priority_service9apply_toiERKN5wsrep7ws_metaERKNS0_12const_bufferERNS0_14mutable_bufferE+0xbc)[0x55da3f8da50c] |
/usr/local/mysql/bin/mysqld(_ZN5wsrep12server_state8on_applyERNS_21high_priority_serviceERKNS_9ws_handleERKNS_7ws_metaERKNS_12const_bufferE+0x138)[0x55da40006988] |
/usr/local/mysql/bin/mysqld(+0xfc48d1)[0x55da400168d1] |
/usr/local/mysql/lib/galera-4/libgalera_smm.so(+0x164746)[0x7fa8f9463746] |
/usr/local/mysql/lib/galera-4/libgalera_smm.so(+0x1a461d)[0x7fa8f94a361d] |
/usr/local/mysql/lib/galera-4/libgalera_smm.so(+0x1a4b19)[0x7fa8f94a3b19] |
/usr/local/mysql/lib/galera-4/libgalera_smm.so(+0x17f557)[0x7fa8f947e557] |
/usr/local/mysql/lib/galera-4/libgalera_smm.so(+0x17fbb2)[0x7fa8f947ebb2] |
/usr/local/mysql/lib/galera-4/libgalera_smm.so(+0x17fd8d)[0x7fa8f947ed8d] |
/usr/local/mysql/lib/galera-4/libgalera_smm.so(+0x1a3e83)[0x7fa8f94a2e83] |
/usr/local/mysql/lib/galera-4/libgalera_smm.so(+0x1bd6a3)[0x7fa8f94bc6a3] |
/usr/local/mysql/bin/mysqld(_ZN5wsrep18wsrep_provider_v2611run_applierEPNS_21high_priority_serviceE+0xe)[0x55da4001539e] |
/usr/local/mysql/bin/mysqld(+0x89f952)[0x55da3f8f1952] |
/usr/local/mysql/bin/mysqld(_Z15start_wsrep_THDPv+0x35d)[0x55da3f8e4d6d] |
/lib64/libpthread.so.0(+0x82de)[0x7fa8fcea72de] |
/lib64/libc.so.6(clone+0x43)[0x7fa8fbc88133] |
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7fa8d4036376): CREATE INDEX ix_kombu_message_visible ON kombu_message (visible) |
Connection ID (thread ID): 2 |
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 |
|
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.
|
Writing a core file...
|
Working directory at /mysql/data
|
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 8388608 unlimited bytes |
Max core file size 104857600 104857600 bytes |
Max resident set unlimited unlimited bytes
|
Max processes 5000 5000 processes |
Max open files 65535 65535 files |
Max locked memory 16777216 16777216 bytes |
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 63366 63366 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: "/corefile/core-%...
|