Page 1 of 1
Mysql crash - Status: { DRDY ERR } error: {IDNF}
Posted: 2019/09/16 16:28:03
by 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 1997 times
Re: Mysql crash - Status: { DRDY ERR } error: {IDNF}
Posted: 2019/09/16 16:57:42
by 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.
Re: Mysql crash - Status: { DRDY ERR } error: {IDNF}
Posted: 2019/09/17 08:59:03
by exop
I fixed my problem.
TrevorH wrote: ↑2019/09/16 16:57:42
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,
Re: Mysql crash - Status: { DRDY ERR } error: {IDNF}
Posted: 2019/09/17 10:29:01
by 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.