Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2.6, 10.2(EOL)
-
None
-
Oracle Linux 7.3/CentOS 7 Plataform 64 bits
MariaDB 10.2.6
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)"; |
Attachments
Issue Links
- causes
-
-
- Closed
-
- is duplicated by
-
-
- Closed
-
- relates to
-
-
- Closed
-
Activity
|
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.
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.
Reproduced with the test case below:
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, 0x556224eb183fAllocated 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:1297Error: 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:2146Allocated 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:1297Mysqld 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 debug170622 17:35:46 [ERROR] mysqld got signal 6 ;This could be because you hit a bug. It is also possible that this binaryor 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-bugsWe will try our best to scrape up some info that will hopefully helpdiagnose the problem, but since we have already crashed,something is definitely wrong and this may fail.Server version: 10.2.6-MariaDBkey_buffer_size=134217728read_buffer_size=131072max_used_connections=1max_threads=153thread_count=8It is possible that mysqld could use up tokey_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467201 K bytes of memoryHope that's ok; if not, decrease some variables in the equation.Thread pointer: 0x7fa0d18fc608Attempting backtrace. You can use the following information to find outwhere mysqld died. If you see no messages after this, something wentterribly wrong...stack_bottom = 0x700010689e90 thread_stack 0x490000 mysqld 0x0000000101aac574 my_print_stacktrace + 600 mysqld 0x00000001014f6bd7 handle_fatal_signal + 6950 libsystem_platform.dylib 0x00007fffc6a96b3a _sigtramp + 260 ??? 0x0000000000000000 0x0 + 00 libsystem_c.dylib 0x00007fffc691b420 abort + 1290 libsystem_malloc.dylib 0x00007fffc6a0afe7 szone_size + 00 mysqld 0x000000010152ba6b _ZN15Item_func_regex7cleanupEv + 530 mysqld 0x000000010164b731 _ZN3THD19cleanup_after_queryEv + 3030 mysqld 0x000000010167c36e _Z11mysql_parseP3THDPcjP12Parser_statebb + 7440 mysqld 0x0000000101679f74 _Z16dispatch_command19enum_server_commandP3THDPcjbb + 52790 mysqld 0x000000010167b440 _Z10do_commandP3THD + 8920 mysqld 0x000000010174aa1e _Z24do_handle_one_connectionP7CONNECT + 5470 mysqld 0x000000010174a7ee handle_one_connection + 560 libsystem_pthread.dylib 0x00007fffc6aa093b _pthread_body + 1800 libsystem_pthread.dylib 0x00007fffc6aa0887 _pthread_body + 00 libsystem_pthread.dylib 0x00007fffc6aa008d thread_start + 13Trying to get some variables.Some pointers may be invalid and cause the dump to abort.Query (0x7fa0d190a020): is an invalid pointerConnection ID (thread ID): 11Status: NOT_KILLEDOptimizer 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