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

sreeninair

Well-Known Member
Dec 23, 2013
100
0
16
cPanel Access Level
Root Administrator
Hello Guys,

I am getting the following error message in mysql commandline when innodb is enabled. Mysql version is 5.0

=================================
Code:
*** 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
Code:
[~]# 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

Administrator
Staff member
Apr 11, 2011
47,909
2,229
463
Hello :)

You reference using the following line in your /etc/my.cnf file:

Code:
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.