[MDEV-20252] Specific SQL query consistently crashes MariaDB Created: 2019-08-05  Updated: 2020-07-08  Resolved: 2020-01-16

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.4.7
Fix Version/s: 10.4.11

Type: Bug Priority: Critical
Reporter: Guillaume M Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: None
Environment:

CentOS 7.6.1810


Issue Links:
Duplicate
duplicates MDEV-20746 Crash on query with EXISTS Closed
duplicates MDEV-20873 date between and multiple order by cr... Closed
is duplicated by MDEV-20862 ERROR 2013 when SELECT with DATE_ADD Closed
Problem/Incident
is caused by MDEV-20056 Assertion `!prebuilt->index->is_prima... Closed

 Description   

Hello

The following SQL query always crashes MariaDB 10.4.7:

SELECT /* MigrateActors::migrate wiki@multi */ oi_name,oi_timestamp,oi_user,oi_user_text,CASE WHEN oi_user = 0 OR oi_user IS NULL THEN (SELECT actor_id FROM `actor` WHERE (oi_user_text = actor_name) ) ELSE (SELECT actor_id FROM `actor` WHERE (oi_user = actor_user) ) END AS `actor_id` FROM `oldimage` WHERE oi_actor = '0' AND (oi_name > 'Toltz_3.png' OR oi_name = 'Toltz_3.png' AND (oi_timestamp > '20131122110506')) ORDER BY oi_name,oi_timestamp LIMIT 100

With the following error:

Aug  5 11:37:05 mysql mysqld: 190805 11:37:05 [ERROR] mysqld got signal 11 ;
Aug  5 11:37:05 mysql mysqld: This could be because you hit a bug. It is also possible that this binary
Aug  5 11:37:05 mysql mysqld: or one of the libraries it was linked against is corrupt, improperly built,
Aug  5 11:37:05 mysql mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
Aug  5 11:37:05 mysql mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Aug  5 11:37:05 mysql mysqld: We will try our best to scrape up some info that will hopefully help
Aug  5 11:37:05 mysql mysqld: diagnose the problem, but since we have already crashed,
Aug  5 11:37:05 mysql mysqld: something is definitely wrong and this may fail.
Aug  5 11:37:05 mysql mysqld: Server version: 10.4.7-MariaDB-log
Aug  5 11:37:05 mysql mysqld: key_buffer_size=8589934592
Aug  5 11:37:05 mysql mysqld: read_buffer_size=2097152
Aug  5 11:37:05 mysql mysqld: max_used_connections=48
Aug  5 11:37:05 mysql mysqld: max_threads=752
Aug  5 11:37:05 mysql mysqld: thread_count=54
Aug  5 11:37:05 mysql mysqld: It is possible that mysqld could use up to
Aug  5 11:37:05 mysql mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11487264 K  bytes of memory
Aug  5 11:37:05 mysql mysqld: Hope that's ok; if not, decrease some variables in the equation.
Aug  5 11:37:05 mysql mysqld: Thread pointer: 0x7f40000009a8
Aug  5 11:37:05 mysql mysqld: Attempting backtrace. You can use the following information to find out
Aug  5 11:37:05 mysql mysqld: where mysqld died. If you see no messages after this, something went
Aug  5 11:37:05 mysql mysqld: terribly wrong...
Aug  5 11:37:05 mysql mysqld: stack_bottom = 0x7f4138ce3cf0 thread_stack 0x40000
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5572e3b6d6be]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x5572e35fc81f]
Aug  5 11:37:05 mysql mysqld: sigaction.c:0(__restore_rt)[0x7f4b71f105d0]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(handler_index_cond_check+0xbf)[0x5572e360723f]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(+0x5987d1)[0x5572e32f47d1]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(+0xb37893)[0x5572e3893893]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(+0xa51b17)[0x5572e37adb17]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(_ZN7handler10ha_rnd_posEPhS0_+0x1c2)[0x5572e3601a72]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(_Z16rr_from_pointersP11READ_RECORD+0x2a)[0x5572e372fe4a]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x1a9)[0x5572e3429a19]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xb9c)[0x5572e344c08c]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x5572e344c2e3]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x186)[0x5572e344a5e6]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1d7)[0x5572e344b157]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(+0x5870ea)[0x5572e32e30ea]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x47b8)[0x5572e33f0eb8]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x3ad)[0x5572e33f623d]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x21aa)[0x5572e33f95ca]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x11c)[0x5572e33faefc]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x241)[0x5572e34d80a1]
Aug  5 11:37:05 mysql mysqld: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x5572e34d81fd]
Aug  5 11:37:05 mysql mysqld: pthread_create.c:0(start_thread)[0x7f4b71f08dd5]
Aug  5 11:37:05 mysql mysqld: /lib64/libc.so.6(clone+0x6d)[0x7f4b702ab02d]
Aug  5 11:37:05 mysql mysqld: Trying to get some variables.
Aug  5 11:37:05 mysql mysqld: Some pointers may be invalid and cause the dump to abort.
Aug  5 11:37:05 mysql mysqld: Query (0x7f400000fd80): SELECT /* MigrateActors::migrate wiki@multi */  oi_name,oi_timestamp,oi_user,oi_user_text,CASE WHEN oi_user = 0 OR oi_user IS NULL THEN (SELECT  actor_id  FROM `actor`    WHERE (oi_user_text = actor_name)  ) ELSE (SELECT  actor_id  FROM `actor`    WHERE (oi_user = actor_user)  ) END AS `actor_id`  FROM `oldimage`    WHERE oi_actor = '0' AND (oi_name > 'Toltz_3.png' OR oi_name = 'Toltz_3.png' AND (oi_timestamp > '20131122110506'))  ORDER BY oi_name,oi_timestamp LIMIT 100
Aug  5 11:37:05 mysql mysqld: Connection ID (thread ID): 511
Aug  5 11:37:05 mysql mysqld: Status: NOT_KILLED
Aug  5 11:37:05 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=on,condition_pushdown_from_having=on
Aug  5 11:37:05 mysql mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
Aug  5 11:37:05 mysql mysqld: information that should help you find out what is causing the crash.
Aug  5 11:37:05 mysql mysqld: Writing a core file...
Aug  5 11:37:05 mysql mysqld: Working directory at /var/lib/mysql
Aug  5 11:37:05 mysql mysqld: Resource Limits:
Aug  5 11:37:05 mysql mysqld: Limit                     Soft Limit           Hard Limit           Units
Aug  5 11:37:05 mysql mysqld: Max cpu time              unlimited            unlimited            seconds
Aug  5 11:37:05 mysql mysqld: Max file size             unlimited            unlimited            bytes
Aug  5 11:37:05 mysql mysqld: Max data size             unlimited            unlimited            bytes
Aug  5 11:37:05 mysql mysqld: Max stack size            8388608              unlimited            bytes
Aug  5 11:37:05 mysql mysqld: Max core file size        0                    unlimited            bytes
Aug  5 11:37:05 mysql mysqld: Max resident set          unlimited            unlimited            bytes
Aug  5 11:37:05 mysql mysqld: Max processes             255976               255976               processes
Aug  5 11:37:05 mysql mysqld: Max open files            16364                16364                files
Aug  5 11:37:05 mysql mysqld: Max locked memory         65536                65536                bytes
Aug  5 11:37:05 mysql mysqld: Max address space         unlimited            unlimited            bytes
Aug  5 11:37:05 mysql mysqld: Max file locks            unlimited            unlimited            locks
Aug  5 11:37:05 mysql mysqld: Max pending signals       255976               255976               signals
Aug  5 11:37:05 mysql kernel: mysqld[11293]: segfault at 0 ip 00005572e360723f sp 00007f4138cde8c0 error 4 in mysqld[5572e2d5c000+1449000]
Aug  5 11:37:05 mysql mysqld: Max msgqueue size         819200               819200               bytes
Aug  5 11:37:05 mysql mysqld: Max nice priority         0                    0
Aug  5 11:37:05 mysql mysqld: Max realtime priority     0                    0
Aug  5 11:37:05 mysql mysqld: Max realtime timeout      unlimited            unlimited            us
Aug  5 11:37:06 mysql systemd: mariadb.service: main process exited, code=killed, status=11/SEGV
Aug  5 11:37:06 mysql systemd: Unit mariadb.service entered failed state.
Aug  5 11:37:06 mysql systemd: mariadb.service failed.
Aug  5 11:37:11 mysql systemd: mariadb.service holdoff time over, scheduling restart.
 
And when I remove the comment part:
 
SELECT oi_name,oi_timestamp,oi_user,oi_user_text,CASE WHEN oi_user = 0 OR oi_user IS NULL THEN (SELECT actor_id FROM `actor` WHERE (oi_user_text = actor_name) ) ELSE (SELECT actor_id FROM `actor` WHERE (oi_user = actor_user) ) END AS `actor_id` FROM `oldimage` WHERE oi_actor = '0' AND (oi_name > 'Toltz_3.png' OR oi_name = 'Toltz_3.png' AND (oi_timestamp > '20131122110506')) ORDER BY oi_name,oi_timestamp LIMIT 100
 
I get this crash log:
 
Aug  5 11:58:49 mysql mysqld: 190805 11:58:49 [ERROR] mysqld got signal 11 ;
Aug  5 11:58:49 mysql mysqld: This could be because you hit a bug. It is also possible that this binary
Aug  5 11:58:49 mysql mysqld: or one of the libraries it was linked against is corrupt, improperly built,
Aug  5 11:58:49 mysql mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
Aug  5 11:58:49 mysql mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Aug  5 11:58:49 mysql mysqld: We will try our best to scrape up some info that will hopefully help
Aug  5 11:58:49 mysql mysqld: diagnose the problem, but since we have already crashed,
Aug  5 11:58:49 mysql mysqld: something is definitely wrong and this may fail.
Aug  5 11:58:49 mysql mysqld: Server version: 10.4.7-MariaDB-log
Aug  5 11:58:49 mysql mysqld: key_buffer_size=8589934592
Aug  5 11:58:49 mysql mysqld: read_buffer_size=2097152
Aug  5 11:58:49 mysql mysqld: max_used_connections=169
Aug  5 11:58:49 mysql mysqld: max_threads=752
Aug  5 11:58:49 mysql mysqld: thread_count=175
Aug  5 11:58:49 mysql mysqld: It is possible that mysqld could use up to
Aug  5 11:58:49 mysql mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11487264 K  bytes of memory
Aug  5 11:58:49 mysql mysqld: Hope that's ok; if not, decrease some variables in the equation.
Aug  5 11:58:49 mysql mysqld: Thread pointer: 0x7faf2c04b498
Aug  5 11:58:49 mysql mysqld: Attempting backtrace. You can use the following information to find out
Aug  5 11:58:49 mysql mysqld: where mysqld died. If you see no messages after this, something went
Aug  5 11:58:49 mysql mysqld: terribly wrong...
Aug  5 11:58:49 mysql mysqld: stack_bottom = 0x7fafe631bcf0 thread_stack 0x40000
Aug  5 11:58:49 mysql mysqld: *** buffer overflow detected ***: /usr/sbin/mysqld terminated
Aug  5 11:58:49 mysql mysqld: ======= Backtrace: =========
Aug  5 11:58:49 mysql mysqld: /lib64/libc.so.6(__fortify_fail+0x37)[0x7fba2edbdb67]
Aug  5 11:58:49 mysql mysqld: /lib64/libc.so.6(+0x115ce2)[0x7fba2edbbce2]
Aug  5 11:58:49 mysql mysqld: /lib64/libc.so.6(+0x117ac7)[0x7fba2edbdac7]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(my_addr_resolve+0xda)[0x55ccb580d0ba]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x1c2)[0x55ccb57f5852]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x55ccb528481f]
Aug  5 11:58:49 mysql mysqld: /lib64/libpthread.so.0(+0xf5d0)[0x7fba30a095d0]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(handler_index_cond_check+0xbf)[0x55ccb528f23f]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(+0x5987d1)[0x55ccb4f7c7d1]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(+0xb37893)[0x55ccb551b893]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(+0xa51b17)[0x55ccb5435b17]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(_ZN7handler10ha_rnd_posEPhS0_+0x1c2)[0x55ccb5289a72]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(_Z16rr_from_pointersP11READ_RECORD+0x2a)[0x55ccb53b7e4a]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x1a9)[0x55ccb50b1a19]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xb9c)[0x55ccb50d408c]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x55ccb50d42e3]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x186)[0x55ccb50d25e6]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1d7)[0x55ccb50d3157]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(+0x5870ea)[0x55ccb4f6b0ea]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x47b8)[0x55ccb5078eb8]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x3ad)[0x55ccb507e23d]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x21aa)[0x55ccb50815ca]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x11c)[0x55ccb5082efc]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x241)[0x55ccb51600a1]
Aug  5 11:58:49 mysql mysqld: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x55ccb51601fd]
Aug  5 11:58:49 mysql mysqld: /lib64/libpthread.so.0(+0x7dd5)[0x7fba30a01dd5]
Aug  5 11:58:49 mysql mysqld: /lib64/libc.so.6(clone+0x6d)[0x7fba2eda402d]
Aug  5 11:58:49 mysql mysqld: ======= Memory map: ========
Aug  5 11:58:49 mysql mysqld: 55ccb49e4000-55ccb5e2d000 r-xp 00000000 09:02 2100741                    /usr/sbin/mysqld
Aug  5 11:58:49 mysql mysqld: 55ccb602d000-55ccb6156000 r--p 01449000 09:02 2100741                    /usr/sbin/mysqld
Aug  5 11:58:49 mysql mysqld: 55ccb6156000-55ccb6210000 rw-p 01572000 09:02 2100741                    /usr/sbin/mysqld
Aug  5 11:58:49 mysql mysqld: 55ccb6210000-55ccb6abf000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 55ccb8a9a000-55ccda807000 rw-p 00000000 00:00 0                          [heap]
Aug  5 11:58:49 mysql mysqld: 7fae44000000-7fae47f4f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae47f4f000-7fae48000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae4c000000-7fae4cc00000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae4cc00000-7fae50000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae54000000-7fae54b0c000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae54b0c000-7fae58000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae58000000-7fae58bed000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae58bed000-7fae5c000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae5c000000-7fae5e5ef000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae5e5ef000-7fae60000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae60000000-7fae60b91000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae60b91000-7fae64000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae64000000-7fae64b98000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae64b98000-7fae68000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae68000000-7fae68baf000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae68baf000-7fae6c000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae6c000000-7fae6c918000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae6c918000-7fae70000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae70000000-7fae708e5000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae708e5000-7fae74000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae74000000-7fae74bb3000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae74bb3000-7fae78000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae7c000000-7fae7fffd000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae7fffd000-7fae80000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae84000000-7fae84ac5000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae84ac5000-7fae88000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae88000000-7fae88ca3000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae88ca3000-7fae8c000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae8c000000-7fae8caea000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae8caea000-7fae90000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae90000000-7fae90900000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae90900000-7fae94000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae94000000-7fae98000000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae98000000-7fae98abc000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae98abc000-7fae9c000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae9c000000-7fae9cb07000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fae9cb07000-7faea0000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faea0000000-7faea0bba000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faea0bba000-7faea4000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faea4000000-7faea4af9000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faea4af9000-7faea8000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faea8000000-7faea8be1000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faea8be1000-7faeac000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faeac000000-7faeac9f0000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faeac9f0000-7faeb0000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faeb0000000-7faeb0aaf000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faeb0aaf000-7faeb4000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faeb4000000-7faeb4a8f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faeb4a8f000-7faeb8000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faeb8000000-7faeb8d05000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faeb8d05000-7faebc000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faebc000000-7faebca2a000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faebca2a000-7faec0000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faec0000000-7faec0b30000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faec0b30000-7faec4000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faec4000000-7faec4a72000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faec4a72000-7faec8000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faec8000000-7faeca77a000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faeca77a000-7faecc000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faecc000000-7faecc8f0000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faecc8f0000-7faed0000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faed0000000-7faed0b48000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faed0b48000-7faed4000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faed4000000-7faed4ace000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faed4ace000-7faed8000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faed8000000-7faed8827000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faed8827000-7faedc000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faedc000000-7faedcab4000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faedcab4000-7faee0000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faee0000000-7faee0a3a000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faee0a3a000-7faee4000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faee4000000-7faee4aae000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faee4aae000-7faee8000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faee8000000-7faee87f0000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faee87f0000-7faeec000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faeec000000-7faeecb90000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faeecb90000-7faef0000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faef0000000-7faef0a99000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faef0a99000-7faef4000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faef4000000-7faef5f3c000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faef5f3c000-7faef8000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faef8000000-7faef9523000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faef9523000-7faefc000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faefc000000-7faefcd33000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faefcd33000-7faf00000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf00000000-7faf00f75000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf00f75000-7faf04000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf04000000-7faf04a5d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf04a5d000-7faf08000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf08000000-7faf08acc000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf08acc000-7faf0c000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf0c000000-7faf0cad0000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf0cad0000-7faf10000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf10000000-7faf10909000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf10909000-7faf14000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf14000000-7faf148af000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf148af000-7faf18000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf18000000-7faf18c51000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf18c51000-7faf1c000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf1c000000-7faf1cac5000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf1cac5000-7faf20000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf20000000-7faf20ae4000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf20ae4000-7faf24000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf24000000-7faf248b0000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf248b0000-7faf28000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf28000000-7faf28ae2000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf28ae2000-7faf2c000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf2c000000-7faf2caf2000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf2caf2000-7faf30000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf30000000-7faf30b3b000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf30b3b000-7faf34000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf34000000-7faf3493b000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf3493b000-7faf38000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf38000000-7faf38918000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf38918000-7faf3c000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf3c000000-7faf3cb04000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf3cb04000-7faf40000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf40000000-7faf40b1c000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf40b1c000-7faf44000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf44000000-7faf4484e000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf4484e000-7faf48000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf48000000-7faf486fc000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf486fc000-7faf4c000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf4c000000-7faf4caa4000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf4caa4000-7faf50000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf50000000-7faf50ab0000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf50ab0000-7faf54000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf54000000-7faf54924000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf54924000-7faf58000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf58000000-7faf588d7000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf588d7000-7faf5c000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf5c000000-7faf5ccda000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf5ccda000-7faf60000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf60000000-7faf60b09000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf60b09000-7faf64000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf64000000-7faf64d59000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf64d59000-7faf68000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf68000000-7faf6870a000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf6870a000-7faf6c000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf6c000000-7faf6cb35000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf6cb35000-7faf70000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf70000000-7faf70eb6000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf70eb6000-7faf74000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf74000000-7faf74ab0000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf74ab0000-7faf78000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf78000000-7faf78a2c000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf78a2c000-7faf7c000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf7c000000-7faf7c8e7000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf7c8e7000-7faf80000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf80000000-7faf8091f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf8091f000-7faf84000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf84000000-7faf848c7000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf848c7000-7faf88000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf88000000-7faf88a6d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf88a6d000-7faf8c000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf8c000000-7faf8ca50000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf8ca50000-7faf90000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf90000000-7faf9063e000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf9063e000-7faf94000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf94000000-7faf948f2000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf948f2000-7faf98000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf9c000000-7faf9caa8000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faf9caa8000-7fafa0000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafa0000000-7fafa0662000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafa0662000-7fafa4000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafa4000000-7fafa4880000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafa4880000-7fafa8000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafa8000000-7fafa87fa000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafa87fa000-7fafac000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafac000000-7fafac7c5000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafac7c5000-7fafb0000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafb0f5c000-7fafb4000000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafb4000000-7fafb4a58000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafb4a58000-7fafb8000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafb8000000-7fafb8aa4000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafb8aa4000-7fafbc000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafbc000000-7fafbc8c4000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafbc8c4000-7fafc0000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafc0f5c000-7fafc4000000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafc4000000-7fafc4ac4000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafc4ac4000-7fafc8000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafc8f5c000-7fafcc000000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafcc000000-7fafcc7eb000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafcc7eb000-7fafd0000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd28bd000-7fafd28be000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd28be000-7fafd28ff000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd28ff000-7fafd2900000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2900000-7fafd2941000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2941000-7fafd2942000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2942000-7fafd2983000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2983000-7fafd2984000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2984000-7fafd29c5000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd29c5000-7fafd29c6000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd29c6000-7fafd2a07000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2a07000-7fafd2a08000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2a08000-7fafd2a49000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2a49000-7fafd2a4a000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2a4a000-7fafd2a8b000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2a8b000-7fafd2a8c000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2a8c000-7fafd2acd000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2acd000-7fafd2ace000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2ace000-7fafd2b0f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2b0f000-7fafd2b10000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2b10000-7fafd2b51000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2b51000-7fafd2b52000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2b52000-7fafd2b93000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2b93000-7fafd2b94000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2b94000-7fafd2bd5000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2bd5000-7fafd2bd6000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2bd6000-7fafd2c17000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2c17000-7fafd2c18000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2c18000-7fafd2c59000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2c59000-7fafd2c5a000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2c5a000-7fafd2c9b000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2c9b000-7fafd2c9c000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2c9c000-7fafd2cdd000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2cdd000-7fafd2cde000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2cde000-7fafd2d1f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2d1f000-7fafd2d20000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2d20000-7fafd2d61000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2d61000-7fafd2d62000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2d62000-7fafd2da3000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2da3000-7fafd2da4000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2da4000-7fafd2de5000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2de5000-7fafd2de6000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2de6000-7fafd2e27000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2e27000-7fafd2e28000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2e28000-7fafd2e69000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2e69000-7fafd2e6a000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2e6a000-7fafd2eab000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2eab000-7fafd2eac000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2eac000-7fafd2eed000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2eed000-7fafd2eee000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2eee000-7fafd2f2f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2f2f000-7fafd2f30000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2f30000-7fafd2f71000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2f71000-7fafd2f72000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2f72000-7fafd2fb3000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2fb3000-7fafd2fb4000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2fb4000-7fafd2ff5000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2ff5000-7fafd2ff6000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd2ff6000-7fafd37f6000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd37f6000-7fafd37f7000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd37f7000-7fafd3ff7000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd3ff7000-7fafd3ff8000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd3ff8000-7fafd47f8000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd47f8000-7fafd47f9000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd47f9000-7fafd4ff9000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd4ff9000-7fafd4ffa000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd4ffa000-7fafd57fa000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd57fa000-7fafd57fb000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd57fb000-7fafd5ffb000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd5ffb000-7fafd5ffc000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd5ffc000-7fafd67fc000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd67fc000-7fafd67fd000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd67fd000-7fafd6ffd000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd6ffd000-7fafd6ffe000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd6ffe000-7fafd77fe000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd77fe000-7fafd77ff000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd77ff000-7fafd7fff000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd7fff000-7fafd8000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd8000000-7fafd8800000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd8800000-7fafd8801000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd8801000-7fafd9001000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd9001000-7fafd9002000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd9002000-7fafd9802000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd9802000-7fafd9803000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafd9803000-7fafda003000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafda003000-7fafda004000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafda004000-7fafe5e6b000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe5e79000-7fafe5e7a000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe5e7a000-7fafe5ebb000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe5ebb000-7fafe5ebc000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe5ebc000-7fafe5efd000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe5efd000-7fafe5efe000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe5efe000-7fafe5f3f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe5f3f000-7fafe5f40000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe5f40000-7fafe5f81000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe5f81000-7fafe5f82000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe5f82000-7fafe5fc3000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe5fc3000-7fafe5fc4000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe5fc4000-7fafe6005000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6005000-7fafe6006000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6006000-7fafe6047000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6047000-7fafe6048000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6047000-7fafe6048000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6048000-7fafe6089000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6089000-7fafe608a000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe608a000-7fafe60cb000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe60cb000-7fafe60cc000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe60cc000-7fafe610d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe610d000-7fafe610e000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe610e000-7fafe614f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe614f000-7fafe6150000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6150000-7fafe6191000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6191000-7fafe6192000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6192000-7fafe61d3000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe61d3000-7fafe61d4000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe61d4000-7fafe6215000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6215000-7fafe6216000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6216000-7fafe6257000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6257000-7fafe6258000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6258000-7fafe6299000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6299000-7fafe629a000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe629a000-7fafe62db000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe62db000-7fafe62dc000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe62dc000-7fafe631d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe631d000-7fafe631e000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe631e000-7fafe635f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe635f000-7fafe6360000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6360000-7fafe63a1000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe63a1000-7fafe63a2000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe63a2000-7fafe63e3000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe63e3000-7fafe63e4000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe63e4000-7fafe6425000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6425000-7fafe6426000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6426000-7fafe6467000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6467000-7fafe6468000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6468000-7fafe64a9000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe64a9000-7fafe64aa000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe64aa000-7fafe64eb000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe64eb000-7fafe64ec000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe64ec000-7fafe652d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe652d000-7fafe652e000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe652e000-7fafe656f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe656f000-7fafe6570000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6570000-7fafe65b1000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe65b1000-7fafe65b2000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe65b2000-7fafe65f3000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe65f3000-7fafe65f4000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe65f4000-7fafe6635000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6635000-7fafe6636000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6636000-7fafe6677000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6677000-7fafe6678000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6678000-7fafe66b9000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe66b9000-7fafe66ba000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe66ba000-7fafe66fb000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe66fb000-7fafe66fc000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe66fc000-7fafe673d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe673d000-7fafe673e000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe673e000-7fafe677f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe677f000-7fafe6780000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6780000-7fafe67c1000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe67c1000-7fafe67c2000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6803000-7fafe6804000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6804000-7fafe6845000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6845000-7fafe6846000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6846000-7fafe6887000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6887000-7fafe6888000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6888000-7fafe68c9000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe68c9000-7fafe68ca000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe68ca000-7fafe690b000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe690b000-7fafe690c000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe690c000-7fafe694d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe694d000-7fafe694e000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe694e000-7fafe698f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe698f000-7fafe6990000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6990000-7fafe69d1000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe69d1000-7fafe69d2000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe69d2000-7fafe6a13000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6a13000-7fafe6a14000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6a14000-7fafe6a55000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6a55000-7fafe6a56000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6a56000-7fafe6a97000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6a97000-7fafe6a98000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6a98000-7fafe6ad9000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6ad9000-7fafe6ada000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6ada000-7fafe6b1b000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6b1b000-7fafe6b1c000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6b1c000-7fafe6b5d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6b5d000-7fafe6b5e000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6b5e000-7fafe6b9f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6b9f000-7fafe6ba0000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6ba0000-7fafe6be1000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6be1000-7fafe6be2000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6be2000-7fafe6c23000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6c23000-7fafe6c24000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6c24000-7fafe6c65000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6c65000-7fafe6c66000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6c66000-7fafe6ca7000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6ca7000-7fafe6ca8000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6ca8000-7fafe6ce9000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6ce9000-7fafe6cea000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6cea000-7fafe6d2b000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6d2b000-7fafe6d2c000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6d2c000-7fafe6d6d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6d6d000-7fafe6d6e000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6d6e000-7fafe6daf000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6daf000-7fafe6db0000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6db0000-7fafe6df1000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6df1000-7fafe6df2000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6df2000-7fafe6e33000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6e33000-7fafe6e34000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6e34000-7fafe6e75000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6e75000-7fafe6e76000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6e76000-7fafe6eb7000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6eb7000-7fafe6eb8000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6eb8000-7fafe6ef9000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6ef9000-7fafe6efa000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6efa000-7fafe6f3b000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6f3b000-7fafe6f3c000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6f3c000-7fafe6f7d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6f7d000-7fafe6f7e000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe6f7e000-7fafe6fbf000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe71cf000-7fafe71d0000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe71d0000-7fafe7211000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7211000-7fafe7212000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7212000-7fafe7253000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7253000-7fafe7254000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7254000-7fafe7295000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7295000-7fafe7296000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7296000-7fafe72d7000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe72d7000-7fafe72d8000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe72d8000-7fafe7319000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7319000-7fafe731a000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe731a000-7fafe735b000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe735b000-7fafe735c000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe735c000-7fafe739d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe739d000-7fafe739e000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe739e000-7fafe73df000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe73df000-7fafe73e0000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe73e0000-7fafe7421000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7421000-7fafe7422000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7422000-7fafe7463000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7463000-7fafe7464000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7464000-7fafe74a5000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe74a5000-7fafe74a6000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe74a6000-7fafe74e7000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe74e7000-7fafe74e8000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe74e8000-7fafe7529000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7529000-7fafe752a000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe752a000-7fafe756b000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe756b000-7fafe756c000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe756c000-7fafe75ad000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe75ad000-7fafe75ae000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe75ae000-7fafe75ef000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe75ef000-7fafe75f0000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe75f0000-7fafe7631000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7631000-7fafe7632000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7632000-7fafe7673000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7673000-7fafe7674000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7674000-7fafe76b5000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe76b5000-7fafe76b6000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe76b6000-7fafe76f7000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe76f7000-7fafe76f8000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe76f8000-7fafe7739000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7739000-7fafe773a000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe773a000-7fafe777b000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe777b000-7fafe777c000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe777c000-7fafe77bd000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe77bd000-7fafe77be000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe77be000-7fafe77ff000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe77ff000-7fafe7800000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe7800000-7fafe8000000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe8000000-7fafe888f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafe888f000-7fafec000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafec000000-7fafec655000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fafec655000-7faff0000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff0000000-7faff047f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff047f000-7faff4000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff4000000-7faff48be000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff48be000-7faff8000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff801e000-7faff801f000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff801f000-7faff8060000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff8060000-7faff8061000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff8061000-7faff80a2000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff80a2000-7faff80a3000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff80a3000-7faff80e4000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff80e4000-7faff80e5000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff80e5000-7faff8126000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff8126000-7faff8127000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff8127000-7faff8168000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff8168000-7faff8169000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff8169000-7faff81aa000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff81aa000-7faff81ab000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff81ab000-7faff81ec000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff81ec000-7faff81ed000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff81ed000-7faff822e000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff822e000-7faff822f000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff822f000-7faff8270000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff8270000-7faff8271000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff8271000-7faff82b2000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff82b2000-7faff82b3000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff82b3000-7faff82f4000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff82f4000-7faff82f5000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff82f5000-7faff8336000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff8336000-7faff8337000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff8337000-7faff8378000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff8378000-7faff8379000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff8379000-7faff8b79000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff8b79000-7faff8b7a000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff8b7a000-7faff937a000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff937a000-7faff937b000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff937b000-7faff9b7b000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff9b7b000-7faff9b7c000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faff9b7c000-7faffa37c000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffa37c000-7faffa37d000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffa37d000-7faffab7d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffab7d000-7faffab7e000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffab7e000-7faffb37e000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffb37e000-7faffb37f000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffb37f000-7faffbb7f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffbb7f000-7faffbb80000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffbb80000-7faffc380000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffc380000-7faffc381000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffc381000-7faffcb81000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffcb81000-7faffcb82000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffcb82000-7faffd382000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffd382000-7faffd383000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffd383000-7faffdb83000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffdb83000-7faffdb84000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffdb84000-7faffe384000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffe384000-7faffeb84000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7faffeb84000-7fb014000000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb014000000-7fb614000000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb614000000-7fb614696000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb614696000-7fb618000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618005000-7fb618006000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618006000-7fb618047000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618047000-7fb618048000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618048000-7fb618089000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618089000-7fb61808a000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb61808a000-7fb6180cb000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb6180cb000-7fb6180cc000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb6180cc000-7fb61810d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb61810d000-7fb61810e000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb61810e000-7fb61814f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb61814f000-7fb618150000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618150000-7fb618191000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618191000-7fb618192000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618192000-7fb6181d3000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb6181d3000-7fb6181d4000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb6181d4000-7fb618215000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618215000-7fb618216000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618216000-7fb618257000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618257000-7fb618258000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618258000-7fb618299000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618299000-7fb61829a000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb61829a000-7fb6182db000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb6182db000-7fb6182dc000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb6182dc000-7fb61831d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb61831d000-7fb61831e000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb61831e000-7fb61835f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb61835f000-7fb618360000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618360000-7fb6183a1000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb6183a1000-7fb6183a2000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb6183a2000-7fb6183e3000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb6183e3000-7fb6183e4000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb6183e4000-7fb618425000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618425000-7fb618426000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fb618426000-7fba1c000000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba1c000000-7fba1c9e9000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba1c9e9000-7fba20000000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba20005000-7fba20006000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba20006000-7fba20047000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba20047000-7fba20048000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba20048000-7fba20089000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba20089000-7fba2008a000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba2008a000-7fba200cb000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba200cb000-7fba200cc000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba200cc000-7fba2010d000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba2010d000-7fba2010e000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba2010e000-7fba2014f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba2014f000-7fba20150000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba20150000-7fba20191000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba20191000-7fba20192000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba20192000-7fba201d3000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba201d3000-7fba201d4000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba201d4000-7fba20215000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba20215000-7fba20216000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba20216000-7fba20257000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba20257000-7fba20258000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba20258000-7fba22d4c000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba22d4c000-7fba22d4d000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba22d4d000-7fba23736000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba23736000-7fba23737000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba23737000-7fba2bf33000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba2bf33000-7fba2bf3f000 r-xp 00000000 09:02 1445708                    /usr/lib64/libnss_files-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2bf3f000-7fba2c13e000 ---p 0000c000 09:02 1445708                    /usr/lib64/libnss_files-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2c13e000-7fba2c13f000 r--p 0000b000 09:02 1445708                    /usr/lib64/libnss_files-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2c13f000-7fba2c140000 rw-p 0000c000 09:02 1445708                    /usr/lib64/libnss_files-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2c140000-7fba2c146000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba2c146000-7fba2c149000 r-xp 00000000 09:02 1445691                    /usr/lib64/libkeyutils.so.1.5
Aug  5 11:58:49 mysql mysqld: 7fba2c149000-7fba2c348000 ---p 00003000 09:02 1445691                    /usr/lib64/libkeyutils.so.1.5
Aug  5 11:58:49 mysql mysqld: 7fba2c348000-7fba2c349000 r--p 00002000 09:02 1445691                    /usr/lib64/libkeyutils.so.1.5
Aug  5 11:58:49 mysql mysqld: 7fba2c349000-7fba2c34a000 rw-p 00003000 09:02 1445691                    /usr/lib64/libkeyutils.so.1.5
Aug  5 11:58:49 mysql mysqld: 7fba2c34a000-7fba2c358000 r-xp 00000000 09:02 1445798                    /usr/lib64/libkrb5support.so.0.1
Aug  5 11:58:49 mysql mysqld: 7fba2c358000-7fba2c558000 ---p 0000e000 09:02 1445798                    /usr/lib64/libkrb5support.so.0.1
Aug  5 11:58:49 mysql mysqld: 7fba2c558000-7fba2c559000 r--p 0000e000 09:02 1445798                    /usr/lib64/libkrb5support.so.0.1
Aug  5 11:58:49 mysql mysqld: 7fba2c559000-7fba2c55a000 rw-p 0000f000 09:02 1445798                    /usr/lib64/libkrb5support.so.0.1
Aug  5 11:58:49 mysql mysqld: 7fba2c55a000-7fba2c569000 r-xp 00000000 09:02 1445683                    /usr/lib64/libbz2.so.1.0.6
Aug  5 11:58:49 mysql mysqld: 7fba2c569000-7fba2c768000 ---p 0000f000 09:02 1445683                    /usr/lib64/libbz2.so.1.0.6
Aug  5 11:58:49 mysql mysqld: 7fba2c768000-7fba2c769000 r--p 0000e000 09:02 1445683                    /usr/lib64/libbz2.so.1.0.6
Aug  5 11:58:49 mysql mysqld: 7fba2c769000-7fba2c76a000 rw-p 0000f000 09:02 1445683                    /usr/lib64/libbz2.so.1.0.6
Aug  5 11:58:49 mysql mysqld: 7fba2c76a000-7fba2c781000 r-xp 00000000 09:02 1446147                    /usr/lib64/libelf-0.172.so
Aug  5 11:58:49 mysql mysqld: 7fba2c781000-7fba2c980000 ---p 00017000 09:02 1446147                    /usr/lib64/libelf-0.172.so
Aug  5 11:58:49 mysql mysqld: 7fba2c980000-7fba2c981000 r--p 00016000 09:02 1446147                    /usr/lib64/libelf-0.172.so
Aug  5 11:58:49 mysql mysqld: 7fba2c981000-7fba2c982000 rw-p 00017000 09:02 1446147                    /usr/lib64/libelf-0.172.so
Aug  5 11:58:49 mysql mysqld: 7fba2c982000-7fba2c9e2000 r-xp 00000000 09:02 1446189                    /usr/lib64/libpcre.so.1.2.0
Aug  5 11:58:49 mysql mysqld: 7fba2c9e2000-7fba2cbe2000 ---p 00060000 09:02 1446189                    /usr/lib64/libpcre.so.1.2.0
Aug  5 11:58:49 mysql mysqld: 7fba2cbe2000-7fba2cbe3000 r--p 00060000 09:02 1446189                    /usr/lib64/libpcre.so.1.2.0
Aug  5 11:58:49 mysql mysqld: 7fba2cbe3000-7fba2cbe4000 rw-p 00061000 09:02 1446189                    /usr/lib64/libpcre.so.1.2.0
Aug  5 11:58:49 mysql mysqld: 7fba2cbe4000-7fba2cbe8000 r-xp 00000000 09:02 1445846                    /usr/lib64/libattr.so.1.1.0
Aug  5 11:58:49 mysql mysqld: 7fba2cbe8000-7fba2cde7000 ---p 00004000 09:02 1445846                    /usr/lib64/libattr.so.1.1.0
Aug  5 11:58:49 mysql mysqld: 7fba2cde7000-7fba2cde8000 r--p 00003000 09:02 1445846                    /usr/lib64/libattr.so.1.1.0
Aug  5 11:58:49 mysql mysqld: 7fba2cde8000-7fba2cde9000 rw-p 00004000 09:02 1445846                    /usr/lib64/libattr.so.1.1.0
Aug  5 11:58:49 mysql mysqld: 7fba2cde9000-7fba2ce1a000 r-xp 00000000 09:02 1445824                    /usr/lib64/libk5crypto.so.3.1
Aug  5 11:58:49 mysql mysqld: 7fba2ce1a000-7fba2d019000 ---p 00031000 09:02 1445824                    /usr/lib64/libk5crypto.so.3.1
Aug  5 11:58:49 mysql mysqld: 7fba2d019000-7fba2d01b000 r--p 00030000 09:02 1445824                    /usr/lib64/libk5crypto.so.3.1
Aug  5 11:58:49 mysql mysqld: 7fba2d01b000-7fba2d01c000 rw-p 00032000 09:02 1445824                    /usr/lib64/libk5crypto.so.3.1
Aug  5 11:58:49 mysql mysqld: 7fba2d01c000-7fba2d01f000 r-xp 00000000 09:02 1446097                    /usr/lib64/libcom_err.so.2.1
Aug  5 11:58:49 mysql mysqld: 7fba2d01f000-7fba2d21e000 ---p 00003000 09:02 1446097                    /usr/lib64/libcom_err.so.2.1
Aug  5 11:58:49 mysql mysqld: 7fba2d21e000-7fba2d21f000 r--p 00002000 09:02 1446097                    /usr/lib64/libcom_err.so.2.1
Aug  5 11:58:49 mysql mysqld: 7fba2d21f000-7fba2d220000 rw-p 00003000 09:02 1446097                    /usr/lib64/libcom_err.so.2.1
Aug  5 11:58:49 mysql mysqld: 7fba2d220000-7fba2d2f9000 r-xp 00000000 09:02 1445835                    /usr/lib64/libkrb5.so.3.3
Aug  5 11:58:49 mysql mysqld: 7fba2d2f9000-7fba2d4f8000 ---p 000d9000 09:02 1445835                    /usr/lib64/libkrb5.so.3.3
Aug  5 11:58:49 mysql mysqld: 7fba2d4f8000-7fba2d506000 r--p 000d8000 09:02 1445835                    /usr/lib64/libkrb5.so.3.3
Aug  5 11:58:49 mysql mysqld: 7fba2d506000-7fba2d509000 rw-p 000e6000 09:02 1445835                    /usr/lib64/libkrb5.so.3.3
Aug  5 11:58:49 mysql mysqld: 7fba2d509000-7fba2d553000 r-xp 00000000 09:02 1445893                    /usr/lib64/libgssapi_krb5.so.2.2
Aug  5 11:58:49 mysql mysqld: 7fba2d553000-7fba2d753000 ---p 0004a000 09:02 1445893                    /usr/lib64/libgssapi_krb5.so.2.2
Aug  5 11:58:49 mysql mysqld: 7fba2d753000-7fba2d754000 r--p 0004a000 09:02 1445893                    /usr/lib64/libgssapi_krb5.so.2.2
Aug  5 11:58:49 mysql mysqld: 7fba2d754000-7fba2d756000 rw-p 0004b000 09:02 1445893                    /usr/lib64/libgssapi_krb5.so.2.2
Aug  5 11:58:49 mysql mysqld: 7fba2d756000-7fba2d76b000 r-xp 00000000 09:02 1445450                    /usr/lib64/libgcc_s-4.8.5-20150702.so.1
Aug  5 11:58:49 mysql mysqld: 7fba2d76b000-7fba2d96a000 ---p 00015000 09:02 1445450                    /usr/lib64/libgcc_s-4.8.5-20150702.so.1
Aug  5 11:58:49 mysql mysqld: 7fba2d96a000-7fba2d96b000 r--p 00014000 09:02 1445450                    /usr/lib64/libgcc_s-4.8.5-20150702.so.1
Aug  5 11:58:49 mysql mysqld: 7fba2d96b000-7fba2d96c000 rw-p 00015000 09:02 1445450                    /usr/lib64/libgcc_s-4.8.5-20150702.so.1
Aug  5 11:58:49 mysql mysqld: 7fba2d96c000-7fba2d9b8000 r-xp 00000000 09:02 1445719                    /usr/lib64/libdw-0.172.so
Aug  5 11:58:49 mysql mysqld: 7fba2d9b8000-7fba2dbb8000 ---p 0004c000 09:02 1445719                    /usr/lib64/libdw-0.172.so
Aug  5 11:58:49 mysql mysqld: 7fba2dbb8000-7fba2dbba000 r--p 0004c000 09:02 1445719                    /usr/lib64/libdw-0.172.so
Aug  5 11:58:49 mysql mysqld: 7fba2dbba000-7fba2dbbb000 rw-p 0004e000 09:02 1445719                    /usr/lib64/libdw-0.172.so
Aug  5 11:58:49 mysql mysqld: 7fba2dbbb000-7fba2dbd1000 r-xp 00000000 09:02 1445808                    /usr/lib64/libresolv-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2dbd1000-7fba2ddd0000 ---p 00016000 09:02 1445808                    /usr/lib64/libresolv-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2ddd0000-7fba2ddd1000 r--p 00015000 09:02 1445808                    /usr/lib64/libresolv-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2ddd1000-7fba2ddd2000 rw-p 00016000 09:02 1445808                    /usr/lib64/libresolv-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2ddd2000-7fba2ddd4000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba2ddd4000-7fba2ddd8000 r-xp 00000000 09:02 1446111                    /usr/lib64/libgpg-error.so.0.10.0
Aug  5 11:58:49 mysql mysqld: 7fba2ddd8000-7fba2dfd7000 ---p 00004000 09:02 1446111                    /usr/lib64/libgpg-error.so.0.10.0
Aug  5 11:58:49 mysql mysqld: 7fba2dfd7000-7fba2dfd8000 r--p 00003000 09:02 1446111                    /usr/lib64/libgpg-error.so.0.10.0
Aug  5 11:58:49 mysql mysqld: 7fba2dfd8000-7fba2dfd9000 rw-p 00004000 09:02 1446111                    /usr/lib64/libgpg-error.so.0.10.0
Aug  5 11:58:49 mysql mysqld: 7fba2dfd9000-7fba2e056000 r-xp 00000000 09:02 1446077                    /usr/lib64/libgcrypt.so.11.8.2
Aug  5 11:58:49 mysql mysqld: 7fba2e056000-7fba2e255000 ---p 0007d000 09:02 1446077                    /usr/lib64/libgcrypt.so.11.8.2
Aug  5 11:58:49 mysql mysqld: 7fba2e255000-7fba2e256000 r--p 0007c000 09:02 1446077                    /usr/lib64/libgcrypt.so.11.8.2
Aug  5 11:58:49 mysql mysqld: 7fba2e256000-7fba2e259000 rw-p 0007d000 09:02 1446077                    /usr/lib64/libgcrypt.so.11.8.2
Aug  5 11:58:49 mysql mysqld: 7fba2e259000-7fba2e25a000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba2e25a000-7fba2e26e000 r-xp 00000000 09:02 1446260                    /usr/lib64/liblz4.so.1.7.5
Aug  5 11:58:49 mysql mysqld: 7fba2e26e000-7fba2e46d000 ---p 00014000 09:02 1446260                    /usr/lib64/liblz4.so.1.7.5
Aug  5 11:58:49 mysql mysqld: 7fba2e46d000-7fba2e46e000 r--p 00013000 09:02 1446260                    /usr/lib64/liblz4.so.1.7.5
Aug  5 11:58:49 mysql mysqld: 7fba2e46e000-7fba2e46f000 rw-p 00014000 09:02 1446260                    /usr/lib64/liblz4.so.1.7.5
Aug  5 11:58:49 mysql mysqld: 7fba2e46f000-7fba2e493000 r-xp 00000000 09:02 1445728                    /usr/lib64/libselinux.so.1
Aug  5 11:58:49 mysql mysqld: 7fba2e493000-7fba2e692000 ---p 00024000 09:02 1445728                    /usr/lib64/libselinux.so.1
Aug  5 11:58:49 mysql mysqld: 7fba2e692000-7fba2e693000 r--p 00023000 09:02 1445728                    /usr/lib64/libselinux.so.1
Aug  5 11:58:49 mysql mysqld: 7fba2e693000-7fba2e694000 rw-p 00024000 09:02 1445728                    /usr/lib64/libselinux.so.1
Aug  5 11:58:49 mysql mysqld: 7fba2e694000-7fba2e696000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba2e696000-7fba2e69d000 r-xp 00000000 09:02 1445830                    /usr/lib64/librt-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2e69d000-7fba2e89c000 ---p 00007000 09:02 1445830                    /usr/lib64/librt-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2e89c000-7fba2e89d000 r--p 00006000 09:02 1445830                    /usr/lib64/librt-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2e89d000-7fba2e89e000 rw-p 00007000 09:02 1445830                    /usr/lib64/librt-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2e89e000-7fba2e8a2000 r-xp 00000000 09:02 1446122                    /usr/lib64/libcap.so.2.22
Aug  5 11:58:49 mysql mysqld: 7fba2e8a2000-7fba2eaa1000 ---p 00004000 09:02 1446122                    /usr/lib64/libcap.so.2.22
Aug  5 11:58:49 mysql mysqld: 7fba2eaa1000-7fba2eaa2000 r--p 00003000 09:02 1446122                    /usr/lib64/libcap.so.2.22
Aug  5 11:58:49 mysql mysqld: 7fba2eaa2000-7fba2eaa3000 rw-p 00004000 09:02 1446122                    /usr/lib64/libcap.so.2.22
Aug  5 11:58:49 mysql mysqld: 7fba2eaa3000-7fba2eaa5000 r-xp 00000000 09:02 1445873                    /usr/lib64/libfreebl3.so
Aug  5 11:58:49 mysql mysqld: 7fba2eaa5000-7fba2eca4000 ---p 00002000 09:02 1445873                    /usr/lib64/libfreebl3.so
Aug  5 11:58:49 mysql mysqld: 7fba2eca4000-7fba2eca5000 r--p 00001000 09:02 1445873                    /usr/lib64/libfreebl3.so
Aug  5 11:58:49 mysql mysqld: 7fba2eca5000-7fba2eca6000 rw-p 00002000 09:02 1445873                    /usr/lib64/libfreebl3.so
Aug  5 11:58:49 mysql mysqld: 7fba2eca6000-7fba2ee68000 r-xp 00000000 09:02 1445319                    /usr/lib64/libc-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2ee68000-7fba2f068000 ---p 001c2000 09:02 1445319                    /usr/lib64/libc-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2f068000-7fba2f06c000 r--p 001c2000 09:02 1445319                    /usr/lib64/libc-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2f06c000-7fba2f06e000 rw-p 001c6000 09:02 1445319                    /usr/lib64/libc-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2f06e000-7fba2f073000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba2f073000-7fba2f174000 r-xp 00000000 09:02 1445342                    /usr/lib64/libm-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2f174000-7fba2f373000 ---p 00101000 09:02 1445342                    /usr/lib64/libm-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2f373000-7fba2f374000 r--p 00100000 09:02 1445342                    /usr/lib64/libm-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2f374000-7fba2f375000 rw-p 00101000 09:02 1445342                    /usr/lib64/libm-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2f375000-7fba2f45e000 r-xp 00000000 09:02 1445733                    /usr/lib64/libstdc++.so.6.0.19
Aug  5 11:58:49 mysql mysqld: 7fba2f45e000-7fba2f65d000 ---p 000e9000 09:02 1445733                    /usr/lib64/libstdc++.so.6.0.19
Aug  5 11:58:49 mysql mysqld: 7fba2f65d000-7fba2f665000 r--p 000e8000 09:02 1445733                    /usr/lib64/libstdc++.so.6.0.19
Aug  5 11:58:49 mysql mysqld: 7fba2f665000-7fba2f667000 rw-p 000f0000 09:02 1445733                    /usr/lib64/libstdc++.so.6.0.19
Aug  5 11:58:49 mysql mysqld: 7fba2f667000-7fba2f67c000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba2f67c000-7fba2f67e000 r-xp 00000000 09:02 1445335                    /usr/lib64/libdl-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2f67e000-7fba2f87e000 ---p 00002000 09:02 1445335                    /usr/lib64/libdl-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2f87e000-7fba2f87f000 r--p 00002000 09:02 1445335                    /usr/lib64/libdl-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2f87f000-7fba2f880000 rw-p 00003000 09:02 1445335                    /usr/lib64/libdl-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba2f880000-7fba2fab5000 r-xp 00000000 09:02 1445788                    /usr/lib64/libcrypto.so.1.0.2k
Aug  5 11:58:49 mysql mysqld: 7fba2fab5000-7fba2fcb5000 ---p 00235000 09:02 1445788                    /usr/lib64/libcrypto.so.1.0.2k
Aug  5 11:58:49 mysql mysqld: 7fba2fcb5000-7fba2fcd1000 r--p 00235000 09:02 1445788                    /usr/lib64/libcrypto.so.1.0.2k
Aug  5 11:58:49 mysql mysqld: 7fba2fcd1000-7fba2fcde000 rw-p 00251000 09:02 1445788                    /usr/lib64/libcrypto.so.1.0.2k
Aug  5 11:58:49 mysql mysqld: 7fba2fcde000-7fba2fce2000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba2fce2000-7fba2fd49000 r-xp 00000000 09:02 1445959                    /usr/lib64/libssl.so.1.0.2k
Aug  5 11:58:49 mysql mysqld: 7fba2fd49000-7fba2ff49000 ---p 00067000 09:02 1445959                    /usr/lib64/libssl.so.1.0.2k
Aug  5 11:58:49 mysql mysqld: 7fba2ff49000-7fba2ff4d000 r--p 00067000 09:02 1445959                    /usr/lib64/libssl.so.1.0.2k
Aug  5 11:58:49 mysql mysqld: 7fba2ff4d000-7fba2ff54000 rw-p 0006b000 09:02 1445959                    /usr/lib64/libssl.so.1.0.2k
Aug  5 11:58:49 mysql mysqld: 7fba2ff54000-7fba2ff83000 r-xp 00000000 09:02 1445936                    /usr/lib64/libsystemd.so.0.6.0
Aug  5 11:58:49 mysql mysqld: 7fba2ff83000-7fba30183000 ---p 0002f000 09:02 1445936                    /usr/lib64/libsystemd.so.0.6.0
Aug  5 11:58:49 mysql mysqld: 7fba30183000-7fba30184000 r--p 0002f000 09:02 1445936                    /usr/lib64/libsystemd.so.0.6.0
Aug  5 11:58:49 mysql mysqld: 7fba30184000-7fba30185000 rw-p 00030000 09:02 1445936                    /usr/lib64/libsystemd.so.0.6.0
Aug  5 11:58:49 mysql mysqld: 7fba30185000-7fba3018d000 r-xp 00000000 09:02 1445329                    /usr/lib64/libcrypt-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba3018d000-7fba3038c000 ---p 00008000 09:02 1445329                    /usr/lib64/libcrypt-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba3038c000-7fba3038d000 r--p 00007000 09:02 1445329                    /usr/lib64/libcrypt-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba3038d000-7fba3038e000 rw-p 00008000 09:02 1445329                    /usr/lib64/libcrypt-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba3038e000-7fba303bc000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba303bc000-7fba303d1000 r-xp 00000000 09:02 1445916                    /usr/lib64/libz.so.1.2.7
Aug  5 11:58:49 mysql mysqld: 7fba303d1000-7fba305d0000 ---p 00015000 09:02 1445916                    /usr/lib64/libz.so.1.2.7
Aug  5 11:58:49 mysql mysqld: 7fba305d0000-7fba305d1000 r--p 00014000 09:02 1445916                    /usr/lib64/libz.so.1.2.7
Aug  5 11:58:49 mysql mysqld: 7fba305d1000-7fba305d2000 rw-p 00015000 09:02 1445916                    /usr/lib64/libz.so.1.2.7
Aug  5 11:58:49 mysql mysqld: 7fba305d2000-7fba305d3000 r-xp 00000000 09:02 1446227                    /usr/lib64/libaio.so.1.0.1
Aug  5 11:58:49 mysql mysqld: 7fba305d3000-7fba307d2000 ---p 00001000 09:02 1446227                    /usr/lib64/libaio.so.1.0.1
Aug  5 11:58:49 mysql mysqld: 7fba307d2000-7fba307d3000 r--p 00000000 09:02 1446227                    /usr/lib64/libaio.so.1.0.1
Aug  5 11:58:49 mysql mysqld: 7fba307d3000-7fba307d4000 rw-p 00001000 09:02 1446227                    /usr/lib64/libaio.so.1.0.1
Aug  5 11:58:49 mysql mysqld: 7fba307d4000-7fba307f9000 r-xp 00000000 09:02 1446120                    /usr/lib64/liblzma.so.5.2.2
Aug  5 11:58:49 mysql mysqld: 7fba307f9000-7fba309f8000 ---p 00025000 09:02 1446120                    /usr/lib64/liblzma.so.5.2.2
Aug  5 11:58:49 mysql mysqld: 7fba309f8000-7fba309f9000 r--p 00024000 09:02 1446120                    /usr/lib64/liblzma.so.5.2.2
Aug  5 11:58:49 mysql mysqld: 7fba309f9000-7fba309fa000 rw-p 00025000 09:02 1446120                    /usr/lib64/liblzma.so.5.2.2
Aug  5 11:58:49 mysql mysqld: 7fba309fa000-7fba30a11000 r-xp 00000000 09:02 1445769                    /usr/lib64/libpthread-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba30a11000-7fba30c10000 ---p 00017000 09:02 1445769                    /usr/lib64/libpthread-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba30c10000-7fba30c11000 r--p 00016000 09:02 1445769                    /usr/lib64/libpthread-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba30c11000-7fba30c12000 rw-p 00017000 09:02 1445769                    /usr/lib64/libpthread-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba30c12000-7fba30c16000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba30c16000-7fba30c38000 r-xp 00000000 09:02 1444752                    /usr/lib64/ld-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba30c3d000-7fba30c3e000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba30c3e000-7fba30c7f000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba30c7f000-7fba30c80000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba30c80000-7fba30cc1000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba30cc1000-7fba30cc2000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba30cc2000-7fba30d03000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba30d03000-7fba30d04000 ---p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba30d04000-7fba30d46000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba30d46000-7fba30d49000 rw-s 00000000 00:0b 21933546                   /[aio] (deleted)
Aug  5 11:58:49 mysql mysqld: 7fba30d49000-7fba30d4c000 rw-s 00000000 00:0b 21933545                   /[aio] (deleted)
Aug  5 11:58:49 mysql mysqld: 7fba30d4c000-7fba30d4f000 rw-s 00000000 00:0b 21933544                   /[aio] (deleted)
Aug  5 11:58:49 mysql mysqld: 7fba30d4f000-7fba30d52000 rw-s 00000000 00:0b 21933543                   /[aio] (deleted)
Aug  5 11:58:49 mysql mysqld: 7fba30d52000-7fba30d55000 rw-s 00000000 00:0b 21933542                   /[aio] (deleted)
Aug  5 11:58:49 mysql mysqld: 7fba30d55000-7fba30d58000 rw-s 00000000 00:0b 21933541                   /[aio] (deleted)
Aug  5 11:58:49 mysql mysqld: 7fba30d58000-7fba30d5b000 rw-s 00000000 00:0b 21933540                   /[aio] (deleted)
Aug  5 11:58:49 mysql mysqld: 7fba30d5b000-7fba30d5e000 rw-s 00000000 00:0b 21933539                   /[aio] (deleted)
Aug  5 11:58:49 mysql mysqld: 7fba30d5e000-7fba30e2e000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba30e2e000-7fba30e2f000 rw-s 00000000 00:0b 21933547                   /[aio] (deleted)
Aug  5 11:58:49 mysql mysqld: 7fba30e2f000-7fba30e32000 rw-s 00000000 00:0b 21933538                   /[aio] (deleted)
Aug  5 11:58:49 mysql mysqld: 7fba30e32000-7fba30e35000 rw-s 00000000 00:0b 21933537                   /[aio] (deleted)
Aug  5 11:58:49 mysql mysqld: 7fba30e35000-7fba30e36000 rw-s 00000000 00:0b 21933536                   /[aio] (deleted)
Aug  5 11:58:49 mysql mysqld: 7fba30e36000-7fba30e37000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7fba30e37000-7fba30e38000 r--p 00021000 09:02 1444752                    /usr/lib64/ld-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba30e38000-7fba30e39000 rw-p 00022000 09:02 1444752                    /usr/lib64/ld-2.17.so
Aug  5 11:58:49 mysql mysqld: 7fba30e39000-7fba30e3a000 rw-p 00000000 00:00 0
Aug  5 11:58:49 mysql mysqld: 7ffeb8b85000-7ffeb8ba6000 rw-p 00000000 00:00 0                          [stack]
Aug  5 11:58:49 mysql mysqld: 7ffeb8bd2000-7ffeb8bd4000 r-xp 00000000 00:00 0                          [vdso]
Aug  5 11:58:49 mysql mysqld: ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
Aug  5 11:58:49 mysql mysqld: Fatal signal 6 while backtracing
Aug  5 11:58:49 mysql systemd: mariadb.service: main process exited, code=killed, status=6/ABRT
Aug  5 11:58:49 mysql systemd: Unit mariadb.service entered failed state.
Aug  5 11:58:49 mysql systemd: mariadb.service failed.

I use the CentOS packages from MariaDB official repository: http://yum.mariadb.org/10.4/centos7-amd64

Thanks for your assistance!



 Comments   
Comment by Elena Stepanova [ 2019-08-05 ]

Could you please provide your cnf file(s) and the output of

SHOW CREATE TABLE `actor`;
SHOW CREATE TABLE `oldimage`;
SHOW INDEX IN `actor`;
SHOW INDEX IN `oldimage`;

If any of the tables is a view, then also the same for all tables referred by the view.

Thanks.

Comment by Guillaume M [ 2019-08-05 ]

Hi Elena,

Please find the requested information below.

/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
 
[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

SHOW CREATE TABLE `actor`;
==================

CREATE TABLE `actor` (
 `actor_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `actor_user` int(10) unsigned DEFAULT NULL,
 `actor_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 PRIMARY KEY (`actor_id`),
 UNIQUE KEY `actor_name` (`actor_name`),
 UNIQUE KEY `actor_user` (`actor_user`)
) ENGINE=InnoDB AUTO_INCREMENT=852 DEFAULT CHARSET=utf8

SHOW CREATE TABLE `oldimage`;
=====================

CREATE TABLE `oldimage` (
 `oi_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
 `oi_archive_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
 `oi_size` int(10) unsigned NOT NULL DEFAULT 0,
 `oi_width` int(11) NOT NULL DEFAULT 0,
 `oi_height` int(11) NOT NULL DEFAULT 0,
 `oi_bits` int(11) NOT NULL DEFAULT 0,
 `oi_description` varbinary(767) NOT NULL DEFAULT '',
 `oi_description_id` bigint(20) unsigned NOT NULL DEFAULT 0,
 `oi_user` int(10) unsigned NOT NULL DEFAULT 0,
 `oi_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
 `oi_actor` bigint(20) unsigned NOT NULL DEFAULT 0,
 `oi_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `oi_metadata` mediumblob NOT NULL,
 `oi_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') DEFAULT NULL,
 `oi_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') DEFAULT NULL,
 `oi_minor_mime` varbinary(100) NOT NULL DEFAULT 'unknown',
 `oi_deleted` tinyint(3) unsigned NOT NULL DEFAULT 0,
 `oi_sha1` varbinary(32) NOT NULL DEFAULT '',
 KEY `oi_usertext_timestamp` (`oi_user_text`,`oi_timestamp`),
 KEY `oi_name_timestamp` (`oi_name`,`oi_timestamp`),
 KEY `oi_name_archive_name` (`oi_name`,`oi_archive_name`(14)),
 KEY `oi_sha1` (`oi_sha1`),
 KEY `oi_actor_timestamp` (`oi_actor`,`oi_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

SHOW INDEX IN `actor`;
===============

Table 	Non_unique 	Key_name 	Seq_in_index 	Column_name 	Collation 	Cardinality 	Sub_part 	Packed 	Null 	Index_type 	Comment 	Index_comment
actor 	0 	PRIMARY 	1 	actor_id 	A 	226 	NULL 	NULL 		BTREE 		
actor 	0 	actor_name 	1 	actor_name 	A 	226 	NULL 	NULL 		BTREE 		
actor 	0 	actor_user 	1 	actor_user 	A 	226 	NULL 	NULL 	YES 	BTREE 		

SHOW INDEX IN `oldimage`;
=================

Table 	Non_unique 	Key_name 	Seq_in_index 	Column_name 	Collation 	Cardinality 	Sub_part 	Packed 	Null 	Index_type 	Comment 	Index_comment
oldimage 	1 	oi_usertext_timestamp 	1 	oi_user_text 	A 	6 	NULL 	NULL 		BTREE 		
oldimage 	1 	oi_usertext_timestamp 	2 	oi_timestamp 	A 	1231 	NULL 	NULL 		BTREE 		
oldimage 	1 	oi_name_timestamp 	1 	oi_name 	A 	1231 	NULL 	NULL 		BTREE 		
oldimage 	1 	oi_name_timestamp 	2 	oi_timestamp 	A 	1231 	NULL 	NULL 		BTREE 		
oldimage 	1 	oi_name_archive_name 	1 	oi_name 	A 	1231 	NULL 	NULL 		BTREE 		
oldimage 	1 	oi_name_archive_name 	2 	oi_archive_name 	A 	1231 	14 	NULL 		BTREE 		
oldimage 	1 	oi_sha1 	1 	oi_sha1 	A 	1231 	NULL 	NULL 		BTREE 		
oldimage 	1 	oi_actor_timestamp 	1 	oi_actor 	A 	2 	NULL 	NULL 		BTREE 		
oldimage 	1 	oi_actor_timestamp 	2 	oi_timestamp 	A 	1231 	NULL 	NULL 		BTREE 		

Thanks!

Comment by Guillaume M [ 2019-08-05 ]

More information.

The crash does NOT happen when the oldimage table is empty.

The crash DOES happen with these simplified queries:
SELECT * FROM `oldimage` WHERE oi_actor = '0' AND (oi_name > 'Toltz_3.png' OR oi_name = 'Toltz_3.png') ORDER BY oi_name,oi_timestamp
SELECT * FROM `oldimage` WHERE oi_actor = '0' AND (oi_name > 'Toltz_3.png' OR oi_name = 'Toltz_3.png' AND (oi_timestamp > '20131122110506')) ORDER BY oi_name,oi_timestamp

It does NOT happen with:
SELECT * FROM `oldimage` WHERE oi_actor = '0' AND (oi_name > 'Toltz_3.png' OR oi_name = 'Toltz_3.png' AND (oi_timestamp > '20131122110506'))
SELECT * FROM `oldimage` WHERE oi_actor = '0' AND (oi_name > 'Toltz_3.png' OR oi_name = 'Toltz_3.png' AND (oi_timestamp > '20131122110506')) LIMIT 100
SELECT * FROM `oldimage` WHERE oi_actor = '0' ORDER BY oi_name,oi_timestamp
SELECT * FROM `oldimage` WHERE (oi_name > 'Toltz_3.png' OR oi_name = 'Toltz_3.png') ORDER BY oi_name,oi_timestamp
SELECT * FROM `oldimage` WHERE oi_actor = '0' AND (oi_name > 'Toltz_3.png') ORDER BY oi_name,oi_timestamp
SELECT * FROM `oldimage` WHERE oi_actor = '0' AND (oi_name = 'Toltz_3.png') ORDER BY oi_name,oi_timestamp

Comment by Elena Stepanova [ 2019-08-05 ]

guiyom,

Could you please try

set optimizer_switch='rowid_filter=off'; 

in the session which runs the problematic query (or globally before the session starts, or add the setting to the config and restart) and let us know if it helps to avoid the crash?

If it does not help, please check if you can get a result of

EXPLAIN EXTENDED SELECT /* MigrateActors::migrate wiki@multi */ oi_name,oi_timestamp,oi_user,oi_user_text,CASE WHEN oi_user = 0 OR oi_user IS NULL THEN (SELECT actor_id FROM `actor` WHERE (oi_user_text = actor_name) ) ELSE (SELECT actor_id FROM `actor` WHERE (oi_user = actor_user) ) END AS `actor_id` FROM `oldimage` WHERE oi_actor = '0' AND (oi_name > 'Toltz_3.png' OR oi_name = 'Toltz_3.png' AND (oi_timestamp > '20131122110506')) ORDER BY oi_name,oi_timestamp LIMIT 100;
SHOW WARNINGS;

Be careful, as it may cause the same crash, so only run it when you can take the risk.

Comment by Guillaume M [ 2019-08-05 ]

The crash does NOT happen with set optimizer_switch='rowid_filter=off' executed in the session.

The EXPLAIN query does not crash the server, with or without rowid_filter=off.

Without:

EXPLAIN EXTENDED SELECT /* MigrateActors::migrate wiki@multi */ oi_name,oi_timestamp,oi_user,oi_user_text,CASE WHEN oi_user = 0 OR oi_user IS NULL THEN (SELECT actor_id FROM `actor` WHERE (oi_user_text = actor_name) ) ELSE (SELECT actor_id FROM `actor` WHERE (oi_user = actor_user) ) END AS `actor_id` FROM `oldimage` WHERE oi_actor = '0' AND (oi_name > 'Toltz_3.png' OR oi_name = 'Toltz_3.png' AND (oi_timestamp > '20131122110506')) ORDER BY oi_name,oi_timestamp LIMIT 100;

+------+--------------------+----------+------------+-----------------------------------------------------------+-----------------------------------------+---------+------------------------------------------+-----------+----------+-------------------------------------------------+
| id   | select_type        | table    | type       | possible_keys                                             | key                                     | key_len | ref                                      | rows      | filtered | Extra                                           |
+------+--------------------+----------+------------+-----------------------------------------------------------+-----------------------------------------+---------+------------------------------------------+-----------+----------+-------------------------------------------------+
|    1 | PRIMARY            | oldimage | ref|filter | oi_name_timestamp,oi_name_archive_name,oi_actor_timestamp | oi_actor_timestamp|oi_name_archive_name | 8|767   | const                                    | 121 (10%) |     9.99 | Using where; Using filesort; Using rowid filter |
|    3 | DEPENDENT SUBQUERY | actor    | ref        | actor_user                                                | actor_user                              | 5       | wiki_fantasyrivals.oldimage.oi_user      | 1         |   100.00 | Using index                                     |
|    2 | DEPENDENT SUBQUERY | actor    | eq_ref     | actor_name                                                | actor_name                              | 767     | wiki_fantasyrivals.oldimage.oi_user_text | 1         |   100.00 | Using index                                     |
+------+--------------------+----------+------------+-----------------------------------------------------------+-----------------------------------------+---------+------------------------------------------+-----------+----------+-------------------------------------------------+
3 rows in set, 3 warnings (0.002 sec)

SHOW WARNINGS;

+-------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Code | Message                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
+-------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Note  | 1276 | Field or reference 'wiki_fantasyrivals.oldimage.oi_user_text' of SELECT #2 was resolved in SELECT #1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| Note  | 1276 | Field or reference 'wiki_fantasyrivals.oldimage.oi_user' of SELECT #3 was resolved in SELECT #1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| Note  | 1003 | /* select#1 */ select `wiki_fantasyrivals`.`oldimage`.`oi_name` AS `oi_name`,`wiki_fantasyrivals`.`oldimage`.`oi_timestamp` AS `oi_timestamp`,`wiki_fantasyrivals`.`oldimage`.`oi_user` AS `oi_user`,`wiki_fantasyrivals`.`oldimage`.`oi_user_text` AS `oi_user_text`,case when (`wiki_fantasyrivals`.`oldimage`.`oi_user` = 0 or /*always not null*/ 1 is null) then <expr_cache><`wiki_fantasyrivals`.`oldimage`.`oi_user_text`>((/* select#2 */ select `wiki_fantasyrivals`.`actor`.`actor_id` from `wiki_fantasyrivals`.`actor` where `wiki_fantasyrivals`.`oldimage`.`oi_user_text` = `wiki_fantasyrivals`.`actor`.`actor_name`)) else <expr_cache><`wiki_fantasyrivals`.`oldimage`.`oi_user`>((/* select#3 */ select `wiki_fantasyrivals`.`actor`.`actor_id` from `wiki_fantasyrivals`.`actor` where `wiki_fantasyrivals`.`oldimage`.`oi_user` = `wiki_fantasyrivals`.`actor`.`actor_user`)) end AS `actor_id` from `wiki_fantasyrivals`.`oldimage` where `wiki_fantasyrivals`.`oldimage`.`oi_actor` = 0 and (`wiki_fantasyrivals`.`oldimage`.`oi_name` > 'Toltz_3.png' or `wiki_fantasyrivals`.`oldimage`.`oi_name` = 'Toltz_3.png' and `wiki_fantasyrivals`.`oldimage`.`oi_timestamp` > '20131122110506') order by `wiki_fantasyrivals`.`oldimage`.`oi_name`,`wiki_fantasyrivals`.`oldimage`.`oi_timestamp` limit 100 |
+-------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.000 sec)

With rowid_filter=off:

EXPLAIN EXTENDED SELECT /* MigrateActors::migrate wiki@multi */ oi_name,oi_timestamp,oi_user,oi_user_text,CASE WHEN oi_user = 0 OR oi_user IS NULL THEN (SELECT actor_id FROM `actor` WHERE (oi_user_text = actor_name) ) ELSE (SELECT actor_id FROM `actor` WHERE (oi_user = actor_user) ) END AS `actor_id` FROM `oldimage` WHERE oi_actor = '0' AND (oi_name > 'Toltz_3.png' OR oi_name = 'Toltz_3.png' AND (oi_timestamp > '20131122110506')) ORDER BY oi_name,oi_timestamp LIMIT 100;

+------+--------------------+----------+--------+-----------------------------------------------------------+--------------------+---------+------------------------------------------+------+----------+-----------------------------+
| id   | select_type        | table    | type   | possible_keys                                             | key                | key_len | ref                                      | rows | filtered | Extra                       |
+------+--------------------+----------+--------+-----------------------------------------------------------+--------------------+---------+------------------------------------------+------+----------+-----------------------------+
|    1 | PRIMARY            | oldimage | ref    | oi_name_timestamp,oi_name_archive_name,oi_actor_timestamp | oi_actor_timestamp | 8       | const                                    | 121  |     9.99 | Using where; Using filesort |
|    3 | DEPENDENT SUBQUERY | actor    | ref    | actor_user                                                | actor_user         | 5       | wiki_fantasyrivals.oldimage.oi_user      | 1    |   100.00 | Using index                 |
|    2 | DEPENDENT SUBQUERY | actor    | eq_ref | actor_name                                                | actor_name         | 767     | wiki_fantasyrivals.oldimage.oi_user_text | 1    |   100.00 | Using index                 |
+------+--------------------+----------+--------+-----------------------------------------------------------+--------------------+---------+------------------------------------------+------+----------+-----------------------------+
3 rows in set, 3 warnings (0.000 sec)

SHOW WARNINGS;

+-------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Code | Message                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
+-------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Note  | 1276 | Field or reference 'wiki_fantasyrivals.oldimage.oi_user_text' of SELECT #2 was resolved in SELECT #1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| Note  | 1276 | Field or reference 'wiki_fantasyrivals.oldimage.oi_user' of SELECT #3 was resolved in SELECT #1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| Note  | 1003 | /* select#1 */ select `wiki_fantasyrivals`.`oldimage`.`oi_name` AS `oi_name`,`wiki_fantasyrivals`.`oldimage`.`oi_timestamp` AS `oi_timestamp`,`wiki_fantasyrivals`.`oldimage`.`oi_user` AS `oi_user`,`wiki_fantasyrivals`.`oldimage`.`oi_user_text` AS `oi_user_text`,case when (`wiki_fantasyrivals`.`oldimage`.`oi_user` = 0 or /*always not null*/ 1 is null) then <expr_cache><`wiki_fantasyrivals`.`oldimage`.`oi_user_text`>((/* select#2 */ select `wiki_fantasyrivals`.`actor`.`actor_id` from `wiki_fantasyrivals`.`actor` where `wiki_fantasyrivals`.`oldimage`.`oi_user_text` = `wiki_fantasyrivals`.`actor`.`actor_name`)) else <expr_cache><`wiki_fantasyrivals`.`oldimage`.`oi_user`>((/* select#3 */ select `wiki_fantasyrivals`.`actor`.`actor_id` from `wiki_fantasyrivals`.`actor` where `wiki_fantasyrivals`.`oldimage`.`oi_user` = `wiki_fantasyrivals`.`actor`.`actor_user`)) end AS `actor_id` from `wiki_fantasyrivals`.`oldimage` where `wiki_fantasyrivals`.`oldimage`.`oi_actor` = 0 and (`wiki_fantasyrivals`.`oldimage`.`oi_name` > 'Toltz_3.png' or `wiki_fantasyrivals`.`oldimage`.`oi_name` = 'Toltz_3.png' and `wiki_fantasyrivals`.`oldimage`.`oi_timestamp` > '20131122110506') order by `wiki_fantasyrivals`.`oldimage`.`oi_name`,`wiki_fantasyrivals`.`oldimage`.`oi_timestamp` limit 100 |
+-------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.000 sec)

Comment by Elena Stepanova [ 2019-08-05 ]

guiyom,

Thanks.
You can then add optimizer_switch='rowid_filter=off' to your cnf file as a workaround till the bug is fixed.

Comment by Elena Stepanova [ 2019-08-05 ]

While I couldn't reproduce the crash with the provided query and tables (it is quite possibly closely related to the data in the tables), I have a test case which causes seemingly identical stack trace:

--source include/have_innodb.inc
 
set global innodb_stats_persistent= OFF;
 
CREATE TABLE t1 (a INT) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1),(0);
 
CREATE TABLE t2 (
  b1 INT,
  b2 INT,
  b3 INT,
  KEY (b1),
  KEY (b3),
  KEY (b1,b3,b2),
  KEY (b2,b3)
) ENGINE=InnoDB;
INSERT INTO t2 (b1,b3) VALUES (1,1),(6,6),(8,8),(0,0),(4,4);
 
CREATE TABLE t3 (c INT) ENGINE=InnoDB;
INSERT INTO t3 VALUES (1),(2);
 
SELECT * FROM (SELECT * FROM t1 STRAIGHT_JOIN t2 ON t1.a = t2.b3) sq STRAIGHT_JOIN t3 ON sq.b2 = t3.c WHERE sq.b1 <= 0;

10.4 60a37783

#3  <signal handler called>
#4  0x000055eba2605d13 in handler_index_cond_check (h_arg=0x7f5938073018) at /data/src/10.4/sql/handler.cc:5981
#5  0x000055eba29cd7ad in row_search_idx_cond_check (mysql_rec=0x7f5938068350 "\365\001", prebuilt=0x7f59380737d8, rec=0x7f598155c07e "", offsets=0x7f5980d82bb0) at /data/src/10.4/storage/innobase/row/row0sel.cc:3900
#6  0x000055eba29d11b0 in row_search_mvcc (buf=0x7f5938068350 "\365\001", mode=PAGE_CUR_G, prebuilt=0x7f59380737d8, match_mode=0, direction=0) at /data/src/10.4/storage/innobase/row/row0sel.cc:5220
#7  0x000055eba282cdd9 in ha_innobase::index_read (this=0x7f5938073018, buf=0x7f5938068350 "\365\001", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:9322
#8  0x000055eba282dd42 in ha_innobase::index_first (this=0x7f5938073018, buf=0x7f5938068350 "\365\001") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:9695
#9  0x000055eba282df1a in ha_innobase::rnd_next (this=0x7f5938073018, buf=0x7f5938068350 "\365\001") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:9788
#10 0x000055eba25fd515 in handler::ha_rnd_next (this=0x7f5938073018, buf=0x7f5938068350 "\365\001") at /data/src/10.4/sql/handler.cc:2834
#11 0x000055eba278d928 in rr_sequential (info=0x7f59381a62a8) at /data/src/10.4/sql/records.cc:477
#12 0x000055eba2211fb5 in READ_RECORD::read_record (this=0x7f59381a62a8) at /data/src/10.4/sql/records.h:69
#13 0x000055eba2337ed5 in join_init_read_record (tab=0x7f59381a61e0) at /data/src/10.4/sql/sql_select.cc:21076
#14 0x000055eba247ba14 in JOIN_TAB_SCAN::open (this=0x7f59381a82c0) at /data/src/10.4/sql/sql_join_cache.cc:3349
#15 0x000055eba2479f0d in JOIN_CACHE::join_matching_records (this=0x7f59381a8060, skip_last=false) at /data/src/10.4/sql/sql_join_cache.cc:2252
#16 0x000055eba2479a3a in JOIN_CACHE::join_records (this=0x7f59381a8060, skip_last=false) at /data/src/10.4/sql/sql_join_cache.cc:2088
#17 0x000055eba233577c in sub_select_cache (join=0x7f59380186e0, join_tab=0x7f59381a61e0, end_of_records=true) at /data/src/10.4/sql/sql_select.cc:19913
#18 0x000055eba2335987 in sub_select (join=0x7f59380186e0, join_tab=0x7f59381a5e38, end_of_records=true) at /data/src/10.4/sql/sql_select.cc:20084
#19 0x000055eba233514e in do_select (join=0x7f59380186e0, procedure=0x0) at /data/src/10.4/sql/sql_select.cc:19675
#20 0x000055eba230b3eb in JOIN::exec_inner (this=0x7f59380186e0) at /data/src/10.4/sql/sql_select.cc:4392
#21 0x000055eba230a598 in JOIN::exec (this=0x7f59380186e0) at /data/src/10.4/sql/sql_select.cc:4174
#22 0x000055eba230bc3d in mysql_select (thd=0x7f5938000b00, tables=0x7f5938015ff0, wild_num=1, fields=..., conds=0x7f5938017b98, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f59380186b8, unit=0x7f5938004a30, select_lex=0x7f5938013278) at /data/src/10.4/sql/sql_select.cc:4606
#23 0x000055eba22fc216 in handle_select (thd=0x7f5938000b00, lex=0x7f5938004968, result=0x7f59380186b8, setup_tables_done_option=0) at /data/src/10.4/sql/sql_select.cc:425
#24 0x000055eba22c57fb in execute_sqlcom_select (thd=0x7f5938000b00, all_tables=0x7f5938015ff0) at /data/src/10.4/sql/sql_parse.cc:6356
#25 0x000055eba22bb642 in mysql_execute_command (thd=0x7f5938000b00) at /data/src/10.4/sql/sql_parse.cc:3898
#26 0x000055eba22c958f in mysql_parse (thd=0x7f5938000b00, rawbuf=0x7f5938013128 "SELECT * FROM (SELECT * FROM t1 STRAIGHT_JOIN t2 ON t1.a = t2.b3) sq STRAIGHT_JOIN t3 ON sq.b2 = t3.c WHERE sq.b1 <= 0", length=118, parser_state=0x7f5980d85170, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7908
#27 0x000055eba22b5838 in dispatch_command (command=COM_QUERY, thd=0x7f5938000b00, packet=0x7f593819dcc1 "", packet_length=118, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1843
#28 0x000055eba22b3f7e in do_command (thd=0x7f5938000b00) at /data/src/10.4/sql/sql_parse.cc:1360
#29 0x000055eba242db12 in do_handle_one_connection (connect=0x55eba50dc950) at /data/src/10.4/sql/sql_connect.cc:1404
#30 0x000055eba242d861 in handle_one_connection (arg=0x55eba50dc950) at /data/src/10.4/sql/sql_connect.cc:1306
#31 0x000055eba2d5941f in pfs_spawn_thread (arg=0x55eba505b2c0) at /data/src/10.4/storage/perfschema/pfs.cc:1862
#32 0x00007f59895294a4 in start_thread (arg=0x7f5980d86700) at pthread_create.c:456
#33 0x00007f5987a71d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

After it is fixed, please ask guiyom to check if the patch fixes the initial problem as well.

Comment by Guillaume M [ 2019-08-05 ]

Thanks Elena!

And I do confirm the query also do work correctly with "optimizer_switch='rowid_filter=off'" added to the cnf file.

I can send you the dump of the tables to help you to create a testcase if you wish. It's only a few kBs.
They're non-sensitive data but I'd prefer not to upload them publicly and I didn't find how to make an attachment private but I can send you the dump by email for instance.

Comment by Elena Stepanova [ 2019-08-05 ]

guiyom,

You can't add a private attachment to a public JIRA issue, but you can upload the file to ftp://ftp.askmonty.org/private .

Comment by Guillaume M [ 2019-08-05 ]

I've just uploaded to the FTP a MDEV-20252.zip file that contains the two tables dumps.

Comment by Igor Babaev [ 2019-11-27 ]

This bug was fixed by the patch for MDEV-20056. The test case will be added though.

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