regexp on views - crashed mariadb server

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

*** 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

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)";