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 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:
    16
    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:
    16
    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:
    16
    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:
    16
    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