LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices



Reply
 
Search this Thread
Old 08-08-2006, 06:38 AM   #1
guarriman
Member
 
Registered: Nov 2004
Posts: 101

Rep: Reputation: 15
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,
 
Old 08-08-2006, 07:10 AM   #2
dambla
Member
 
Registered: Aug 2006
Posts: 51

Rep: Reputation: 15
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
 
Old 08-08-2006, 11:34 AM   #3
guarriman
Member
 
Registered: Nov 2004
Posts: 101

Original Poster
Rep: Reputation: 15
Hi dambla,

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

Regards,
 
Old 08-08-2006, 01:14 PM   #4
dambla
Member
 
Registered: Aug 2006
Posts: 51

Rep: Reputation: 15
I honestly doubt it. post /var/log/syslog please.
 
Old 08-08-2006, 04:35 PM   #5
closet geek
Member
 
Registered: Apr 2003
Location: England
Posts: 146

Rep: Reputation: 15
Hi,

Just run the REPAIR command on the table:

mysql> REPAIR TABLE name USE_FRM;

cg

Last edited by closet geek; 08-08-2006 at 04:36 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
NFS problems - "/usr/sbin/exportfs" just hangs meeble Linux - Networking 4 07-03-2008 08:14 AM
Samba --> nobody run "add user script = /usr/sbin/useradd ....." ??!! Unconfigured Fedora 1 02-23-2006 05:54 AM
Samba --> nobody run "add user script = /usr/sbin/useradd %u ....." ???? Unconfigured Linux - Software 1 02-21-2006 10:01 AM
"**** /sbin/dhcpcd: not running" messages on shutdown/reboot Nylex Slackware 2 01-22-2006 10:12 AM


All times are GMT -5. The time now is 07:13 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration