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 started acting up - refused to restart etc..

Discussion in 'General Discussion' started by SupermanInNY, Jan 3, 2006.

  1. SupermanInNY

    SupermanInNY Well-Known Member

    Joined:
    Jul 19, 2003
    Messages:
    255
    Likes Received:
    0
    Trophy Points:
    166
    Last night (around 4AM -oh what a joy) I got calls from clients about sites not pulling up.
    Soon enough I realized that mysql is the culprit.


    This is from the error log:

    1054487 051231 3:34:24 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054488 051231 3:34:25 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054489 051231 3:35:29 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054490 051231 3:35:30 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054491 051231 3:36:26 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054492 051231 3:36:27 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054493 051231 3:36:54 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054494 051231 3:37:01 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054495 051231 3:37:36 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054496 051231 3:37:38 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054497 051231 3:46:41 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054498 051231 3:46:42 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054499 051231 3:46:59 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054500 051231 3:46:59 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054501 051231 3:48:26 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054502 051231 3:48:27 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054503 051231 3:48:56 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054504 051231 3:48:57 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054505 051231 3:49:21 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054506 051231 3:49:22 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054507 051231 3:49:59 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054508 051231 3:49:59 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054509 051231 3:51:01 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054510 051231 3:51:02 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054511 051231 3:51:57 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054512 051231 3:51:58 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054513 051231 3:52:31 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    1054514 051231 3:52:32 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)

    The tables_priv.MYI is having issues.
    What is that?
    I have a lots of lines with that error.

    Any pointers on how to resolve this?

    Thanks,

    -Alon.
     
    #1 SupermanInNY, Jan 3, 2006
    Last edited: Jan 3, 2006
  2. dropby23

    dropby23 Well-Known Member

    Joined:
    Jan 16, 2005
    Messages:
    155
    Likes Received:
    0
    Trophy Points:
    166
    did you try to repair the tables via mysql command line or phpmyadmin
     
  3. SupermanInNY

    SupermanInNY Well-Known Member

    Joined:
    Jul 19, 2003
    Messages:
    255
    Likes Received:
    0
    Trophy Points:
    166
    Table Op Msg_type Msg_text
    mysql.tables_priv repair error Can't open file: 'tables_priv.MYI'. (errno: 138)


    I tried to do that.
    As you can see, this is the mysql table of the mysql database.
     
  4. SupermanInNY

    SupermanInNY Well-Known Member

    Joined:
    Jul 19, 2003
    Messages:
    255
    Likes Received:
    0
    Trophy Points:
    166
    Please check the file permissions you have with the mysql database:





    domainv.com:/var/lib/mysql/mysql => ll
    total 956
    -rw------- 1 mysql mysql 8820 May 30 2005 columns_priv.frm
    -rw------- 1 mysql mysql 0 May 30 2005 columns_priv.MYD
    -rw------- 1 mysql mysql 1024 May 30 2005 columns_priv.MYI
    -rw------- 1 mysql mysql 9178 May 30 2005 db.frm
    -rw------- 1 mysql mysql 356792 Jan 3 16:40 db.MYD
    -rw------- 1 mysql mysql 55296 Jan 3 16:40 db.MYI
    -rw------- 1 mysql mysql 8665 May 30 2005 func.frm
    -rw------- 1 mysql mysql 0 Jun 4 2005 func.MYD
    -rw------- 1 mysql mysql 1024 Jun 4 2005 func.MYI
    -rw------- 1 mysql mysql 8700 May 30 2005 help_category.frm
    -rw------- 1 mysql mysql 868 May 30 2005 help_category.MYD
    -rw------- 1 mysql mysql 3072 May 30 2005 help_category.MYI
    -rw------- 1 mysql mysql 8612 May 30 2005 help_keyword.frm
    -rw------- 1 mysql mysql 7392 May 30 2005 help_keyword.MYD
    -rw------- 1 mysql mysql 13312 May 30 2005 help_keyword.MYI
    -rw------- 1 mysql mysql 8630 May 30 2005 help_relation.frm
    -rw------- 1 mysql mysql 5175 Jun 4 2005 help_relation.MYD
    -rw------- 1 mysql mysql 9216 Jun 4 2005 help_relation.MYI
    -rw------- 1 mysql mysql 8770 May 30 2005 help_topic.frm
    -rw------- 1 mysql mysql 182668 May 30 2005 help_topic.MYD
    -rw------- 1 mysql mysql 15360 May 30 2005 help_topic.MYI
    -rw------- 1 mysql mysql 9148 May 30 2005 host.frm
    -rw------- 1 mysql mysql 0 Jun 4 2005 host.MYD
    -rw-rw---- 1 mysql mysql 1024 Jun 4 2005 host.MYI
    -rw-rw---- 1 mysql mysql 8925 May 30 2005 tables_priv.frm
    -rw-rw---- 1 mysql mysql 17020 May 30 2005 tables_priv.MYD
    -rw-rw---- 1 mysql mysql 5120 May 30 2005 tables_priv.MYI
    -rw------- 1 mysql mysql 8636 May 30 2005 time_zone.frm
    -rw------- 1 mysql mysql 8624 May 30 2005 time_zone_leap_second.frm
    -rw------- 1 mysql mysql 0 Jun 4 2005 time_zone_leap_second.MYD
    -rw------- 1 mysql mysql 1024 Jun 4 2005 time_zone_leap_second.MYI
    -rw------- 1 mysql mysql 0 Jun 4 2005 time_zone.MYD
    -rw------- 1 mysql mysql 1024 Jun 4 2005 time_zone.MYI
    -rw------- 1 mysql mysql 8606 May 30 2005 time_zone_name.frm
    -rw------- 1 mysql mysql 0 May 30 2005 time_zone_name.MYD
    -rw------- 1 mysql mysql 1024 May 30 2005 time_zone_name.MYI
    -rw------- 1 mysql mysql 8686 May 30 2005 time_zone_transition.frm
    -rw------- 1 mysql mysql 0 Jun 4 2005 time_zone_transition.MYD
    -rw------- 1 mysql mysql 1024 Jun 4 2005 time_zone_transition.MYI
    -rw------- 1 mysql mysql 8748 May 30 2005 time_zone_transition_type.frm
    -rw------- 1 mysql mysql 0 Jun 4 2005 time_zone_transition_type.MYD
    -rw------- 1 mysql mysql 1024 Jun 4 2005 time_zone_transition_type.MYI
    -rw------- 1 mysql mysql 9992 May 30 2005 user.frm
    -rw------- 1 mysql mysql 32200 Jan 3 16:40 user.MYD
    -rw------- 1 mysql mysql 15360 Jan 3 16:40 user.MYI


    I changed the permission to chmod 660 for the tables_priv.* hoping this will resolve the issue, and then I restarted the mysql service.

    I just initiated a service mysql restart and see the errors:


    060103 22:33:14 mysqld ended

    060103 22:33:15 mysqld started
    060103 22:33:15 Warning: Asked for 196608 thread stack, but got 126976
    060103 22:33:16 InnoDB: Started
    060103 22:33:16 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    /usr/sbin/mysqld: ready for connections.
    Version: '4.0.25-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 Official MySQL RPM
    060103 22:33:49 /usr/sbin/mysqld: Can't open file: 'columns_priv.MYI'. (errno: 138)
    060103 22:33:49 /usr/sbin/mysqld: Can't open file: 'help_category.MYI'. (errno: 142)
    060103 22:33:49 /usr/sbin/mysqld: Can't open file: 'help_keyword.MYI'. (errno: 142)
    060103 22:33:49 /usr/sbin/mysqld: Can't open file: 'help_topic.MYI'. (errno: 142)
    060103 22:33:49 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
    060103 22:33:49 /usr/sbin/mysqld: Can't open file: 'time_zone_name.MYI'. (errno: 142)


    So, I don't know what to do.

    -Alon.
     
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