Mariadb may fail to start during upgrades due to outdated package

[Andrew Bonney]

When upgrading from Zed to Antelope we encountered the following from the first Galera node:

[Warning] WSREP: Support for allowlist service v1 wsrep_init_allowlist_service_v1 not found from provider: /usr/lib/galera/libgalera_smm.so: undefined symbol: wsrep_init_allowlist_service_v1
[Warning] WSREP: Provider does not support allowlist service v1
[ERROR] WSREP: Failed to create a new provider '/usr/lib/galera/libgalera_smm.so' with options 'gcache.size = 1024M; gmcast.listen_addr = tcp://<ip:<port>': Failed to initialize allowlist service
[ERROR] WSREP: Failed to load provider

It appears that /usr/lib/galera/libgalera_smm.so is provided by the galera-4 package which is not uninstalled/re-installed during the upgrade process. As such our version was significantly behind where it should have been, and was incompatible with the upgraded mariadb binaries.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/openstack-ansible-galera_server/+/890787

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/openstack-ansible-galera_server/+/890787
Committed: https://opendev.org/openstack/openstack-ansible-galera_server/commit/27cd830c654dc7dbb8930d208cfbcebf72637503
Submitter: "Zuul (22348)"
Branch: master

commit 27cd830c654dc7dbb8930d208cfbcebf72637503
Author: Andrew Bonney <email address hidden>
Date: Tue Aug 8 13:33:26 2023 +0100

    Remove galera-4 package during upgrades to force version up

    Current upgrades leave the galera-4 package in place which
    can cause incompatibilities when the mariadb binaries are
    updated.

    By forcing removal of this package during upgrades it should
    be re-installed with a version matching the rest of the
    mariadb packages.

    RHEL distros already have a removal step for galera-*

    Change-Id: I99d993a7c466cb744136bd06f4ab2e21c2569151
    Closes-Bug: #2028946

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/2023.1
Review: https://review.opendev.org/c/openstack/openstack-ansible-galera_server/+/892879

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/openstack-ansible-galera_server/+/892879
Committed: https://opendev.org/openstack/openstack-ansible-galera_server/commit/da20aed93e6cdd2c52a72cd1bcb78fb10eef701e
Submitter: "Zuul (22348)"
Branch: stable/2023.1

commit da20aed93e6cdd2c52a72cd1bcb78fb10eef701e
Author: Andrew Bonney <email address hidden>
Date: Tue Aug 8 13:33:26 2023 +0100

    Remove galera-4 package during upgrades to force version up

    Current upgrades leave the galera-4 package in place which
    can cause incompatibilities when the mariadb binaries are
    updated.

    By forcing removal of this package during upgrades it should
    be re-installed with a version matching the rest of the
    mariadb packages.

    RHEL distros already have a removal step for galera-*

    Change-Id: I99d993a7c466cb744136bd06f4ab2e21c2569151
    Closes-Bug: #2028946
    (cherry picked from commit 27cd830c654dc7dbb8930d208cfbcebf72637503)