Checksum validation

[MattKnowles]

One of our servers shutdown when it ran out of memory. Once it was rebooted we went to restart the database and got a couple of errors like the one below:


BROKER 0: (14410) Checksum validation of dbkey 407113024 block type 2 in area 23 does not match data. Expected: -5577 received 21849.


Should we be worried? If so, what do we need to do to rectify it?

Many thanks,

Matt

 

[cj_brandt]

Do you know if you store table or index data in area 23 ? If you only store index data in area 23, you could rebuild your indexes in that area and then run a dbscan or dbrpr.

If you store table data in area 23 and you use after imaging, I would recommend restoring a backup and using AI logs to roll forward to the point right before the server crash. If you don't use After Imaging, you'll have to decide if you want to risk having corrupt blocks in the database or losing the data entered since last backup.