kernel: sd 0:0:0:0: SCSI error: return code = 0x08000002

[javad-afzal]

Hi
can any body help me with this, will be thank full


kernel: sd 0:0:0:0: SCSI error: return code = 0x08000002
kernel: sda: Current: sense key: Medium Error
kernel: Add. Sense: Read retries exhausted
kernel:
kernel: Info fld=0x855de86
kernel: end_request: I/O error, dev sda, sector 139845254

[Irithori]

The disk sda seems broken.
If this is a raid >= 1 then find out the exact disk via the raidtools and replace it,
if not, try to safe as much data as possible before you replace th disk.

[javad-afzal]

i just have only 1 drive which is sda, there is no other hardrive present... everything works fine except i cannot repair the sql database present in it.. whenever i try to repair the database it gives error "end_request: I/O error, dev sda, sector 139845254"

[Irithori]

Again: Because the disk sda is broken.
You need to
- copy any unsaved data (if still possible)
- replace the disk
- restore data

[javad-afzal]

thanks bro
but i was wondering if there is a way as if i take data on that sector and put it on some other sector.... coz it is still working fine from 3 to 4 days as i rebooted the system several times...

[Irithori]

Modern harddiscs do that on their own. To a certain degree.
But once these sector errors appear on OS level (ie: the disc logic cannot deal with them anymore), it is urgent to get a new disc.
You can check before and periodically by monitoring S.M.A.R.T.
It enables you to act before data gets corrupted.
Also: A raid would have avoided reinstall/restore from backup.

The disc will not magically heal. If anything, it will get worse.
Your backup works, right?

[javad-afzal]

thanks again Bro for your precious time...
my backup will not work on new HDD i have to reinstall it all thats why i m curious to make this HDD work fine. i searched alot about it, i have found these
sg_verify: to check for the health of a sector
sg_reassign: to remap a dead sector to one from the good sector list

but i dont know how to work around it...
the link for aabove article is as follows.
masterzen.fr/2009/02/01/the-curse-of-bad-blocks-is-no-more/

[Irithori]

I believe, this procedure will only have a temporary effect.
And a chance of further damage.

You say, you have a backup.
In this situation, I would kickstart a new machine and restore the data there.

[javad-afzal]

what about smartmontools? will they work for this situation or anything is helpless...........?