Comment 16 for bug 1991222

Hi,

I am facing similar issue in my xena and yoga deployments. I am using percona xtradb cluster 8.0 and seeing these errors on different neutron tables.

2022-04-04T15:39:17.342175+05:00 187579 [ERROR] [MY-011825] [InnoDB] WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron_ml2`.`portsecuritybindings`
2022-04-05T14:18:19.801183+05:00 275503 [ERROR] [MY-011825] [InnoDB] WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron_ml2`.`ml2_port_binding_levels`
2022-04-19T11:13:26.063954+05:00 400458 [ERROR] [MY-011825] [InnoDB] WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron_ml2`.`portsecuritybindings`
2022-04-25T13:17:08.562935+05:00 919410 [ERROR] [MY-011825] [InnoDB] WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron_ml2`.`ml2_port_bindings`
2022-04-26T14:58:36.891617+05:00 1028780 [ERROR] [MY-011825] [InnoDB] WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron_ml2`.`portsecuritybindings`
2022-05-11T22:31:12.693103+05:00 2509379 [ERROR] [MY-011825] [InnoDB] WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron_ml2`.`provisioningblocks`
2022-05-12T10:46:48.540775+05:00 2540522 [ERROR] [MY-011825] [InnoDB] WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron_ml2`.`provisioningblocks`
2022-05-12T11:15:44.698450+05:00 2540497 [ERROR] [MY-011825] [InnoDB] WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron_ml2`.`portsecuritybindings`
2022-05-12T11:18:47.129934+05:00 2543106 [ERROR] [MY-011825] [InnoDB] WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron_ml2`.`securitygroupportbindings`

I have once opened it on percona forum here https://forums.percona.com/t/wsrep-referenced-fk-check-fail/13958