hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Can't touch two files.. i/o errors!
Reply

Forum Jump

Can't touch two files.. i/o errors!

Reply Post New Thread In Hosting Security and Technology Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 12-19-2006, 03:04 PM
Dan Grossman Dan Grossman is offline
Web Hosting Master
 
Join Date: Oct 2003
Posts: 1,479

Can't touch two files.. i/o errors!


In one of my MySQL databases, I have several thousand tables. MySQL stores each table as a separate file (well, files). I noticed in my normal routine of running mysqlcheck over the database that two had become corrupted, which isn't that unusual. It happens.

Usually I just run mysqlcheck --repair on the table, it fixes it, and I move on. That didn't work. OK, next step, I shut down MySQL and run myisamchk on the table file, that *always* fixes it. No good, gives me an error writing to the file I've never seen before.

Then I go and see if I can copy the file out and take a look at it alone. I try moving one of the two corrupted table files:

Code:
cp: reading `counter_premium/_3928_log.MYI': Input/output error
What could mess up two individual files so bad that they give I/O errors?

__________________
Dan Grossman - dan @ awio.com
My Blog | Affiliate Program for Web Hosts



Sponsored Links
  #2  
Old 12-19-2006, 03:34 PM
Scott.Mc Scott.Mc is offline
Engineer
 
Join Date: Jan 2005
Location: Scotland, UK
Posts: 2,522
If you are getting I/O errors it's possible there is something wrong with that partition, I suggest you back it up first and then fsck it. It's highly likely that you may even loose those files(well they may be somewhere in lost+found).

-Scott

__________________
Server Management - AdminGeekZ.com
Infrastructure Management, Web Application Performance, mySQL DBA. System Automation.
WordPress/Magento Performance, Apache to Nginx Conversion, Varnish Implimentation, DDoS Protection, Custom Nginx Modules
Check our wordpress varnish plugin. Contact us for quote: sales@admingeekz.com

  #3  
Old 12-19-2006, 03:47 PM
Rus Foster Rus Foster is offline
Web Hosting Master
 
Join Date: Jun 2003
Location: UK
Posts: 6,587
If you run dmesg is there aything obvious in there?

__________________
Rus Foster - Director of Cloud @ UK2 Group
VPS.net - True Cloud Hosting powered by OnApp and HP SANS
Tel: +447714137805 | Email: rghf@uk2group.com

Sponsored Links
  #4  
Old 12-19-2006, 04:07 PM
Dan Grossman Dan Grossman is offline
Web Hosting Master
 
Join Date: Oct 2003
Posts: 1,479
Quote:
Originally Posted by Scott.Mc
If you are getting I/O errors it's possible there is something wrong with that partition, I suggest you back it up first and then fsck it. It's highly likely that you may even loose those files(well they may be somewhere in lost+found).

-Scott
Thanks for the tips. This drive is just a single large partition. Is it safe to run fsck on it while in use? If not, what's the best way to do so?

__________________
Dan Grossman - dan @ awio.com
My Blog | Affiliate Program for Web Hosts

  #5  
Old 12-19-2006, 04:11 PM
Rus Foster Rus Foster is offline
Web Hosting Master
 
Join Date: Jun 2003
Location: UK
Posts: 6,587
You can't do a live fsck it has to be taken down to single user mode. I would do a full backup right now before doing anything else

__________________
Rus Foster - Director of Cloud @ UK2 Group
VPS.net - True Cloud Hosting powered by OnApp and HP SANS
Tel: +447714137805 | Email: rghf@uk2group.com

  #6  
Old 12-19-2006, 04:14 PM
Dan Grossman Dan Grossman is offline
Web Hosting Master
 
Join Date: Oct 2003
Posts: 1,479
Quote:
Originally Posted by a2b2
You can't do a live fsck it has to be taken down to single user mode. I would do a full backup right now before doing anything else
And how do I do that without physical access?

__________________
Dan Grossman - dan @ awio.com
My Blog | Affiliate Program for Web Hosts

  #7  
Old 12-19-2006, 04:24 PM
Rus Foster Rus Foster is offline
Web Hosting Master
 
Join Date: Jun 2003
Location: UK
Posts: 6,587
Is it just those files that are playing up or are there other. Hit me up on AIM (a2b2support) and happy to guide you through it

__________________
Rus Foster - Director of Cloud @ UK2 Group
VPS.net - True Cloud Hosting powered by OnApp and HP SANS
Tel: +447714137805 | Email: rghf@uk2group.com

Reply

Related posts from TheWhir.com
Title Type Date Posted
Dropbox Suffers Temporary Outage Impacting File Sharing and Synchronizing Web Hosting News 2014-03-14 12:11:46
The Pirate Bay Uploads Continue to Grow Despite Anti-Piracy Pressure Web Hosting News 2013-12-31 11:33:12
Egnyte Synchronizes Google Drive with Private Cloud Storage Web Hosting News 2013-07-17 12:36:21
Malwarebytes Launches Data Scan-and-Backup Service Web Hosting News 2013-05-07 14:51:03
Court Documents Show Megaupload Helped Feds Take Down File Sharing Service NinjaVideo Web Hosting News 2012-11-21 10:53:49


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

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

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?