glibc detected : /usr/sbin/mysqld: malloc(): memory corruption: 0x0000 : MYSQL

sreeninair

• March 27, 2014 02:06

Hello Guys, I am getting the following error message in mysql commandline when innodb is enabled. Mysql version is 5.0 ================================= *** glibc detected *** /usr/sbin/mysqld: malloc(): memory corruption: 0x00007f9b0509ca90 *** ======= Backtrace: ========= /lib64/libc.so.6[0x3cf7c7225e] /lib64/libc.so.6(__libc_malloc+0x6e)[0x3cf7c7409e] /usr/sbin/mysqld(my_malloc+0x32)[0x7b44b2] /usr/sbin/mysqld(_Z7openfrmP3THDPKcS2_jjjP8st_table+0xb5e)[0x59d05e] /usr/sbin/mysqld[0x596683] /usr/sbin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP11st_mem_rootPbj+0x5f5)[0x597a45] /usr/sbin/mysqld(_Z11open_tablesP3THDPP10TABLE_LISTPjj+0x2fe)[0x59822e] /usr/sbin/mysqld(_Z30open_normal_and_derived_tablesP3THDP10TABLE_LISTj+0x1e)[0x5983fe] /usr/sbin/mysqld(_Z14get_all_tablesP3THDP10TABLE_LISTP4Item+0x6dd)[0x6344fd] /usr/sbin/mysqld(_Z24get_schema_tables_resultP4JOIN23enum_schema_table_state+0x109)[0x62f3f9] /usr/sbin/mysqld(_ZN4JOIN4execEv+0x9c2)[0x5bd152] /usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x19d)[0x5beabd] /usr/sbin/mysqld(_Z13handle_selectP3THDP6st_lexP13select_resultm+0x157)[0x5bf3b7] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x13ca)[0x56aafa] /usr/sbin/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x1d1)[0x56eee1] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xfd3)[0x56ff83] /usr/sbin/mysqld(handle_one_connection+0x93b)[0x5710bb] /lib64/libpthread.so.0[0x3cf840683d] /lib64/libc.so.6(clone+0x6d)[0x3cf7cd526d] ======= Memory map: ======== 00400000-009fd000 r-xp 00000000 fd:00 91107873 /usr/sbin/mysqld 00bfd000-00c55000 rw-p 005fd000 fd:00 91107873 /usr/sbin/mysqld 00c55000-00c67000 rw-p 00000000 00:00 0 00e54000-00eb1000 rw-p 00654000 fd:00 91107873 /usr/sbin/mysqld 00eb1000-01e3c000 rw-p 00000000 00:00 0 [heap] 3cf7800000-3cf781c000 r-xp 00000000 fd:00 152568121 /lib64/ld-2.5.so 3cf7a1c000-3cf7a1d000 r--p 0001c000 fd:00 152568121 /lib64/ld-2.5.so 3cf7a1d000-3cf7a1e000 rw-p 0001d000 fd:00 152568121 /lib64/ld-2.5.so 3cf7c00000-3cf7d4f000 r-xp 00000000 fd:00 152568122 /lib64/libc-2.5.so 3cf7d4f000-3cf7f4f000 ---p 0014f000 fd:00 152568122 /lib64/libc-2.5.so 3cf7f4f000-3cf7f53000 r--p 0014f000 fd:00 152568122 /lib64/libc-2.5.so 3cf7f53000-3cf7f54000 rw-p 00153000 fd:00 152568122 /lib64/libc-2.5.so 3cf7f54000-3cf7f59000 rw-p 00000000 00:00 0 3cf8000000-3cf8002000 r-xp 00000000 fd:00 153682200 /lib64/libdl-2.5.so 3cf8002000-3cf8202000 ---p 00002000 fd:00 153682200 /lib64/libdl-2.5.so 3cf8202000-3cf8203000 r--p 00002000 fd:00 153682200 /lib64/libdl-2.5.so 3cf8203000-3cf8204000 rw-p 00003000 fd:00 153682200 /lib64/libdl-2.5.so 3cf8400000-3cf8416000 r-xp 00000000 fd:00 153682495 /lib64/libpthread-2.5.so 3cf8416000-3cf8616000 ---p 00016000 fd:00 153682495 /lib64/libpthread-2.5.so 3cf8616000-3cf8617000 r--p 00016000 fd:00 153682495 /lib64/libpthread-2.5.so 3cf8617000-3cf8618000 rw-p 00017000 fd:00 153682495 /lib64/libpthread-2.5.so 3cf8618000-3cf861c000 rw-p 00000000 00:00 0 3cf8800000-3cf8882000 r-xp 00000000 fd:00 153682496 /lib64/libm-2.5.so 3cf8882000-3cf8a81000 ---p 00082000 fd:00 153682496 /lib64/libm-2.5.so 3cf8a81000-3cf8a82000 r--p 00081000 fd:00 153682496 /lib64/libm-2.5.so 3cf8a82000-3cf8a83000 rw-p 00082000 fd:00 153682496 /lib64/libm-2.5.so 3cf9000000-3cf9007000 r-xp 00000000 fd:00 153682497 /lib64/librt-2.5.so 3cf9007000-3cf9207000 ---p 00007000 fd:00 153682497 /lib64/librt-2.5.so 3cf9207000-3cf9208000 r--p 00007000 fd:00 153682497 /lib64/librt-2.5.so 3cf9208000-3cf9209000 rw-p 00008000 fd:00 153682497 /lib64/librt-2.5.so 3cf9c00000-3cf9c15000 r-xp 00000000 fd:00 153682507 /lib64/libnsl-2.5.so 3cf9c15000-3cf9e14000 ---p 00015000 fd:00 153682507 /lib64/libnsl-2.5.so 3cf9e14000-3cf9e15000 r--p 00014000 fd:00 153682507 /lib64/libnsl-2.5.so 3cf9e15000-3cf9e16000 rw-p 00015000 fd:00 153682507 /lib64/libnsl-2.5.so 3cf9e16000-3cf9e18000 rw-p 00000000 00:00 0 3cfa000000-3cfa009000 r-xp 00000000 fd:00 153682530 /lib64/libcrypt-2.5.so 3cfa009000-3cfa208000 ---p 00009000 fd:00 153682530 /lib64/libcrypt-2.5.so 3cfa208000-3cfa209000 r--p 00008000 fd:00 153682530 /lib64/libcrypt-2.5.so 3cfa209000-3cfa20a000 rw-p 00009000 fd:00 153682530 /lib64/libcrypt-2.5.so 3cfa20a000-3cfa238000 rw-p 00000000 00:00 0 3cfac00000-3cfac11000 r-xp 00000000 fd:00 153682519 /lib64/libresolv-2.5.so 3cfac11000-3cfae11000 ---p 00011000 fd:00 153682519 /lib64/libresolv-2.5.so 3cfae11000-3cfae12000 r--p 00011000 fd:00 153682519 /lib64/libresolv-2.5.so 3cfae12000-3cfae13000 rw-p 00012000 fd:00 153682519 /lib64/libresolv-2.5.so 3cfae13000-3cfae15000 rw-p 00000000 00:00 0 7f9b04000000-7f9b05104000 rw-p 00000000 00:00 0 7f9b05104000-7f9b08000000 ---p 00000000 00:00 0 7f9b081e1000-7f9b081e5000 r-xp 00000000 fd:00 153682466 /lib64/libnss_dns-2.5.so 7f9b081e5000-7f9b083e4000 ---p 00004000 fd:00 153682466 /lib64/libnss_dns-2.5.so 7f9b083e4000-7f9b083e5000 r--p 00003000 fd:00 153682466 /lib64/libnss_dns-2.5.so 7f9b083e5000-7f9b083e6000 rw-p 00004000 fd:00 153682466 /lib64/libnss_dns-2.5.so 7f9b083e6000-7f9b083e7000 ---p 00000000 00:00 0 7f9b083e7000-7f9b08427000 rw-p 00000000 00:00 0
================================== current My.cnf [~]# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock default-storage-engine=InnoDB #skip-innodb innodb_force_recovery=4 max_user_connections=150 max_connections=1000 open_files_limit=50000 innodb_buffer_pool_size=1200M innodb_flush_method=O_DIRECT
===================== The serve is getting stopped after this message. I have found in a forum as "http://www.olivierdoucet.info/blog/2013/04/17/story-mysql-crash-memory-issue/" to use 'innodb_flush_method=O_DIRECT" in my.cnf. Still same error. Pleae help me on this. Thanks Sreenivas

• 

  cPanelMichael

  • April 01, 2014 12:52

  Hello :) You reference using the following line in your /etc/my.cnf file: innodb_force_recovery=4
  Was InnoDB corrupted at some point? That option is not intended for permanent use, and is only intended to resolve instances of InnoDB corruption. Thank you.

  0

Please sign in to leave a comment.