lib_mysqludf_json导致mysql重启原因分析

  • A+
所属分类:MySQL 运维案例

本文地址:http://www.bhlaab.com/mysql/lib_mysqludf_json-causes-mysql-to-restart-the-cause-analysis/
文章摘要:lib,第九次招聘网站酷乐,那还用说魏征马鹿。

在《mysqludf_json将关系数据以JSON编码》提到使用lib_mysqludf_json会引起数据库重启。mysql错误日志如下:
mysqld_safe Number of processes running now: 0
mysqld_safe mysqld restarted
*** glibc detected *** /usr/local/mysql5.6/bin/mysqld: corrupted double-linked list: 0x00000000185fa230 ***
======= Backtrace: =========
/lib64/libc.so.6[0x2ab3bd0a96c3]
/lib64/libc.so.6[0x2ab3bd0abc1c]
/lib64/libc.so.6(__libc_malloc+0x6e)[0x2ab3bd0adf0e]
/usr/local/mysql5.6/bin/mysqld(my_malloc+0x32)[0x8f5dc2]
/usr/local/mysql5.6/bin/mysqld(alloc_root+0x7e)[0x8f244e]
/usr/local/mysql5.6/bin/mysqld(_ZN4JOIN8optimizeEv+0x1002)[0x860582]
/usr/local/mysql5.6/bin/mysqld[0x70a0f4]
/usr/local/mysql5.6/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xbc)[0x70abac]
/usr/local/mysql5.6/bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x175)[0x70adb5]
/usr/local/mysql5.6/bin/mysqld[0x6e7069]
/usr/local/mysql5.6/bin/mysqld(_Z21mysql_execute_commandP3THD+0x3426)[0x6eb636]
/usr/local/mysql5.6/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x318)[0x6eeed8]
/usr/local/mysql5.6/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x8f1)[0x6ef8c1]
/usr/local/mysql5.6/bin/mysqld(_Z10do_commandP3THD+0xd7)[0x6f0da7]
/usr/local/mysql5.6/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x116)[0x6badc6]
/usr/local/mysql5.6/bin/mysqld(handle_one_connection+0x45)[0x6baea5]
/usr/local/mysql5.6/bin/mysqld(pfs_spawn_thread+0x126)[0xac3886]
/lib64/libpthread.so.0[0x2ab3bbe4b83d]
/lib64/libc.so.6(clone+0x6d)[0x2ab3bd10ef8d]
======= Memory map: ========
00400000-00f79000 r-xp 00000000 08:03 3518378 /usr/local/mysql-5.6.13-linux-glibc2.5-x86_64/bin/mysqld
01178000-01324000 rw-p 00b78000 08:03 3518378 /usr/local/mysql-5.6.13-linux-glibc2.5-x86_64/bin/mysqld
01324000-01376000 rw-p 01324000 00:00 0
17fe0000-186f9000 rw-p 17fe0000 00:00 0 [heap]
2ab3bbc27000-2ab3bbc43000 r-xp 00000000 08:07 196714 /lib64/ld-2.5.so
2ab3bbc43000-2ab3bbc45000 rw-p 2ab3bbc43000 00:00 0
2ab3bbe43000-2ab3bbe44000 r--p 0001c000 08:07 196714 /lib64/ld-2.5.so
2ab3bbe44000-2ab3bbe45000 rw-p 0001d000 08:07 196714 /lib64/ld-2.5.so
2ab3bbe45000-2ab3bbe5b000 r-xp 00000000 08:07 196641 /lib64/libpthread-2.5.so
2ab3bbe5b000-2ab3bc05b000 ---p 00016000 08:07 196641 /lib64/libpthread-2.5.so
2ab3bc05b000-2ab3bc05c000 r--p 00016000 08:07 196641 /lib64/libpthread-2.5.so
2ab3bc05c000-2ab3bc05d000 rw-p 00017000 08:07 196641 /lib64/libpthread-2.5.so
2ab3bc05d000-2ab3bc061000 rw-p 2ab3bc05d000 00:00 0
2ab3bc061000-2ab3bc062000 r-xp 00000000 08:03 3780151 /usr/lib64/libaio.so.1.0.1
2ab3bc062000-2ab3bc261000 ---p 00001000 08:03 3780151 /usr/lib64/libaio.so.1.0.1
2ab3bc261000-2ab3bc262000 rw-p 00000000 08:03 3780151 /usr/lib64/libaio.so.1.0.1
2ab3bc262000-2ab3bc269000 r-xp 00000000 08:07 196837 /lib64/librt-2.5.so
2ab3bc269000-2ab3bc469000 ---p 00007000 08:07 196837 /lib64/librt-2.5.so
2ab3bc469000-2ab3bc46a000 r--p 00007000 08:07 196837 /lib64/librt-2.5.so
2ab3bc46a000-2ab3bc46b000 rw-p 00008000 08:07 196837 /lib64/librt-2.5.so
2ab3bc46b000-2ab3bc46c000 rw-p 2ab3bc46b000 00:00 0
2ab3bc46c000-2ab3bc475000 r-xp 00000000 08:07 196621 /lib64/libcrypt-2.5.so
2ab3bc475000-2ab3bc674000 ---p 00009000 08:07 196621 /lib64/libcrypt-2.5.so
2ab3bc674000-2ab3bc675000 r--p 00008000 08:07 196621 /lib64/libcrypt-2.5.so
2ab3bc675000-2ab3bc676000 rw-p 00009000 08:07 196621 /lib64/libcrypt-2.5.so
2ab3bc676000-2ab3bc6a4000 rw-p 2ab3bc676000 00:00 0
2ab3bc6a4000-2ab3bc6a6000 r-xp 00000000 08:07 196830 /lib64/libdl-2.5.so
2ab3bc6a6000-2ab3bc8a6000 ---p 00002000 08:07 196830 /lib64/libdl-2.5.so
2ab3bc8a6000-2ab3bc8a7000 r--p 00002000 08:07 196830 /lib64/libdl-2.5.so
2ab3bc8a7000-2ab3bc8a8000 rw-p 00003000 08:07 196830 /lib64/libdl-2.5.so
2ab3bc8a8000-2ab3bc98e000 r-xp 00000000 08:03 3779126 /usr/lib64/libstdc++.so.6.0.8
2ab3bc98e000-2ab3bcb8d000 ---p 000e6000 08:03 3779126 /usr/lib64/libstdc++.so.6.0.8
2ab3bcb8d000-2ab3bcb93000 r--p 000e5000 08:03 3779126 /usr/lib64/libstdc++.so.6.0.8
2ab3bcb93000-2ab3bcb96000 rw-p 000eb000 08:03 3779126 /usr/lib64/libstdc++.so.6.0.8
2ab3bcb96000-2ab3bcba9000 rw-p 2ab3bcb96000 00:00 0
2ab3bcba9000-2ab3bcc2b000 r-xp 00000000 08:07 196831 /lib64/libm-2.5.so
2ab3bcc2b000-2ab3bce2a000 ---p 00082000 08:07 196831 /lib64/libm-2.5.so
2ab3bce2a000-2ab3bce2b000 r--p 00081000 08:07 196831 /lib64/libm-2.5.so
2ab3bce2b000-2ab3bce2c000 rw-p 00082000 08:07 196831 /lib64/libm-2.5.so
2ab3bce2c000-2ab3bce39000 r-xp 00000000 08:07 196826 /lib64/libgcc_s-4.1.2-20080825.so.1
2ab3bce39000-2ab3bd039000 ---p 0000d000 08:07 196826 /lib64/libgcc_s-4.1.2-20080825.so.1
2ab3bd039000-2ab3bd03a000 rw-p 0000d000 08:07 196826 /lib64/libgcc_s-4.1.2-20080825.so.1
2ab3bd03a000-2ab3bd189000 r-xp 00000000 08:07 196617 /lib64/libc-2.5.so
2ab3bd189000-2ab3bd388000 ---p 0014f000 08:07 196617 /lib64/libc-2.5.so
2ab3bd388000-2ab3bd38c000 r--p 0014e000 08:07 196617 /lib64/libc-2.5.so
2ab3bd38c000-2ab3bd38d000 rw-p 00152000 08:07 196617 /lib64/libc-2.5.so
2ab3bd38d000-2ab3bd394000 rw-p 2ab3bd38d000 00:00 0
2ab3bd394000-2ab3bd395000 ---p 2ab3bd394000 00:00 0
2ab3bd395000-2ab3eb469000 rw-p 2ab3bd395000 00:00 0
2ab3eb471000-2ab3eb47b000 r-xp 00000000 08:07 196834 /lib64/libnss_files-2.5.so
2ab3eb47b000-2ab3eb67a000 ---p 0000a000 08:07 196834 /lib64/libnss_files-2.5.so
2ab3eb67a000-2ab3eb67b000 r--p 00009000 08:07 196834 /lib64/libnss_files-2.5.so
2ab3eb67b000-2ab3eb67c000 rw-p 0000a000 08:07 196834 /lib64/libnss_files-2.5.so
2ab3eb67c000-2ab3f4ffc000 rw-p 2ab3eb67c000 00:00 0
2ab3f4ffc000-2ab3f4ffd000 ---p 2ab3f4ffc000 00:00 0
2ab3f4ffd000-2ab3f59fd000 rw-p 2ab3f4ffd000 00:00 0
2ab3f59fd000-2ab3f59fe000 ---p 2ab3f59fd000 00:00 0
2ab3f59fe000-2ab3f63fe000 rw-p 2ab3f59fe000 00:00 0
2ab3f63fe000-2ab3f63ff000 ---p 2ab3f63fe000 00:00 0
2ab3f63ff000-2ab3f6dff000 rw-p 2ab3f63ff000 00:00 0
2ab3f6dff000-2ab3f6e00000 ---p 2ab3f6dff000 00:00 0
2ab3f6e00000-2ab3f7800000 rw-p 2ab3f6e00000 00:00 0
2ab3f7800000-2ab3f7801000 ---p 2ab3f7800000 00:00 0
2ab3f7801000-2ab3f8201000 rw-p 2ab3f7801000 00:00 0
2ab3f8201000-2ab3f8202000 ---p 2ab3f8201000 00:00 0
2ab3f8202000-2ab3f8c02000 rw-p 2ab3f8202000 00:00 0
2ab3f8c02000-2ab3f8c03000 ---p 2ab3f8c02000 00:00 0
2ab3f8c03000-2ab3f9603000 rw-p 2ab3f8c03000 00:00 0
2ab3f9603000-2ab3f9604000 ---p 2ab3f9603000 00:00 0
2ab3f9604000-2ab3fa004000 rw-p 2ab3f9604000 00:00 0
2ab3fa004000-2ab3fa005000 ---p 2ab3fa004000 00:00 0
2ab3fa005000-2ab3faa05000 rw-p 2ab3fa005000 00:00 0
2ab3fae23000-2ab3fb028000 rw-p 2ab3fae23000 00:00 0
2ab3fb028000-2ab3fb029000 ---p 2ab3fb028000 00:00 0
2ab3fb029000-2ab3fbab2000 rw-p 2ab3fb029000 00:00 0
2ab3fbab2000-2ab3fbab3000 ---p 2ab3fbab2000 00:00 0
2ab3fbab3000-2ab3fc4b3000 rw-p 2ab3fbab3000 00:00 0
2ab3fc4b3000-2ab3fc4b4000 ---p 2ab3fc4b3000 00:00 0
2ab3fc4b4000-2ab3fceb4000 rw-p 2ab3fc4b4000 00:00 0
2ab3fceb4000-2ab3fceb5000 ---p 2ab3fceb4000 00:00 0
2ab3fceb5000-2ab3fd8b5000 rw-p 2ab3fceb5000 00:00 0
2ab3fd8b5000-2ab3fd8b6000 ---p 2ab3fd8b5000 00:00 0
2ab3fd8b6000-2ab3fe2b6000 rw-p 2ab3fd8b6000 00:00 0
2ab3fe2b6000-2ab3fe2b7000 ---p 2ab3fe2b6000 00:00 0
2ab3fe2b7000-2ab3fecb7000 rw-p 2ab3fe2b7000 00:00 0
2ab3fecb7000-2ab3fecb8000 ---p 2ab3fecb7000 00:00 0
2ab3fecb8000-2ab3ff6b8000 rw-p 2ab3fecb8000 00:00 0
2ab3ff6b8000-2ab3ff6b9000 ---p 2ab3ff6b8000 00:00 0
2ab3ff6b9000-2ab4000b9000 rw-p 2ab3ff6b9000 00:00 0
2ab4000b9000-2ab4000ba000 ---p 2ab4000b9000 00:00 0
2ab4000ba000-2ab400aba000 rw-p 2ab4000ba000 00:00 0
2ab400aba000-2ab400abb000 ---p 2ab400aba000 00:00 0
2ab400abb000-2ab400afb000 rw-p 2ab400abb000 00:00 0
2ab400afb000-2ab400afe000 r-xp 00000000 08:03 3526873 /usr/local/mysql-5.6.13-linux-glibc2.5-x86_64/lib/plugin/lib_mysqludf_json.so
2ab400afe000-2ab400cfd000 ---p 00003000 08:03 3526873 /usr/local/mysql-5.6.13-linux-glibc2.5-x86_64/lib/plugin/lib_mysqludf_json.so
2ab400cfd000-2ab400cfe000 rw-p 00002000 08:03 3526873 /usr/local/mysql-5.6.13-linux-glibc2.5-x86_64/lib/plugin/lib_mysqludf_json.so
2ab400cfe000-2ab400cff000 ---p 2ab400cfe000 00:00 0
2ab400cff000-2ab400d3f000 rw-p 2ab400cff000 00:00 0
7fff67361000-7fff67376000 rw-p 7ffffffe9000 00:00 0 [stack]
7fff673fd000-7fff67400000 r-xp 7fff673fd000 00:00 0 [vdso]
ffffffffff600000-ffffffffffe00000 ---p 00000000 00:00 0 [vsyscall]
mysqld_safe Number of processes running now: 0
mysqld_safe mysqld restarted

*** glibc detected *** /usr/local/mysql5.6/bin/mysqld: corrupted double-linked list: 0x00000000185fa230 ***
先记录下,再来查查原因咯。

微信公众号
扫一扫关注运维生存时间公众号,获取最新技术文章~

发表评论


目前评论:3   其中:访客  2   博主  0   引用   1

    • 不能说 9

      因json_members 经常会使mysql crash,所以在实际情况中,不要使用此函数。

        • 运维生存时间 9

          @不能说 嗯。 是会出现的。不知道咋解决

      • 来自外部的引用: 1

        • mysqludf_json将关系数据以JSON编码