Bug #116864 Index corruption
Submitted: 4 Dec 2024 7:43 Modified: 4 Jan 11:48
Reporter: Amol Kulkarni Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:8.0.35 OS:Any
Assigned to: MySQL Verification Team CPU Architecture:Any

[4 Dec 2024 7:43] Amol Kulkarni
Description:
Hi,

In one of my project I am using mysql db v8.0.35 where we faced index corruption issue. Our most recent backup file was also not worked because of same. I want to understand is this condition raised in case of disabling SQL_SAFE_UPDATES feature. while some query execution our developer has disabled it as it was not allowed some bulk delete operation.

How to repeat:
Its random & we have faced this first time so don't know the steps to reproduce it.
[4 Dec 2024 11:48] MySQL Verification Team
Hi,

You need to explain the problem in more details. Index corruption on InnoDB tables in 99% cases happens because of faulty hardware.

Furthermore, you are using rather old release, please upgrade to .40 and see if that helps.

Thank you for using MySQL Server
[5 Jan 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".