<div dir="ltr">Hi,<div><br></div><div>I have wallaby deployed via kolla-ansible and  from time to time see this in mariadb log  while i'm running tempest tests against wallaby: </div><div><br></div>/var/log/kolla/mariadb/mariadb.log:2021-07-13  9:09:17 838 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron`.`provisioningblocks`<br>/var/log/kolla/mariadb/mariadb.log:2021-07-13  9:10:02 841 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron`.`provisioningblocks`<br>/var/log/kolla/mariadb/mariadb.log:2021-07-13  9:10:13 836 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron`.`provisioningblocks`<br>/var/log/kolla/mariadb/mariadb.log:2021-07-13  9:10:37 841 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron`.`provisioningblocks`<br>/var/log/kolla/mariadb/mariadb.log:2021-07-13  9:13:29 813 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron`.`provisioningblocks`<br>/var/log/kolla/mariadb/mariadb.log:2021-07-13  9:13:37 854 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron`.`provisioningblocks`<br>/var/log/kolla/mariadb/mariadb.log:2021-07-13  9:16:45 845 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron`.`provisioningblocks`<br>/var/log/kolla/mariadb/mariadb.log:2021-07-13  9:25:41 838 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron`.`portsecuritybindings`<br>/var/log/kolla/mariadb/mariadb.log:2021-07-13  9:26:30 838 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron`.`provisioningblocks`<br>/var/log/kolla/mariadb/mariadb.log:2021-07-13  9:27:14 827 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron`.`provisioningblocks`<br>/var/log/kolla/mariadb/mariadb.log:2021-07-13  9:27:38 866 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron`.`provisioningblocks`<br>/var/log/kolla/mariadb/mariadb.log:2021-07-13  9:28:28 846 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron`.`provisioningblocks`<br>/var/log/kolla/mariadb/mariadb.log:2021-07-13  9:29:27 840 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron`.`provisioningblocks`<br>/var/log/kolla/mariadb/mariadb.log:2021-07-13  9:43:39 842 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `neutron`.`provisioningblocks`<br><div><br></div><div><br></div><div>I found some info in openstack-discuss below : </div><div><br></div><div><a href="http://lists.openstack.org/pipermail/openstack-discuss/2020-May/014928.html">http://lists.openstack.org/pipermail/openstack-discuss/2020-May/014928.html</a></div><div><br></div><div>So, it seems it is mariadb issue, but it should be fixed in version which I am using  </div><div><br></div><div>root@controller0:/home/ubuntu# docker exec -itu root mariadb bash<br>(mariadb)[root@controller0 /]# dpkg -l | grep mariadb<br>ii  libmariadb3:amd64              1:10.5.10-2                    amd64        MariaDB database client library<br>ii  mariadb-backup                 1:10.5.10-2                    amd64        Backup tool for MariaDB server<br>ii  mariadb-client                 1:10.5.10-2                    all          MariaDB database client (metapackage depending on the latest version)<br>ii  mariadb-client-10.5            1:10.5.10-2                    amd64        MariaDB database client binaries<br>ii  mariadb-client-core-10.5       1:10.5.10-2                    amd64        MariaDB database core client binaries<br>ii  mariadb-common                 1:10.5.10-2                    all          MariaDB common configuration files<br>ii  mariadb-server                 1:10.5.10-2                    all          MariaDB database server (metapackage depending on the latest version)<br>ii  mariadb-server-10.5            1:10.5.10-2                    amd64        MariaDB database server binaries<br>ii  mariadb-server-core-10.5       1:10.5.10-2                    amd64        MariaDB database core server files<br></div><div><br></div><div>So, is it really mariadb issue or neutron ? </div><div>No similar log from other services in mariadb log.</div><div><br></div><div>Thanks,</div><div>Michal Arbet (kevko)</div><div><br></div><div><br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div style="margin:0px;padding:0px 0px 20px;width:1503px;color:rgb(34,34,34);font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:medium"><div style="margin:8px 0px 0px;padding:0px"><div dir="ltr"><span><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:small"><span style="color:rgb(136,136,136);vertical-align:top;line-height:18px;font-size:11pt;font-family:Arial,Helvetica,Geneva;font-weight:bold">Michal Arbet<br></span><span style="color:rgb(136,136,136);font-size:10pt;vertical-align:top;line-height:18px;font-family:Arial,Helvetica,Geneva">Openstack Engineer<br><img src="https://www.google.com/a/ultimum.io/images/logo.gif" width="200" height="81"><br>Ultimum Technologies a.s.<br>Na Poříčí 1047/26, 11000 Praha 1<br>Czech Republic<br><br><a value="+420608314961" style="color:rgb(17,85,204)">+420 604 228 897</a> <br><a href="mailto:michal.arbet@ultimum.io" style="color:rgb(17,85,204)" target="_blank">michal.arbet@ultimum.io</a><br></span><font color="#1155cc" face="Arial, Helvetica, Geneva" style="font-size:12.8px"><span style="font-size:13.3333px;line-height:18px"><u><a href="https://ultimum.io/" style="color:rgb(17,85,204)" target="_blank">https://ultimum.io</a></u></span></font><br></div><div dir="ltr" style="font-family:Arial,Helvetica,sans-serif;font-size:small"><font color="#1155cc" face="Arial, Helvetica, Geneva" style="font-size:12.8px"><span style="font-size:13.3333px;line-height:18px"><br></span></font></div><div style="font-family:Arial,Helvetica,sans-serif;font-size:small"><font color="#666666"><a href="https://www.linkedin.com/company/ultimum-technologies" style="color:rgb(17,85,204)" target="_blank">LinkedIn</a> | <a href="https://twitter.com/ultimumtech" style="color:rgb(17,85,204)" target="_blank">Twitter</a> | <a href="https://www.facebook.com/ultimumtechnologies/timeline" style="color:rgb(17,85,204)" target="_blank">Facebook</a></font></div></div></div></div></div></div></div></div></span></div></div><div><div></div><div><div></div></div></div><div></div></div></div></div></div></div></div>