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

MATCH AGAINST (NULL) consistenly crashes MariaDB 10.4.7

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 10.4.7
    • N/A
    • Server
    • CentOS 7.6.1810

    Description

      Hello,

      The following malformed SQL query consistently crashes MariaDB 10.4.7:

      SELECT uid, name, price, price_base, link, teaser300, MATCH (name) AGAINST (NULL) AS score FROM products WHERE MATCH (name) AGAINST (NULL) ORDER BY score DESC LIMIT 0,10

      Here the crash log:

      Sep  4 11:09:37 mysql mysqld: 190904 11:09:37 [ERROR] mysqld got signal 11 ;
      Sep  4 11:09:37 mysql mysqld: This could be because you hit a bug. It is also possible that this binary
      Sep  4 11:09:37 mysql mysqld: or one of the libraries it was linked against is corrupt, improperly built,
      Sep  4 11:09:37 mysql mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
      Sep  4 11:09:37 mysql mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      Sep  4 11:09:37 mysql mysqld: We will try our best to scrape up some info that will hopefully help
      Sep  4 11:09:37 mysql mysqld: diagnose the problem, but since we have already crashed,
      Sep  4 11:09:37 mysql mysqld: something is definitely wrong and this may fail.
      Sep  4 11:09:37 mysql mysqld: Server version: 10.4.7-MariaDB-log
      Sep  4 11:09:37 mysql mysqld: key_buffer_size=8589934592
      Sep  4 11:09:37 mysql mysqld: read_buffer_size=2097152
      Sep  4 11:09:37 mysql mysqld: max_used_connections=30
      Sep  4 11:09:37 mysql mysqld: max_threads=752
      Sep  4 11:09:37 mysql mysqld: thread_count=36
      Sep  4 11:09:37 mysql mysqld: It is possible that mysqld could use up to
      Sep  4 11:09:37 mysql mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11487264 K  bytes of memory
      Sep  4 11:09:37 mysql mysqld: Hope that's ok; if not, decrease some variables in the equation.
      Sep  4 11:09:37 mysql mysqld: Thread pointer: 0x7f16980009a8
      Sep  4 11:09:37 mysql mysqld: Attempting backtrace. You can use the following information to find out
      Sep  4 11:09:37 mysql mysqld: where mysqld died. If you see no messages after this, something went
      Sep  4 11:09:37 mysql mysqld: terribly wrong...
      Sep  4 11:09:37 mysql mysqld: stack_bottom = 0x7f1761a4ecf0 thread_stack 0x40000
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55acdc0c06be]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x55acdbb4f81f]
      Sep  4 11:09:37 mysql mysqld: sigaction.c:0(__restore_rt)[0x7f2199b485d0]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(_ZNK26Type_handler_string_result13Item_const_eqEPK10Item_constS2_b+0x41)[0x55acdba7d8f1]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(_ZNK15Item_func_match2eqEPK4Itemb+0xa5)[0x55acdbbbc275]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(_Z13setup_ftfuncsP13st_select_lex+0x62)[0x55acdb8e72c2]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x2da)[0x55acdb999fca]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x9d)[0x55acdb99d43d]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xe1)[0x55acdb99d541]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1d7)[0x55acdb99e157]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(+0x5870ea)[0x55acdb8360ea]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x47b8)[0x55acdb943eb8]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(_ZN18Prepared_statement7executeEP6Stringb+0x4b6)[0x55acdb95d0f6]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0x92)[0x55acdb95d2b2]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(+0x6aec17)[0x55acdb95dc17]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(_Z19mysqld_stmt_executeP3THDPcj+0x27)[0x55acdb95dca7]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x17e2)[0x55acdb94bc02]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x11c)[0x55acdb94defc]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x241)[0x55acdba2b0a1]
      Sep  4 11:09:37 mysql mysqld: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x55acdba2b1fd]
      Sep  4 11:09:37 mysql mysqld: pthread_create.c:0(start_thread)[0x7f2199b40dd5]
      Sep  4 11:09:37 mysql mysqld: /lib64/libc.so.6(clone+0x6d)[0x7f2197ee302d]
      Sep  4 11:09:37 mysql mysqld: Trying to get some variables.
      Sep  4 11:09:37 mysql mysqld: Some pointers may be invalid and cause the dump to abort.
      Sep  4 11:09:37 mysql mysqld: Query (0x7f169800fd80): SELECT uid, name, price, price_base, link, teaser300, MATCH (name) AGAINST (NULL) AS score FROM shop.gp_products WHERE MATCH (name) AGAINST (NULL) ORDER BY score DESC LIMIT 0,10
      Sep  4 11:09:37 mysql mysqld: Connection ID (thread ID): 1450
      Sep  4 11:09:37 mysql mysqld: Status: NOT_KILLED
      Sep  4 11:09:37 mysql mysqld: 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=off,condition_pushdown_from_having=on
      Sep  4 11:09:37 mysql mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
      Sep  4 11:09:37 mysql mysqld: information that should help you find out what is causing the crash.
      Sep  4 11:09:37 mysql mysqld: Writing a core file...
      Sep  4 11:09:37 mysql mysqld: Working directory at /var/lib/mysql
      Sep  4 11:09:37 mysql mysqld: Resource Limits:
      Sep  4 11:09:37 mysql mysqld: Limit                     Soft Limit           Hard Limit           Units
      Sep  4 11:09:37 mysql mysqld: Max cpu time              unlimited            unlimited            seconds
      Sep  4 11:09:37 mysql mysqld: Max file size             unlimited            unlimited            bytes
      Sep  4 11:09:37 mysql mysqld: Max data size             unlimited            unlimited            bytes
      Sep  4 11:09:37 mysql mysqld: Max stack size            8388608              unlimited            bytes
      Sep  4 11:09:37 mysql mysqld: Max core file size        0                    unlimited            bytes
      Sep  4 11:09:37 mysql mysqld: Max resident set          unlimited            unlimited            bytes
      Sep  4 11:09:37 mysql mysqld: Max processes             255976               255976               processes
      Sep  4 11:09:37 mysql mysqld: Max open files            16364                16364                files
      Sep  4 11:09:37 mysql mysqld: Max locked memory         65536                65536                bytes
      Sep  4 11:09:37 mysql mysqld: Max address space         unlimited            unlimited            bytes
      Sep  4 11:09:37 mysql mysqld: Max file locks            unlimited            unlimited            locks
      Sep  4 11:09:37 mysql mysqld: Max pending signals       255976               255976               signals
      Sep  4 11:09:37 mysql kernel: mysqld[21307]: segfault at 10 ip 000055acdba7d8f1 sp 00007f1761a4a940 error 4 in mysqld[55acdb2af000+1449000]
      Sep  4 11:09:37 mysql mysqld: Max msgqueue size         819200               819200               bytes
      Sep  4 11:09:37 mysql mysqld: Max nice priority         0                    0
      Sep  4 11:09:37 mysql mysqld: Max realtime priority     0                    0
      Sep  4 11:09:37 mysql mysqld: Max realtime timeout      unlimited            unlimited            us
      Sep  4 11:09:38 mysql systemd: mariadb.service: main process exited, code=killed, status=11/SEGV
      Sep  4 11:09:38 mysql systemd: Unit mariadb.service entered failed state.
      Sep  4 11:09:38 mysql systemd: mariadb.service failed.
      Sep  4 11:09:43 mysql systemd: mariadb.service holdoff time over, scheduling restart.
      

      And another one:

      Sep  4 11:13:06 mysql mysqld: 190904 11:13:06 [ERROR] mysqld got signal 11 ;
      Sep  4 11:13:06 mysql mysqld: This could be because you hit a bug. It is also possible that this binary
      Sep  4 11:13:06 mysql mysqld: or one of the libraries it was linked against is corrupt, improperly built,
      Sep  4 11:13:06 mysql mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
      Sep  4 11:13:06 mysql mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      Sep  4 11:13:06 mysql mysqld: We will try our best to scrape up some info that will hopefully help
      Sep  4 11:13:06 mysql mysqld: diagnose the problem, but since we have already crashed,
      Sep  4 11:13:06 mysql mysqld: something is definitely wrong and this may fail.
      Sep  4 11:13:06 mysql mysqld: Server version: 10.4.7-MariaDB-log
      Sep  4 11:13:06 mysql mysqld: key_buffer_size=8589934592
      Sep  4 11:13:06 mysql mysqld: read_buffer_size=2097152
      Sep  4 11:13:06 mysql mysqld: max_used_connections=40
      Sep  4 11:13:06 mysql mysqld: max_threads=752
      Sep  4 11:13:06 mysql mysqld: thread_count=46
      Sep  4 11:13:06 mysql mysqld: It is possible that mysqld could use up to
      Sep  4 11:13:06 mysql mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11487264 K  bytes of memory
      Sep  4 11:13:06 mysql mysqld: Hope that's ok; if not, decrease some variables in the equation.
      Sep  4 11:13:06 mysql mysqld: Thread pointer: 0x7f8ed80009a8
      Sep  4 11:13:06 mysql mysqld: Attempting backtrace. You can use the following information to find out
      Sep  4 11:13:06 mysql mysqld: where mysqld died. If you see no messages after this, something went
      Sep  4 11:13:06 mysql mysqld: terribly wrong...
      Sep  4 11:13:06 mysql mysqld: stack_bottom = 0x7f90055aacf0 thread_stack 0x40000
      Sep  4 11:13:06 mysql mysqld: *** buffer overflow detected ***: /usr/sbin/mysqld terminated
      Sep  4 11:13:06 mysql mysqld: ======= Backtrace: =========
      Sep  4 11:13:06 mysql mysqld: /lib64/libc.so.6(__fortify_fail+0x37)[0x7f9a3c05bb67]
      Sep  4 11:13:06 mysql mysqld: /lib64/libc.so.6(+0x115ce2)[0x7f9a3c059ce2]
      Sep  4 11:13:06 mysql mysqld: /lib64/libc.so.6(+0x117ac7)[0x7f9a3c05bac7]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(my_addr_resolve+0xda)[0x564d286360ba]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x1c2)[0x564d2861e852]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x564d280ad81f]
      Sep  4 11:13:06 mysql mysqld: /lib64/libpthread.so.0(+0xf5d0)[0x7f9a3dca75d0]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(_ZNK26Type_handler_string_result13Item_const_eqEPK10Item_constS2_b+0x41)[0x564d27fdb8f1]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(_ZNK15Item_func_match2eqEPK4Itemb+0xa5)[0x564d2811a275]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(_Z13setup_ftfuncsP13st_select_lex+0x62)[0x564d27e452c2]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x2da)[0x564d27ef7fca]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x9d)[0x564d27efb43d]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xe1)[0x564d27efb541]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1d7)[0x564d27efc157]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(+0x5870ea)[0x564d27d940ea]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x47b8)[0x564d27ea1eb8]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(_ZN18Prepared_statement7executeEP6Stringb+0x4b6)[0x564d27ebb0f6]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0x92)[0x564d27ebb2b2]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(+0x6aec17)[0x564d27ebbc17]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(_Z19mysqld_stmt_executeP3THDPcj+0x27)[0x564d27ebbca7]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x17e2)[0x564d27ea9c02]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x11c)[0x564d27eabefc]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x241)[0x564d27f890a1]
      Sep  4 11:13:06 mysql mysqld: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x564d27f891fd]
      Sep  4 11:13:06 mysql mysqld: /lib64/libpthread.so.0(+0x7dd5)[0x7f9a3dc9fdd5]
      Sep  4 11:13:06 mysql mysqld: /lib64/libc.so.6(clone+0x6d)[0x7f9a3c04202d]
      Sep  4 11:13:06 mysql mysqld: ======= Memory map: ========
      Sep  4 11:13:06 mysql mysqld: 564d2780d000-564d28c56000 r-xp 00000000 09:02 2100741                    /usr/sbin/mysqld
      Sep  4 11:13:06 mysql mysqld: 564d28e56000-564d28f7f000 r--p 01449000 09:02 2100741                    /usr/sbin/mysqld
      Sep  4 11:13:06 mysql mysqld: 564d28f7f000-564d29039000 rw-p 01572000 09:02 2100741                    /usr/sbin/mysqld
      Sep  4 11:13:06 mysql mysqld: 564d29039000-564d298e8000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 564d2abd9000-564d4aebb000 rw-p 00000000 00:00 0                          [heap]
      Sep  4 11:13:06 mysql mysqld: 7f8ed0000000-7f8ed063d000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f8ed063d000-7f8ed4000000 ---p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f8ed8000000-7f8ed8894000 rw-p 00000000 00:00 0
       
      ...
       
      Sep  4 11:13:06 mysql mysqld: 7f9a309d5000-7f9a391d1000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a391d1000-7f9a391dd000 r-xp 00000000 09:02 1445708                    /usr/lib64/libnss_files-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a391dd000-7f9a393dc000 ---p 0000c000 09:02 1445708                    /usr/lib64/libnss_files-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a393dc000-7f9a393dd000 r--p 0000b000 09:02 1445708                    /usr/lib64/libnss_files-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a393dd000-7f9a393de000 rw-p 0000c000 09:02 1445708                    /usr/lib64/libnss_files-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a393de000-7f9a393e4000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a393e4000-7f9a393e7000 r-xp 00000000 09:02 1445691                    /usr/lib64/libkeyutils.so.1.5
      Sep  4 11:13:06 mysql mysqld: 7f9a393e7000-7f9a395e6000 ---p 00003000 09:02 1445691                    /usr/lib64/libkeyutils.so.1.5
      Sep  4 11:13:06 mysql mysqld: 7f9a395e6000-7f9a395e7000 r--p 00002000 09:02 1445691                    /usr/lib64/libkeyutils.so.1.5
      Sep  4 11:13:06 mysql mysqld: 7f9a395e7000-7f9a395e8000 rw-p 00003000 09:02 1445691                    /usr/lib64/libkeyutils.so.1.5
      Sep  4 11:13:06 mysql mysqld: 7f9a395e8000-7f9a395f6000 r-xp 00000000 09:02 1445798                    /usr/lib64/libkrb5support.so.0.1
      Sep  4 11:13:06 mysql mysqld: 7f9a395f6000-7f9a397f6000 ---p 0000e000 09:02 1445798                    /usr/lib64/libkrb5support.so.0.1
      Sep  4 11:13:06 mysql mysqld: 7f9a397f6000-7f9a397f7000 r--p 0000e000 09:02 1445798                    /usr/lib64/libkrb5support.so.0.1
      Sep  4 11:13:06 mysql mysqld: 7f9a397f7000-7f9a397f8000 rw-p 0000f000 09:02 1445798                    /usr/lib64/libkrb5support.so.0.1
      Sep  4 11:13:06 mysql mysqld: 7f9a397f8000-7f9a39807000 r-xp 00000000 09:02 1445683                    /usr/lib64/libbz2.so.1.0.6
      Sep  4 11:13:06 mysql mysqld: 7f9a39807000-7f9a39a06000 ---p 0000f000 09:02 1445683                    /usr/lib64/libbz2.so.1.0.6
      Sep  4 11:13:06 mysql mysqld: 7f9a39a06000-7f9a39a07000 r--p 0000e000 09:02 1445683                    /usr/lib64/libbz2.so.1.0.6
      Sep  4 11:13:06 mysql mysqld: 7f9a39a07000-7f9a39a08000 rw-p 0000f000 09:02 1445683                    /usr/lib64/libbz2.so.1.0.6
      Sep  4 11:13:06 mysql mysqld: 7f9a39a08000-7f9a39a1f000 r-xp 00000000 09:02 1446147                    /usr/lib64/libelf-0.172.so
      Sep  4 11:13:06 mysql mysqld: 7f9a39a1f000-7f9a39c1e000 ---p 00017000 09:02 1446147                    /usr/lib64/libelf-0.172.so
      Sep  4 11:13:06 mysql mysqld: 7f9a39c1e000-7f9a39c1f000 r--p 00016000 09:02 1446147                    /usr/lib64/libelf-0.172.so
      Sep  4 11:13:06 mysql mysqld: 7f9a39c1f000-7f9a39c20000 rw-p 00017000 09:02 1446147                    /usr/lib64/libelf-0.172.so
      Sep  4 11:13:06 mysql mysqld: 7f9a39c20000-7f9a39c80000 r-xp 00000000 09:02 1446189                    /usr/lib64/libpcre.so.1.2.0
      Sep  4 11:13:06 mysql mysqld: 7f9a39c80000-7f9a39e80000 ---p 00060000 09:02 1446189                    /usr/lib64/libpcre.so.1.2.0
      Sep  4 11:13:06 mysql mysqld: 7f9a39e80000-7f9a39e81000 r--p 00060000 09:02 1446189                    /usr/lib64/libpcre.so.1.2.0
      Sep  4 11:13:06 mysql mysqld: 7f9a39e81000-7f9a39e82000 rw-p 00061000 09:02 1446189                    /usr/lib64/libpcre.so.1.2.0
      Sep  4 11:13:06 mysql mysqld: 7f9a39e82000-7f9a39e86000 r-xp 00000000 09:02 1445846                    /usr/lib64/libattr.so.1.1.0
      Sep  4 11:13:06 mysql mysqld: 7f9a39e86000-7f9a3a085000 ---p 00004000 09:02 1445846                    /usr/lib64/libattr.so.1.1.0
      Sep  4 11:13:06 mysql mysqld: 7f9a3a085000-7f9a3a086000 r--p 00003000 09:02 1445846                    /usr/lib64/libattr.so.1.1.0
      Sep  4 11:13:06 mysql mysqld: 7f9a3a086000-7f9a3a087000 rw-p 00004000 09:02 1445846                    /usr/lib64/libattr.so.1.1.0
      Sep  4 11:13:06 mysql mysqld: 7f9a3a087000-7f9a3a0b8000 r-xp 00000000 09:02 1445824                    /usr/lib64/libk5crypto.so.3.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3a0b8000-7f9a3a2b7000 ---p 00031000 09:02 1445824                    /usr/lib64/libk5crypto.so.3.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3a2b7000-7f9a3a2b9000 r--p 00030000 09:02 1445824                    /usr/lib64/libk5crypto.so.3.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3a2b9000-7f9a3a2ba000 rw-p 00032000 09:02 1445824                    /usr/lib64/libk5crypto.so.3.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3a2ba000-7f9a3a2bd000 r-xp 00000000 09:02 1446097                    /usr/lib64/libcom_err.so.2.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3a2bd000-7f9a3a4bc000 ---p 00003000 09:02 1446097                    /usr/lib64/libcom_err.so.2.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3a4be000-7f9a3a597000 r-xp 00000000 09:02 1445835                    /usr/lib64/libkrb5.so.3.3
      Sep  4 11:13:06 mysql mysqld: 7f9a3a597000-7f9a3a796000 ---p 000d9000 09:02 1445835                    /usr/lib64/libkrb5.so.3.3
      Sep  4 11:13:06 mysql mysqld: 7f9a3a796000-7f9a3a7a4000 r--p 000d8000 09:02 1445835                    /usr/lib64/libkrb5.so.3.3
      Sep  4 11:13:06 mysql mysqld: 7f9a3a7a4000-7f9a3a7a7000 rw-p 000e6000 09:02 1445835                    /usr/lib64/libkrb5.so.3.3
      Sep  4 11:13:06 mysql mysqld: 7f9a3a7a7000-7f9a3a7f1000 r-xp 00000000 09:02 1445893                    /usr/lib64/libgssapi_krb5.so.2.2
      Sep  4 11:13:06 mysql mysqld: 7f9a3a7f1000-7f9a3a9f1000 ---p 0004a000 09:02 1445893                    /usr/lib64/libgssapi_krb5.so.2.2
      Sep  4 11:13:06 mysql mysqld: 7f9a3a9f1000-7f9a3a9f2000 r--p 0004a000 09:02 1445893                    /usr/lib64/libgssapi_krb5.so.2.2
      Sep  4 11:13:06 mysql mysqld: 7f9a3a9f2000-7f9a3a9f4000 rw-p 0004b000 09:02 1445893                    /usr/lib64/libgssapi_krb5.so.2.2
      Sep  4 11:13:06 mysql mysqld: 7f9a3a9f4000-7f9a3aa09000 r-xp 00000000 09:02 1445450                    /usr/lib64/libgcc_s-4.8.5-20150702.so.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3aa09000-7f9a3ac08000 ---p 00015000 09:02 1445450                    /usr/lib64/libgcc_s-4.8.5-20150702.so.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3ac08000-7f9a3ac09000 r--p 00014000 09:02 1445450                    /usr/lib64/libgcc_s-4.8.5-20150702.so.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3ac09000-7f9a3ac0a000 rw-p 00015000 09:02 1445450                    /usr/lib64/libgcc_s-4.8.5-20150702.so.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3ac0a000-7f9a3ac56000 r-xp 00000000 09:02 1445719                    /usr/lib64/libdw-0.172.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3ac56000-7f9a3ae56000 ---p 0004c000 09:02 1445719                    /usr/lib64/libdw-0.172.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3ae56000-7f9a3ae58000 r--p 0004c000 09:02 1445719                    /usr/lib64/libdw-0.172.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3ae58000-7f9a3ae59000 rw-p 0004e000 09:02 1445719                    /usr/lib64/libdw-0.172.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3ae59000-7f9a3ae6f000 r-xp 00000000 09:02 1445808                    /usr/lib64/libresolv-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3ae6f000-7f9a3b06e000 ---p 00016000 09:02 1445808                    /usr/lib64/libresolv-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3b06e000-7f9a3b06f000 r--p 00015000 09:02 1445808                    /usr/lib64/libresolv-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3b06f000-7f9a3b070000 rw-p 00016000 09:02 1445808                    /usr/lib64/libresolv-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3b070000-7f9a3b072000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3b072000-7f9a3b076000 r-xp 00000000 09:02 1446111                    /usr/lib64/libgpg-error.so.0.10.0
      Sep  4 11:13:06 mysql mysqld: 7f9a3b076000-7f9a3b275000 ---p 00004000 09:02 1446111                    /usr/lib64/libgpg-error.so.0.10.0
      Sep  4 11:13:06 mysql mysqld: 7f9a3b275000-7f9a3b276000 r--p 00003000 09:02 1446111                    /usr/lib64/libgpg-error.so.0.10.0
      Sep  4 11:13:06 mysql mysqld: 7f9a3b276000-7f9a3b277000 rw-p 00004000 09:02 1446111                    /usr/lib64/libgpg-error.so.0.10.0
      Sep  4 11:13:06 mysql mysqld: 7f9a3b277000-7f9a3b2f4000 r-xp 00000000 09:02 1446077                    /usr/lib64/libgcrypt.so.11.8.2
      Sep  4 11:13:06 mysql mysqld: 7f9a3b2f4000-7f9a3b4f3000 ---p 0007d000 09:02 1446077                    /usr/lib64/libgcrypt.so.11.8.2
      Sep  4 11:13:06 mysql mysqld: 7f9a3b4f3000-7f9a3b4f4000 r--p 0007c000 09:02 1446077                    /usr/lib64/libgcrypt.so.11.8.2
      Sep  4 11:13:06 mysql mysqld: 7f9a3b4f4000-7f9a3b4f7000 rw-p 0007d000 09:02 1446077                    /usr/lib64/libgcrypt.so.11.8.2
      Sep  4 11:13:06 mysql mysqld: 7f9a3b4f7000-7f9a3b4f8000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3b4f8000-7f9a3b50c000 r-xp 00000000 09:02 1446260                    /usr/lib64/liblz4.so.1.7.5
      Sep  4 11:13:06 mysql mysqld: 7f9a3b50c000-7f9a3b70b000 ---p 00014000 09:02 1446260                    /usr/lib64/liblz4.so.1.7.5
      Sep  4 11:13:06 mysql mysqld: 7f9a3b70b000-7f9a3b70c000 r--p 00013000 09:02 1446260                    /usr/lib64/liblz4.so.1.7.5
      Sep  4 11:13:06 mysql mysqld: 7f9a3b70c000-7f9a3b70d000 rw-p 00014000 09:02 1446260                    /usr/lib64/liblz4.so.1.7.5
      Sep  4 11:13:06 mysql mysqld: 7f9a3b70d000-7f9a3b731000 r-xp 00000000 09:02 1445728                    /usr/lib64/libselinux.so.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3b731000-7f9a3b930000 ---p 00024000 09:02 1445728                    /usr/lib64/libselinux.so.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3b930000-7f9a3b931000 r--p 00023000 09:02 1445728                    /usr/lib64/libselinux.so.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3b931000-7f9a3b932000 rw-p 00024000 09:02 1445728                    /usr/lib64/libselinux.so.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3b932000-7f9a3b934000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3b934000-7f9a3b93b000 r-xp 00000000 09:02 1445830                    /usr/lib64/librt-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3b93b000-7f9a3bb3a000 ---p 00007000 09:02 1445830                    /usr/lib64/librt-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3bb3a000-7f9a3bb3b000 r--p 00006000 09:02 1445830                    /usr/lib64/librt-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3bb3b000-7f9a3bb3c000 rw-p 00007000 09:02 1445830                    /usr/lib64/librt-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3bb3c000-7f9a3bb40000 r-xp 00000000 09:02 1446122                    /usr/lib64/libcap.so.2.22
      Sep  4 11:13:06 mysql mysqld: 7f9a3bb40000-7f9a3bd3f000 ---p 00004000 09:02 1446122                    /usr/lib64/libcap.so.2.22
      Sep  4 11:13:06 mysql mysqld: 7f9a3bd3f000-7f9a3bd40000 r--p 00003000 09:02 1446122                    /usr/lib64/libcap.so.2.22
      Sep  4 11:13:06 mysql mysqld: 7f9a3bd40000-7f9a3bd41000 rw-p 00004000 09:02 1446122                    /usr/lib64/libcap.so.2.22
      Sep  4 11:13:06 mysql mysqld: 7f9a3bd41000-7f9a3bd43000 r-xp 00000000 09:02 1445873                    /usr/lib64/libfreebl3.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3bd43000-7f9a3bf42000 ---p 00002000 09:02 1445873                    /usr/lib64/libfreebl3.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3bf42000-7f9a3bf43000 r--p 00001000 09:02 1445873                    /usr/lib64/libfreebl3.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3bf43000-7f9a3bf44000 rw-p 00002000 09:02 1445873                    /usr/lib64/libfreebl3.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3bf44000-7f9a3c106000 r-xp 00000000 09:02 1445319                    /usr/lib64/libc-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3c106000-7f9a3c306000 ---p 001c2000 09:02 1445319                    /usr/lib64/libc-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3c306000-7f9a3c30a000 r--p 001c2000 09:02 1445319                    /usr/lib64/libc-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3c30a000-7f9a3c30c000 rw-p 001c6000 09:02 1445319                    /usr/lib64/libc-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3c30c000-7f9a3c311000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3c311000-7f9a3c412000 r-xp 00000000 09:02 1445342                    /usr/lib64/libm-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3c412000-7f9a3c611000 ---p 00101000 09:02 1445342                    /usr/lib64/libm-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3c611000-7f9a3c612000 r--p 00100000 09:02 1445342                    /usr/lib64/libm-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3c612000-7f9a3c613000 rw-p 00101000 09:02 1445342                    /usr/lib64/libm-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3c613000-7f9a3c6fc000 r-xp 00000000 09:02 1445733                    /usr/lib64/libstdc++.so.6.0.19
      Sep  4 11:13:06 mysql mysqld: 7f9a3c6fc000-7f9a3c8fb000 ---p 000e9000 09:02 1445733                    /usr/lib64/libstdc++.so.6.0.19
      Sep  4 11:13:06 mysql mysqld: 7f9a3c8fb000-7f9a3c903000 r--p 000e8000 09:02 1445733                    /usr/lib64/libstdc++.so.6.0.19
      Sep  4 11:13:06 mysql mysqld: 7f9a3c903000-7f9a3c905000 rw-p 000f0000 09:02 1445733                    /usr/lib64/libstdc++.so.6.0.19
      Sep  4 11:13:06 mysql mysqld: 7f9a3c905000-7f9a3c91a000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3c91a000-7f9a3c91c000 r-xp 00000000 09:02 1445335                    /usr/lib64/libdl-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3c91c000-7f9a3cb1c000 ---p 00002000 09:02 1445335                    /usr/lib64/libdl-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3cb1c000-7f9a3cb1d000 r--p 00002000 09:02 1445335                    /usr/lib64/libdl-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3cb1d000-7f9a3cb1e000 rw-p 00003000 09:02 1445335                    /usr/lib64/libdl-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3cb1e000-7f9a3cd53000 r-xp 00000000 09:02 1445788                    /usr/lib64/libcrypto.so.1.0.2k
      Sep  4 11:13:06 mysql mysqld: 7f9a3cd53000-7f9a3cf53000 ---p 00235000 09:02 1445788                    /usr/lib64/libcrypto.so.1.0.2k
      Sep  4 11:13:06 mysql mysqld: 7f9a3cf53000-7f9a3cf6f000 r--p 00235000 09:02 1445788                    /usr/lib64/libcrypto.so.1.0.2k
      Sep  4 11:13:06 mysql mysqld: 7f9a3cf6f000-7f9a3cf7c000 rw-p 00251000 09:02 1445788                    /usr/lib64/libcrypto.so.1.0.2k
      Sep  4 11:13:06 mysql mysqld: 7f9a3cf7c000-7f9a3cf80000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3cf80000-7f9a3cfe7000 r-xp 00000000 09:02 1445959                    /usr/lib64/libssl.so.1.0.2k
      Sep  4 11:13:06 mysql mysqld: 7f9a3cfe7000-7f9a3d1e7000 ---p 00067000 09:02 1445959                    /usr/lib64/libssl.so.1.0.2k
      Sep  4 11:13:06 mysql mysqld: 7f9a3d1e7000-7f9a3d1eb000 r--p 00067000 09:02 1445959                    /usr/lib64/libssl.so.1.0.2k
      Sep  4 11:13:06 mysql mysqld: 7f9a3d1eb000-7f9a3d1f2000 rw-p 0006b000 09:02 1445959                    /usr/lib64/libssl.so.1.0.2k
      Sep  4 11:13:06 mysql mysqld: 7f9a3d1f2000-7f9a3d221000 r-xp 00000000 09:02 1445936                    /usr/lib64/libsystemd.so.0.6.0
      Sep  4 11:13:06 mysql mysqld: 7f9a3d221000-7f9a3d421000 ---p 0002f000 09:02 1445936                    /usr/lib64/libsystemd.so.0.6.0
      Sep  4 11:13:06 mysql mysqld: 7f9a3d421000-7f9a3d422000 r--p 0002f000 09:02 1445936                    /usr/lib64/libsystemd.so.0.6.0
      Sep  4 11:13:06 mysql mysqld: 7f9a3d422000-7f9a3d423000 rw-p 00030000 09:02 1445936                    /usr/lib64/libsystemd.so.0.6.0
      Sep  4 11:13:06 mysql mysqld: 7f9a3d423000-7f9a3d42b000 r-xp 00000000 09:02 1445329                    /usr/lib64/libcrypt-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3d42b000-7f9a3d62a000 ---p 00008000 09:02 1445329                    /usr/lib64/libcrypt-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3d62a000-7f9a3d62b000 r--p 00007000 09:02 1445329                    /usr/lib64/libcrypt-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3d62b000-7f9a3d62c000 rw-p 00008000 09:02 1445329                    /usr/lib64/libcrypt-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3d62c000-7f9a3d65a000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3d65a000-7f9a3d66f000 r-xp 00000000 09:02 1445916                    /usr/lib64/libz.so.1.2.7
      Sep  4 11:13:06 mysql mysqld: 7f9a3d66f000-7f9a3d86e000 ---p 00015000 09:02 1445916                    /usr/lib64/libz.so.1.2.7
      Sep  4 11:13:06 mysql mysqld: 7f9a3d86e000-7f9a3d86f000 r--p 00014000 09:02 1445916                    /usr/lib64/libz.so.1.2.7
      Sep  4 11:13:06 mysql mysqld: 7f9a3d86f000-7f9a3d870000 rw-p 00015000 09:02 1445916                    /usr/lib64/libz.so.1.2.7
      Sep  4 11:13:06 mysql mysqld: 7f9a3d870000-7f9a3d871000 r-xp 00000000 09:02 1446227                    /usr/lib64/libaio.so.1.0.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3d871000-7f9a3da70000 ---p 00001000 09:02 1446227                    /usr/lib64/libaio.so.1.0.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3da70000-7f9a3da71000 r--p 00000000 09:02 1446227                    /usr/lib64/libaio.so.1.0.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3da71000-7f9a3da72000 rw-p 00001000 09:02 1446227                    /usr/lib64/libaio.so.1.0.1
      Sep  4 11:13:06 mysql mysqld: 7f9a3da72000-7f9a3da97000 r-xp 00000000 09:02 1446120                    /usr/lib64/liblzma.so.5.2.2
      Sep  4 11:13:06 mysql mysqld: 7f9a3da97000-7f9a3dc96000 ---p 00025000 09:02 1446120                    /usr/lib64/liblzma.so.5.2.2
      Sep  4 11:13:06 mysql mysqld: 7f9a3dc96000-7f9a3dc97000 r--p 00024000 09:02 1446120                    /usr/lib64/liblzma.so.5.2.2
      Sep  4 11:13:06 mysql mysqld: 7f9a3dc97000-7f9a3dc98000 rw-p 00025000 09:02 1446120                    /usr/lib64/liblzma.so.5.2.2
      Sep  4 11:13:06 mysql mysqld: 7f9a3dc98000-7f9a3dcaf000 r-xp 00000000 09:02 1445769                    /usr/lib64/libpthread-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3dcaf000-7f9a3deae000 ---p 00017000 09:02 1445769                    /usr/lib64/libpthread-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3deae000-7f9a3deaf000 r--p 00016000 09:02 1445769                    /usr/lib64/libpthread-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3deaf000-7f9a3deb0000 rw-p 00017000 09:02 1445769                    /usr/lib64/libpthread-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3deb0000-7f9a3deb4000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3deb4000-7f9a3ded6000 r-xp 00000000 09:02 1444752                    /usr/lib64/ld-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3dedb000-7f9a3dedc000 ---p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3dedc000-7f9a3df1d000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3df1d000-7f9a3df1e000 ---p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3df1e000-7f9a3df5f000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3df5f000-7f9a3df60000 ---p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3df60000-7f9a3dfa1000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3dfa1000-7f9a3dfa2000 ---p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3dfa2000-7f9a3dfe4000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3dfe4000-7f9a3dfe7000 rw-s 00000000 00:0b 87561698                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dfe7000-7f9a3dfea000 rw-s 00000000 00:0b 87561697                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dfea000-7f9a3dfed000 rw-s 00000000 00:0b 87561696                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dfed000-7f9a3dff0000 rw-s 00000000 00:0b 87561695                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dff0000-7f9a3dff3000 rw-s 00000000 00:0b 87561694                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dff3000-7f9a3dff6000 rw-s 00000000 00:0b 87561693                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dff6000-7f9a3dff9000 rw-s 00000000 00:0b 87561692                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dff9000-7f9a3dffc000 rw-s 00000000 00:0b 87561691                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dffc000-7f9a3e0cc000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3dfe4000-7f9a3dfe7000 rw-s 00000000 00:0b 87561698                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dfe7000-7f9a3dfea000 rw-s 00000000 00:0b 87561697                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dfea000-7f9a3dfed000 rw-s 00000000 00:0b 87561696                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dfed000-7f9a3dff0000 rw-s 00000000 00:0b 87561695                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dff0000-7f9a3dff3000 rw-s 00000000 00:0b 87561694                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dff3000-7f9a3dff6000 rw-s 00000000 00:0b 87561693                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dff6000-7f9a3dff9000 rw-s 00000000 00:0b 87561692                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dff9000-7f9a3dffc000 rw-s 00000000 00:0b 87561691                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3dffc000-7f9a3e0cc000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3e0cc000-7f9a3e0cd000 rw-s 00000000 00:0b 87561699                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3e0cd000-7f9a3e0d0000 rw-s 00000000 00:0b 87561690                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3e0d0000-7f9a3e0d3000 rw-s 00000000 00:0b 87561689                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3e0d3000-7f9a3e0d4000 rw-s 00000000 00:0b 87561688                   /[aio] (deleted)
      Sep  4 11:13:06 mysql mysqld: 7f9a3e0d4000-7f9a3e0d5000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7f9a3e0d5000-7f9a3e0d6000 r--p 00021000 09:02 1444752                    /usr/lib64/ld-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3e0d6000-7f9a3e0d7000 rw-p 00022000 09:02 1444752                    /usr/lib64/ld-2.17.so
      Sep  4 11:13:06 mysql mysqld: 7f9a3e0d7000-7f9a3e0d8000 rw-p 00000000 00:00 0
      Sep  4 11:13:06 mysql mysqld: 7ffeae9ed000-7ffeaea0e000 rw-p 00000000 00:00 0                          [stack]
      Sep  4 11:13:06 mysql mysqld: 7ffeaeb8e000-7ffeaeb90000 r-xp 00000000 00:00 0                          [vdso]
      Sep  4 11:13:06 mysql mysqld: ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
      Sep  4 11:13:06 mysql mysqld: Fatal signal 6 while backtracing
      Sep  4 11:13:06 mysql systemd: mariadb.service: main process exited, code=killed, status=6/ABRT
      Sep  4 11:13:06 mysql systemd: Unit mariadb.service entered failed state.
      Sep  4 11:13:06 mysql systemd: mariadb.service failed.
      Sep  4 11:13:11 mysql systemd: mariadb.service holdoff time over, scheduling restart.
      

      Our MariaDB config:

      /etc/my.cnf
      =======

      [client-server]
       
      !includedir /etc/my.cnf.d

      /etc/my.cnf.d/client.cnf
      ==============

      [client]
       
      [client-mariadb]

      /etc/my.cnf.d/mysql-clients.cnf
      ===================

      [mysql]
      ssl-ca=/etc/mysql/ssl/ca-cert.pem
      ssl-cert=/etc/mysql/ssl/client-cert.pem
      ssl-key=/etc/mysql/ssl/client-key.pem
       
      [mysql_upgrade]
       
      [mysqladmin]
       
      [mysqlbinlog]
       
      [mysqlcheck]
       
      [mysqldump]
       
      [mysqlimport]
       
      [mysqlshow]
       
      [mysqlslap]

      /etc/my.cnf.d/server.cnf
      ===============

      [server]
       
      [mysqld]
      user = mysql
      datadir = /var/lib/mysql
      skip-external-locking
      skip-name-resolve
      character-set-server = latin1
      sql_mode = "NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER"
       
      aria-pagecache-buffer-size = 8G
      key_buffer_size = 8G
      max_allowed_packet = 64M
      thread_stack = 256K
      thread_cache_size = 128
      myisam-recover-options = BACKUP
      max_connections = 750
      table_open_cache = 7500
      table_definition_cache = 10000
       
      query_cache_type = 1
      query_cache_limit = 1M
      query_cache_size = 128M
       
      slow_query_log = 1
      slow_query_log_file = /var/log/mysql/mysql-slow.log
      long_query_time = 2
       
      max_connect_errors  = 100000
      wait_timeout = 3600
      connect_timeout = 10
      interactive_timeout = 300
       
      join_buffer_size = 8M
      sort_buffer_size = 2M
      read_buffer_size = 2M
      read_rnd_buffer_size = 8M
      tmp_table_size = 64M
      myisam_sort_buffer_size = 128M
      myisam_max_sort_file_size = 10G
       
      ft_min_word_len = 2
      ft_stopword_file = ""
       
      innodb_file_per_table = 1
      innodb_buffer_pool_size = 24G
      innodb_flush_log_at_trx_commit = 0
      innodb_log_buffer_size = 4M
      innodb_log_file_size = 256M
      innodb_log_files_in_group = 3
      innodb_thread_concurrency = 16
      innodb_flush_method = O_DIRECT
       
      ssl
      ssl-ca=/etc/mysql/ssl/ca-cert.pem
      ssl-cert=/etc/mysql/ssl/server-cert.pem
      ssl-key=/etc/mysql/ssl/server-key.pem
       
      optimizer_switch='rowid_filter=off'
       
      [embedded]
       
      [mysqld-5.5]
       
      [mariadb]
       
      [mariadb-5.5]
       
      [mysqldump]
      quick
      quote-names
      max_allowed_packet = 16M
       
      [mysql]
       
      [isamchk]
      key_buffer = 16M
       
      [myisamchk]
      key_buffer = 512M
      sort_buffer_size = 512M
      read_buffer = 8M
      write_buffer = 8M
      ft_min_word_len = 2

      We used optimizer_switch='rowid_filter=off' because of MDEV-20252.

      Best regards,
      Guillaume

      Attachments

        Activity

          People

            Unassigned Unassigned
            guiyom Guillaume M
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.