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

Issues related to applications and software problems
Post Reply
exop
Posts: 3
Joined: 2018/08/28 13:02:34

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

Post by exop » 2019/09/16 16:28:03

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
2019-09-16 18_23_56-Window.png (82.94 KiB) Viewed 574 times

User avatar
TrevorH
Forum Moderator
Posts: 27125
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

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

Post by TrevorH » 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.
CentOS 6 will die in November 2020 - migrate sooner rather than later!
CentOS 5 has been EOL for nearly 3 years and should no longer be used for anything!
Full time Geek, part time moderator. Use the FAQ Luke

exop
Posts: 3
Joined: 2018/08/28 13:02:34

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

Post by exop » 2019/09/17 08:59:03

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,

User avatar
avij
Retired Moderator
Posts: 3039
Joined: 2010/12/01 19:25:52
Location: Helsinki, Finland
Contact:

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

Post by avij » 2019/09/17 10:29:01

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.

Post Reply

Return to “CentOS 6 - Software Support”