Open Stack

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 :

http://lists.openstack.org/pipermail/openstack-discuss/2020-May/014928.html

So, it seems it is mariadb issue, but it should be fixed in version which I
am using

root at controller0:/home/ubuntu# docker exec -itu root mariadb bash
(mariadb)[root at 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)


Michal Arbet
Openstack Engineer

Ultimum Technologies a.s.
Na Poříčí 1047/26, 11000 Praha 1
Czech Republic

+420 604 228 897
michal.arbet at ultimum.io
*https://ultimum.io <https://ultimum.io/>*

LinkedIn <https://www.linkedin.com/company/ultimum-technologies> | Twitter
<https://twitter.com/ultimumtech> | Facebook
<https://www.facebook.com/ultimumtechnologies/timeline>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20210713/58514b9d/attachment.html>