Hi,
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:
/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`
/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`
/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`
/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`
/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`
/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`
/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`
/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`
/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`
/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`
/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`
/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`
/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`
/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`
I found some info in openstack-discuss below :
So, it seems it is mariadb issue, but it should be fixed in version which I am using
root@controller0:/home/ubuntu# docker exec -itu root mariadb bash
(mariadb)[root@controller0 /]# dpkg -l | grep mariadb
ii libmariadb3:amd64 1:10.5.10-2 amd64 MariaDB database client library
ii mariadb-backup 1:10.5.10-2 amd64 Backup tool for MariaDB server
ii mariadb-client 1:10.5.10-2 all MariaDB database client (metapackage depending on the latest version)
ii mariadb-client-10.5 1:10.5.10-2 amd64 MariaDB database client binaries
ii mariadb-client-core-10.5 1:10.5.10-2 amd64 MariaDB database core client binaries
ii mariadb-common 1:10.5.10-2 all MariaDB common configuration files
ii mariadb-server 1:10.5.10-2 all MariaDB database server (metapackage depending on the latest version)
ii mariadb-server-10.5 1:10.5.10-2 amd64 MariaDB database server binaries
ii mariadb-server-core-10.5 1:10.5.10-2 amd64 MariaDB database core server files
So, is it really mariadb issue or neutron ?
No similar log from other services in mariadb log.
Thanks,
Michal Arbet (kevko)
