[MDEV-20489] MATCH AGAINST (NULL) consistenly crashes MariaDB 10.4.7 Created: 2019-09-04  Updated: 2019-11-18  Resolved: 2019-11-18

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.4.7
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Guillaume M Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

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

 Comments   
Comment by Alice Sherepa [ 2019-09-04 ]

Could you please add the output of 

SHOW CREATE TABLE shop.gp_products;

Comment by Guillaume M [ 2019-09-04 ] 

CREATE TABLE `gp_products` (
 
 `uid` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
 
 `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
 
 `description` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
 
 `price` int(10) unsigned NOT NULL,
 
 `price_base` int(10) unsigned NOT NULL,
 
 `link` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
 
 `publisher` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
 
 `category` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
 
 `ean` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
 
 `delivery_type` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
 
 `steam_id` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
 
 `platforms` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
 
 `packshot` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
 
 `teaser620` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
 
 `teaser300` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
 
 `metacritic` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
 
 PRIMARY KEY (`uid`),
 
 FULLTEXT KEY `name` (`name`)
 
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

Comment by Elena Stepanova [ 2019-10-06 ]

guiyom,

Is it production with confidential contents of the table, or is it your test instance? Would you be able to upload the table data with which the crash is reproducible for you? Maybe you can obfuscate it, if it remains reproducible. The data can be uploaded to ftp.askmonty.org/private, so that only MariaDB developers had access to it.

Comment by Guillaume M [ 2019-10-10 ]

Hi Elena,

(Un?)fortunately the crash isn't reproducible anymore, and I didn't dump the table when it happened.
Since I reported this bug we upgraded to MariaDB 10.4.8. So I don't know if the crash doesn't happen anymore because of the table content or if the bug got fixed.
Anyway, I'll be sure to dump the table and post an update if it happened again.

Comment by Elena Stepanova [ 2019-11-18 ]

Okay, I'll close it for now, if the problem occurs again, please comment and we'll re-open it.

Generated at Thu Feb 08 08:59:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.