[#MDEV-16611] Crash on Stored Procedure calling View in Join

[MDEV-16611] Crash on Stored Procedure calling View in Join Created: 2018-06-28 Updated: 2018-10-01 Resolved: 2018-10-01
Status:	Closed
Project:	MariaDB Server
Component/s:	Server
Affects Version/s:	10.3.7
Fix Version/s:	10.2.17, 10.3.9

Type:

Bug

Priority:

Major

Reporter:

Holger Rojahn

Assignee:

Alice Sherepa

Resolution:

Fixed

Votes:

Labels:

None

Environment:

Ubuntu 64 Bit
Perhaps ~~MDEV-13144~~ Problem ?!
Regex dont catch on View but View is involved ?!

Issue Links:

Problem/Incident
is caused by	~~MDEV-13144~~	regexp on views - crashed mariadb server	Closed
Relates
relates to	~~MDEV-12939~~	A query crashes MariaDB in Item_func_...	Closed
relates to	~~MDEV-13144~~	regexp on views - crashed mariadb server	Closed
relates to	~~MDEV-16614~~	signal 7 after calling stored procedu...	Closed

Description

- - Error in `/usr/sbin/mysqld': double free or corruption (fasttop): 0x00007fd9d4a213a0 *** ======= Backtrace: ========= /lib/x86_64-linux-gnu/libc.so.6(+0x777e5)[0x7fd9e11037e5]
    /lib/x86_64-linux-gnu/libc.so.6(+0x8037a)[0x7fd9e110c37a]
    /lib/x86_64-linux-gnu/libc.so.6(cfree+0x4c)[0x7fd9e111053c]
    /usr/sbin/mysqld(_ZN15Item_func_regex7cleanupEv+0x33)[0x5568045b40c3]
    /usr/sbin/mysqld(_ZN11Query_arena10free_itemsEv+0x2d)[0x55680435891d]
    /usr/sbin/mysqld(_ZN3THD19cleanup_after_queryEv+0x11b)[0x55680435b36b]
    /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x891)[0x556804313291]
    /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x90a)[0x55680431461a]
    /usr/sbin/mysqld(+0x5701b9)[0x5568043961b9]
    /usr/sbin/mysqld(+0x571666)[0x556804397666]
    /usr/sbin/mysqld(_ZN12Sql_cmd_call7executeEP3THD+0x90)[0x556804397e10]
    /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1407)[0x55680439dfe7]
    /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x21a)[0x5568043a577a]
    /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1c23)[0x5568043a80c3]
    /usr/sbin/mysqld(_Z10do_commandP3THD+0x13c)[0x5568043a8b7c]
    /usr/sbin/mysqld(_Z11tp_callbackP13TP_connection+0x123)[0x5568044b4da3]
    /usr/sbin/mysqld(+0x7265f8)[0x55680454c5f8]
    /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fd9e1ae86ba]
    /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fd9e119341d]
    ======= Memory map: ========
    556803e26000-55680507f000 r-xp 00000000 fc:00 524725 /usr/sbin/mysqld
    55680527e000-556805370000 r--p 01258000 fc:00 524725 /usr/sbin/mysqld
    556805370000-556805429000 rw-p 0134a000 fc:00 524725 /usr/sbin/mysqld
    556805429000-556805cc0000 rw-p 00000000 00:00 0
    556806b1a000-556807524000 rw-p 00000000 00:00 0 [heap]
    7fd97347d000-7fd97382a000 rw-p 00000000 00:00 0 7fd973840000-7fd9738fe000 rw-p 00000000 00:00 0 7fd973af0000-7fd973c97000 rw-p 00000000 00:00 0 7fd973c9f000-7fd973f04000 rw-p 00000000 00:00 0 7fd973f13000-7fd97403e000 rw-p 00000000 00:00 0 7fd974050000-7fd9740b4000 rw-p 00000000 00:00 0 7fd9740c3000-7fd9742df000 rw-p 00000000 00:00 0 7fd9742ec000-7fd9744ea000 rw-p 00000000 00:00 0 7fd9744ec000-7fd9745bd000 rw-p 00000000 00:00 0 7fd9745cb000-7fd9746b4000 rw-p 00000000 00:00 0 7fd9746b4000-7fd9746b5000 ---p 00000000 00:00 0 7fd9746b5000-7fd9746fe000 rw-p 00000000 00:00 0 7fd9746fe000-7fd9746ff000 ---p 00000000 00:00 0 7fd9746ff000-7fd9747bd000 rw-p 00000000 00:00 0 7fd9747c0000-7fd9747e6000 rw-p 00000000 00:00 0 7fd9747f8000-7fd97480c000 rw-p 00000000 00:00 0 7fd974816000-7fd97494f000 rw-p 00000000 00:00 0 7fd974957000-7fd974a2e000 rw-p 00000000 00:00 0 7fd974a31000-7fd974b03000 rw-p 00000000 00:00 0 7fd974b07000-7fd974bbd000 rw-p 00000000 00:00 0 7fd974bc7000-7fd974bda000 rw-p 00000000 00:00 0 7fd974bdc000-7fd974cf9000 rw-p 00000000 00:00 0 7fd974d0b000-7fd974d1f000 rw-p 00000000 00:00 0 7fd974d20000-7fd974e8d000 rw-p 00000000 00:00 0 7fd974e95000-7fd974ecb000 rw-p 00000000 00:00 0 7fd974ee8000-7fd974f81000 rw-p 00000000 00:00 0 7fd974f8f000-7fd974fc8000 rw-p 00000000 00:00 0 7fd974fd7000-7fd974fea000 rw-p 00000000 00:00 0 7fd975004000-7fd975118000 rw-p 00000000 00:00 0 7fd97511d000-7fd9751c3000 rw-p 00000000 00:00 0 7fd9751cc000-7fd97521c000 rw-p 00000000 00:00 0 7fd97522a000-7fd975250000 rw-p 00000000 00:00 0 7fd975260000-7fd9752bf000 rw-p 00000000 00:00 0 7fd9752d0000-7fd975417000 rw-p 00000000 00:00 0 7fd97541e000-7fd97545a000 rw-p 00000000 00:00 0 7fd975464000-7fd9755d4000 rw-p 00000000 00:00 0 7fd9755d9000-7fd97567a000 rw-p 00000000 00:00 0 7fd975687000-7fd9756ad000 rw-p 00000000 00:00 0 7fd9756bc000-7fd9756d0000 rw-p 00000000 00:00 0 7fd9756d7000-7fd975713000 rw-p 00000000 00:00 0 7fd97571e000-7fd975730000 rw-p 00000000 00:00 0 7fd975735000-7fd9757a3000 rw-p 00000000 00:00 0 7fd9757a9000-7fd9757e4000 rw-p 00000000 00:00 0 7fd9757e6000-7fd9757fa000 rw-p 00000000 00:00 0 7fd9757fb000-7fd9758a5000 rw-p 00000000 00:00 0 7fd9758ad000-7fd9758d5000 rw-p 00000000 00:00 0 7fd9758d8000-7fd975911000 rw-p 00000000 00:00 0 7fd97591a000-7fd9759c1000 rw-p 00000000 00:00 0 7fd9759c4000-7fd9759ec000 rw-p 00000000 00:00 0 7fd9759f8000-7fd975a7d000 rw-p 00000000 00:00 0 7fd975a82000-7fd975ae2000 rw-p 00000000 00:00 0 7fd975af3000-7fd975c08000 rw-p 00000000 00:00 0 7fd975c0e000-7fd975c58000 rw-p 00000000 00:00 0 7fd975c62000-7fd975c74000 rw-p 00000000 00:00 0 7fd975c91000-7fd975e1e000 rw-p 00000000 00:00 0 7fd975e23000-7fd975eae000 rw-p 00000000 00:00 0 7fd975eb9000-7fd975f18000 rw-p 00000000 00:00 0 7fd975f36000-7fd975ffc000 rw-p 00000000 00:00 0 7fd975ffc000-7fd975ffd000 ---p 00000000 00:00 0 7fd975ffd000-7fd9767fd000 rw-p 00000000 00:00 0 7fd9767fd000-7fd9767fe000 ---p 00000000 00:00 0 7fd9767fe000-7fd976ffe000 rw-p 00000000 00:00 0 7fd976ffe000-7fd976fff000 ---p 00000000 00:00 0 7fd976fff000-7fd9777ff000 rw-p 00000000 00:00 0 7fd9777ff000-7fd977800000 ---p 00000000 00:00 0 7fd977800000-7fd978000000 rw-p 00000000 00:00 0 7fd978000000-7fd978021000 rw-p 00000000 00:00 0 7fd978021000-7fd97c000000 ---p 00000000 00:00 0 7fd97c000000-7fd97c021000 rw-p 00000000 00:00 0 7fd97c021000-7fd980000000 ---p 00000000 00:00 0 7fd980000000-7fd980021000 rw-p 00000000 00:00 0 7fd980021000-7fd984000000 ---p 00000000 00:00 0 7fd984000000-7fd984038000 rw-p 00000000 00:00 0 7fd984038000-7fd988000000 ---p 00000000 00:00 0 7fd988000000-7fd98a13b000 rw-p 00000000 00:00 0 7fd98a13b000-7fd98c000000 ---p 00000000 00:00 0 7fd98c00a000-7fd98c093000 rw-p 00000000 00:00 0 7fd98c09c000-7fd98c0c2000 rw-p 00000000 00:00 0 7fd98c0c6000-7fd98c10e000 rw-p 00000000 00:00 0 7fd98c11f000-7fd98c144000 rw-p 00000000 00:00 0 7fd98c152000-7fd98c222000 rw-p 00000000 00:00 0 7fd98c23b000-7fd98c318000 rw-p 00000000 00:00 0 7fd98c31a000-7fd98c3f5000 rw-p 00000000 00:00 0 7fd98c404000-7fd98c4f0000 rw-p 00000000 00:00 0 7fd98c4f8000-7fd98c54b000 rw-p 00000000 00:00 0 7fd98c54d000-7fd98c5f6000 rw-p 00000000 00:00 0 7fd98c607000-7fd98c677000 rw-p 00000000 00:00 0 7fd98c67f000-7fd98c7f9000 rw-p 00000000 00:00 0 7fd98c7f9000-7fd98c7fa000 ---p 00000000 00:00 0 7fd98c7fa000-7fd98cffa000 rw-p 00000000 00:00 0 7fd98cffa000-7fd98cffb000 ---p 00000000 00:00 0 7fd98cffb000-7fd98d7fb000 rw-p 00000000 00:00 0 7fd98d7fb000-7fd98d7fc000 ---p 00000000 00:00 0 7fd98d7fc000-7fd98dffc000 rw-p 00000000 00:00 0 7fd98dffc000-7fd98dffd000 ---p 00000000 00:00 0 7fd98dffd000-7fd98e7fd000 rw-p 00000000 00:00 0 7fd98e7fd000-7fd98e7fe000 ---p 00000000 00:00 0 7fd98e7fe000-7fd98effe000 rw-p 00000000 00:00 0 7fd98effe000-7fd98efff000 ---p 00000000 00:00 0 7fd98efff000-7fd98f7ff000 rw-p 00000000 00:00 0 7fd98f7ff000-7fd98f800000 ---p 00000000 00:00 0 7fd98f800000-7fd990000000 rw-p 00000000 00:00 0 7fd990000000-7fd99002e000 rw-p 00000000 00:00 0 7fd99002e000-7fd994000000 ---p 00000000 00:00 0 7fd994000000-7fd994021000 rw-p 00000000 00:00 0 7fd994021000-7fd998000000 ---p 00000000 00:00 0 7fd998000000-7fd998029000 rw-p 00000000 00:00 0 7fd998029000-7fd99c000000 ---p 00000000 00:00 0 7fd99c000000-7fd99c04c000 rw-p 00000000 00:00 0 7fd99c050000-7fd99c099000 rw-p 00000000 00:00 0 7fd99c0a6000-7fd99c181000 rw-p 00000000 00:00 0 7fd99c192000-7fd99c20c000 rw-p 00000000 00:00 0 7fd99c21a000-7fd99c31e000 rw-p 00000000 00:00 0 7fd99c32c000-7fd99c374000 rw-p 00000000 00:00 0 7fd99c375000-7fd99c456000 rw-p 00000000 00:00 0
    7fd99c456000-7fd99c46d000 r-xp 00000000 fc:00 7742096 /lib/x86_64-linux-gnu/libresolv-2.23.so
    7fd99c46d000-7fd99c66d000 ---p 00017000 fc:00 7742096 /lib/x86_64-linux-gnu/libresolv-2.23.so
    7fd99c66d000-7fd99c66e000 r--p 00017000 fc:00 7742096 /lib/x86_64-linux-gnu/libresolv-2.23.so
    7fd99c66e000-7fd99c66f000 rw-p 00018000 fc:00 7742096 /lib/x86_64-linux-gnu/libresolv-2.23.so
    7fd99c66f000-7fd99c671000 rw-p 00000000 00:00 0 7fd99c671000-7fd99c672000 ---p 00000000 00:00 0 7fd99c672000-7fd99ce72000 rw-p 00000000 00:00 0 7fd99ce72000-7fd99ce73000 ---p 00000000 00:00 0 7fd99ce73000-7fd99d673000 rw-p 00000000 00:00 0 7fd99d673000-7fd99d674000 ---p 00000000 00:00 0 7fd99d674000-7fd99de74000 rw-p 00000000 00:00 0 7fd99de74000-7fd99de75000 ---p 00000000 00:00 0 7fd99de75000-7fd99e675000 rw-p 00000000 00:00 0 7fd99e675000-7fd99e676000 ---p 00000000 00:00 0 7fd99e676000-7fd99ee76000 rw-p 00000000 00:00 0 7fd99ee76000-7fd99ee77000 ---p 00000000 00:00 0 7fd99ee77000-7fd99f677000 rw-p 00000000 00:00 0 7fd99f677000-7fd99f678000 ---p 00000000 00:00 0 7fd99f678000-7fd99fe78000 rw-p 00000000 00:00 0 7fd99fe78000-7fd99fe79000 ---p 00000000 00:00 0 7fd99fe79000-7fd9a0679000 rw-p 00000000 00:00 0 7fd9a0679000-7fd9a067a000 ---p 00000000 00:00 0 7fd9a067a000-7fd9a0e7a000 rw-p 00000000 00:00 0 7fd9a0e7a000-7fd9a0e7b000 ---p 00000000 00:00 0 7fd9a0e7b000-7fd9a167b000 rw-p 00000000 00:00 0 7fd9a167b000-7fd9a167c000 ---p 00000000 00:00 0 7fd9a167c000-7fd9a1e7c000 rw-p 00000000 00:00 0 7fd9a1e7c000-7fd9a1e7d000 ---p 00000000 00:00 0 7fd9a1e7d000-7fd9a267d000 rw-p 00000000 00:00 0 7fd9a267d000-7fd9a267e000 ---p 00000000 00:00 0 7fd9a267e000-7fd9a2e7e000 rw-p 00000000 00:00 0 7fd9a2e7e000-7fd9a2e7f000 ---p 00000000 00:00 0 7fd9a2e7f000-7fd9a367f000 rw-p 00000000 00:00 0 7fd9a367f000-7fd9a3680000 ---p 00000000 00:00 0 7fd9a3680000-7fd9a3e80000 rw-p 00000000 00:00 0 7fd9a3e80000-7fd9a8000000 rw-p 00000000 00:00 0 7fd9a8000000-7fd9a80c5000 rw-p 00000000 00:00 0 7fd9a80c5000-7fd9ac000000 ---p 00000000 00:00 0 7fd9ac000000-7fd9ac335000 rw-p 00000000 00:00 0 7fd9ac335000-7fd9b0000000 ---p 00000000 00:00 0 7fd9b0000000-7fd9b0976000 rw-p 00000000 00:00 0 7fd9b0976000-7fd9b4000000 ---p 00000000 00:00 0 7fd9b4000000-7fd9b4278000 rw-p 00000000 00:00 0 7fd9b4278000-7fd9b8000000 ---p 00000000 00:00 0 7fd9b8000000-7fd9b8148000 rw-p 00000000 00:00 0 7fd9b8148000-7fd9bc000000 ---p 00000000 00:00 0 7fd9bc00b000-7fd9bc05b000 rw-p 00000000 00:00 0
    7fd9bc05b000-7fd9bc060000 r-xp 00000000 fc:00 7742102 /lib/x86_64-linux-gnu/libnss_dns-2.23.so
    7fd9bc060000-7fd9bc260000 ---p 00005000 fc:00 7742102 /lib/x86_64-linux-gnu/libnss_dns-2.23.so
    7fd9bc260000-7fd9bc261000 r--p 00005000 fc:00 7742102 /lib/x86_64-linux-gnu/libnss_dns-2.23.so
    7fd9bc261000-7fd9bc262000 rw-p 00006000 fc:00 7742102 /lib/x86_64-linux-gnu/libnss_dns-2.23.so
    7fd9bc262000-7fd9bc467000 rw-p 00000000 00:00 0 7fd9bc478000-7fd9bc540000 rw-p 00000000 00:00 0 7fd9bc546000-7fd9bc58e000 rw-p 00000000 00:00 0 7fd9bc599000-7fd9bc5e5000 rw-p 00000000 00:00 0 7fd9bc5ef000-7fd9bc623000 rw-p 00000000 00:00 0 7fd9bc62e000-7fd9bc667000 rw-p 00000000 00:00 0 7fd9bc667000-7fd9bd667000 rw-p 00000000 00:00 0 7fd9bd667000-7fd9bda68000 rw-p 00000000 00:00 0 7fd9bda68000-7fd9bda69000 ---p 00000000 00:00 0 7fd9bda69000-7fd9be269000 rw-p 00000000 00:00 0 7fd9be269000-7fd9be26a000 ---p 00000000 00:00 0 7fd9be26a000-7fd9bea6a000 rw-p 00000000 00:00 0 7fd9bea6f000-7fd9bea93000 rw-p 00000000 00:00 0 7fd9bea96000-7fd9beaba000 rw-p 00000000 00:00 0 7fd9beabf000-7fd9beb98000 rw-p 00000000 00:00 0 7fd9beba2000-7fd9bece1000 rw-p 00000000 00:00 0 7fd9bece6000-7fd9bed08000 rw-p 00000000 00:00 0 7fd9bed15000-7fd9bed74000 rw-p 00000000 00:00 0 7fd9bed83000-7fd9bede1000 rw-p 00000000 00:00 0 7fd9bede3000-7fd9bee2f000 rw-p 00000000 00:00 0 7fd9bee41000-7fd9befc6000 rw-p 00000000 00:00 0 7fd9befd8000-7fd9bf037000 rw-p 00000000 00:00 0 7fd9bf03f000-7fd9bf191000 rw-p 00000000 00:00 0 7fd9bf198000-7fd9bf20e000 rw-p 00000000 00:00 0 7fd9bf215000-7fd9bf263000 rw-p 00000000 00:00 0 7fd9bf281000-7fd9bf294000 rw-p 00000000 00:00 0 7fd9bf2a7000-7fd9bf2f3000 rw-p 00000000 00:00 0 7fd9bf2f5000-7fd9bf459000 rw-p 00000000 00:00 0 7fd9bf45e000-7fd9bf484000 rw-p 00000000 00:00 0 7fd9bf485000-7fd9bf4be000 rw-p 00000000 00:00 0 7fd9bf4c1000-7fd9bf567000 rw-p 00000000 00:00 0 7fd9bf56a000-7fd9bf5a3000 rw-p 00000000 00:00 0 7fd9bf5ac000-7fd9bf644000 rw-p 00000000 00:00 0 7fd9bf64e000-7fd9bf69a000 rw-p 00000000 00:00 0 7fd9bf6b7000-7fd9bf6fe000 rw-p 00000000 00:00 0 7fd9bf706000-7fd9bf73c000 rw-p 00000000 00:00 0 7fd9bf73e000-7fd9bf7b9000 rw-p 00000000 00:00 0 7fd9bf7ba000-7fd9bf808000 rw-p 00000000 00:00 0 7fd9bf811000-7fd9bf824000 rw-p 00000000 00:00 0 7fd9bf831000-7fd9bf902000 rw-p 00000000 00:00 0 7fd9bf906000-7fd9bf946000 rw-p 00000000 00:00 0 7fd9bf949000-7fd9bf9ea000 rw-p 00000000 00:00 0 7fd9bf9ea000-7fd9bf9eb000 ---p 00000000 00:00 0 7fd9bf9eb000-7fd9bfa34000 rw-p 00000000 00:00 0 7fd9bfa34000-7fd9bfa35000 ---p 00000000 00:00 0 7fd9bfa35000-7fd9bfa7e000 rw-p 00000000 00:00 0 7fd9bfa82000-7fd9bfac2000 rw-p 00000000 00:00 0 7fd9bfac2000-7fd9bfac3000 ---p 00000000 00:00 0 7fd9bfac3000-7fd9bfb0c000 rw-p 00000000 00:00 0 7fd9bfb0c000-7fd9bfb0d000 ---p 00000000 00:00 0 7fd9bfb0d000-7fd9bfb56000 rw-p 00000000 00:00 0 7fd9bfb56000-7fd9bfb57000 ---p 00000000 00:00 0 7fd9bfb57000-7fd9bfba0000 rw-p 00000000 00:00 0 7fd9bfba0000-7fd9bfba1000 ---p 00000000 00:00 0 7fd9bfba1000-7fd9bfbea000 rw-p 00000000 00:00 0 7fd9bfbea000-7fd9bfbeb000 ---p 00000000 00:00 0 7fd9bfbeb000-7fd9bfc34000 rw-p 00000000 00:00 0 7fd9bfc34000-7fd9bfc35000 ---p 00000000 00:00 0 7fd9bfc35000-7fd9bfc7e000 rw-p 00000000 00:00 0 7fd9bfc81000-7fd9bfc9b000 rw-p 00000000 00:00 0 7fd9bfc9e000-7fd9bfcd9000 rw-p 00000000 00:00 0 7fd9bfcdb000-7fd9bfe89000 rw-p 00000000 00:00 0 7fd9bfe8d000-7fd9bfea1000 rw-p 00000000 00:00 0 7fd9bfead000-7fd9bfec0000 rw-p 00000000 00:00 0 7fd9bfeca000-7fd9bfef0000 rw-p 00000000 00:00 0 7fd9bfefc000-7fd9bff68000 rw-p 00000000 00:00 0 7fd9bff72000-7fd9bff85000 rw-p 00000000 00:00 0 7fd9bff8a000-7fd9c00bf000 rw-p 00000000 00:00 0 7fd9c00c7000-7fd9c00da000 rw-p 00000000 00:00 0 7fd9c00dc000-7fd9c011a000 rw-p 00000000 00:00 0 7fd9c0122000-7fd9c015b000 rw-p 00000000 00:00 0 7fd9c0167000-7fd9c022d000 rw-p 00000000 00:00 0 7fd9c022d000-7fd9c022e000 ---p 00000000 00:00 0 7fd9c022e000-7fd9c0378000 rw-p 00000000 00:00 0 7fd9c037f000-7fd9c03ee000 rw-p 00000000 00:00 0 7fd9c03ee000-7fd9c03ef000 ---p 00000000 00:00 0 7fd9c03ef000-7fd9c0438000 rw-p 00000000 00:00 0 7fd9c0448000-7fd9c0475000 rw-p 00000000 00:00 0 7fd9c047f000-7fd9c050d000 rw-p 00000000 00:00 0 7fd9c050e000-7fd9c059c000 rw-p 00000000 00:00 0 7fd9c05a4000-7fd9c05fe000 rw-p 00000000 00:00 0 7fd9c060c000-7fd9c0633000 rw-p 00000000 00:00 0 7fd9c0634000-7fd9c065a000 rw-p 00000000 00:00 0 7fd9c0669000-7fd9c0690000 rw-p 00000000 00:00 0 7fd9c0698000-7fd9c0721000 rw-p 00000000 00:00 0 7fd9c0723000-7fd9c0780000 rw-p 00000000 00:00 0 7fd9c0783000-7fd9c07f2000 rw-p 00000000 00:00 0 7fd9c07f2000-7fd9c07f3000 ---p 00000000 00:00 0 7fd9c07f3000-7fd9c0ff3000 rw-p 00000000 00:00 0 7fd9c0ff3000-7fd9c0ff4000 ---p 00000000 00:00 0 7fd9c0ff4000-7fd9c17f4000 rw-p 00000000 00:00 0 7fd9c17f4000-7fd9c17f5000 ---p 00000000 00:00 0 7fd9c17f5000-7fd9c1ff5000 rw-p 00000000 00:00 0 7fd9c1ff5000-7fd9c1ff6000 ---p 00000000 00:00 0 7fd9c1ff6000-7fd9c27f6000 rw-p 00000000 00:00 0 7fd9c27f6000-7fd9c27f7000 ---p 00000000 00:00 0 7fd9c27f7000-7fd9c2ff7000 rw-p 00000000 00:00 0 7fd9c2ff7000-7fd9c2ff8000 ---p 00000000 00:00 0 7fd9c2ff8000-7fd9c37f8000 rw-p 00000000 00:00 0 7fd9c37f8000-7fd9c37f9000 ---p 00000000 00:00 0 7fd9c37f9000-7fd9c3ff9000 rw-p 00000000 00:00 0 7fd9c3ff9000-7fd9c3ffa000 ---p 00000000 00:00 0 7fd9c3ffa000-7fd9c47fa000 rw-p 00000000 00:00 0 7fd9c47fa000-7fd9c47fb000 ---p 00000000 00:00 0 7fd9c47fb000-7fd9c4ffb000 rw-p 00000000 00:00 0 7fd9c4ffb000-7fd9c4ffc000 ---p 00000000 00:00 0 7fd9c4ffc000-7fd9cc000000 rw-p 00000000 00:00 0 7fd9cc000000-7fd9cc021000 rw-p 00000000 00:00 0 7fd9cc021000-7fd9d0000000 ---p 00000000 00:00 0 7fd9d0002000-7fd9d004d000 rw-p 00000000 00:00 0 7fd9d004f000-7fd9d00a5000 rw-p 00000000 00:00 0 7fd9d00ab000-7fd9d00cd000 rw-p 00000000 00:00 0 7fd9d00de000-7fd9d0162000 rw-p 00000000 00:00 0 7fd9d0166000-7fd9d0177000 rw-p 00000000 00:00 0 7fd9d017e000-7fd9d01a4000 rw-p 00000000 00:00 0 7fd9d01b3000-7fd9d01eb000 rw-p 00000000 00:00 0 7fd9d01ec000-7fd9d022c000 rw-p 00000000 00:00 0
    7fd9d022c000-7fd9d0231000 rw-s 00000000 00:0d 11736615 /[aio] (deleted)
    7fd9d0236000-7fd9d0280000 rw-p 00000000 00:00 0
    7fd9d0280000-7fd9d0285000 rw-s 00000000 00:0d 11736614 /[aio] (deleted)
    7fd9d0285000-7fd9d02ad000 rw-p 00000000 00:00 0 7fd9d02b3000-7fd9d02fb000 rw-p 00000000 00:00 0 7fd9d02fb000-7fd9d030e000 rw-p 00000000 00:00 0 7fd9d0310000-7fd9d0335000 rw-p 00000000 00:00 0 7fd9d0337000-7fd9d03a5000 rw-p 00000000 00:00 0 7fd9d03a5000-7fd9d0403000 rw-p 00000000 00:00 0
    7fd9d0403000-7fd9d0408000 rw-s 00000000 00:0d 11736613 /[aio] (deleted)
    7fd9d0408000-7fd9d048a000 rw-p 00000000 00:00 0 7fd9d048a000-7fd9d048b000 ---p 00000000 00:00 0 7fd9d048b000-7fd9d04d4000 rw-p 00000000 00:00 0 7fd9d04d8000-7fd9d0511000 rw-p 00000000 00:00 0 7fd9d051c000-7fd9d0530000 rw-p 00000000 00:00 0 7fd9d0539000-7fd9d0571000 rw-p 00000000 00:00 0 7fd9d0571000-7fd9d0572000 ---p 00000000 00:00 0 7fd9d0572000-7fd9d0d72000 rw-p 00000000 00:00 0 7fd9d0d72000-7fd9d0d73000 ---p 00000000 00:00 0 7fd9d0d73000-7fd9d2549000 rw-p 00000000 00:00 0
    7fd9d2549000-7fd9d3dff000 r-xp 00000000 fc:00 528147 /usr/lib/x86_64-linux-gnu/libicudata.so.55.1
    7fd9d3dff000-7fd9d3ffe000 ---p 018b6000 fc:00 528147 /usr/lib/x86_64-linux-gnu/libicudata.so.55.1
    7fd9d3ffe000-7fd9d3fff000 r--p 018b5000 fc:00 528147 /usr/lib/x86_64-linux-gnu/libicudata.so.55.1
    7fd9d3fff000-7fd9d4000000 rw-p 018b6000 fc:00 528147 /usr/lib/x86_64-linux-gnu/libicudata.so.55.1
    7fd9d4000000-7fd9d4a80000 rw-p 00000000 00:00 0 7fd9d4a80000-7fd9d8000000 ---p 00000000 00:00 0 7fd9d8002000-7fd9d8800000 rw-p 00000000 00:00 0 7fd9d8803000-7fd9d8816000 rw-p 00000000 00:00 0
    7fd9d8816000-7fd9d881b000 rw-s 00000000 00:0d 11736612 /[aio] (deleted)
    7fd9d881b000-7fd9d8820000 rw-s 00000000 00:0d 11736611 /[aio] (deleted)
    7fd9d8820000-7fd9d8825000 rw-s 00000000 00:0d 11736610 /[aio] (deleted)
    7fd9d882d000-7fd9d8853000 rw-p 00000000 00:00 0 7fd9d885e000-7fd9d887a000 rw-p 00000000 00:00 0
    7fd9d887a000-7fd9d887f000 rw-s 00000000 00:0d 11736609 /[aio] (deleted)
    7fd9d887f000-7fd9d893e000 rw-p 00000000 00:00 0
    7fd9d893e000-7fd9d8954000 r-xp 00000000 fc:00 524547 /usr/lib/mysql/plugin/ha_archive.so
    7fd9d8954000-7fd9d8b54000 ---p 00016000 fc:00 524547 /usr/lib/mysql/plugin/ha_archive.so
    7fd9d8b54000-7fd9d8b55000 r--p 00016000 fc:00 524547 /usr/lib/mysql/plugin/ha_archive.so
    7fd9d8b55000-7fd9d8b56000 rw-p 00017000 fc:00 524547 /usr/lib/mysql/plugin/ha_archive.so
    7fd9d8b56000-7fd9d8b89000 r-xp 00000000 fc:00 537562 /usr/lib/x86_64-linux-gnu/libjemalloc.so.1
    7fd9d8b89000-7fd9d8d89000 ---p 00033000 fc:00 537562 /usr/lib/x86_64-linux-gnu/libjemalloc.so.1
    7fd9d8d89000-7fd9d8d8b000 r--p 00033000 fc:00 537562 /usr/lib/x86_64-linux-gnu/libjemalloc.so.1
    7fd9d8d8b000-7fd9d8d8c000 rw-p 00035000 fc:00 537562 /usr/lib/x86_64-linux-gnu/libjemalloc.so.1
    7fd9d8d8c000-7fd9d8d8d000 rw-p 00000000 00:00 0
    7fd9d8d8d000-7fd9d8f23000 r-xp 00000000 fc:00 524378 /usr/lib/mysql/plugin/ha_tokudb.so
    7fd9d8f23000-7fd9d9123000 ---p 00196000 fc:00 524378 /usr/lib/mysql/plugin/ha_tokudb.so
    7fd9d9123000-7fd9d9125000 r--p 00196000 fc:00 524378 /usr/lib/mysql/plugin/ha_tokudb.so
    7fd9d9125000-7fd9d9128000 rw-p 00198000 fc:00 524378 /usr/lib/mysql/plugin/ha_tokudb.so
    7fd9d9128000-7fd9d9131000 rw-p 00000000 00:00 0
    7fd9d9131000-7fd9d913a000 r-xp 00000000 fc:00 532946 /usr/lib/x86_64-linux-gnu/libltdl.so.7.3.1
    7fd9d913a000-7fd9d9339000 ---p 00009000 fc:00 532946 /usr/lib/x86_64-linux-gnu/libltdl.so.7.3.1
    7fd9d9339000-7fd9d933a000 r--p 00008000 fc:00 532946 /usr/lib/x86_64-linux-gnu/libltdl.so.7.3.1
    7fd9d933a000-7fd9d933b000 rw-p 00009000 fc:00 532946 /usr/lib/x86_64-linux-gnu/libltdl.so.7.3.1
    7fd9d933b000-7fd9d94ba000 r-xp 00000000 fc:00 528151 /usr/lib/x86_64-linux-gnu/libicuuc.so.55.1
    7fd9d94ba000-7fd9d96ba000 ---p 0017f000 fc:00 528151 /usr/lib/x86_64-linux-gnu/libicuuc.so.55.1
    7fd9d96ba000-7fd9d96ca000 r--p 0017f000 fc:00 528151 /usr/lib/x86_64-linux-gnu/libicuuc.so.55.1
    7fd9d96ca000-7fd9d96cb000 rw-p 0018f000 fc:00 528151 /usr/lib/x86_64-linux-gnu/libicuuc.so.55.1
    7fd9d96cb000-7fd9d96cf000 rw-p 00000000 00:00 0
    7fd9d96cf000-7fd9d9730000 r-xp 00000000 fc:00 532948 /usr/lib/x86_64-linux-gnu/libodbc.so.2.0.0
    7fd9d9730000-7fd9d992f000 ---p 00061000 fc:00 532948 /usr/lib/x86_64-linux-gnu/libodbc.so.2.0.0
    7fd9d992f000-7fd9d9930000 r--p 00060000 fc:00 532948 /usr/lib/x86_64-linux-gnu/libodbc.so.2.0.0
    7fd9d9930000-7fd9d9937000 rw-p 00061000 fc:00 532948 /usr/lib/x86_64-linux-gnu/libodbc.so.2.0.0
    7fd9d9937000-7fd9d9938000 rw-p 00000000 00:00 0
    7fd9d9938000-7fd9d9ae9000 r-xp 00000000 fc:00 526415 /usr/lib/x86_64-linux-gnu/libxml2.so.2.9.3
    7fd9d9ae9000-7fd9d9ce8000 ---p 001b1000 fc:00 526415 /usr/lib/x86_64-linux-gnu/libxml2.so.2.9.3
    7fd9d9ce8000-7fd9d9cf0000 r--p 001b0000 fc:00 526415 /usr/lib/x86_64-linux-gnu/libxml2.so.2.9.3
    7fd9d9cf0000-7fd9d9cf2000 rw-p 001b8000 fc:00 526415 /usr/lib/x86_64-linux-gnu/libxml2.so.2.9.3
    7fd9d9cf2000-7fd9d9cf3000 rw-p 00000000 00:00 0
    7fd9d9cf3000-7fd9d9e72000 r-xp 00000000 fc:00 524446 /usr/lib/mysql/plugin/ha_connect.so
    7fd9d9e72000-7fd9da071000 ---p 0017f000 fc:00 524446 /usr/lib/mysql/plugin/ha_connect.so
    7fd9da071000-7fd9da083000 r--p 0017e000 fc:00 524446 /usr/lib/mysql/plugin/ha_connect.so
    7fd9da083000-7fd9da085000 rw-p 00190000 fc:00 524446 /usr/lib/mysql/plugin/ha_connect.so
    7fd9da085000-7fd9db088000 rw-p 00000000 00:00 0 7fd9db088000-7fd9db089000 ---p 00000000 00:00 0 7fd9db089000-7fd9df885000 rw-p 00000000 00:00 0
    7fd9df885000-7fd9df890000 r-xp 00000000 fc:00 7742105 /lib/x86_64-linux-gnu/libnss_files-2.23.so
    7fd9df890000-7fd9dfa8f000 ---p 0000b000 fc:00 7742105 /lib/x86_64-linux-gnu/libnss_files-2.23.so
    7fd9dfa8f000-7fd9dfa90000 r--p 0000a000 fc:00 7742105 /lib/x86_64-linux-gnu/libnss_files-2.23.so
    7fd9dfa90000-7fd9dfa91000 rw-p 0000b000 fc:00 7742105 /lib/x86_64-linux-gnu/libnss_files-2.23.so
    7fd9dfa91000-7fd9dfa97000 rw-p 00000000 00:00 0
    7fd9dfa97000-7fd9dfaa2000 r-xp 00000000 fc:00 7742109 /lib/x86_64-linux-gnu/libnss_nis-2.23.so
    7fd9dfaa2000-7fd9dfca1000 ---p 0000b000 fc:00 7742109 /lib/x86_64-linux-gnu/libnss_nis-2.23.so
    7fd9dfca1000-7fd9dfca2000 r--p 0000a000 fc:00 7742109 /lib/x86_64-linux-gnu/libnss_nis-2.23.so
    7fd9dfca2000-7fd9dfca3000 rw-p 0000b000 fc:00 7742109 /lib/x86_64-linux-gnu/libnss_nis-2.23.so
    7fd9dfca3000-7fd9dfcb9000 r-xp 00000000 fc:00 7742089 /lib/x86_64-linux-gnu/libnsl-2.23.so
    7fd9dfcb9000-7fd9dfeb8000 ---p 00016000 fc:00 7742089 /lib/x86_64-linux-gnu/libnsl-2.23.so
    7fd9dfeb8000-7fd9dfeb9000 r--p 00015000 fc:00 7742089 /lib/x86_64-linux-gnu/libnsl-2.23.so
    7fd9dfeb9000-7fd9dfeba000 rw-p 00016000 fc:00 7742089 /lib/x86_64-linux-gnu/libnsl-2.23.so
    7fd9dfeba000-7fd9dfebc000 rw-p 00000000 00:00 0
    7fd9dfebc000-7fd9dfec4000 r-xp 00000000 fc:00 7742100 /lib/x86_64-linux-gnu/libnss_compat-2.23.so
    7fd9dfec4000-7fd9e00c3000 ---p 00008000 fc:00 7742100 /lib/x86_64-linux-gnu/libnss_compat-2.23.so
    7fd9e00c3000-7fd9e00c4000 r--p 00007000 fc:00 7742100 /lib/x86_64-linux-gnu/libnss_compat-2.23.so
    7fd9e00c4000-7fd9e00c5000 rw-p 00008000 fc:00 7742100 /lib/x86_64-linux-gnu/libnss_compat-2.23.so
    7fd9e00c5000-7fd9e00d7000 r-xp 00000000 fc:00 7733787 /lib/x86_64-linux-gnu/libgpg-error.so.0.17.0
    7fd9e00d7000-7fd9e02d7000 ---p 00012000 fc:00 7733787 /lib/x86_64-linux-gnu/libgpg-error.so.0.17.0
    7fd9e02d7000-7fd9e02d8000 r--p 00012000 fc:00 7733787 /lib/x86_64-linux-gnu/libgpg-error.so.0.17.0
    7fd9e02d8000-7fd9e02d9000 rw-p 00013000 fc:00 7733787 /lib/x86_64-linux-gnu/libgpg-error.so.0.17.0
    7fd9e02d9000-7fd9e0347000 r-xp 00000000 fc:00 7733837 /lib/x86_64-linux-gnu/libpcre.so.3.13.2
    7fd9e0347000-7fd9e0547000 ---p 0006e000 fc:00 7733837 /lib/x86_64-linux-gnu/libpcre.so.3.13.2
    7fd9e0547000-7fd9e0548000 r--p 0006e000 fc:00 7733837 /lib/x86_64-linux-gnu/libpcre.so.3.13.2
    7fd9e0548000-7fd9e0549000 rw-p 0006f000 fc:00 7733837 /lib/x86_64-linux-gnu/libpcre.so.3.13.2
    7fd9e0549000-7fd9e055f000 r-xp 00000000 fc:00 7733783 /lib/x86_64-linux-gnu/libgcc_s.so.1
    7fd9e055f000-7fd9e075e000 ---p 00016000 fc:00 7733783 /lib/x86_64-linux-gnu/libgcc_s.so.1
    7fd9e075e000-7fd9e075f000 rw-p 00015000 fc:00 7733783 /lib/x86_64-linux-gnu/libgcc_s.so.1
    7fd9e075f000-7fd9e0836000 r-xp 00000000 fc:00 7733998 /lib/x86_64-linux-gnu/libgcrypt.so.20.0.5
    7fd9e0836000-7fd9e0a36000 ---p 000d7000 fc:00 7733998 /lib/x86_64-linux-gnu/libgcrypt.so.20.0.5
    7fd9e0a36000-7fd9e0a37000 r--p 000d7000 fc:00 7733998 /lib/x86_64-linux-gnu/libgcrypt.so.20.0.5
    7fd9e0a37000-7fd9e0a3f000 rw-p 000d8000 fc:00 7733998 /lib/x86_64-linux-gnu/libgcrypt.so.20.0.5
    7fd9e0a3f000-7fd9e0a40000 rw-p 00000000 00:00 0
    7fd9e0a40000-7fd9e0a61000 r-xp 00000000 fc:00 7733797 /lib/x86_64-linux-gnu/liblzma.so.5.0.0
    7fd9e0a61000-7fd9e0c60000 ---p 00021000 fc:00 7733797 /lib/x86_64-linux-gnu/liblzma.so.5.0.0
    7fd9e0c60000-7fd9e0c61000 r--p 00020000 fc:00 7733797 /lib/x86_64-linux-gnu/liblzma.so.5.0.0
    7fd9e0c61000-7fd9e0c62000 rw-p 00021000 fc:00 7733797 /lib/x86_64-linux-gnu/liblzma.so.5.0.0
    7fd9e0c62000-7fd9e0c69000 r-xp 00000000 fc:00 7742110 /lib/x86_64-linux-gnu/librt-2.23.so
    7fd9e0c69000-7fd9e0e68000 ---p 00007000 fc:00 7742110 /lib/x86_64-linux-gnu/librt-2.23.so
    7fd9e0e68000-7fd9e0e69000 r--p 00006000 fc:00 7742110 /lib/x86_64-linux-gnu/librt-2.23.so
    7fd9e0e69000-7fd9e0e6a000 rw-p 00007000 fc:00 7742110 /lib/x86_64-linux-gnu/librt-2.23.so
    7fd9e0e6a000-7fd9e0e89000 r-xp 00000000 fc:00 7733854 /lib/x86_64-linux-gnu/libselinux.so.1
    7fd9e0e89000-7fd9e1088000 ---p 0001f000 fc:00 7733854 /lib/x86_64-linux-gnu/libselinux.so.1
    7fd9e1088000-7fd9e1089000 r--p 0001e000 fc:00 7733854 /lib/x86_64-linux-gnu/libselinux.so.1
    7fd9e1089000-7fd9e108a000 rw-p 0001f000 fc:00 7733854 /lib/x86_64-linux-gnu/libselinux.so.1
    7fd9e108a000-7fd9e108c000 rw-p 00000000 00:00 0
    7fd9e108c000-7fd9e124c000 r-xp 00000000 fc:00 7742092 /lib/x86_64-linux-gnu/libc-2.23.so
    7fd9e124c000-7fd9e144c000 ---p 001c0000 fc:00 7742092 /lib/x86_64-linux-gnu/libc-2.23.so
    7fd9e144c000-7fd9e1450000 r--p 001c0000 fc:00 7742092 /lib/x86_64-linux-gnu/libc-2.23.so
    7fd9e1450000-7fd9e1452000 rw-p 001c4000 fc:00 7742092 /lib/x86_64-linux-gnu/libc-2.23.so
    7fd9e1452000-7fd9e1456000 rw-p 00000000 00:00 0
    7fd9e1456000-7fd9e155e000 r-xp 00000000 fc:00 7742087 /lib/x86_64-linux-gnu/libm-2.23.so
    7fd9e155e000-7fd9e175d000 ---p 00108000 fc:00 7742087 /lib/x86_64-linux-gnu/libm-2.23.so
    7fd9e175d000-7fd9e175e000 r--p 00107000 fc:00 7742087 /lib/x86_64-linux-gnu/libm-2.23.so
    7fd9e175e000-7fd9e175f000 rw-p 00108000 fc:00 7742087 /lib/x86_64-linux-gnu/libm-2.23.so
    7fd9e175f000-7fd9e18d1000 r-xp 00000000 fc:00 524539 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.21
    7fd9e18d1000-7fd9e1ad1000 ---p 00172000 fc:00 524539 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.21
    7fd9e1ad1000-7fd9e1adb000 r--p 00172000 fc:00 524539 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.21
    7fd9e1adb000-7fd9e1add000 rw-p 0017c000 fc:00 524539 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.21
    7fd9e1add000-7fd9e1ae1000 rw-p 00000000 00:00 0
    7fd9e1ae1000-7fd9e1af9000 r-xp 00000000 fc:00 7742091 /lib/x86_64-linux-gnu/libpthread-2.23.so
    7fd9e1af9000-7fd9e1cf8000 ---p 00018000 fc:00 7742091 /lib/x86_64-linux-gnu/libpthread-2.23.so
    7fd9e1cf8000-7fd9e1cf9000 r--p 00017000 fc:00 7742091 /lib/x86_64-linux-gnu/libpthread-2.23.so
    7fd9e1cf9000-7fd9e1cfa000 rw-p 00018000 fc:00 7742091 /lib/x86_64-linux-gnu/libpthread-2.23.so
    7fd9e1cfa000-7fd9e1cfe000 rw-p 00000000 00:00 0
    7fd9e1cfe000-7fd9e1d01000 r-xp 00000000 fc:00 7742094 /lib/x86_64-linux-gnu/libdl-2.23.so
    7fd9e1d01000-7fd9e1f00000 ---p 00003000 fc:00 7742094 /lib/x86_64-linux-gnu/libdl-2.23.so
    7fd9e1f00000-7fd9e1f01000 r--p 00002000 fc:00 7742094 /lib/x86_64-linux-gnu/libdl-2.23.so
    7fd9e1f01000-7fd9e1f02000 rw-p 00003000 fc:00 7742094 /lib/x86_64-linux-gnu/libdl-2.23.so
    7fd9e1f02000-7fd9e211c000 r-xp 00000000 fc:00 7733379 /lib/x86_64-linux-gnu/libcrypto.so.1.0.0
    7fd9e211c000-7fd9e231b000 ---p 0021a000 fc:00 7733379 /lib/x86_64-linux-gnu/libcrypto.so.1.0.0
    7fd9e231b000-7fd9e2337000 r--p 00219000 fc:00 7733379 /lib/x86_64-linux-gnu/libcrypto.so.1.0.0
    7fd9e2337000-7fd9e2343000 rw-p 00235000 fc:00 7733379 /lib/x86_64-linux-gnu/libcrypto.so.1.0.0
    7fd9e2343000-7fd9e2346000 rw-p 00000000 00:00 0
    7fd9e2346000-7fd9e23a4000 r-xp 00000000 fc:00 7734073 /lib/x86_64-linux-gnu/libssl.so.1.0.0
    7fd9e23a4000-7fd9e25a4000 ---p 0005e000 fc:00 7734073 /lib/x86_64-linux-gnu/libssl.so.1.0.0
    7fd9e25a4000-7fd9e25a8000 r--p 0005e000 fc:00 7734073 /lib/x86_64-linux-gnu/libssl.so.1.0.0
    7fd9e25a8000-7fd9e25af000 rw-p 00062000 fc:00 7734073 /lib/x86_64-linux-gnu/libssl.so.1.0.0
    7fd9e25af000-7fd9e25b8000 r-xp 00000000 fc:00 7742111 /lib/x86_64-linux-gnu/libcrypt-2.23.so
    7fd9e25b8000-7fd9e27b7000 ---p 00009000 fc:00 7742111 /lib/x86_64-linux-gnu/libcrypt-2.23.so
    7fd9e27b7000-7fd9e27b8000 r--p 00008000 fc:00 7742111 /lib/x86_64-linux-gnu/libcrypt-2.23.so
    7fd9e27b8000-7fd9e27b9000 rw-p 00009000 fc:00 7742111 /lib/x86_64-linux-gnu/libcrypt-2.23.so
    7fd9e27b9000-7fd9e27e7000 rw-p 00000000 00:00 0
    7fd9e27e7000-7fd9e2800000 r-xp 00000000 fc:00 7733734 /lib/x86_64-linux-gnu/libz.so.1.2.8
    7fd9e2800000-7fd9e29ff000 ---p 00019000 fc:00 7733734 /lib/x86_64-linux-gnu/libz.so.1.2.8
    7fd9e29ff000-7fd9e2a00000 r--p 00018000 fc:00 7733734 /lib/x86_64-linux-gnu/libz.so.1.2.8
    7fd9e2a00000-7fd9e2a01000 rw-p 00019000 fc:00 7733734 /lib/x86_64-linux-gnu/libz.so.1.2.8
    7fd9e2a01000-7fd9e2a0b000 r-xp 00000000 fc:00 525545 /usr/lib/x86_64-linux-gnu/libnuma.so.1.0.0
    7fd9e2a0b000-7fd9e2c0a000 ---p 0000a000 fc:00 525545 /usr/lib/x86_64-linux-gnu/libnuma.so.1.0.0
    7fd9e2c0a000-7fd9e2c0b000 r--p 00009000 fc:00 525545 /usr/lib/x86_64-linux-gnu/libnuma.so.1.0.0
    7fd9e2c0b000-7fd9e2c0c000 rw-p 0000a000 fc:00 525545 /usr/lib/x86_64-linux-gnu/libnuma.so.1.0.0
    7fd9e2c0c000-7fd9e2c0d000 r-xp 00000000 fc:00 7737702 /lib/x86_64-linux-gnu/libaio.so.1.0.1
    7fd9e2c0d000-7fd9e2e0c000 ---p 00001000 fc:00 7737702 /lib/x86_64-linux-gnu/libaio.so.1.0.1
    7fd9e2e0c000-7fd9e2e0d000 r--p 00000000 fc:00 7737702 /lib/x86_64-linux-gnu/libaio.so.1.0.1
    7fd9e2e0d000-7fd9e2e0e000 rw-p 00001000 fc:00 7737702 /lib/x86_64-linux-gnu/libaio.so.1.0.1
    7fd9e2e0e000-7fd9e2e25000 r-xp 00000000 fc:00 526646 /usr/lib/x86_64-linux-gnu/liblz4.so.1.7.1
    7fd9e2e25000-7fd9e3024000 ---p 00017000 fc:00 526646 /usr/lib/x86_64-linux-gnu/liblz4.so.1.7.1
    7fd9e3024000-7fd9e3025000 r--p 00016000 fc:00 526646 /usr/lib/x86_64-linux-gnu/liblz4.so.1.7.1
    7fd9e3025000-7fd9e3026000 rw-p 00017000 fc:00 526646 /usr/lib/x86_64-linux-gnu/liblz4.so.1.7.1
    7fd9e3026000-7fd9e304c000 r-xp 00000000 fc:00 7742090 /lib/x86_64-linux-gnu/ld-2.23.so
    7fd9e304c000-7fd9e304e000 rw-s 00000000 00:0d 11736616 /[aio] (deleted)
    7fd9e304e000-7fd9e3053000 rw-s 00000000 00:0d 11736608 /[aio] (deleted)
    7fd9e3053000-7fd9e3058000 rw-s 00000000 00:0d 11736607 /[aio] (deleted)
    7fd9e3058000-7fd9e31bd000 rw-p 00000000 00:00 0
    7fd9e31bd000-7fd9e323d000 r-xp 00000000 fc:00 7733882 /lib/x86_64-linux-gnu/libsystemd.so.0.14.0
    7fd9e323d000-7fd9e3240000 r--p 0007f000 fc:00 7733882 /lib/x86_64-linux-gnu/libsystemd.so.0.14.0
    7fd9e3240000-7fd9e3241000 rw-p 00082000 fc:00 7733882 /lib/x86_64-linux-gnu/libsystemd.so.0.14.0
    7fd9e3241000-7fd9e3245000 rw-p 00000000 00:00 0
    7fd9e3245000-7fd9e324a000 rw-s 00000000 00:0d 11736606 /[aio] (deleted)
    7fd9e324a000-7fd9e324b000 rw-s 00000000 00:0d 11736605 /[aio] (deleted)
    7fd9e324b000-7fd9e324c000 r--p 00025000 fc:00 7742090 /lib/x86_64-linux-gnu/ld-2.23.so
    7fd9e324c000-7fd9e324d000 rw-p 00026000 fc:00 7742090 /lib/x86_64-linux-gnu/ld-2.23.so
    7fd9e324d000-7fd9e324e000 rw-p 00000000 00:00 0
    7ffd26f71000-7ffd26f92000 rw-p 00000000 00:00 0 [stack]
    7ffd26fb6000-7ffd26fb9000 r--p 00000000 00:00 0 [vvar]
    7ffd26fb9000-7ffd26fbb000 r-xp 00000000 00:00 0 [vdso]
    ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall]
    180628 13:04:17 [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.3.7-MariaDB-1:10.3.7+maria~xenial-log
key_buffer_size=16777216
read_buffer_size=2097152
max_used_connections=2
max_threads=65537
thread_count=14
It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4429269571 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7fd9cc000b68
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 = 0x7fd9bfa32c48 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x556804acb03e]
/usr/sbin/mysqld(handle_fatal_signal+0x347)[0x556804577607]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fd9e1af2390]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38)[0x7fd9e10c1428]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7fd9e10c302a]
/lib/x86_64-linux-gnu/libc.so.6(+0x777ea)[0x7fd9e11037ea]
/lib/x86_64-linux-gnu/libc.so.6(+0x8037a)[0x7fd9e110c37a]
/lib/x86_64-linux-gnu/libc.so.6(cfree+0x4c)[0x7fd9e111053c]
/usr/sbin/mysqld(_ZN15Item_func_regex7cleanupEv+0x33)[0x5568045b40c3]
/usr/sbin/mysqld(_ZN11Query_arena10free_itemsEv+0x2d)[0x55680435891d]
/usr/sbin/mysqld(_ZN3THD19cleanup_after_queryEv+0x11b)[0x55680435b36b]
/usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x891)[0x556804313291]
/usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x90a)[0x55680431461a]
/usr/sbin/mysqld(+0x5701b9)[0x5568043961b9]
/usr/sbin/mysqld(+0x571666)[0x556804397666]
/usr/sbin/mysqld(_ZN12Sql_cmd_call7executeEP3THD+0x90)[0x556804397e10]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1407)[0x55680439dfe7]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x21a)[0x5568043a577a]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1c23)[0x5568043a80c3]
/usr/sbin/mysqld(_Z10do_commandP3THD+0x13c)[0x5568043a8b7c]
/usr/sbin/mysqld(_Z11tp_callbackP13TP_connection+0x123)[0x5568044b4da3]
/usr/sbin/mysqld(+0x7265f8)[0x55680454c5f8]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fd9e1ae86ba]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fd9e119341d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7fd9cc012ae0): CALL `PROC_Simulabrechnung`('1.9', '1.8', '1.7', '1.6', '1.5', '2018-06-01', '2018-06-15', 'STANDARD', '12', '%', '225') Connection ID (thread ID): 14
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,split_materialized=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.
Thu Jun 28 13:04:23 2018 PerconaFT recovery starting in env /var/lib/mysql/ Thu Jun 28 13:04:23 2018 PerconaFT recovery scanning backward from 3092443475 Thu Jun 28 13:04:23 2018 PerconaFT recovery bw_end_checkpoint at 3092443274 timestamp 1530183812547474 xid 3092443211 (bw_newer) Thu Jun 28 13:04:23 2018 PerconaFT recovery bw_begin_checkpoint at 3092443211 timestamp 1530183805984367 (bw_between) Thu Jun 28 13:04:23 2018 PerconaFT recovery turning around at begin checkpoint 3092443211 time 6563107 Thu Jun 28 13:04:23 2018 PerconaFT recovery starts scanning forward to 3092443475 from 3092443211 left 264 (fw_between)

Comments

Comment by Holger Rojahn [ 2018-06-28 ]

Procedure Simul_Abrechnung:
BEGIN
SELECT concat(auszahlungen.knr) as knr,
(select kunden.kunde.namelang from kunden.kunde where kunden.kunde.knri = auszahlungen.knr) as Namelang,
(select kunden.kunde.hauptkunde from kunden.kunde where kunden.kunde.knri = auszahlungen.knr) as Hauptkunde,
SUM(abrechnungswertBrutto) AS "Abrechnungswert Brutto ",
round(sum(abrechnungswertBrutto/100*GKV_Grundpreis),2) as "Honorar Brutto",
round(sum(edvdatenschutz1),2) as "Datenschutzpauschale Brutto",
round(sum(abrechnungswertBrutto/100*GKV_Grundpreis)+sum(edvDatenschutz1),2) as "Gesamt Brutto",

min(auszahldatum) as "Erste Auszahlung", max(auszahldatum) as "Letzte Auszahlung" ,
sum(if(auszahlungen.auszahldatum =NULL,0,1)) as "Posteingänge mit Auszahlung ",
AVG(IF(anzahlTage BETWEEN 3 AND 5,GKV_Grundpreis, NULL)) AS gebuehr_3_tage,
sum(IF(anzahlTage BETWEEN 3 AND 5,1, 0)) AS anzahl_3_tage,

round(sum(if(anzahlTage between 3 and 5, (abrechnungswertBrutto/100*GKV_Grundpreis)+edvDatenschutz1,0)),2) as "Honorar Brutto 3 Tage (ECHT)",
round(sum(if(anzahlTage between 3 and 5, (abrechnungswertBrutto/100*simul3tage)+(if (edvDatenschutz1>0,datenschutz,0)),0)),2) as "Honorar Brutto 3 Tage (Simuliert)",
round(sum(if(anzahlTage between 3 and 5, (abrechnungswertBrutto/100*Stammdaten.abrSimul.3tage)+if(Stammdaten.abrSimul.datenschutz>=0,if (edvDatenschutz1>0, Stammdaten.abrSimul.datenschutz,edvDatenschutz), edvDatenschutz1) ,0)),2) as "Honorar Brutto 3 Tage (vorgabe Kunde)",

AVG(IF(anzahlTage between 9 and 12, GKV_Grundpreis, NULL)) as gebuehr_10_tage,
sum(IF(anzahlTage BETWEEN 9 AND 12,1, 0)) AS anzahl_10_tage,
round(sum(if(anzahlTage between 9 and 12, (abrechnungswertBrutto/100*GKV_Grundpreis)+edvDatenschutz1,0)),2) as "Honorar Brutto 10 Tage (ECHT)",
round(sum(if(anzahlTage between 9 and 12, (abrechnungswertBrutto/100*simul10tage)+(if (edvDatenschutz1>0,datenschutz,0)),0)),2) as "Honorar Brutto 10 Tage (Simuliert)",
round(sum(if(anzahlTage between 9 and 12, (abrechnungswertBrutto/100*Stammdaten.abrSimul.10tage)+if(Stammdaten.abrSimul.datenschutz>=0,if (edvDatenschutz1>0, Stammdaten.abrSimul.datenschutz,edvDatenschutz),edvDatenschutz1),0)),2) as "Honorar Brutto 10 Tage (vorgabe Kunde)",

AVG(IF(anzahlTage between 14 and 16, GKV_Grundpreis, NULL)) as gebuehr_15_tage,
sum(IF(anzahlTage BETWEEN 14 AND 16,1, 0)) AS anzahl_15_tage,
round(sum(if(anzahlTage between 14 and 16, (abrechnungswertBrutto/100*GKV_Grundpreis)+edvDatenschutz1,0)),2) as "Honorar Brutto 15 Tage (ECHT)",
round(sum(if(anzahlTage between 14 and 16, (abrechnungswertBrutto/100*simul15tage)+(if (edvDatenschutz1>0,datenschutz,0)),0)),2) as "Honorar Brutto 15 Tage (Simuliert)",
round(sum(if(anzahlTage between 14 and 16, (abrechnungswertBrutto/100*Stammdaten.abrSimul.15tage)+if(Stammdaten.abrSimul.datenschutz>=0,if (edvDatenschutz1>0, Stammdaten.abrSimul.datenschutz,edvDatenschutz),edvDatenschutz1),0)),2) as "Honorar Brutto 15 Tage (vorgabe Kunde)",

AVG(IF(anzahlTage between 19 and 21, GKV_Grundpreis, NULL)) as gebuehr_20_tage,
sum(IF(anzahlTage BETWEEN 19 AND 21,1, 0)) AS anzahl_20_tage,
round(sum(if(anzahlTage between 19 and 21, (abrechnungswertBrutto/100*GKV_Grundpreis)+edvDatenschutz1,0)),2) as "Honorar Brutto 20 Tage (ECHT)",
round(sum(if(anzahlTage between 19 and 21, (abrechnungswertBrutto/100*simul20tage)+(if (edvDatenschutz1>0,datenschutz,0)),0)),2) as "Honorar Brutto 20 Tage (Simuliert)",
round(sum(if(anzahlTage between 19 and 21, (abrechnungswertBrutto/100*Stammdaten.abrSimul.20tage)+if(Stammdaten.abrSimul.datenschutz>=0,if (edvDatenschutz1>0, Stammdaten.abrSimul.datenschutz,edvDatenschutz),edvDatenschutz1),0)),2) as "Honorar Brutto 20 Tage (vorgabe Kunde)",

AVG(IF(anzahlTage >= 24 , GKV_Grundpreis, NULL)) as gebuehr_25_tage,
sum(IF(anzahlTage >=24 ,1, 0)) AS anzahl_25_tage,
round(sum(if(anzahlTage >= 24 , (abrechnungswertBrutto/100*GKV_Grundpreis)+edvDatenschutz1,0)),2) as "Honorar Brutto 25 Tage (ECHT)",
round(sum(if(anzahlTage >= 24 , (abrechnungswertBrutto/100*simul20tage)+(if (edvDatenschutz1>0,datenschutz,0)),0)),2) as "Honorar Brutto 25 Tage (Simuliert)",
round(sum(if(anzahlTage >=24, (abrechnungswertBrutto/100*Stammdaten.abrSimul.25tage)+if(Stammdaten.abrSimul.datenschutz>=0, if (edvDatenschutz1>0, Stammdaten.abrSimul.datenschutz,edvDatenschutz),edvDatenschutz1),0)),2) as "Honorar Brutto 25 Tage (vorgabe Kunde)"

FROM auszahlungen

left JOIN V_Gebuehr_Kunde ON V_Gebuehr_Kunde.pegNr = auszahlungen.pegnr

left join Stammdaten.abrSimul on Stammdaten.abrSimul.konfigName=konfiguration and Stammdaten.abrSimul.knr = auszahlungen.knr
WHERE auszahlungen.auszahldatum between auszahlVon and auszahlBis and berufsgruppe regexp var_berufsgruppe and auszahlungen.knr regexp kunde
group by knr with rollup;

END

Comment by Holger Rojahn [ 2018-06-28 ]

View V_Gebuehr_Kunde (Runs fine with select * from ..)
SELECT `absetzungen`.`honorar`.`VORGANG_ID` AS `VORGANG_ID`,`absetzungen`.`auszahlungen`.`pegnr` AS `pegNr`,`absetzungen`.`auszahlungen`.`knr` AS `knr`,`absetzungen`.`auszahlungen`.`Bgr` AS `berufsgruppe`,`absetzungen`.`auszahlungen`.`auszahldatum` AS `abrechnungsdatum`,`absetzungen`.`auszahlungen`.`eingangsdatum` AS `eingangsdatum`,`absetzungen`.`auszahlungen`.`anlagedatum` AS `anlagedatum`,`absetzungen`.`auszahlungen`.`auszahldatum1` AS `restauszahlung`, SUM(IF(`absetzungen`.`honorarPos`.`FAKTOR_ID` = 11,`absetzungen`.`honorarPos`.`GEBUEHR`,0)) AS `GKV_honorarProRezept`, SUM(IF(`absetzungen`.`honorarPos`.`FAKTOR_ID` = 12,`absetzungen`.`honorarPos`.`GEBUEHR`,0)) AS `PKV_HonorarProRezept`, SUM(IF(`absetzungen`.`honorarPos`.`FAKTOR_ID` = 21,`absetzungen`.`honorarPos`.`GEBUEHR`,0)) AS `GKV_mindestgebuehr`, SUM(IF(`absetzungen`.`honorarPos`.`FAKTOR_ID` = 22,`absetzungen`.`honorarPos`.`GEBUEHR`,0)) AS `PKV_mindestgebuehr`, SUM(IF(`absetzungen`.`honorarPos`.`FAKTOR_ID` = 23,`absetzungen`.`honorarPos`.`GEBUEHR`,0)) AS `ET_mindestgebuehr`,`absetzungen`.`auszahlungen`.`auszahltage` AS `anzahlTage`,`absetzungen`.`auszahlungen`.`auszahltageart` AS `tageArt`, SUM(IF(`absetzungen`.`honorarPos`.`FAKTOR_ID` = 1 AND `absetzungen`.`honorarPosAufteilung`.`ABRECHNUNGSGEBUEHR_ID` IN (1,13),`absetzungen`.`honorarPosAufteilung`.`PROZENTSATZ`,0)) AS `GKV_grundpreis`, SUM(IF(`absetzungen`.`honorarPos`.`FAKTOR_ID` = 4 AND `absetzungen`.`honorarPosAufteilung`.`ABRECHNUNGSGEBUEHR_ID` IN (1,13),`absetzungen`.`honorarPosAufteilung`.`PROZENTSATZ`,0)) AS `PKV_grundpreis`, SUM(IF(`absetzungen`.`honorarPos`.`FAKTOR_ID` = 15 AND `absetzungen`.`honorarPosAufteilung`.`ABRECHNUNGSGEBUEHR_ID` IN (1,13),`absetzungen`.`honorarPosAufteilung`.`PROZENTSATZ`,0)) AS `ET_Grundpreis`, SUM(IF(`INF`.`FAKTOR_HONORARLEISTUNGSART`.`HONORARLEISTUNGSART_ID` = 60,`absetzungen`.`honorarLeistungArt`.`PROZENT`,0)) AS `Arztnummernstatistik`, SUM(IF(`INF`.`FAKTOR_HONORARLEISTUNGSART`.`HONORARLEISTUNGSART_ID` = 59,`absetzungen`.`honorarLeistungArt`.`PROZENT`,0)) AS `Mitarbeiterstatistik`,`absetzungen`.`honorar`.`GESAMTBETRAGBRUTTO` AS `gesamtbetragBrutto`,`absetzungen`.`honorar`.`GESAMTBETRAGZUZAHLUNG` AS `gesamtbetragZuzahlung`,`absetzungen`.`honorar`.`GESAMTBETRAGNETTO` AS `gesamtbetragNetto`,`absetzungen`.`honorar`.`BELEGANZAHLVOMBELEGWERTREAL` AS `belegAnzahl`, IF(`absetzungen`.`auszahlungen`.`besonderheit` = 'interne Neuabrechnung',1,0) AS `kostenlos`,`absetzungen`.`honorar`.`EDVDATENPAUSCHALE` AS `edvDatenschutz1`,`absetzungen`.`honorar`.`MWST` AS `mwst`,`absetzungen`.`honorar`.`GESAMTBETRAGVERMINDERT` AS `gesamtbetragVermindert`,`absetzungen`.`honorar`.`HONORARSUMME_NETTO` AS `honorarNetto`,`absetzungen`.`honorar`.`VO_GEBUEHR` AS `voGebuehr`
FROM (((((((`absetzungen`.`auszahlungen`
LEFT JOIN `absetzungen`.`honorar` ON(`absetzungen`.`honorar`.`VORGANG_ID` = `absetzungen`.`auszahlungen`.`pegnr`))
LEFT JOIN `absetzungen`.`honorarPos` ON(`absetzungen`.`honorarPos`.`HONORAR_ID` = `absetzungen`.`honorar`.`HONORAR_ID`))
LEFT JOIN `INF`.`FAKTOR` ON(`INF`.`FAKTOR`.`FAKTOR_ID` = `absetzungen`.`honorarPos`.`FAKTOR_ID`))
LEFT JOIN `absetzungen`.`honorarPosAufteilung` ON(`absetzungen`.`honorarPosAufteilung`.`POS_ID` = `absetzungen`.`honorarPos`.`POS_ID`))
LEFT JOIN `absetzungen`.`honorarZusatzleistung` ON(`absetzungen`.`honorarZusatzleistung`.`HONORAR_ID` = `absetzungen`.`honorar`.`HONORAR_ID`))
LEFT JOIN `absetzungen`.`honorarLeistungArt` ON(`absetzungen`.`honorarLeistungArt`.`HONORARLEISTUNG_ID` = `absetzungen`.`honorarZusatzleistung`.`HONORARLEISTUNG_ID`))
LEFT JOIN `INF`.`FAKTOR_HONORARLEISTUNGSART` ON(`INF`.`FAKTOR_HONORARLEISTUNGSART`.`HONORARLEISTUNGSART_ID` = `absetzungen`.`honorarLeistungArt`.`HONORARLEISTUNGSART_ID`))
WHERE `absetzungen`.`auszahlungen`.`pegnr` IS NOT NULL
GROUP BY `absetzungen`.`auszahlungen`.`pegnr`

Comment by Holger Rojahn [ 2018-06-28 ]

Info:
Write the View Data into a Table (create table test as select * from V_Gebuehr_Kunde) and join this Table in the Procedure works fine.

Puttin the View's select as subquery into the join wont work..

Perhaps something with the Join Optimizer ?!

Comment by Alice Sherepa [ 2018-06-29 ]

Could you please check, if the problem, that is reported here will persist after fix of ~~MDEV-16614~~.
If the server will still crash, then I will need definitions of all tables, that are involved, to reproduce it.

Comment by Holger Rojahn [ 2018-06-29 ]

Hi,
i will check this out.
Removing Regex and replace it with a like wont crash.
Waiting for Fix for ~~MDEV-16614~~.

Comment by Alice Sherepa [ 2018-09-04 ]

Hi h.rojahn, have you been able to try 10.3.9 ?

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

[MDEV-16611] Crash on Stored Procedure calling View in Join Created: 2018-06-28 Updated: 2018-10-01 Resolved: 2018-10-01