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.

Mysql frequently down with Event Scheduler: Loaded 0 events

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

  1. gopkris2005

    gopkris2005 Well-Known Member

    Joined:
    Jan 9, 2007
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    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?
     
  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.
     
  3. gopkris2005

    gopkris2005 Well-Known Member

    Joined:
    Jan 9, 2007
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    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...



     
  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!
     
Loading...

Share This Page