Bug 1899052

Summary: InnoDB: WSREP: referenced FK check fail: Lock wait index Export
Product: Red Hat Enterprise Linux 8 Reporter: Michael Bayer <mbayer>
Component: mariadbAssignee: Michal Schorm <mschorm>
Status: CLOSED CURRENTRELEASE QA Contact: RHEL CS Apps Subsystem QE <rhel-cs-apps-subsystem-qe>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 8.6CC: databases-maint, hhorak
Target Milestone: rc   
Target Release: 8.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: mariadb-server-10.3.27-3.module+el8.3.0+8972+5e3224e9 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2021-01-04 11:15:53 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 Michael Bayer 2020-11-18 13:41:31 UTC 
Description of problem:

in openstack we are seeing the impacts of https://jira.mariadb.org/browse/MDEV-18562 , a concerning message in the logs related to WSREP.  it has been fixed in mariadb 10.2.28/10.3.19

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

10.3.17

How reproducible:

varies

Steps to Reproduce:
1. see bz#1898707 for environment information
2.
3.

Actual results:

errors in the log that don't seem to impact the application server:

2020-11-17  6:39:24 171356 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `ix_workers_service_id` table `cinder`.`workers`
2020-11-17  6:39:32 171283 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `ix_workers_service_id` table `cinder`.`workers`
2020-11-17  7:42:46 184320 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `fk_stack_id` table `heat`.`sync_point`
2020-11-17  7:43:00 184585 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `fk_stack_id` table `heat`.`sync_point`
2020-11-17  7:43:24 184648 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `fk_stack_id` table `heat`.`sync_point`
2020-11-17  8:33:44 184050 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `ix_workers_service_id` table `cinder`.`workers`

etc

Expected results:

no error messages in the log

Additional info:
Comment 1 Honza Horak 2021-01-04 11:15:53 UTC 
Advisory RHSA-2020:5500 shipped 10.3.27, so I believe it is now fixed in RHEL-8.3.0.
https://access.redhat.com/errata/RHSA-2020:5500

Please, feel free to re-open if the problem persists.