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 Errors showing up in logs

Discussion in 'Database Discussions' started by ukgaz, Mar 23, 2011.

  1. ukgaz

    ukgaz Member

    Joined:
    Aug 18, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    Was wondering if anyone has seen these errors before:

    File Location: /usr/local/cpanel/logs/error_log

    DBD::mysql::db do failed: Can't find file: 'servers' (errno: 2) at /usr/local/cpanel/Cpanel/Mysql.pm line 1079.
    DBD::mysql::db do failed: Can't find file: 'servers' (errno: 2) at /usr/local/cpanel/Cpanel/Mysql.pm line 1079.
    [2011-03-23 15:01:06 +0300] warn [cpanel] Cpanel::AdminBin::adminrun(mysql) set error in context mysql
    [2011-03-23 15:01:06 +0300] warn [mysql::initcache] Encountered error in mysql::initcache: Error from mysql wrapper: DBDISKUSED|kkgaz_e107|0

    I'm trying to delete some databases, it confirms delete yet they are still in the list, any suggestions?
     
  2. ukgaz

    ukgaz Member

    Joined:
    Aug 18, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Looks like it is related, I done a tail -f on the error log and the error popped up again when running the delete database command.

    DBD::mysql::db do failed: Can't find file: 'servers' (errno: 2) at /usr/local/cpanel/Cpanel/Mysql.pm line 1079.
    DBD::mysql::db do failed: Can't find file: 'servers' (errno: 2) at /usr/local/cpanel/Cpanel/Mysql.pm line 1079.
    DBD::mysql::st execute failed: There is no such grant defined for user 'kkgaz_e107' on host 'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 1154.
    DBD::mysql::st execute failed: There is no such grant defined for user 'kkgaz_e107556' on host 'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 1154.
    DBD::mysql::db do failed: Can't find file: 'servers' (errno: 2) at /usr/local/cpanel/Cpanel/Mysql.pm line 1079.
    DBD::mysql::db do failed: Can't find file: 'servers' (errno: 2) at /usr/local/cpanel/Cpanel/Mysql.pm line 1079.
    [2011-03-23 15:12:50 +0000] warn [cpanel] Cpanel::AdminBin::adminrun(mysql) set error in context mysql
    [2011-03-23 15:12:50 +0000] warn [mysql::initcache] Encountered error in mysql::initcache: Error from mysql wrapper: DBDISKUSED|kkgaz_e107|0
     
  3. ukgaz

    ukgaz Member

    Joined:
    Aug 18, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
  4. ukgaz

    ukgaz Member

    Joined:
    Aug 18, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Nope, didn't work
     
  5. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hello ukgaz,

    It appears you've opened up a ticket (1304525) on our system about this issue today. If you can update us to the results of the ticket on completion.

    Thanks.
     
  6. ukgaz

    ukgaz Member

    Joined:
    Aug 18, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Will do, hopefully your guys will find a solution :)
     
  7. ukgaz

    ukgaz Member

    Joined:
    Aug 18, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Ok first we checked the privilege tables we're all ok with

    mysql_fix_privilege_tables --password=[YOUR PASSWORD] --verbose

    Then your guys restored /var/lib/mysql/mysql/servers.MYI and MYD as these we're not there for some strange reason, so in this case people with this issue may be better of raising a ticket with cpanel unless /scripts/mysqlup --force could fix this
     
Loading...

Share This Page