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 restaring every 9-10 minutes

Discussion in 'General Discussion' started by shann, Jun 5, 2008.

  1. shann

    shann Well-Known Member

    Joined:
    Jul 5, 2002
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Website Owner
    Hi,

    mysql is restarting everything 9-10 minutes and I'm not sure what is it causing. Here is the error message from the log file.

    80605 19:28:27 InnoDB: Starting shutdown...
    080605 19:28:29 InnoDB: Shutdown completed; log sequence number 0 1304279005
    080605 19:28:29 [Note] /usr/sbin/mysqld: Shutdown complete

    080605 19:28:29 mysqld ended

    080605 19:28:45 mysqld started
    080605 19:28:45 InnoDB: Started; log sequence number 0 1304279005
    080605 19:28:45 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
    080605 19:28:45 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.0.45-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
    080605 19:28:46 [Note] /usr/sbin/mysqld: Normal shutdown

    080605 19:28:46 InnoDB: Starting shutdown...
    080605 19:28:49 InnoDB: Shutdown completed; log sequence number 0 1304279005
    080605 19:28:49 [Note] /usr/sbin/mysqld: Shutdown complete

    080605 19:28:49 mysqld ended

    080605 19:28:50 mysqld started
    080605 19:28:50 InnoDB: Started; log sequence number 0 1304279005
    080605 19:28:50 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
    080605 19:28:50 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.0.45-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
     
  2. viraj

    viraj Well-Known Member

    Joined:
    Sep 28, 2006
    Messages:
    209
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Are you running INNODB storage engine for your MySQL server ? Can you run "/scripts/mysqlup --force" to force a MySQL update/upgrade. This will repair almost all the problems related to MySQL. I'd recommend using MyISAM storage engine, it's the default & more robust than INNODB... :)
     
  3. jayrb

    jayrb Registered

    Joined:
    Sep 27, 2008
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    chronic problem!

    I am trying to track down a solution to this exact issue and nowhere do I see a clearly stated, "this is the problem and here is how to fix it". What is incredibly annoying is how it continues to show up over years of posts!

    With all due respect to viraj, disabling the InnoDB engine can't be the answer. I would have to check, but I'm confident that very few of my users are running with InnoDB tables anyway.

    I am running 5.0.51a-community and mysql is restarting every ~9 min. Same symptoms as countless threads. In one thread, the poster says the cPanel folks went in and fixed something, but didn't say what they fixed.

    It is causing problems because people try to access a site and the db is unavailable. Not to mention the constant stream of warning emails.

    What - exactly - is the cause and what - exactly - is the solution?

    tia,
    Jay
     
  4. Bartuc

    Bartuc Member

    Joined:
    Jan 9, 2008
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    sometimes I experience same problem. I reboot my webserver and problem goes away.
     
  5. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Have you tried executing /usr/bin/mysql_fix_privilege_tables ?
     
Loading...

Share This Page