fail to cluster mariadb when running ansible on one node

[Seena Fallah]

In the case of running MariaDB role on one host using --limit flag the wsrep_cluster_address will be empty and MariaDB can't be a cluster.

[Mark Goddard (mgoddard)]

This bug report doesn't really describe the user-visible effects of the issue.

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/kolla-ansible/+/814276
Committed: https://opendev.org/openstack/kolla-ansible/commit/68cd2a055371cc25a0502ff4db22fbcdececd478
Submitter: "Zuul (22348)"
Branch: master

commit 68cd2a055371cc25a0502ff4db22fbcdececd478
Author: Seena Fallah <email address hidden>
Date: Sat Oct 16 22:34:21 2021 +0330

    mariadb: use add_host to include inactive hosts in shard grouping

    In case of running mariadb role with --limit the group_by module will only include the limited hosts and other hosts that are not limited by ansible will not be included.
    Using add_host will add all hosts in mariadb group to their shards group

    Signed-off-by: Seena Fallah <email address hidden>
    Change-Id: I1331698e313bd714a16fc35f38fb579d75b56370
    Closes-Bug: #1947589

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/xena
Review: https://review.opendev.org/c/openstack/kolla-ansible/+/816652

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/wallaby
Review: https://review.opendev.org/c/openstack/kolla-ansible/+/816653

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/kolla-ansible/+/816652
Committed: https://opendev.org/openstack/kolla-ansible/commit/06218e2642714250f941927849cbab29d3898467
Submitter: "Zuul (22348)"
Branch: stable/xena

commit 06218e2642714250f941927849cbab29d3898467
Author: Seena Fallah <email address hidden>
Date: Sat Oct 16 22:34:21 2021 +0330

    mariadb: use add_host to include inactive hosts in shard grouping

    In case of running mariadb role with --limit the group_by module will only include the limited hosts and other hosts that are not limited by ansible will not be included.
    Using add_host will add all hosts in mariadb group to their shards group

    Signed-off-by: Seena Fallah <email address hidden>
    Change-Id: I1331698e313bd714a16fc35f38fb579d75b56370
    Closes-Bug: #1947589
    (cherry picked from commit 68cd2a055371cc25a0502ff4db22fbcdececd478)

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/kolla-ansible/+/816653
Committed: https://opendev.org/openstack/kolla-ansible/commit/c6b27b2a8db9db59e0672074ce0971f318074008
Submitter: "Zuul (22348)"
Branch: stable/wallaby

commit c6b27b2a8db9db59e0672074ce0971f318074008
Author: Seena Fallah <email address hidden>
Date: Sat Oct 16 22:34:21 2021 +0330

    mariadb: use add_host to include inactive hosts in shard grouping

    In case of running mariadb role with --limit the group_by module will only include the limited hosts and other hosts that are not limited by ansible will not be included.
    Using add_host will add all hosts in mariadb group to their shards group

    Signed-off-by: Seena Fallah <email address hidden>
    Change-Id: I1331698e313bd714a16fc35f38fb579d75b56370
    Closes-Bug: #1947589
    (cherry picked from commit 68cd2a055371cc25a0502ff4db22fbcdececd478)

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/kolla-ansible 13.0.0.0rc2 release candidate.

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/kolla-ansible 12.3.0 release.

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/kolla-ansible 14.0.0.0rc1 release candidate.