MySQL DBA - Tips and Techniques Magazine

11 Nov 2014

Resolving ‘Can't open file:’…..’ (errno: 145)’ errors

Error log is full of errors, similar to

 

090108  9:32:06 [ERROR] /usr/libexec/mysqld: Can't open file: 'RPT_TR.MYI' (errno: 145)

090108  9:32:06 [ERROR] /usr/libexec/mysqld: Can't open file: 'RPT_TR.MYI' (errno: 145)

090108  9:32:06 [ERROR] /usr/libexec/mysqld: Can't open file: 'RPT_TR.MYI' (errno: 145)

090108  9:32:06 [ERROR] /usr/libexec/mysqld: Can't open file: 'RPT_TR.MYI' (errno: 145)

 


Try to repair this MyISAM table

 

            Logon to mysql, may get message saying other tables are corrupt, e.g.

 

                        Didn't find any fields in table 'RPT_LUR'

                        Didn't find any fields in table 'RPT_TR'

 

            Repair the tables

 

                        mysql> repair table RPT_TR;

 

                        mysql> repair table RPT_LUR;

 

                        could take a long time, also need to have enough space in the filesystem to recreate the MYD file

No comments:

Post a comment