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!

Mysql frequently down with Event Scheduler: Loaded 0 events

Discussion in 'Database Discussion' started by gopkris2005, May 7, 2013.

  1. gopkris2005

    gopkris2005 Well-Known Member

    Joined:
    Jan 9, 2007
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    One of our server mysql keep down frequently with the following errors.

    130507 5:14:06 InnoDB: Started; log sequence number 119 391265068
    130507 5:14:06 [Note] Event Scheduler: Loaded 0 event

    Repaired all the database and configured values very well in my.cnf.

    how to fix it?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. Veeble-Adam

    Veeble-Adam Active Member

    Joined:
    May 7, 2013
    Messages:
    43
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    It seems like the InnoDB has been crashed.

    The only way to recover innodb is to start mysql with various levels of innodb_force_recovery (starting from 4) and try to dump the databases. This would be the only possible way- attempt to dump all databases, drop all databases, stop mysql, remove innodb_force_recovery from my.cnf, kill innodb files, start mysql and restore all databases.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. gopkris2005

    gopkris2005 Well-Known Member

    Joined:
    Jan 9, 2007
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Thanks... I have used innodb_force_recovery=4 and restart mysql server. Repaired all the innodb databases...



     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. Veeble-Adam

    Veeble-Adam Active Member

    Joined:
    May 7, 2013
    Messages:
    43
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Glad to hear it helped!
     
    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