The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Database Discussions' started by sreeninair, Mar 27, 2014.

  1. sreeninair

    sreeninair Well-Known Member

    Joined:
    Dec 23, 2013
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,762
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     

Share This Page