LinuxQuestions.org

LinuxQuestions.org (http://www.linuxquestions.org/questions/index.php)
-   Linux - Software (http://www.linuxquestions.org/questions/forumdisplay.php?f=2)
-   -   Reboot and "/usr/sbin/mysqld: Can't open file: 'my_table.MYI'" message (http://www.linuxquestions.org/questions/showthread.php?t=471911)

guarriman 08-08-2006 05:38 AM

Reboot and "/usr/sbin/mysqld: Can't open file: 'my_table.MYI'" message
 
Hi.

My FC2 server has just restarted due to memory problems.

Browsing mySQL logs, I've found out 5,000 lines like these in less than one hour:
--------------
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file: 'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file: 'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file: 'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file: 'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file: 'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file: 'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file: 'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file: 'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file: 'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file: 'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file: 'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file: 'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file: 'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file: 'my_table.MYI' (errno: 145)
----------------

Can this be the reason of the server reboot?

This is /var/logs/messages:
---------
Aug 8 1:40:02 www kernel: oom-killer: gfp_mask=0x1d2
Aug 8 1:41:43 www kernel: DMA per-cpu:
Aug 8 1:42:33 www kernel: cpu 0 hot: low 2, high 6, batch 1
Aug 8 1:42:55 www kernel: cpu 0 cold: low 0, high 2, batch 1
----------

Thank you very much in advance,

dambla 08-08-2006 06:10 AM

found this site that provides support for some app but also reffers to errno 145 in mysql. http://support.discusware.com/center.../mysql145.html . good luck

guarriman 08-08-2006 10:34 AM

Hi dambla,

Thank you very much for your answer, but could this issue make my Linux machine reboot?

Regards,

dambla 08-08-2006 12:14 PM

I honestly doubt it. post /var/log/syslog please.

closet geek 08-08-2006 03:35 PM

Hi,

Just run the REPAIR command on the table:

mysql> REPAIR TABLE name USE_FRM;

cg


All times are GMT -5. The time now is 03:06 AM.