[MDEV-13144] regexp on views - crashed mariadb server Created: 2017-06-21  Updated: 2018-06-28  Resolved: 2017-07-05

Status: Closed
Project: MariaDB Server
Component/s: Server, Views
Affects Version/s: 10.2.6, 10.2
Fix Version/s: 10.2.7

Type: Bug Priority: Critical
Reporter: Emerson Gaudencio Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None
Environment:

Oracle Linux 7.3/CentOS 7 Plataform 64 bits
MariaDB 10.2.6

Issue Links:
Duplicate
is duplicated by MDEV-12939 A query crashes MariaDB in Item_func_... Closed
Problem/Incident
causes MDEV-16611 Crash on Stored Procedure calling Vie... Closed
Relates
relates to MDEV-16611 Crash on Stored Procedure calling Vie... Closed

 Description   

Step-by-step of the issue with using view:

[root@SC-DB-APP tmp]# mysql -u root
 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
 
Your MariaDB connection id is 153
 
Server version: 10.2.6-MariaDB-log MariaDB Server
 
 
 
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
 
 
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
 
 
MariaDB [(none)]> create database test1;
 
Query OK, 1 row affected (0.00 sec)
 
 
 
MariaDB [(none)]> use test1;
 
Database changed
 
 
 
MariaDB [test1]> select 1 as id, 'test1' as name from dual
 
    -> union all
 
    -> select 2 as id, 'test2' as name from dual
 
    -> union all
 
    -> select 3 as id, 'test2' as name from dual
 
    -> union all
 
    -> select 4 as id, 'test3' as name from dual
 
    -> union all
 
    -> select  5 as id, 'test5' as name from dual
 
    -> union all
 
    -> select  6 as id, 'test6' as name from dual;
 
+----+-------+
 
| id | name  |
 
+----+-------+
 
|  1 | test1 |
 
|  2 | test2 |
 
|  3 | test2 |
 
|  4 | test3 |
 
|  5 | test5 |
 
|  6 | test6 |
 
+----+-------+
 
6 rows in set (0.00 sec)
 
 
 
MariaDB [test1]> create view vw_test_regex as
 
    -> select 1 as id, 'test1' as name from dual
 
    -> union all
 
    -> select 2 as id, 'test2' as name from dual
 
    -> union all
 
    -> select 3 as id, 'test2' as name from dual
 
    -> union all
 
    -> select 4 as id, 'test3' as name from dual
 
    -> union all
 
    -> select  5 as id, 'test5' as name from dual
 
    -> union all
 
    -> select  6 as id, 'test6' as name from dual;
 
Query OK, 0 rows affected (0.02 sec)
 
 
 
MariaDB [test1]> select * from vw_test_regex t
 
    -> where t.name like 'test%';
 
+----+-------+
 
| id | name  |
 
+----+-------+
 
|  1 | test1 |
 
|  2 | test2 |
 
|  3 | test2 |
 
|  4 | test3 |
 
|  5 | test5 |
 
|  6 | test6 |
 
+----+-------+
 
6 rows in set (0.00 sec)
 
 
 
MariaDB [test1]> select * from vw_test_regex t
 
    -> where t.name regexp "(test)";
 
ERROR 2013 (HY000): Lost connection to MySQL server during query
 
MariaDB [test1]>

Here is Error log:

*** Error in `/usr/sbin/mysqld': double free or corruption (fasttop): 0x00007f243c00eef0 ***
 
======= Backtrace: =========
 
/lib64/libc.so.6(+0x7c503)[0x7f2491a1f503]
 
/usr/sbin/mysqld(_ZN15Item_func_regex7cleanupEv+0x38)[0x55c41ef1cdf8]
 
/usr/sbin/mysqld(_ZN4Item17cleanup_processorEPv+0x1a)[0x55c41eeebdea]
 
/usr/sbin/mysqld(_Z25pushdown_cond_for_derivedP3THDP4ItemP10TABLE_LIST+0x26d)[0x55c41ed2f07d]
 
/usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x4f7)[0x55c41ed9ffe7]
 
/usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x3f)[0x55c41eda265f]
 
/usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x94)[0x55c41eda3d54]
 
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x24c)[0x55c41eda491c]
 
/usr/sbin/mysqld(+0x4d0586)[0x55c41ed48586]
 
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x5ae7)[0x55c41ed54807]
 
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2de)[0x55c41ed57dee]
 
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1fcf)[0x55c41ed5ac2f]
 
/usr/sbin/mysqld(_Z10do_commandP3THD+0x161)[0x55c41ed5b7d1]
 
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1aa)[0x55c41ee1b83a]
 
/usr/sbin/mysqld(handle_one_connection+0x3d)[0x55c41ee1b95d]
 
/lib64/libpthread.so.0(+0x7dc5)[0x7f2493446dc5]
 
/lib64/libc.so.6(clone+0x6d)[0x7f2491a9a73d]
 
======= Memory map: ========
 
55c41e878000-55c41f9c1000 r-xp 00000000 08:05 132695                     /usr/sbin/mysqld
 
55c41fbc0000-55c41fc9a000 r--p 01148000 08:05 132695                     /usr/sbin/mysqld
 
55c41fc9a000-55c41fd50000 rw-p 01222000 08:05 132695                     /usr/sbin/mysqld
 
55c41fd50000-55c4205dc000 rw-p 00000000 00:00 0
 
55c4225d9000-55c426312000 rw-p 00000000 00:00 0                          [heap]
 
7f23c0000000-7f23c0021000 rw-p 00000000 00:00 0
 
7f23c0021000-7f23c4000000 ---p 00000000 00:00 0
 
7f23c8000000-7f23c8021000 rw-p 00000000 00:00 0
 
7f23c8021000-7f23cc000000 ---p 00000000 00:00 0
 
7f23cc000000-7f23cc021000 rw-p 00000000 00:00 0
 
7f23cc021000-7f23d0000000 ---p 00000000 00:00 0
 
7f23d0000000-7f23d0021000 rw-p 00000000 00:00 0
 
7f23d0021000-7f23d4000000 ---p 00000000 00:00 0
 
7f23d4000000-7f23d4021000 rw-p 00000000 00:00 0
 
7f23d4021000-7f23d8000000 ---p 00000000 00:00 0
 
7f23d8000000-7f23d805b000 rw-p 00000000 00:00 0
 
7f23d805b000-7f23dc000000 ---p 00000000 00:00 0
 
7f23dc000000-7f23dc04c000 rw-p 00000000 00:00 0
 
7f23dc04c000-7f23e0000000 ---p 00000000 00:00 0
 
7f23e0000000-7f23e00e7000 rw-p 00000000 00:00 0
 
7f23e00e7000-7f23e4000000 ---p 00000000 00:00 0
 
7f23e4000000-7f23e4050000 rw-p 00000000 00:00 0
 
7f23e4050000-7f23e8000000 ---p 00000000 00:00 0
 
7f23e8000000-7f23e8054000 rw-p 00000000 00:00 0
 
7f23e8054000-7f23ec000000 ---p 00000000 00:00 0
 
7f23ec000000-7f23ed029000 rw-p 00000000 00:00 0
 
7f23ed029000-7f23f0000000 ---p 00000000 00:00 0
 
7f23f0000000-7f23f0072000 rw-p 00000000 00:00 0
 
7f23f0072000-7f23f4000000 ---p 00000000 00:00 0
 
7f23f4000000-7f23f4053000 rw-p 00000000 00:00 0
 
7f23f4053000-7f23f8000000 ---p 00000000 00:00 0
 
7f23f8000000-7f23f804a000 rw-p 00000000 00:00 0
 
7f23f804a000-7f23fc000000 ---p 00000000 00:00 0
 
7f23fc000000-7f23fc07e000 rw-p 00000000 00:00 0
 
7f23fc07e000-7f2400000000 ---p 00000000 00:00 0
 
7f2400000000-7f2400910000 rw-p 00000000 00:00 0
 
7f2400910000-7f2404000000 ---p 00000000 00:00 0
 
7f2404000000-7f2404021000 rw-p 00000000 00:00 0
 
7f2404021000-7f2408000000 ---p 00000000 00:00 0
 
7f2408000000-7f2409912000 rw-p 00000000 00:00 0
 
7f2409912000-7f240c000000 ---p 00000000 00:00 0
 
7f240c000000-7f240c021000 rw-p 00000000 00:00 0
 
7f240c021000-7f2410000000 ---p 00000000 00:00 0
 
7f2410000000-7f2410021000 rw-p 00000000 00:00 0
 
7f2410021000-7f2414000000 ---p 00000000 00:00 0
 
7f2414000000-7f2414021000 rw-p 00000000 00:00 0
 
7f2414021000-7f2418000000 ---p 00000000 00:00 0
 
7f2418000000-7f2418828000 rw-p 00000000 00:00 0
 
7f2418828000-7f241c000000 ---p 00000000 00:00 0
 
7f2420000000-7f2420021000 rw-p 00000000 00:00 0
 
7f2420021000-7f2424000000 ---p 00000000 00:00 0
 
7f24255ab000-7f24255ac000 ---p 00000000 00:00 0
 
7f24255ac000-7f24255f5000 rw-p 00000000 00:00 0                          [stack:75386]
 
7f24255f5000-7f24255f6000 ---p 00000000 00:00 0
 
7f24255f6000-7f242563f000 rw-p 00000000 00:00 0                          [stack:75169]
 
7f242563f000-7f2425640000 ---p 00000000 00:00 0
 
7f2425640000-7f2425689000 rw-p 00000000 00:00 0                          [stack:71641]
 
7f2425689000-7f242568a000 ---p 00000000 00:00 0
 
7f242568a000-7f24256d3000 rw-p 00000000 00:00 0                          [stack:65010]
 
7f24256d3000-7f24256d4000 ---p 00000000 00:00 0
 
7f24256d4000-7f242571d000 rw-p 00000000 00:00 0                          [stack:64132]
 
7f242571d000-7f242571e000 ---p 00000000 00:00 0
 
7f242571e000-7f2425767000 rw-p 00000000 00:00 0                          [stack:63925]
 
7f2425767000-7f2425768000 ---p 00000000 00:00 0
 
7f2425768000-7f24257b1000 rw-p 00000000 00:00 0                          [stack:63788]
 
7f24257b1000-7f24257b2000 ---p 00000000 00:00 0
 
7f24257b2000-7f24257fb000 rw-p 00000000 00:00 0                          [stack:63706]
 
7f24257fb000-7f24257fc000 ---p 00000000 00:00 0
 
7f24257fc000-7f2425ffc000 rw-p 00000000 00:00 0                          [stack:63332]
 
7f2425ffc000-7f2425ffd000 ---p 00000000 00:00 0
 
7f2425ffd000-7f24267fd000 rw-p 00000000 00:00 0                          [stack:63331]
 
7f24267fd000-7f24267fe000 ---p 00000000 00:00 0
 
7f24267fe000-7f2426ffe000 rw-p 00000000 00:00 0                          [stack:63330]
 
7f2426ffe000-7f2426fff000 ---p 00000000 00:00 0
 
7f2426fff000-7f24277ff000 rw-p 00000000 00:00 0                          [stack:63329]
 
7f24277ff000-7f2427800000 ---p 00000000 00:00 0
 
7f2427800000-7f2428000000 rw-p 00000000 00:00 0                          [stack:63328]
 
7f2428000000-7f2428021000 rw-p 00000000 00:00 0
 
7f2428021000-7f242c000000 ---p 00000000 00:00 0
 
7f242c01e000-7f242c01f000 ---p 00000000 00:00 0
 
7f242c01f000-7f242c068000 rw-p 00000000 00:00 0                          [stack:63551]
 
7f242c068000-7f242c069000 ---p 00000000 00:00 0
 
7f242c069000-7f242c0b2000 rw-p 00000000 00:00 0                          [stack:63520]
 
7f242c0b2000-7f242c0b3000 ---p 00000000 00:00 0
 
7f242c0b3000-7f242c0fc000 rw-p 00000000 00:00 0                          [stack:63509]
 
7f242c0fc000-7f242c0fd000 ---p 00000000 00:00 0
 
7f242c0fd000-7f242c146000 rw-p 00000000 00:00 0                          [stack:63399]
 
7f242c146000-7f242c147000 ---p 00000000 00:00 0
 
7f242c147000-7f242c190000 rw-p 00000000 00:00 0                          [stack:63398]
 
7f242c190000-7f242c191000 ---p 00000000 00:00 0
 
7f242c191000-7f242c1da000 rw-p 00000000 00:00 0                          [stack:63397]
 
7f242c1da000-7f242c1db000 ---p 00000000 00:00 0
 
7f242c1db000-7f242c224000 rw-p 00000000 00:00 0                          [stack:63387]
 
7f242c224000-7f242c225000 ---p 00000000 00:00 0
 
7f242c225000-7f242c26e000 rw-p 00000000 00:00 0                          [stack:63386]
 
7f242c26e000-7f242c26f000 ---p 00000000 00:00 0
 
7f242c26f000-7f242c2b8000 rw-p 00000000 00:00 0                          [stack:63385]
 
7f242c2b8000-7f242c2b9000 ---p 00000000 00:00 0
 
7f242c2b9000-7f242c302000 rw-p 00000000 00:00 0                          [stack:63366]
 
7f242c302000-7f242c303000 ---p 00000000 00:00 0
 
7f242c303000-7f242c34c000 rw-p 00000000 00:00 0                          [stack:63365]
 
7f242c34c000-7f242c34d000 ---p 00000000 00:00 0
 
7f242c34d000-7f242c396000 rw-p 00000000 00:00 0                          [stack:63362]
 
7f242c396000-7f242c397000 ---p 00000000 00:00 0
 
7f242c397000-7f242c3e0000 rw-p 00000000 00:00 0                          [stack:63361]
 
7f242c3e0000-7f242c3e1000 ---p 00000000 00:00 0
 
7f242c3e1000-7f242c42a000 rw-p 00000000 00:00 0                          [stack:63360]
 
7f242c42a000-7f242c42b000 ---p 00000000 00:00 0
 
7f242c42b000-7f242c474000 rw-p 00000000 00:00 0                          [stack:63359]
 
7f242c474000-7f242c475000 ---p 00000000 00:00 0
 
7f242c475000-7f242c4be000 rw-p 00000000 00:00 0                          [stack:63358]
 
7f242c4be000-7f242c4bf000 ---p 00000000 00:00 0
 
7f242c4bf000-7f242c508000 rw-p 00000000 00:00 0                          [stack:63357]
 
7f242c508000-7f242c509000 ---p 00000000 00:00 0
 
7f242c509000-7f242c552000 rw-p 00000000 00:00 0                          [stack:63356]
 
7f242c552000-7f242c553000 ---p 00000000 00:00 0
 
7f242c553000-7f242c59c000 rw-p 00000000 00:00 0                          [stack:63355]
 
7f242c59c000-7f242c59d000 ---p 00000000 00:00 0
 
7f242c59d000-7f242c5e6000 rw-p 00000000 00:00 0                          [stack:63354]
 
7f242c5e6000-7f242c5f2000 r-xp 00000000 08:05 396039                     /usr/lib64/libnss_files-2.17.so
 
7f242c5f2000-7f242c7f1000 ---p 0000c000 08:05 396039                     /usr/lib64/libnss_files-2.17.so
 
7f242c7f1000-7f242c7f2000 r--p 0000b000 08:05 396039                     /usr/lib64/libnss_files-2.17.so
 
7f242c7f2000-7f242c7f3000 rw-p 0000c000 08:05 396039                     /usr/lib64/libnss_files-2.17.so
 
7f242c7f3000-7f242c7f9000 rw-p 00000000 00:00 0
 
7f242c7f9000-7f242c7fa000 ---p 00000000 00:00 0
 
7f242c7fa000-7f242cffa000 rw-p 00000000 00:00 0                          [stack:63327]
 
7f242cffa000-7f242cffb000 ---p 00000000 00:00 0
 
7f242cffb000-7f242d7fb000 rw-p 00000000 00:00 0                          [stack:63326]
 
7f242d7fb000-7f242d7fc000 ---p 00000000 00:00 0
 
7f242d7fc000-7f242dffc000 rw-p 00000000 00:00 0                          [stack:63325]
 
7f242dffc000-7f242dffd000 ---p 00000000 00:00 0
 
7f242dffd000-7f242e7fd000 rw-p 00000000 00:00 0                          [stack:63324]
 
7f242e7fd000-7f242e7fe000 ---p 00000000 00:00 0
 
7f242e7fe000-7f242effe000 rw-p 00000000 00:00 0                          [stack:63323]
 
7f242effe000-7f242efff000 ---p 00000000 00:00 0
 
7f242efff000-7f242f7ff000 rw-p 00000000 00:00 0                          [stack:63322]
 
7f242f7ff000-7f242f800000 ---p 00000000 00:00 0
 
7f242f800000-7f2430000000 rw-p 00000000 00:00 0                          [stack:63321]
 
7f2430000000-7f2430021000 rw-p 00000000 00:00 0
 
7f2430021000-7f2434000000 ---p 00000000 00:00 0
 
7f2434000000-7f2435078000 rw-p 00000000 00:00 0
 
7f2435078000-7f2438000000 ---p 00000000 00:00 0
 
7f2438000000-7f2438021000 rw-p 00000000 00:00 0
 
7f2438021000-7f243c000000 ---p 00000000 00:00 0
 
7f243c000000-7f243c824000 rw-p 00000000 00:00 0
 
7f243c824000-7f2440000000 ---p 00000000 00:00 0
 
7f2440000000-7f2440021000 rw-p 00000000 00:00 0
 
7f2440021000-7f2444000000 ---p 00000000 00:00 0
 
7f2444008000-7f2444009000 ---p 00000000 00:00 0
 
7f2444009000-7f2444052000 rw-p 00000000 00:00 0                          [stack:63353]
 
7f2444052000-7f2444053000 ---p 00000000 00:00 0
 
7f2444053000-7f244409c000 rw-p 00000000 00:00 0                          [stack:63352]
 
7f244409c000-7f244409d000 ---p 00000000 00:00 0
 
7f244409d000-7f24440e6000 rw-p 00000000 00:00 0                          [stack:63351]
 
7f24440e6000-7f24440e7000 ---p 00000000 00:00 0
 
7f24440e7000-7f2444130000 rw-p 00000000 00:00 0                          [stack:63350]
 
7f2444130000-7f2444131000 ---p 00000000 00:00 0
 
7f2444131000-7f2444b36000 rw-p 00000000 00:00 0                          [stack:63320]
 
7f2444b36000-7f2444b37000 ---p 00000000 00:00 0
 
7f2444b37000-7f2445337000 rw-p 00000000 00:00 0                          [stack:63271]
 
7f2445337000-7f2445338000 ---p 00000000 00:00 0
 
7f2445338000-7f2445b38000 rw-p 00000000 00:00 0                          [stack:63270]
 
7f2445b38000-7f2445b39000 ---p 00000000 00:00 0
 
7f2445b39000-7f2446339000 rw-p 00000000 00:00 0                          [stack:63269]
 
7f2446339000-7f244633a000 ---p 00000000 00:00 0
 
7f244633a000-7f2446b3a000 rw-p 00000000 00:00 0                          [stack:63268]
 
7f2446b3a000-7f2446b3b000 ---p 00000000 00:00 0
 
7f2446b3b000-7f244733b000 rw-p 00000000 00:00 0                          [stack:63267]
 
7f244733b000-7f244733c000 ---p 00000000 00:00 0
 
7f244733c000-7f2447b3c000 rw-p 00000000 00:00 0                          [stack:63266]
 
7f2447b3c000-7f2447b3d000 ---p 00000000 00:00 0
 
7f2447b3d000-7f244833d000 rw-p 00000000 00:00 0                          [stack:63265]
 
7f244833d000-7f244833e000 ---p 00000000 00:00 0
 
7f244833e000-7f2448b3e000 rw-p 00000000 00:00 0                          [stack:63264]
 
7f2448b3e000-7f2448b3f000 ---p 00000000 00:00 0
 
7f2448b3f000-7f246c000000 rw-p 00000000 00:00 0                          [stack:63263]
 
7f246c000000-7f246c021000 rw-p 00000000 00:00 0
 
7f246c021000-7f2470000000 ---p 00000000 00:00 0
 
7f2470030000-7f2470031000 ---p 00000000 00:00 0
 
7f2470031000-7f2470831000 rw-p 00000000 00:00 0                          [stack:63262]
 
7f2470831000-7f2470832000 ---p 00000000 00:00 0
 
7f2470832000-7f2471032000 rw-p 00000000 00:00 0                          [stack:63261]
 
7f2471058000-7f2471059000 ---p 00000000 00:00 0
 
7f2471059000-7f24710a2000 rw-p 00000000 00:00 0                          [stack:63349]
 
7f24710a2000-7f24710a3000 ---p 00000000 00:00 0
 
7f24710a3000-7f2480000000 rw-p 00000000 00:00 0                          [stack:63319]
 
7f2480000000-7f2480021000 rw-p 00000000 00:00 0
 
7f2480021000-7f2484000000 ---p 00000000 00:00 0
 
7f2484019000-7f248401a000 ---p 00000000 00:00 0
 
7f248401a000-7f2484063000 rw-p 00000000 00:00 0                          [stack:63348]
 
7f2484063000-7f2484064000 ---p 00000000 00:00 0
 
7f2484064000-7f24840ad000 rw-p 00000000 00:00 0                          [stack:63347]
 
7f24840ad000-7f24840ae000 ---p 00000000 00:00 0
 
7f24840ae000-7f24840f7000 rw-p 00000000 00:00 0                          [stack:63346]
 
7f24840f7000-7f24840f8000 ---p 00000000 00:00 0
 
7f24840f8000-7f2484141000 rw-p 00000000 00:00 0                          [stack:63345]
 
7f2484141000-7f2484142000 ---p 00000000 00:00 0
 
7f2484142000-7f248418b000 rw-p 00000000 00:00 0                          [stack:63344]
 
7f248418b000-7f248418c000 ---p 00000000 00:00 0
 
7f248418c000-7f24841d5000 rw-p 00000000 00:00 0                          [stack:63343]
 
7f24841d5000-7f24841d6000 ---p 00000000 00:00 0
 
7f24841d6000-7f2486865000 rw-p 00000000 00:00 0                          [stack:63260]
 
7f2486865000-7f2486866000 ---p 00000000 00:00 0
 
7f2486866000-7f248f062000 rw-p 00000000 00:00 0                          [stack:63259]
 
7f248f062000-7f248f065000 r-xp 00000000 08:05 397277                     /usr/lib64/libkeyutils.so.1.5
 
7f248f065000-7f248f264000 ---p 00003000 08:05 397277                     /usr/lib64/libkeyutils.so.1.5
 
7f248f264000-7f248f265000 r--p 00002000 08:05 397277                     /usr/lib64/libkeyutils.so.1.5
 
7f248f265000-7f248f266000 rw-p 00003000 08:05 397277                     /usr/lib64/libkeyutils.so.1.5
 
7f248f266000-7f248f273000 r-xp 00000000 08:05 397545                     /usr/lib64/libkrb5support.so.0.1
 
7f248f273000-7f248f473000 ---p 0000d000 08:05 397545                     /usr/lib64/libkrb5support.so.0.1
 
7f248f473000-7f248f474000 r--p 0000d000 08:05 397545                     /usr/lib64/libkrb5support.so.0.1
 
7f248f474000-7f248f475000 rw-p 0000e000 08:05 397545                     /usr/lib64/libkrb5support.so.0.1
 
7f248f475000-7f248f484000 r-xp 00000000 08:05 396636                     /usr/lib64/libbz2.so.1.0.6
 
7f248f484000-7f248f683000 ---p 0000f000 08:05 396636                     /usr/lib64/libbz2.so.1.0.6
 
7f248f683000-7f248f684000 r--p 0000e000 08:05 396636                     /usr/lib64/libbz2.so.1.0.6
 
7f248f684000-7f248f685000 rw-p 0000f000 08:05 396636                     /usr/lib64/libbz2.so.1.0.6
 
7f248f685000-7f248f69c000 r-xp 00000000 08:05 396618                     /usr/lib64/libelf-0.166.so
 
7f248f69c000-7f248f89b000 ---p 00017000 08:05 396618                     /usr/lib64/libelf-0.166.so
 
7f248f89b000-7f248f89c000 r--p 00016000 08:05 396618                     /usr/lib64/libelf-0.166.so
 
7f248f89c000-7f248f89d000 rw-p 00017000 08:05 396618                     /usr/lib64/libelf-0.166.so
 
7f248f89d000-7f248f8fd000 r-xp 00000000 08:05 396477                     /usr/lib64/libpcre.so.1.2.0
 
7f248f8fd000-7f248fafc000 ---p 00060000 08:05 396477                     /usr/lib64/libpcre.so.1.2.0
 
7f248fafc000-7f248fafd000 r--p 0005f000 08:05 396477                     /usr/lib64/libpcre.so.1.2.0
 
7f248fafd000-7f248fafe000 rw-p 00060000 08:05 396477                     /usr/lib64/libpcre.so.1.2.0
 
7f248fafe000-7f248fb02000 r-xp 00000000 08:05 396878                     /usr/lib64/libattr.so.1.1.0
 
7f248fb02000-7f248fd01000 ---p 00004000 08:05 396878                     /usr/lib64/libattr.so.1.1.0
 
7f248fd01000-7f248fd02000 r--p 00003000 08:05 396878                     /usr/lib64/libattr.so.1.1.0
 
7f248fd02000-7f248fd03000 rw-p 00004000 08:05 396878                     /usr/lib64/libattr.so.1.1.0
 
7f248fd03000-7f248fd32000 r-xp 00000000 08:05 397533                     /usr/lib64/libk5crypto.so.3.1
 
7f248fd32000-7f248ff31000 ---p 0002f000 08:05 397533                     /usr/lib64/libk5crypto.so.3.1
 
7f248ff31000-7f248ff33000 r--p 0002e000 08:05 397533                     /usr/lib64/libk5crypto.so.3.1
 
7f248ff33000-7f248ff34000 rw-p 00030000 08:05 397533                     /usr/lib64/libk5crypto.so.3.1
 
7f248ff34000-7f248ff35000 rw-p 00000000 00:00 0
 
7f248ff35000-7f248ff38000 r-xp 00000000 08:05 396555                     /usr/lib64/libcom_err.so.2.1
 
7f248ff38000-7f2490137000 ---p 00003000 08:05 396555                     /usr/lib64/libcom_err.so.2.1
 
7f2490137000-7f2490138000 r--p 00002000 08:05 396555                     /usr/lib64/libcom_err.so.2.1
 
7f2490138000-7f2490139000 rw-p 00003000 08:05 396555                     /usr/lib64/libcom_err.so.2.1
 
7f2490139000-7f249020f000 r-xp 00000000 08:05 397543                     /usr/lib64/libkrb5.so.3.3
 
7f249020f000-7f249040f000 ---p 000d6000 08:05 397543                     /usr/lib64/libkrb5.so.3.3
 
7f249040f000-7f249041d000 r--p 000d6000 08:05 397543                     /usr/lib64/libkrb5.so.3.3
 
7f249041d000-7f2490420000 rw-p 000e4000 08:05 397543                     /usr/lib64/libkrb5.so.3.3
 
7f2490420000-7f249046b000 r-xp 00000000 08:05 397529                     /usr/lib64/libgssapi_krb5.so.2.2
 
7f249046b000-7f249066b000 ---p 0004b000 08:05 397529                     /usr/lib64/libgssapi_krb5.so.2.2
 
7f249066b000-7f249066c000 r--p 0004b000 08:05 397529                     /usr/lib64/libgssapi_krb5.so.2.2
 
7f249066c000-7f249066e000 rw-p 0004c000 08:05 397529                     /usr/lib64/libgssapi_krb5.so.2.2
 
7f249066e000-7f2490683000 r-xp 00000000 08:05 402239                     /usr/lib64/libgcc_s-4.8.5-20150702.so.1
 
7f2490683000-7f2490882000 ---p 00015000 08:05 402239                     /usr/lib64/libgcc_s-4.8.5-20150702.so.1
 
7f2490882000-7f2490883000 r--p 00014000 08:05 402239                     /usr/lib64/libgcc_s-4.8.5-20150702.so.1
 
7f2490883000-7f2490884000 rw-p 00015000 08:05 402239                     /usr/lib64/libgcc_s-4.8.5-20150702.so.1
 
7f2490884000-7f24908c9000 r-xp 00000000 08:05 396943                     /usr/lib64/libdw-0.166.so
 
7f24908c9000-7f2490ac9000 ---p 00045000 08:05 396943                     /usr/lib64/libdw-0.166.so
 
7f2490ac9000-7f2490acb000 r--p 00045000 08:05 396943                     /usr/lib64/libdw-0.166.so
 
7f2490acb000-7f2490acc000 rw-p 00047000 08:05 396943                     /usr/lib64/libdw-0.166.so
 
7f2490acc000-7f2490ae2000 r-xp 00000000 08:05 396049                     /usr/lib64/libresolv-2.17.so
 
7f2490ae2000-7f2490ce2000 ---p 00016000 08:05 396049                     /usr/lib64/libresolv-2.17.so
 
7f2490ce2000-7f2490ce3000 r--p 00016000 08:05 396049                     /usr/lib64/libresolv-2.17.so
 
7f2490ce3000-7f2490ce4000 rw-p 00017000 08:05 396049                     /usr/lib64/libresolv-2.17.so
 
7f2490ce4000-7f2490ce6000 rw-p 00000000 00:00 0
 
7f2490ce6000-7f2490cea000 r-xp 00000000 08:05 396689                     /usr/lib64/libgpg-error.so.0.10.0
 
7f2490cea000-7f2490ee9000 ---p 00004000 08:05 396689                     /usr/lib64/libgpg-error.so.0.10.0
 
7f2490ee9000-7f2490eea000 r--p 00003000 08:05 396689                     /usr/lib64/libgpg-error.so.0.10.0
 
7f2490eea000-7f2490eeb000 rw-p 00004000 08:05 396689                     /usr/lib64/libgpg-error.so.0.10.0
 
7f2490eeb000-7f2490f67000 r-xp 00000000 08:05 396706                     /usr/lib64/libgcrypt.so.11.8.2
 
7f2490f67000-7f2491167000 ---p 0007c000 08:05 396706                     /usr/lib64/libgcrypt.so.11.8.2
 
7f2491167000-7f2491168000 r--p 0007c000 08:05 396706                     /usr/lib64/libgcrypt.so.11.8.2
 
7f2491168000-7f249116b000 rw-p 0007d000 08:05 396706                     /usr/lib64/libgcrypt.so.11.8.2
 
7f249116b000-7f249116c000 rw-p 00000000 00:00 0
 
7f249116c000-7f2491190000 r-xp 00000000 08:05 396493                     /usr/lib64/libselinux.so.1
 
7f2491190000-7f249138f000 ---p 00024000 08:05 396493                     /usr/lib64/libselinux.so.1
 
7f249138f000-7f2491390000 r--p 00023000 08:05 396493                     /usr/lib64/libselinux.so.1
 
7f2491390000-7f2491391000 rw-p 00024000 08:05 396493                     /usr/lib64/libselinux.so.1
 
7f2491391000-7f2491393000 rw-p 00000000 00:00 0
 
7f2491393000-7f249139a000 r-xp 00000000 08:05 396051                     /usr/lib64/librt-2.17.so
 
7f249139a000-7f2491599000 ---p 00007000 08:05 396051                     /usr/lib64/librt-2.17.so
 
7f2491599000-7f249159a000 r--p 00006000 08:05 396051                     /usr/lib64/librt-2.17.so
 
7f249159a000-7f249159b000 rw-p 00007000 08:05 396051                     /usr/lib64/librt-2.17.so
 
7f249159b000-7f249159f000 r-xp 00000000 08:05 396883                     /usr/lib64/libcap.so.2.22
 
7f249159f000-7f249179e000 ---p 00004000 08:05 396883                     /usr/lib64/libcap.so.2.22
 
7f249179e000-7f249179f000 r--p 00003000 08:05 396883                     /usr/lib64/libcap.so.2.22
 
7f249179f000-7f24917a0000 rw-p 00004000 08:05 396883                     /usr/lib64/libcap.so.2.22
 
7f24917a0000-7f24917a2000 r-xp 00000000 08:05 395416                     /usr/lib64/libfreebl3.so
 
7f24917a2000-7f24919a1000 ---p 00002000 08:05 395416                     /usr/lib64/libfreebl3.so
 
7f24919a1000-7f24919a2000 r--p 00001000 08:05 395416                     /usr/lib64/libfreebl3.so
 
7f24919a2000-7f24919a3000 rw-p 00002000 08:05 395416                     /usr/lib64/libfreebl3.so
 
7f24919a3000-7f2491b59000 r-xp 00000000 08:05 396018                     /usr/lib64/libc-2.17.so
 
7f2491b59000-7f2491d59000 ---p 001b6000 08:05 396018                     /usr/lib64/libc-2.17.so
 
7f2491d59000-7f2491d5d000 r--p 001b6000 08:05 396018                     /usr/lib64/libc-2.17.so
 
7f2491d5d000-7f2491d5f000 rw-p 001ba000 08:05 396018                     /usr/lib64/libc-2.17.so
 
7f2491d5f000-7f2491d64000 rw-p 00000000 00:00 0
 
7f2491d64000-7f2491e64000 r-xp 00000000 08:05 396029                     /usr/lib64/libm-2.17.so
 
7f2491e64000-7f2492064000 ---p 00100000 08:05 396029                     /usr/lib64/libm-2.17.so
 
7f2492064000-7f2492065000 r--p 00100000 08:05 396029                     /usr/lib64/libm-2.17.so
 
7f2492065000-7f2492066000 rw-p 00101000 08:05 396029                     /usr/lib64/libm-2.17.so
 
7f2492066000-7f249214f000 r-xp 00000000 08:05 396339                     /usr/lib64/libstdc++.so.6.0.19
 
7f249214f000-7f249234f000 ---p 000e9000 08:05 396339                     /usr/lib64/libstdc++.so.6.0.19
 
7f249234f000-7f2492357000 r--p 000e9000 08:05 396339                     /usr/lib64/libstdc++.so.6.0.19
 
7f2492357000-7f2492359000 rw-p 000f1000 08:05 396339                     /usr/lib64/libstdc++.so.6.0.19
 
7f2492359000-7f249236e000 rw-p 00000000 00:00 0
 
7f249236e000-7f2492370000 r-xp 00000000 08:05 396025                     /usr/lib64/libdl-2.17.so
 
7f2492370000-7f2492570000 ---p 00002000 08:05 396025                     /usr/lib64/libdl-2.17.so
 
7f2492570000-7f2492571000 r--p 00002000 08:05 396025                     /usr/lib64/libdl-2.17.so
 
7f2492571000-7f2492572000 rw-p 00003000 08:05 396025                     /usr/lib64/libdl-2.17.so
 
7f2492572000-7f2492732000 r-xp 00000000 08:05 397556                     /usr/lib64/libcrypto.so.1.0.1e
 
7f2492732000-7f2492932000 ---p 001c0000 08:05 397556                     /usr/lib64/libcrypto.so.1.0.1e
 
7f2492932000-7f249294c000 r--p 001c0000 08:05 397556                     /usr/lib64/libcrypto.so.1.0.1e
 
7f249294c000-7f2492958000 rw-p 001da000 08:05 397556                     /usr/lib64/libcrypto.so.1.0.1e
 
7f2492958000-7f249295c000 rw-p 00000000 00:00 0
 
7f249295c000-7f24929c0000 r-xp 00000000 08:05 397558                     /usr/lib64/libssl.so.1.0.1e
 
7f24929c0000-7f2492bbf000 ---p 00064000 08:05 397558                     /usr/lib64/libssl.so.1.0.1e
 
7f2492bbf000-7f2492bc3000 r--p 00063000 08:05 397558                     /usr/lib64/libssl.so.1.0.1e
 
7f2492bc3000-7f2492bca000 rw-p 00067000 08:05 397558                     /usr/lib64/libssl.so.1.0.1e
 
7f2492bca000-7f2492bd2000 r-xp 00000000 08:05 396023                     /usr/lib64/libcrypt-2.17.so
 
7f2492bd2000-7f2492dd1000 ---p 00008000 08:05 396023                     /usr/lib64/libcrypt-2.17.so
 
7f2492dd1000-7f2492dd2000 r--p 00007000 08:05 396023                     /usr/lib64/libcrypt-2.17.so
 
7f2492dd2000-7f2492dd3000 rw-p 00008000 08:05 396023                     /usr/lib64/libcrypt-2.17.so
 
7f2492dd3000-7f2492e01000 rw-p 00000000 00:00 0
 
7f2492e01000-7f2492e16000 r-xp 00000000 08:05 396495                     /usr/lib64/libz.so.1.2.7
 
7f2492e16000-7f2493015000 ---p 00015000 08:05 396495                     /usr/lib64/libz.so.1.2.7
 
7f2493015000-7f2493016000 r--p 00014000 08:05 396495                     /usr/lib64/libz.so.1.2.7
 
7f2493016000-7f2493017000 rw-p 00015000 08:05 396495                     /usr/lib64/libz.so.1.2.7
 
7f2493017000-7f2493018000 r-xp 00000000 08:05 402916                     /usr/lib64/libaio.so.1.0.1
 
7f2493018000-7f2493217000 ---p 00001000 08:05 402916                     /usr/lib64/libaio.so.1.0.1
 
7f2493217000-7f2493218000 r--p 00000000 08:05 402916                     /usr/lib64/libaio.so.1.0.1
 
7f2493218000-7f2493219000 rw-p 00001000 08:05 402916                     /usr/lib64/libaio.so.1.0.1
 
7f2493219000-7f249323e000 r-xp 00000000 08:05 396311                     /usr/lib64/liblzma.so.5.2.2
 
7f249323e000-7f249343d000 ---p 00025000 08:05 396311                     /usr/lib64/liblzma.so.5.2.2
 
7f249343d000-7f249343e000 r--p 00024000 08:05 396311                     /usr/lib64/liblzma.so.5.2.2
 
7f249343e000-7f249343f000 rw-p 00025000 08:05 396311                     /usr/lib64/liblzma.so.5.2.2
 
7f249343f000-7f2493456000 r-xp 00000000 08:05 396047                     /usr/lib64/libpthread-2.17.so
 
7f2493456000-7f2493655000 ---p 00017000 08:05 396047                     /usr/lib64/libpthread-2.17.so
 
7f2493655000-7f2493656000 r--p 00016000 08:05 396047                     /usr/lib64/libpthread-2.17.so
 
7f2493656000-7f2493657000 rw-p 00017000 08:05 396047                     /usr/lib64/libpthread-2.17.so
 
7f2493657000-7f249365b000 rw-p 00000000 00:00 0
 
7f249365b000-7f249367b000 r-xp 00000000 08:05 396008                     /usr/lib64/ld-2.17.so
 
7f24936c1000-7f24936c2000 ---p 00000000 00:00 0
 
7f24936c2000-7f249370b000 rw-p 00000000 00:00 0                          [stack:63333]
 
7f249370b000-7f2493714000 rw-s 00000000 00:0c 136091                     /[aio] (deleted)
 
7f2493714000-7f249371d000 rw-s 00000000 00:0c 136090                     /[aio] (deleted)
 
7f249371d000-7f2493726000 rw-s 00000000 00:0c 136089                     /[aio] (deleted)
 
7f2493726000-7f249372f000 rw-s 00000000 00:0c 136088                     /[aio] (deleted)
 
7f249372f000-7f2493738000 rw-s 00000000 00:0c 136087                     /[aio] (deleted)
 
7f2493738000-7f2493741000 rw-s 00000000 00:0c 136086                     /[aio] (deleted)
 
7f2493741000-7f249374a000 rw-s 00000000 00:0c 136085                     /[aio] (deleted)
 
7f249374a000-7f2493753000 rw-s 00000000 00:0c 136084                     /[aio] (deleted)
 
7f2493753000-7f249375c000 rw-s 00000000 00:0c 136083                     /[aio] (deleted)
 
7f249375c000-7f2493765000 rw-s 00000000 00:0c 136082                     /[aio] (deleted)
 
7f2493765000-7f249376e000 rw-s 00000000 00:0c 136081                     /[aio] (deleted)
 
7f249376e000-7f2493777000 rw-s 00000000 00:0c 136080                     /[aio] (deleted)
 
7f2493777000-7f2493847000 rw-p 00000000 00:00 0
 
7f2493847000-7f249386d000 r-xp 00000000 08:05 402451                     /usr/lib64/libsystemd.so.0.6.0
 
7f249386d000-7f249386e000 r--p 00025000 08:05 402451                     /usr/lib64/libsystemd.so.0.6.0
 
7f249386e000-7f249386f000 rw-p 00026000 08:05 402451                     /usr/lib64/libsystemd.so.0.6.0
 
7f249386f000-7f2493871000 rw-p 00000000 00:00 0
 
7f2493877000-7f249387a000 rw-p 00000000 00:00 0
 
7f249387a000-7f249387b000 r--p 0001f000 08:05 396008                     /usr/lib64/ld-2.17.so
 
7f249387b000-7f249387c000 rw-p 00020000 08:05 396008                     /usr/lib64/ld-2.17.so
 
7f249387c000-7f249387d000 rw-p 00000000 00:00 0
 
7ffc8be70000-7ffc8be91000 rw-p 00000000 00:00 0                          [stack]
 
7ffc8bf7c000-7ffc8bf7e000 r--p 00000000 00:00 0                          [vvar]
 
7ffc8bf7e000-7ffc8bf80000 r-xp 00000000 00:00 0                          [vdso]
 
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
 
170621 13:43:59 [ERROR] mysqld got signal 6 ;
 
This could be because you hit a bug. It is also possible that this binary
 
or one of the libraries it was linked against is corrupt, improperly built,
 
or misconfigured. This error can also be caused by malfunctioning hardware.
 
 
 
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
 
 
 
We will try our best to scrape up some info that will hopefully help
 
diagnose the problem, but since we have already crashed,
 
something is definitely wrong and this may fail.
 
 
 
Server version: 10.2.6-MariaDB-log
 
key_buffer_size=134217728
 
read_buffer_size=8388608
 
max_used_connections=19
 
max_threads=502
 
thread_count=44
 
It is possible that mysqld could use up to
 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 135850296 K  bytes of memory
 
Hope that's ok; if not, decrease some variables in the equation.
 
 
 
Thread pointer: 0x7f243c0009a8
 
Attempting backtrace. You can use the following information to find out
 
where mysqld died. If you see no messages after this, something went
 
terribly wrong...
 
stack_bottom = 0x7f24255f3d70 thread_stack 0x49000
 
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55c41f48bc9e]
 
/usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x55c41eeda93d]
 
/lib64/libpthread.so.0(+0xf370)[0x7f249344e370]
 
/lib64/libc.so.6(gsignal+0x37)[0x7f24919d81d7]
 
/lib64/libc.so.6(abort+0x148)[0x7f24919d98c8]
 
/lib64/libc.so.6(+0x74f07)[0x7f2491a17f07]
 
/lib64/libc.so.6(+0x7c503)[0x7f2491a1f503]
 
/usr/sbin/mysqld(_ZN15Item_func_regex7cleanupEv+0x38)[0x55c41ef1cdf8]
 
/usr/sbin/mysqld(_ZN4Item17cleanup_processorEPv+0x1a)[0x55c41eeebdea]
 
/usr/sbin/mysqld(_Z25pushdown_cond_for_derivedP3THDP4ItemP10TABLE_LIST+0x26d)[0x55c41ed2f07d]
 
/usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x4f7)[0x55c41ed9ffe7]
 
/usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x3f)[0x55c41eda265f]
 
/usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x94)[0x55c41eda3d54]
 
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x24c)[0x55c41eda491c]
 
/usr/sbin/mysqld(+0x4d0586)[0x55c41ed48586]
 
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x5ae7)[0x55c41ed54807]
 
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2de)[0x55c41ed57dee]
 
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1fcf)[0x55c41ed5ac2f]
 
/usr/sbin/mysqld(_Z10do_commandP3THD+0x161)[0x55c41ed5b7d1]
 
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1aa)[0x55c41ee1b83a]
 
/usr/sbin/mysqld(handle_one_connection+0x3d)[0x55c41ee1b95d]
 
/lib64/libpthread.so.0(+0x7dc5)[0x7f2493446dc5]
 
/lib64/libc.so.6(clone+0x6d)[0x7f2491a9a73d]
 
 
 
Trying to get some variables.
 
Some pointers may be invalid and cause the dump to abort.
 
Query (0x7f243c00efc0): select * from vw_test_regex t where t.name regexp "(test)"
 
Connection ID (thread ID): 153
 
Status: NOT_KILLED
 
 
 
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
 
 
 
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
 
information that should help you find out what is causing the crash.
 
2017-06-21 13:44:05 140324781299840 [Warning] option 'innodb-sort-buffer-size': unsigned value 268435456 adjusted to 67108864
 
2017-06-21 13:44:05 140324781299840 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
 
2017-06-21 13:44:05 140324781299840 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 
2017-06-21 13:44:05 140324781299840 [Note] InnoDB: Uses event mutexes
 
2017-06-21 13:44:05 140324781299840 [Note] InnoDB: Compressed tables use zlib 1.2.7
 
2017-06-21 13:44:05 140324781299840 [Note] InnoDB: Using Linux native AIO
 
2017-06-21 13:44:05 140324781299840 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 2 to 1 since innodb_buffer_pool_size is less than 1024 MiB
 
2017-06-21 13:44:05 140324781299840 [Note] InnoDB: Number of pools: 1
 
2017-06-21 13:44:05 140324781299840 [Note] InnoDB: Using SSE2 crc32 instructions
 
2017-06-21 13:44:05 140324781299840 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
 
2017-06-21 13:44:05 140324781299840 [Note] InnoDB: Completed initialization of buffer pool
 
2017-06-21 13:44:05 140323463595776 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
 
2017-06-21 13:44:05 140324781299840 [Note] InnoDB: Highest supported file format is Barracuda.
 
2017-06-21 13:44:05 140324781299840 [Note] InnoDB: Starting crash recovery from checkpoint LSN=6022544663
 
2017-06-21 13:44:07 140324781299840 [Note] InnoDB: Starting final batch to recover 27 pages from redo log.
 
InnoDB: Last MySQL binlog file position 0 890146, file name ./SC-DB-APP-bin.000019
 
2017-06-21 13:44:11 140324781299840 [Note] InnoDB: 128 out of 128 rollback segments are active.
 
2017-06-21 13:44:11 140324781299840 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
 
2017-06-21 13:44:11 140324781299840 [Note] InnoDB: Creating shared tablespace for temporary tables
 
2017-06-21 13:44:11 140324781299840 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
2017-06-21 13:44:12 140324781299840 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
 
2017-06-21 13:44:12 140324781299840 [Note] InnoDB: Waiting for purge to start
 
2017-06-21 13:44:12 140324781299840 [Note] InnoDB: 5.7.14 started; log sequence number 6022547044
 
2017-06-21 13:44:12 140323463595776 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6733ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
 
2017-06-21 13:44:12 140323065939712 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
 
2017-06-21 13:44:12 140324781299840 [Note] Plugin 'FEEDBACK' is disabled.
 
2017-06-21 13:44:12 140324781299840 [Note] Recovering after a crash using SC-DB-APP-bin
 
2017-06-21 13:44:12 140324781299840 [Note] Starting crash recovery...
 
2017-06-21 13:44:12 140324781299840 [Note] Crash recovery finished.
 
2017-06-21 13:44:13 140324781299840 [Note] Server socket created on IP: '0.0.0.0'.
 
2017-06-21 13:44:13 140324781299840 [Note] Reading of all Master_info entries succeded
 
2017-06-21 13:44:13 140324781299840 [Note] Added new Master_info '' to hash table

Here is Example Script:

create database test1;
 
 
 
use test1;
 
 
 
create view vw_test_regex as
 
select 1 as id, 'test1' as name from dual
 
union all
 
select 2 as id, 'test2' as name from dual
 
union all
 
select 3 as id, 'test2' as name from dual
 
union all
 
select 4 as id, 'test3' as name from dual
 
union all
 
select  5 as id, 'test5' as name from dual
 
union all
 
select  6 as id, 'test6' as name from dual;
 
 
 
select * from vw_test_regex t
 
where t.name like 'test%';
 
 
 
select * from vw_test_regex t
 
where t.name regexp "(test)";



 Comments   
Comment by Alice Sherepa [ 2017-06-22 ]

Reproduced with the test case below:

create view v1 as select 1 as id, 'test1' as name;
 
select * from v1 where name regexp "(test)";

on 10.2.7-debug (commit 0992be927e1c686c39c39fe53fc2a7869d55143d) there is an error in error log, but no crash

Error: Freeing overrun buffer  0x5562258dffde, 0x5562258cd743, 0x556224e1c3a5, 0x5562251b9ade, 0x5562251b9c28, 0x556224ebf0dd, 0x556224eb62d4, 0x556224eb183f
 
Allocated at 0x556224e1c38b, mysys/safemalloc.c:194, 0x5562251b2232, sql/item_cmpfunc.h:2087, sql/item.h:1789, sql/item_cmpfunc.cc:5641, sql/item_func.cc:237, sql/sql_select.cc:1297
 
 
 
Error: Freeing overrun buffer  mysys/safemalloc.c:194, mysys/my_malloc.c:219, sql/mysqld.cc:3649, sql/item_cmpfunc.h:2087, sql/item_cmpfunc.h:2110, sql/item.h:1789, sql/sql_class.cc:3509, sql/sql_class.cc:2146
 
Allocated at sql/mysqld.cc:3643, 0x7f6c1f7e7642, sql/item_cmpfunc.cc:5419, sql/item_cmpfunc.cc:5441, sql/item_cmpfunc.cc:5619, sql/item_cmpfunc.cc:5641, sql/item_func.cc:237, sql/sql_select.cc:1297

Mysqld crashed on 10.2.5 and 10.2.6

mysqld(14173,0x70001068a000) malloc: *** error for object 0x7fa0d15499a0: pointer being freed was not allocated
 
*** set a breakpoint in malloc_error_break to debug
 
170622 17:35:46 [ERROR] mysqld got signal 6 ;
 
This could be because you hit a bug. It is also possible that this binary
 
or one of the libraries it was linked against is corrupt, improperly built,
 
or misconfigured. This error can also be caused by malfunctioning hardware.
 
 
 
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
 
 
 
We will try our best to scrape up some info that will hopefully help
 
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.
 
 
 
Server version: 10.2.6-MariaDB
 
key_buffer_size=134217728
 
read_buffer_size=131072
 
max_used_connections=1
 
max_threads=153
 
thread_count=8
 
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467201 K  bytes of memory
 
Hope that's ok; if not, decrease some variables in the equation.
 
 
 
Thread pointer: 0x7fa0d18fc608
 
Attempting backtrace. You can use the following information to find out
 
where mysqld died. If you see no messages after this, something went
 
terribly wrong...
 
stack_bottom = 0x700010689e90 thread_stack 0x49000
 
0   mysqld                              0x0000000101aac574 my_print_stacktrace + 60
 
0   mysqld                              0x00000001014f6bd7 handle_fatal_signal + 695
 
0   libsystem_platform.dylib            0x00007fffc6a96b3a _sigtramp + 26
 
0   ???                                 0x0000000000000000 0x0 + 0
 
0   libsystem_c.dylib                   0x00007fffc691b420 abort + 129
 
0   libsystem_malloc.dylib              0x00007fffc6a0afe7 szone_size + 0
 
0   mysqld                              0x000000010152ba6b _ZN15Item_func_regex7cleanupEv + 53
 
0   mysqld                              0x000000010164b731 _ZN3THD19cleanup_after_queryEv + 303
 
0   mysqld                              0x000000010167c36e _Z11mysql_parseP3THDPcjP12Parser_statebb + 744
 
0   mysqld                              0x0000000101679f74 _Z16dispatch_command19enum_server_commandP3THDPcjbb + 5279
 
0   mysqld                              0x000000010167b440 _Z10do_commandP3THD + 892
 
0   mysqld                              0x000000010174aa1e _Z24do_handle_one_connectionP7CONNECT + 547
 
0   mysqld                              0x000000010174a7ee handle_one_connection + 56
 
0   libsystem_pthread.dylib             0x00007fffc6aa093b _pthread_body + 180
 
0   libsystem_pthread.dylib             0x00007fffc6aa0887 _pthread_body + 0
 
0   libsystem_pthread.dylib             0x00007fffc6aa008d thread_start + 13
 
 
 
Trying to get some variables.
 
Some pointers may be invalid and cause the dump to abort.
 
Query (0x7fa0d190a020): is an invalid pointer
 
Connection ID (thread ID): 11
 
Status: NOT_KILLED
 
 
 
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on

Comment by Elena Stepanova [ 2017-06-24 ]

10.2 0992be9 with valgrind

 
==29502== Thread 6:
 
==29502== Invalid read of size 4
 
==29502==    at 0x56A256D: pcre_exec (in /lib/x86_64-linux-gnu/libpcre.so.3.13.1)
 
==29502==    by 0x97BDDD: Regexp_processor_pcre::pcre_exec_with_warn(real_pcre const*, pcre_extra const*, char const*, int, int, int, int*, int) (item_cmpfunc.cc:5558)
 
==29502==    by 0x97BF57: Regexp_processor_pcre::exec(String*, int, unsigned int) (item_cmpfunc.cc:5582)
 
==29502==    by 0x97C0D5: Regexp_processor_pcre::exec(Item*, int, unsigned int) (item_cmpfunc.cc:5609)
 
==29502==    by 0x97C31F: Item_func_regex::val_int() (item_cmpfunc.cc:5651)
 
==29502==    by 0x9A5278: eval_const_cond(Item*) (item_func.cc:79)
 
==29502==    by 0x71CBAB: Item::remove_eq_conds(THD*, Item::cond_result*, bool) (sql_select.cc:15561)
 
==29502==    by 0x700A53: make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*) (sql_select.cc:4211)
 
==29502==    by 0x6F72C9: JOIN::optimize_inner() (sql_select.cc:1508)
 
==29502==    by 0x6F5A7A: JOIN::optimize() (sql_select.cc:1085)
 
==29502==    by 0x6FEB17: mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:3654)
 
==29502==    by 0x6F339F: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:373)
 
==29502==    by 0x6BE7CD: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:6438)
 
==29502==    by 0x6B480A: mysql_execute_command(THD*) (sql_parse.cc:3453)
 
==29502==    by 0x6C219F: mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7875)
 
==29502==    by 0x6B0276: dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) (sql_parse.cc:1817)

Assigned to serg because there was recent activity around similar stack traces in regex under his supervision: MDEV-12420.

Comment by Sergei Golubchik [ 2017-06-26 ]

This is the same as MDEV-12939 — happens when a new 10.2 optimization (MDEV-9197) is applied to REGEX family of functions. Basically, when you have a view or a derived table, and an outer query has a WHERE clause with REGEX that applies to this view or derived table.

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