Bug 2169149

Summary: [16.1] [ERROR] InnoDB: Clustered record for sec rec not found index `instances_project_id_deleted_idx` of table `nova_cell0`.`instances`
Product: Red Hat OpenStack Reporter: Joaquín Veira <jveiraca>
Component: mariadb-galeraAssignee: Damien Ciabrini <dciabrin>
Status: CLOSED NOTABUG QA Contact: pkomarov
Severity: high Docs Contact:
Priority: high    
Version: 16.1 (Train)CC: chjones, lmiccini, mbayer, mwitt
Target Milestone: ---Keywords: Triaged
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2023-08-11 14:46:20 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Joaquín Veira 2023-02-12 08:57:48 UTC
Description of problem:
This is a large deployment with thousands of instances being created and destroyed every day and DB independent nodes.
Since upgrade to 16.1.9 they're seeing these errors on mysql logs from DB nodes.

Version-Release number of selected component (if applicable):
RHOSP 16.1.9

How reproducible:
Ugrade to 16.1.9

Actual results:
Errors with index in mysql logs

Expected results:
No errors

Additional info:
In next updates and there are sosreports and DB dumps attached to the case in the portal