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.

Munin - mysql Restart

Discussion in 'Database Discussions' started by mahdy_sharifi, May 18, 2013.

  1. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hello :

    I use munin for server monitoring , but every 5 min when munin update Mysql server restarted !
    why this issue occurred ?

    Thanks
     
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Have you check your MySQL server logs ?

    and whats error message you receive while restarting the mysql service
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Is MySQL failing to respond before it's restarted, or is it restarting while it's running normally? The MySQL error log may contain some useful information, as mentioned in the previous response.

    Thank you.
     
  4. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hi :

    130522 12:30:15 InnoDB: error: space object of table atlassar_peresta/ps_product,
    InnoDB: space id 3545 did not exist in memory. Retrying an open.
    InnoDB: Error: trying to add tablespace 3545 of name './atlassar_peresta/ps_product.ibd'
    InnoDB: to the tablespace memory cache, but tablespace
    InnoDB: 3545 of name './iraniant_2012/wp_likes.ibd' already exists in the tablespace
    InnoDB: memory cache!
    130522 12:30:15 InnoDB: Assertion failure in thread 140418577573632 in file btr/btr0btr.c line 136
    InnoDB: Failing assertion: (ibool)!!page_is_comp(root) == dict_table_is_comp(index->table)
    InnoDB: We intentionally generate a memory trap.
    InnoDB: Submit a detailed bug report to MySQL Bugs.
    InnoDB: If you get repeated assertion failures or crashes, even
    InnoDB: immediately after the mysqld startup, there may be
    InnoDB: corruption in the InnoDB tablespace. Please refer to
    InnoDB: MySQL :: MySQL 5.1 Reference Manual :: 14.6.5.2 Forcing InnoDB Recovery
    InnoDB: about forcing recovery.
    08:00:15 UTC - mysqld got signal 6 ;
    This could be because you hit a bug. It is also possible that this binary
    or one of the libraries it was linked against is corrupt, improperly built,
    or misconfigured. This error can also be caused by malfunctioning hardware.
    We will try our best to scrape up some info that will hopefully help
    diagnose the problem, but since we have already crashed,
    something is definitely wrong and this may fail.

    key_buffer_size=1073741824
    read_buffer_size=1048576
    max_used_connections=85
    max_threads=600
    thread_count=45
    connection_count=39
    It is possible that mysqld could use up to
    key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2898179 K bytes of memory
    Hope that's ok; if not, decrease some variables in the equation.

    - - - Updated - - -

    After following log , database restarted ...
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page