Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.2.8, 10.2.9, 10.3.1, 10.3.2, 10.3.3, 10.3.4, 10.3.5, 10.2(EOL), 10.3(EOL)
-
None
-
CentOS 7.3
Description
I have a server I upgraded from 5.5.34 to 10.2.8 that had been stable for a couple weeks. Someone ran a month end query and the server crashed with the following message in the error log:
*** Error in `/usr/sbin/mysqld': double free or corruption (!prev): 0x00007f355c2d6c50 ***
|
======= Backtrace: =========
|
/lib64/libc.so.6(+0x7c503)[0x7f408eb51503]
|
/usr/sbin/mysqld(_ZN14Item_subselect7cleanupEv+0x7e)[0x7f40910bffbe]
|
/usr/sbin/mysqld(_ZN11Query_arena10free_itemsEv+0x30)[0x7f4090e59030]
|
/usr/sbin/mysqld(_ZN3THD19cleanup_after_queryEv+0x5c)[0x7f4090e5b94c]
|
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x237)[0x7f4090e91007]
|
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x203d)[0x7f4090e9405d]
|
/usr/sbin/mysqld(_Z10do_commandP3THD+0x149)[0x7f4090e94c69]
|
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1aa)[0x7f4090f585da]
|
/usr/sbin/mysqld(handle_one_connection+0x3d)[0x7f4090f586fd]
|
/lib64/libpthread.so.0(+0x7dc5)[0x7f4090579dc5]
|
/lib64/libc.so.6(clone+0x6d)[0x7f408ebcc76d]
|
======= Memory map: ========
|
7f3540000000-7f3550000000 rw-p 00000000 00:00 0
|
7f355c000000-7f355c6e4000 rw-p 00000000 00:00 0
|
7f355c6e4000-7f3560000000 ---p 00000000 00:00 0
|
7f3560000000-7f35606da000 rw-p 00000000 00:00 0
|
7f35606da000-7f3564000000 ---p 00000000 00:00 0
|
7f3564000000-7f3564430000 rw-p 00000000 00:00 0
|
7f3564430000-7f3568000000 ---p 00000000 00:00 0
|
7f3568000000-7f356861f000 rw-p 00000000 00:00 0
|
7f356861f000-7f356c000000 ---p 00000000 00:00 0
|
7f356c000000-7f356c021000 rw-p 00000000 00:00 0
|
7f356c021000-7f3570000000 ---p 00000000 00:00 0
|
7f3570000000-7f3570021000 rw-p 00000000 00:00 0
|
7f3570021000-7f3574000000 ---p 00000000 00:00 0
|
7f3574000000-7f3574023000 rw-p 00000000 00:00 0
|
7f3574023000-7f3578000000 ---p 00000000 00:00 0
|
7f3578000000-7f3578021000 rw-p 00000000 00:00 0
|
7f3578021000-7f357c000000 ---p 00000000 00:00 0
|
7f357c000000-7f357c021000 rw-p 00000000 00:00 0
|
7f357c021000-7f3580000000 ---p 00000000 00:00 0
|
7f3580000000-7f3580022000 rw-p 00000000 00:00 0
|
7f3580022000-7f3584000000 ---p 00000000 00:00 0
|
7f3584000000-7f3584420000 rw-p 00000000 00:00 0
|
7f3584420000-7f3588000000 ---p 00000000 00:00 0
|
7f3588000000-7f3588021000 rw-p 00000000 00:00 0
|
7f3588021000-7f358c000000 ---p 00000000 00:00 0
|
7f358c000000-7f358fc37000 rw-p 00000000 00:00 0
|
7f358fc37000-7f3590000000 ---p 00000000 00:00 0
|
7f3590000000-7f3590420000 rw-p 00000000 00:00 0
|
7f3590420000-7f3594000000 ---p 00000000 00:00 0
|
7f3594000000-7f3594021000 rw-p 00000000 00:00 0
|
7f3594021000-7f3598000000 ---p 00000000 00:00 0
|
7f3598000000-7f3598038000 rw-p 00000000 00:00 0
|
7f3598038000-7f359c000000 ---p 00000000 00:00 0
|
7f359c000000-7f359c021000 rw-p 00000000 00:00 0
|
7f359c021000-7f35a0000000 ---p 00000000 00:00 0
|
7f35a0000000-7f35a0021000 rw-p 00000000 00:00 0
|
7f35a0021000-7f35a4000000 ---p 00000000 00:00 0
|
7f35a4000000-7f35a4021000 rw-p 00000000 00:00 0
|
7f35a4021000-7f35a8000000 ---p 00000000 00:00 0
|
7f35a8000000-7f35a8021000 rw-p 00000000 00:00 0
|
7f35a8021000-7f35ac000000 ---p 00000000 00:00 0
|
7f35ac000000-7f35ac401000 rw-p 00000000 00:00 0
|
7f35ac401000-7f35b0000000 ---p 00000000 00:00 0
|
7f35b0000000-7f35b0021000 rw-p 00000000 00:00 0
|
7f35b0021000-7f35b4000000 ---p 00000000 00:00 0
|
7f35b4000000-7f35b4ccd000 rw-p 00000000 00:00 0
|
7f35b4ccd000-7f35b8000000 ---p 00000000 00:00 0
|
7f35bafa2000-7f35c4000000 rw-p 00000000 00:00 0
|
7f35c4000000-7f35c4021000 rw-p 00000000 00:00 0
|
7f35c4021000-7f35c8000000 ---p 00000000 00:00 0
|
7f35c8000000-7f35c8021000 rw-p 00000000 00:00 0
|
7f35c8021000-7f35cc000000 ---p 00000000 00:00 0
|
7f35cc000000-7f35cc021000 rw-p 00000000 00:00 0
|
7f35cc021000-7f35d0000000 ---p 00000000 00:00 0
|
7f35d0000000-7f35d0021000 rw-p 00000000 00:00 0
|
7f35d0021000-7f35d4000000 ---p 00000000 00:00 0
|
7f35d77ff000-7f35d7800000 ---p 00000000 00:00 0
|
7f35d7800000-7f35d8000000 rw-p 00000000 00:00 0 [stack:4286]
|
7f35d8000000-7f35d8021000 rw-p 00000000 00:00 0
|
7f35d8021000-7f35dc000000 ---p 00000000 00:00 0
|
7f35dc3d5000-7f35dc3d6000 ---p 00000000 00:00 0
|
7f35dc3d6000-7f35dcbd6000 rw-p 00000000 00:00 0 [stack:4285]
|
7f35dcbd6000-7f35dcbd7000 ---p 00000000 00:00 0
|
7f35dcbd7000-7f35dd3d7000 rw-p 00000000 00:00 0 [stack:4284]
|
7f35dd3d7000-7f35dd3d8000 ---p 00000000 00:00 0
|
7f35dd3d8000-7f35ddbd8000 rw-p 00000000 00:00 0 [stack:4283]
|
7f35ddbd8000-7f35ddbd9000 ---p 00000000 00:00 0
|
7f35ddbd9000-7f35de3d9000 rw-p 00000000 00:00 0 [stack:4282]
|
7f35de3d9000-7f35de3da000 ---p 00000000 00:00 0
|
7f35de3da000-7f35debda000 rw-p 00000000 00:00 0 [stack:4281]
|
7f35debda000-7f35debdb000 ---p 00000000 00:00 0
|
7f35debdb000-7f35df3db000 rw-p 00000000 00:00 0 [stack:4280]
|
7f35df3db000-7f35df3dc000 ---p 00000000 00:00 0
|
7f35df3dc000-7f35dfbdc000 rw-p 00000000 00:00 0 [stack:4279]
|
7f35dfbdc000-7f35dfbdd000 ---p 00000000 00:00 0
|
7f35dfbdd000-7f35e03dd000 rw-p 00000000 00:00 0 [stack:4278]
|
7f35e03dd000-7f35e03de000 ---p 00000000 00:00 0
|
7f35e03de000-7f35e0bde000 rw-p 00000000 00:00 0 [stack:4277]
|
7f35e0bde000-7f35e0bdf000 ---p 00000000 00:00 0
|
7f35e0bdf000-7f35e13df000 rw-p 00000000 00:00 0 [stack:4276]
|
7f35e13df000-7f35e13e0000 ---p 00000000 00:00 0
|
7f35e13e0000-7f35e1be0000 rw-p 00000000 00:00 0 [stack:4275]
|
7f35e1be0000-7f35e1be1000 ---p 00000000 00:00 0
|
7f35e1be1000-7f35e23e1000 rw-p 00000000 00:00 0 [stack:4274]
|
7f35e23e1000-7f35e23e2000 ---p 00000000 00:00 0
|
7f35e23e2000-7f35f1f12000 rw-p 00000000 00:00 0 [stack:4273]
|
7f35f4000000-7f35f4021000 rw-p 00000000 00:00 0
|
7f35f4021000-7f35f8000000 ---p 00000000 00:00 0
|
7f35f8000000-7f35f8ccf000 rw-p 00000000 00:00 0
|
7f35f8ccf000-7f35fc000000 ---p 00000000 00:00 0
|
7f35fc000000-7f35fccca000 rw-p 00000000 00:00 0
|
7f35fccca000-7f3600000000 ---p 00000000 00:00 0
|
7f3604000000-7f3605371000 rw-p 00000000 00:00 0
|
7f3605371000-7f3608000000 ---p 00000000 00:00 0
|
7f360ab51000-7f360ab52000 ---p 00000000 00:00 0
|
7f360ab52000-7f360ab9b000 rw-p 00000000 00:00 0 [stack:55091]
|
7f360ab9b000-7f360ab9c000 ---p 00000000 00:00 0
|
7f360ab9c000-7f360abe5000 rw-p 00000000 00:00 0 [stack:55082]
|
7f360abe5000-7f360abea000 r-xp 00000000 08:03 1573466 /usr/lib64/libnss_dns-2.17.so
|
7f360abea000-7f360ade9000 ---p 00005000 08:03 1573466 /usr/lib64/libnss_dns-2.17.so
|
7f360ade9000-7f360adea000 r--p 00004000 08:03 1573466 /usr/lib64/libnss_dns-2.17.so
|
7f360adea000-7f360adeb000 rw-p 00005000 08:03 1573466 /usr/lib64/libnss_dns-2.17.so
|
7f360adeb000-7f360adf7000 r-xp 00000000 08:03 1573468 /usr/lib64/libnss_files-2.17.so
|
7f360adf7000-7f360aff6000 ---p 0000c000 08:03 1573468 /usr/lib64/libnss_files-2.17.so
|
7f360aff6000-7f360aff7000 r--p 0000b000 08:03 1573468 /usr/lib64/libnss_files-2.17.so
|
7f360aff7000-7f360aff8000 rw-p 0000c000 08:03 1573468 /usr/lib64/libnss_files-2.17.so
|
7f360aff8000-7f360affe000 rw-p 00000000 00:00 0
|
7f360affe000-7f360afff000 ---p 00000000 00:00 0
|
7f360afff000-7f360b7ff000 rw-p 00000000 00:00 0 [stack:4493]
|
7f360b7ff000-7f360b800000 ---p 00000000 00:00 0
|
7f360b800000-7f360c000000 rw-p 00000000 00:00 0 [stack:4492]
|
7f360c000000-7f360c021000 rw-p 00000000 00:00 0
|
7f360c021000-7f3610000000 ---p 00000000 00:00 0
|
7f3610030000-7f3610031000 ---p 00000000 00:00 0
|
7f3610031000-7f361007a000 rw-p 00000000 00:00 0 [stack:51469]
|
7f361007a000-7f361007b000 ---p 00000000 00:00 0
|
7f361007b000-7f361087b000 rw-p 00000000 00:00 0 [stack:4491]
|
7f361087b000-7f361087c000 ---p 00000000 00:00 0
|
7f361087c000-7f361107c000 rw-p 00000000 00:00 0 [stack:4490]
|
7f361107c000-7f361107d000 ---p 00000000 00:00 0
|
7f361107d000-7f361187d000 rw-p 00000000 00:00 0 [stack:4489]
|
7f361187d000-7f361187e000 ---p 00000000 00:00 0
|
7f361187e000-7f361207e000 rw-p 00000000 00:00 0 [stack:4488]
|
7f361207e000-7f361207f000 ---p 00000000 00:00 0
|
7f361207f000-7f361287f000 rw-p 00000000 00:00 0 [stack:4487]
|
7f361287f000-7f3612880000 ---p 00000000 00:00 0
|
7f3612880000-7f3613080000 rw-p 00000000 00:00 0 [stack:4486]
|
7f3613080000-7f3613081000 ---p 00000000 00:00 0
|
7f3613081000-7f3613881000 rw-p 00000000 00:00 0 [stack:4485]
|
7f3613881000-7f3613882000 ---p 00000000 00:00 0
|
7f3613882000-7f3614082000 rw-p 00000000 00:00 0 [stack:4484]
|
7f3614082000-7f3614083000 ---p 00000000 00:00 0
|
7f3614083000-7f3614883000 rw-p 00000000 00:00 0 [stack:4482]
|
7f3614883000-7f3614884000 ---p 00000000 00:00 0
|
7f3614884000-7f3615084000 rw-p 00000000 00:00 0 [stack:4481]
|
7f3615084000-7f3615085000 ---p 00000000 00:00 0
|
7f3615085000-7f3615885000 rw-p 00000000 00:00 0 [stack:4480]
|
7f3615885000-7f3615886000 ---p 00000000 00:00 0
|
7f3615886000-7f3e70000000 rw-p 00000000 00:00 0 [stack:4483]
|
7f3e70000000-7f3e70021000 rw-p 00000000 00:00 0
|
7f3e70021000-7f3e74000000 ---p 00000000 00:00 0
|
7f3e74033000-7f3e74034000 ---p 00000000 00:00 0
|
7f3e74034000-7f3e7407d000 rw-p 00000000 00:00 0 [stack:51470]
|
7f3e7407d000-7f3e7407e000 ---p 00000000 00:00 0
|
7f3e7407e000-7f3e740c7000 rw-p 00000000 00:00 0 [stack:4831]
|
7f3e740c7000-7f3e740c8000 ---p 00000000 00:00 0
|
7f3e740c8000-7f407c000000 rw-p 00000000 00:00 0 [stack:4550]
|
7f407c000000-7f407c021000 rw-p 00000000 00:00 0
|
7f407c021000-7f4080000000 ---p 00000000 00:00 0
|
7f408002e000-7f408002f000 ---p 00000000 00:00 0
|
7f408002f000-7f4080078000 rw-p 00000000 00:00 0 [stack:4502]
|
7f4080078000-7f4080079000 ---p 00000000 00:00 0
|
7f4080079000-7f408201e000 rw-p 00000000 00:00 0 [stack:4501]
|
7f408201e000-7f408201f000 ---p 00000000 00:00 0
|
7f408201f000-7f4082f54000 rw-p 00000000 00:00 0 [stack:4216]
|
7f4082f54000-7f4082f56000 r-xp 00000000 08:03 1578123 /usr/lib64/mysql/plugin/sql_errlog.so
|
7f4082f56000-7f4083155000 ---p 00002000 08:03 1578123 /usr/lib64/mysql/plugin/sql_errlog.so
|
7f4083155000-7f4083156000 r--p 00001000 08:03 1578123 /usr/lib64/mysql/plugin/sql_errlog.so
|
7f4083156000-7f4083157000 rw-p 00002000 08:03 1578123 /usr/lib64/mysql/plugin/sql_errlog.so
|
7f4083157000-7f408315b000 r-xp 00000000 08:03 1573939 /usr/lib64/libcap-ng.so.0.0.0
|
7f408315b000-7f408335b000 ---p 00004000 08:03 1573939 /usr/lib64/libcap-ng.so.0.0.0
|
7f408335b000-7f408335c000 r--p 00004000 08:03 1573939 /usr/lib64/libcap-ng.so.0.0.0
|
7f408335c000-7f408335d000 rw-p 00005000 08:03 1573939 /usr/lib64/libcap-ng.so.0.0.0
|
7f408335d000-7f4083379000 r-xp 00000000 08:03 1573728 /usr/lib64/libaudit.so.1.0.0
|
7f4083379000-7f4083579000 ---p 0001c000 08:03 1573728 /usr/lib64/libaudit.so.1.0.0
|
7f4083579000-7f408357a000 r--p 0001c000 08:03 1573728 /usr/lib64/libaudit.so.1.0.0
|
7f408357a000-7f408357b000 rw-p 0001d000 08:03 1573728 /usr/lib64/libaudit.so.1.0.0
|
7f408357b000-7f4083585000 rw-p 00000000 00:00 0
|
7f4083585000-7f4083592000 r-xp 00000000 08:03 1575772 /usr/lib64/libpam.so.0.83.1
|
7f4083592000-7f4083792000 ---p 0000d000 08:03 1575772 /usr/lib64/libpam.so.0.83.1
|
7f4083792000-7f4083793000 r--p 0000d000 08:03 1575772 /usr/lib64/libpam.so.0.83.1
|
7f4083793000-7f4083794000 rw-p 0000e000 08:03 1575772 /usr/lib64/libpam.so.0.83.1
|
7f4083794000-7f4083796000 r-xp 00000000 08:03 1578104 /usr/lib64/mysql/plugin/auth_pam.so
|
7f4083796000-7f4083995000 ---p 00002000 08:03 1578104 /usr/lib64/mysql/plugin/auth_pam.so
|
7f4083995000-7f4083996000 r--p 00001000 08:03 1578104 /usr/lib64/mysql/plugin/auth_pam.so
|
7f4083996000-7f4083997000 rw-p 00002000 08:03 1578104 /usr/lib64/mysql/plugin/auth_pam.so
|
7f4083997000-7f4083998000 ---p 00000000 00:00 0
|
7f4083998000-7f408c194000 rw-p 00000000 00:00 0 [stack:3662]
|
7f408c194000-7f408c197000 r-xp 00000000 08:03 1573818 /usr/lib64/libkeyutils.so.1.5
|
7f408c197000-7f408c396000 ---p 00003000 08:03 1573818 /usr/lib64/libkeyutils.so.1.5
|
7f408c396000-7f408c397000 r--p 00002000 08:03 1573818 /usr/lib64/libkeyutils.so.1.5
|
7f408c397000-7f408c398000 rw-p 00003000 08:03 1573818 /usr/lib64/libkeyutils.so.1.5
|
7f408c398000-7f408c3a5000 r-xp 00000000 08:03 1579319 /usr/lib64/libkrb5support.so.0.1
|
7f408c3a5000-7f408c5a5000 ---p 0000d000 08:03 1579319 /usr/lib64/libkrb5support.so.0.1
|
7f408c5a5000-7f408c5a6000 r--p 0000d000 08:03 1579319 /usr/lib64/libkrb5support.so.0.1
|
7f408c5a6000-7f408c5a7000 rw-p 0000e000 08:03 1579319 /usr/lib64/libkrb5support.so.0.1
|
7f408c5a7000-7f408c5b6000 r-xp 00000000 08:03 1573733 /usr/lib64/libbz2.so.1.0.6
|
7f408c5b6000-7f408c7b5000 ---p 0000f000 08:03 1573733 /usr/lib64/libbz2.so.1.0.6
|
7f408c7b5000-7f408c7b6000 r--p 0000e000 08:03 1573733 /usr/lib64/libbz2.so.1.0.6
|
7f408c7b6000-7f408c7b7000 rw-p 0000f000 08:03 1573733 /usr/lib64/libbz2.so.1.0.6
|
7f408c7b7000-7f408c7ce000 r-xp 00000000 08:03 1573731 /usr/lib64/libelf-0.166.so
|
7f408c7ce000-7f408c9cd000 ---p 00017000 08:03 1573731 /usr/lib64/libelf-0.166.so
|
7f408c9cd000-7f408c9ce000 r--p 00016000 08:03 1573731 /usr/lib64/libelf-0.166.so
|
7f408c9ce000-7f408c9cf000 rw-p 00017000 08:03 1573731 /usr/lib64/libelf-0.166.so
|
7f408c9cf000-7f408ca2f000 r-xp 00000000 08:03 1573614 /usr/lib64/libpcre.so.1.2.0
|
7f408ca2f000-7f408cc2e000 ---p 00060000 08:03 1573614 /usr/lib64/libpcre.so.1.2.0
|
7f408cc2e000-7f408cc2f000 r--p 0005f000 08:03 1573614 /usr/lib64/libpcre.so.1.2.0
|
7f408cc2f000-7f408cc30000 rw-p 00060000 08:03 1573614 /usr/lib64/libpcre.so.1.2.0
|
7f408cc30000-7f408cc34000 r-xp 00000000 08:03 1573772 /usr/lib64/libattr.so.1.1.0
|
7f408cc34000-7f408ce33000 ---p 00004000 08:03 1573772 /usr/lib64/libattr.so.1.1.0
|
7f408ce33000-7f408ce34000 r--p 00003000 08:03 1573772 /usr/lib64/libattr.so.1.1.0
|
7f408ce34000-7f408ce35000 rw-p 00004000 08:03 1573772 /usr/lib64/libattr.so.1.1.0
|
7f408ce35000-7f408ce64000 r-xp 00000000 08:03 1575237 /usr/lib64/libk5crypto.so.3.1
|
7f408ce64000-7f408d063000 ---p 0002f000 08:03 1575237 /usr/lib64/libk5crypto.so.3.1
|
7f408d063000-7f408d065000 r--p 0002e000 08:03 1575237 /usr/lib64/libk5crypto.so.3.1
|
7f408d065000-7f408d066000 rw-p 00030000 08:03 1575237 /usr/lib64/libk5crypto.so.3.1
|
7f408d066000-7f408d067000 rw-p 00000000 00:00 0
|
7f408d067000-7f408d06a000 r-xp 00000000 08:03 1573638 /usr/lib64/libcom_err.so.2.1
|
7f408d06a000-7f408d269000 ---p 00003000 08:03 1573638 /usr/lib64/libcom_err.so.2.1
|
7f408d269000-7f408d26a000 r--p 00002000 08:03 1573638 /usr/lib64/libcom_err.so.2.1
|
7f408d26a000-7f408d26b000 rw-p 00003000 08:03 1573638 /usr/lib64/libcom_err.so.2.1
|
7f408d26b000-7f408d341000 r-xp 00000000 08:03 1575247 /usr/lib64/libkrb5.so.3.3
|
7f408d341000-7f408d541000 ---p 000d6000 08:03 1575247 /usr/lib64/libkrb5.so.3.3
|
7f408d541000-7f408d54f000 r--p 000d6000 08:03 1575247 /usr/lib64/libkrb5.so.3.3
|
7f408d54f000-7f408d552000 rw-p 000e4000 08:03 1575247 /usr/lib64/libkrb5.so.3.3
|
7f408d552000-7f408d59d000 r-xp 00000000 08:03 1573787 /usr/lib64/libgssapi_krb5.so.2.2
|
7f408d59d000-7f408d79d000 ---p 0004b000 08:03 1573787 /usr/lib64/libgssapi_krb5.so.2.2
|
7f408d79d000-7f408d79e000 r--p 0004b000 08:03 1573787 /usr/lib64/libgssapi_krb5.so.2.2
|
7f408d79e000-7f408d7a0000 rw-p 0004c000 08:03 1573787 /usr/lib64/libgssapi_krb5.so.2.2
|
7f408d7a0000-7f408d7b5000 r-xp 00000000 08:03 1579713 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
|
7f408d7b5000-7f408d9b4000 ---p 00015000 08:03 1579713 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
|
7f408d9b4000-7f408d9b5000 r--p 00014000 08:03 1579713 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
|
7f408d9b5000-7f408d9b6000 rw-p 00015000 08:03 1579713 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
|
7f408d9b6000-7f408d9fb000 r-xp 00000000 08:03 1573931 /usr/lib64/libdw-0.166.so
|
7f408d9fb000-7f408dbfb000 ---p 00045000 08:03 1573931 /usr/lib64/libdw-0.166.so
|
7f408dbfb000-7f408dbfd000 r--p 00045000 08:03 1573931 /usr/lib64/libdw-0.166.so
|
7f408dbfd000-7f408dbfe000 rw-p 00047000 08:03 1573931 /usr/lib64/libdw-0.166.so
|
7f408dbfe000-7f408dc14000 r-xp 00000000 08:03 1579301 /usr/lib64/libresolv-2.17.so
|
7f408dc14000-7f408de14000 ---p 00016000 08:03 1579301 /usr/lib64/libresolv-2.17.so
|
7f408de14000-7f408de15000 r--p 00016000 08:03 1579301 /usr/lib64/libresolv-2.17.so
|
7f408de15000-7f408de16000 rw-p 00017000 08:03 1579301 /usr/lib64/libresolv-2.17.so
|
7f408de16000-7f408de18000 rw-p 00000000 00:00 0
|
7f408de18000-7f408de1c000 r-xp 00000000 08:03 1573820 /usr/lib64/libgpg-error.so.0.10.0
|
7f408de1c000-7f408e01b000 ---p 00004000 08:03 1573820 /usr/lib64/libgpg-error.so.0.10.0
|
7f408e01b000-7f408e01c000 r--p 00003000 08:03 1573820 /usr/lib64/libgpg-error.so.0.10.0
|
7f408e01c000-7f408e01d000 rw-p 00004000 08:03 1573820 /usr/lib64/libgpg-error.so.0.10.0
|
7f408e01d000-7f408e099000 r-xp 00000000 08:03 1573828 /usr/lib64/libgcrypt.so.11.8.2
|
7f408e099000-7f408e299000 ---p 0007c000 08:03 1573828 /usr/lib64/libgcrypt.so.11.8.2
|
7f408e299000-7f408e29a000 r--p 0007c000 08:03 1573828 /usr/lib64/libgcrypt.so.11.8.2
|
7f408e29a000-7f408e29d000 rw-p 0007d000 08:03 1573828 /usr/lib64/libgcrypt.so.11.8.2
|
7f408e29d000-7f408e29e000 rw-p 00000000 00:00 0
|
7f408e29e000-7f408e2c2000 r-xp 00000000 08:03 1573624 /usr/lib64/libselinux.so.1
|
7f408e2c2000-7f408e4c1000 ---p 00024000 08:03 1573624 /usr/lib64/libselinux.so.1
|
7f408e4c1000-7f408e4c2000 r--p 00023000 08:03 1573624 /usr/lib64/libselinux.so.1
|
7f408e4c2000-7f408e4c3000 rw-p 00024000 08:03 1573624 /usr/lib64/libselinux.so.1
|
7f408e4c3000-7f408e4c5000 rw-p 00000000 00:00 0
|
7f408e4c5000-7f408e4cc000 r-xp 00000000 08:03 1579302 /usr/lib64/librt-2.17.so
|
7f408e4cc000-7f408e6cb000 ---p 00007000 08:03 1579302 /usr/lib64/librt-2.17.so
|
7f408e6cb000-7f408e6cc000 r--p 00006000 08:03 1579302 /usr/lib64/librt-2.17.so
|
7f408e6cc000-7f408e6cd000 rw-p 00007000 08:03 1579302 /usr/lib64/librt-2.17.so
|
7f408e6cd000-7f408e6d1000 r-xp 00000000 08:03 1573774 /usr/lib64/libcap.so.2.22
|
7f408e6d1000-7f408e8d0000 ---p 00004000 08:03 1573774 /usr/lib64/libcap.so.2.22
|
7f408e8d0000-7f408e8d1000 r--p 00003000 08:03 1573774 /usr/lib64/libcap.so.2.22
|
7f408e8d1000-7f408e8d2000 rw-p 00004000 08:03 1573774 /usr/lib64/libcap.so.2.22
|
7f408e8d2000-7f408e8d4000 r-xp 00000000 08:03 1573444 /usr/lib64/libfreebl3.so
|
7f408e8d4000-7f408ead3000 ---p 00002000 08:03 1573444 /usr/lib64/libfreebl3.so
|
7f408ead3000-7f408ead4000 r--p 00001000 08:03 1573444 /usr/lib64/libfreebl3.so
|
7f408ead4000-7f408ead5000 rw-p 00002000 08:03 1573444 /usr/lib64/libfreebl3.so
|
7f408ead5000-7f408ec8c000 r-xp 00000000 08:03 1573450 /usr/lib64/libc-2.17.so
|
7f408ec8c000-7f408ee8b000 ---p 001b7000 08:03 1573450 /usr/lib64/libc-2.17.so
|
7f408ee8b000-7f408ee8f000 r--p 001b6000 08:03 1573450 /usr/lib64/libc-2.17.so
|
7f408ee8f000-7f408ee91000 rw-p 001ba000 08:03 1573450 /usr/lib64/libc-2.17.so
|
7f408ee91000-7f408ee96000 rw-p 00000000 00:00 0
|
7f408ee96000-7f408ef96000 r-xp 00000000 08:03 1579298 /usr/lib64/libm-2.17.so
|
7f408ef96000-7f408f196000 ---p 00100000 08:03 1579298 /usr/lib64/libm-2.17.so
|
7f408f196000-7f408f197000 r--p 00100000 08:03 1579298 /usr/lib64/libm-2.17.so
|
7f408f197000-7f408f198000 rw-p 00101000 08:03 1579298 /usr/lib64/libm-2.17.so
|
7f408f198000-7f408f281000 r-xp 00000000 08:03 1573497 /usr/lib64/libstdc++.so.6.0.19
|
7f408f281000-7f408f481000 ---p 000e9000 08:03 1573497 /usr/lib64/libstdc++.so.6.0.19
|
7f408f481000-7f408f48a000 r--p 000e9000 08:03 1573497 /usr/lib64/libstdc++.so.6.0.19
|
7f408f48a000-7f408f48c000 rw-p 000f2000 08:03 1573497 /usr/lib64/libstdc++.so.6.0.19
|
7f408f48c000-7f408f4a1000 rw-p 00000000 00:00 0
|
7f408f4a1000-7f408f4a3000 r-xp 00000000 08:03 1579297 /usr/lib64/libdl-2.17.so
|
7f408f4a3000-7f408f6a3000 ---p 00002000 08:03 1579297 /usr/lib64/libdl-2.17.so
|
7f408f6a3000-7f408f6a4000 r--p 00002000 08:03 1579297 /usr/lib64/libdl-2.17.so
|
7f408f6a4000-7f408f6a5000 rw-p 00003000 08:03 1579297 /usr/lib64/libdl-2.17.so
|
7f408f6a5000-7f408f865000 r-xp 00000000 08:03 1575255 /usr/lib64/libcrypto.so.1.0.1e
|
7f408f865000-7f408fa65000 ---p 001c0000 08:03 1575255 /usr/lib64/libcrypto.so.1.0.1e
|
7f408fa65000-7f408fa7f000 r--p 001c0000 08:03 1575255 /usr/lib64/libcrypto.so.1.0.1e
|
7f408fa7f000-7f408fa8b000 rw-p 001da000 08:03 1575255 /usr/lib64/libcrypto.so.1.0.1e
|
7f408fa8b000-7f408fa8f000 rw-p 00000000 00:00 0
|
7f408fa8f000-7f408faf3000 r-xp 00000000 08:03 1579321 /usr/lib64/libssl.so.1.0.1e
|
7f408faf3000-7f408fcf2000 ---p 00064000 08:03 1579321 /usr/lib64/libssl.so.1.0.1e
|
7f408fcf2000-7f408fcf6000 r--p 00063000 08:03 1579321 /usr/lib64/libssl.so.1.0.1e
|
7f408fcf6000-7f408fcfd000 rw-p 00067000 08:03 1579321 /usr/lib64/libssl.so.1.0.1e
|
7f408fcfd000-7f408fd05000 r-xp 00000000 08:03 1573454 /usr/lib64/libcrypt-2.17.so
|
7f408fd05000-7f408ff04000 ---p 00008000 08:03 1573454 /usr/lib64/libcrypt-2.17.so
|
7f408ff04000-7f408ff05000 r--p 00007000 08:03 1573454 /usr/lib64/libcrypt-2.17.so
|
7f408ff05000-7f408ff06000 rw-p 00008000 08:03 1573454 /usr/lib64/libcrypt-2.17.so
|
7f408ff06000-7f408ff34000 rw-p 00000000 00:00 0
|
7f408ff34000-7f408ff49000 r-xp 00000000 08:03 1573627 /usr/lib64/libz.so.1.2.7
|
7f408ff49000-7f4090148000 ---p 00015000 08:03 1573627 /usr/lib64/libz.so.1.2.7
|
7f4090148000-7f4090149000 r--p 00014000 08:03 1573627 /usr/lib64/libz.so.1.2.7
|
7f4090149000-7f409014a000 rw-p 00015000 08:03 1573627 /usr/lib64/libz.so.1.2.7
|
7f409014a000-7f409014b000 r-xp 00000000 08:03 1576535 /usr/lib64/libaio.so.1.0.1
|
7f409014b000-7f409034a000 ---p 00001000 08:03 1576535 /usr/lib64/libaio.so.1.0.1
|
7f409034a000-7f409034b000 r--p 00000000 08:03 1576535 /usr/lib64/libaio.so.1.0.1
|
7f409034b000-7f409034c000 rw-p 00001000 08:03 1576535 /usr/lib64/libaio.so.1.0.1
|
7f409034c000-7f4090371000 r-xp 00000000 08:03 1573612 /usr/lib64/liblzma.so.5.2.2
|
7f4090371000-7f4090570000 ---p 00025000 08:03 1573612 /usr/lib64/liblzma.so.5.2.2
|
7f4090570000-7f4090571000 r--p 00024000 08:03 1573612 /usr/lib64/liblzma.so.5.2.2
|
7f4090571000-7f4090572000 rw-p 00025000 08:03 1573612 /usr/lib64/liblzma.so.5.2.2
|
7f4090572000-7f4090589000 r-xp 00000000 08:03 1573476 /usr/lib64/libpthread-2.17.so
|
7f4090589000-7f4090788000 ---p 00017000 08:03 1573476 /usr/lib64/libpthread-2.17.so
|
7f4090788000-7f4090789000 r--p 00016000 08:03 1573476 /usr/lib64/libpthread-2.17.so
|
7f4090789000-7f409078a000 rw-p 00017000 08:03 1573476 /usr/lib64/libpthread-2.17.so
|
7f409078a000-7f409078e000 rw-p 00000000 00:00 0
|
7f409078e000-7f40907ae000 r-xp 00000000 08:03 1573443 /usr/lib64/ld-2.17.so
|
7f40907b3000-7f40907b4000 rw-p 00000000 00:00 0
|
7f40907b4000-7f40907b5000 ---p 00000000 00:00 0
|
7f40907b5000-7f40907fe000 rw-p 00000000 00:00 0 [stack:4500]
|
7f40907fe000-7f40907ff000 ---p 00000000 00:00 0
|
7f40907ff000-7f4090848000 rw-p 00000000 00:00 0 [stack:4499]
|
7f4090848000-7f4090849000 ---p 00000000 00:00 0
|
7f4090849000-7f4090893000 rw-p 00000000 00:00 0 [stack:4494]
|
7f4090893000-7f4090896000 rw-s 00000000 00:0a 29155 /[aio] (deleted)
|
7f4090896000-7f4090899000 rw-s 00000000 00:0a 29154 /[aio] (deleted)
|
7f4090899000-7f409089c000 rw-s 00000000 00:0a 29153 /[aio] (deleted)
|
7f409089c000-7f409089f000 rw-s 00000000 00:0a 29152 /[aio] (deleted)
|
7f409089f000-7f40908a2000 rw-s 00000000 00:0a 29151 /[aio] (deleted)
|
7f40908a2000-7f40908a5000 rw-s 00000000 00:0a 29150 /[aio] (deleted)
|
7f40908a5000-7f4090975000 rw-p 00000000 00:00 0
|
7f4090975000-7f409099b000 r-xp 00000000 08:03 1575819 /usr/lib64/libsystemd.so.0.6.0
|
7f409099b000-7f409099c000 r--p 00025000 08:03 1575819 /usr/lib64/libsystemd.so.0.6.0
|
7f409099c000-7f409099d000 rw-p 00026000 08:03 1575819 /usr/lib64/libsystemd.so.0.6.0
|
7f409099d000-7f409099f000 rw-p 00000000 00:00 0
|
7f409099f000-7f40909a0000 rw-s 00000000 00:0a 29156 /[aio] (deleted)
|
7f40909a0000-7f40909a3000 rw-s 00000000 00:0a 29149 /[aio] (deleted)
|
7f40909a3000-7f40909a6000 rw-s 00000000 00:0a 29148 /[aio] (deleted)
|
7f40909a6000-7f40909a9000 rw-s 00000000 00:0a 29147 /[aio] (deleted)
|
7f40909a9000-7f40909ac000 rw-s 00000000 00:0a 29146 /[aio] (deleted)
|
7f40909ac000-7f40909ad000 rw-s 00000000 00:0a 29145 /[aio] (deleted)
|
7f40909ad000-7f40909ae000 rw-p 00000000 00:00 0
|
7f40909ae000-7f40909af000 r--p 00020000 08:03 1573443 /usr/lib64/ld-2.17.so
|
7f40909af000-7f40909b0000 rw-p 00021000 08:03 1573443 /usr/lib64/ld-2.17.so
|
7f40909b0000-7f40909b1000 rw-p 00000000 00:00 0
|
7f40909b1000-7f4091b0e000 r-xp 00000000 08:03 1578125 /usr/sbin/mysqld
|
7f4091d0e000-7f4091de8000 r--p 0115d000 08:03 1578125 /usr/sbin/mysqld
|
7f4091de8000-7f4091e9f000 rw-p 01237000 08:03 1578125 /usr/sbin/mysqld
|
7f4091e9f000-7f409272e000 rw-p 00000000 00:00 0
|
7f4093c8f000-7f40c4547000 rw-p 00000000 00:00 0 [heap]
|
7ffe4c2d6000-7ffe4c2f7000 rw-p 00000000 00:00 0 [stack]
|
7ffe4c368000-7ffe4c36a000 r-xp 00000000 00:00 0 [vdso]
|
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall]
|
180401 6:02:09 [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.8-MariaDB-log
|
key_buffer_size=8589934592
|
read_buffer_size=2097152
|
max_used_connections=6
|
max_threads=1502
|
thread_count=15
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 14572555 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
 |
Thread pointer: 0x7f355c0008c8
|
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 = 0x7f360abe3d70 thread_stack 0x49000
|
(my_addr_resolve failure: fork)
|
/usr/sbin/mysqld(my_print_stacktrace+0x2e) [0x7f40915d2a7e]
|
/usr/sbin/mysqld(handle_fatal_signal+0x30d) [0x7f4091018dbd]
|
/lib64/libpthread.so.0(+0xf370) [0x7f4090581370]
|
/lib64/libc.so.6(gsignal+0x37) [0x7f408eb0a1d7]
|
/lib64/libc.so.6(abort+0x148) [0x7f408eb0b8c8]
|
/lib64/libc.so.6(+0x74f07) [0x7f408eb49f07]
|
/lib64/libc.so.6(+0x7c503) [0x7f408eb51503]
|
/usr/sbin/mysqld(Item_subselect::cleanup()+0x7e) [0x7f40910bffbe]
|
/usr/sbin/mysqld(Query_arena::free_items()+0x30) [0x7f4090e59030]
|
/usr/sbin/mysqld(THD::cleanup_after_query()+0x5c) [0x7f4090e5b94c]
|
/usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool)+0x237) [0x7f4090e91007]
|
/usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool)+0x203d) [0x7f4090e9405d]
|
/usr/sbin/mysqld(do_command(THD*)+0x149) [0x7f4090e94c69]
|
/usr/sbin/mysqld(do_handle_one_connection(CONNECT*)+0x1aa) [0x7f4090f585da]
|
/usr/sbin/mysqld(handle_one_connection+0x3d) [0x7f4090f586fd]
|
/lib64/libpthread.so.0(+0x7dc5) [0x7f4090579dc5]
|
/lib64/libc.so.6(clone+0x6d) [0x7f408ebcc76d]
|
 |
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f355c01f120): SELECT CONCAT(exchange_ts_str, '_', symbol) AS trade_key, exchange, exchange_ts_str, fill_id, origin, user_id, context, symbol, side, price, quantity, order_id, leg_type, account_number FR
|
OM `drop_copy_fill_events` WHERE ts_str like '2018-03%' AND CONCAT(exchange_ts_str, '_', symbol) IN ( SELECT distinct CONCAT(exchange_ts_str, '_', symbol) FROM `drop_copy_fill_ev
|
ents` where ts_str like '2018-03%' AND exchange NOT IN ('ICE', 'NYSE_LIFFE_US') group by CONCAT(exchange_ts_str, '_', symbol) having count(*) > 1 and count(d
|
istinct price) = 1 and count(distinct quantity) = 1 and count(distinct side) = 2 and count(distinct user_id) = 2 ) ORDER BY account_number
|
Connection ID (thread ID): 19
|
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.
|
Attachments
Issue Links
- relates to
-
MDEV-15065 Item_subselect::cleanup double free or corruption
- Closed
-
MDEV-15585 signal 11 in cleanup phase
- Closed
-
MDEV-15928 MariaDB SELECT query ends with lost connection
- Closed
-
MDEV-16078 Server crashes in Item::delete_self or in String::free or ASAN fails with use-after-poison in String::alloced_length upon executing PS with out-of-range error
- Closed
-
MDEV-16118 Frequenly & unpredicted crash (buffer overflow detected ***: /usr/sbin/mysqld terminated))
- Closed