Mysql crash - Status: { DRDY ERR } error: {IDNF}

[exop]

Hello,

My mySQL server crashed today because of a corrupted physical disk.
I changed the disk and we could rebuild it with the raid 10.

But the error is still here.

Any idea?

2019-09-16 18_23_56-Window.png (82.94 KiB) Viewed 2001 times

[TrevorH]

I'd say you either replaced the wrong disk or you have a second dead one.

No idea why you considered it necessary to obscure parts of the error messages. Even the hostname isn't exactly sensitive information.

[exop]

I fixed my problem.

I'd say you either replaced the wrong disk or you have a second dead one.

No idea why you considered it necessary to obscure parts of the error messages. Even the hostname isn't exactly sensitive information.

It was not a problem with the new disk.

It was an IDB file that was damaged by the first disk problem that was blocking the mysql service to restart.
Restoring the file with the associated RFM file solved the problem.

thanks anyway.

Sincerely,

[avij]

The errors you saw were hardware errors. When you restored the file from backup the file got probably written to a different part of the disk. It would be a good idea to do a read test of your RAID array, like with dd if=/dev/sda of=/dev/null bs=1048576 conv=sync,noerror. It is possible that there are still unreadable sectors on your RAID array.