Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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

Discussion in 'Database Discussion' 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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,827
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice