keystone: disable log_bin_trust_function_creators function task is skipped

Bug #1987982 reported by Lin PeiWen
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
kolla-ansible
Fix Released
Undecided
Unassigned

Bug Description

**Bug Report**

When multiple control nodes upgrade the keystone role,disable log_bin_trust_function_creators function task is skipped

# kolla-ansible -i /mnt/multinode upgrade --tag=keystone
RUNNING HANDLER [keystone : Init keystone database upgrade] *********************************************************************************************
changed: [192.168.56.201]

RUNNING HANDLER [keystone : Finish keystone database upgrade] *******************************************************************************************
changed: [192.168.56.205]

TASK [keystone : Disable log_bin_trust_function_creators function] ************************************************************************
skipping: [192.168.56.201]

What you expected to happen:

After performing a keystone upgrade, the database setting should be "log_bin_trust_function_creators | OFF", not "log_bin_trust_function_creators | ON"

How to reproduce it (minimal and precise):
In a multi-controller node environment, execute the following command
# kolla-ansible -i /mnt/multinode upgrade --tag=keystone

**Environment**:
OS:Centos 8
Kernel :4.18.0-193.el8.x86_64
Kolla-Ansible version: master
docker-ce:20.10.11

Changed in kolla-ansible:
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to kolla-ansible (master)

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

commit aa80f81d304c4734f8556740871d57d86f0190f7
Author: LinPeiWen <email address hidden>
Date: Wed Aug 10 21:02:10 2022 +0800

    keystone: Remove redundant 'when'

    In a multi-controller node, the presence of "run_once: True"
    and "when: inventory_hostname == groups['keystone'][-1]"
    will cause the task to be skipped

    Closes-Bug: #1987982

    Change-Id: I6a8f4ca285cda0675711b631aeed7ae4c992d879

Changed in kolla-ansible:
status: In Progress → Fix Released
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla-ansible (stable/yoga)

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla-ansible (stable/xena)

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla-ansible (stable/wallaby)

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla-ansible (stable/victoria)

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla-ansible (stable/ussuri)

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to kolla-ansible (stable/ussuri)

Reviewed: https://review.opendev.org/c/openstack/kolla-ansible/+/855244
Committed: https://opendev.org/openstack/kolla-ansible/commit/4e4795909f313111d0f59762cc77d15ad05cb844
Submitter: "Zuul (22348)"
Branch: stable/ussuri

commit 4e4795909f313111d0f59762cc77d15ad05cb844
Author: LinPeiWen <email address hidden>
Date: Wed Aug 10 21:02:10 2022 +0800

    keystone: Remove redundant 'when'

    In a multi-controller node, the presence of "run_once: True"
    and "when: inventory_hostname == groups['keystone'][-1]"
    will cause the task to be skipped

    Closes-Bug: #1987982

    Change-Id: I6a8f4ca285cda0675711b631aeed7ae4c992d879
    (cherry picked from commit aa80f81d304c4734f8556740871d57d86f0190f7)

tags: added: in-stable-ussuri
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to kolla-ansible (stable/yoga)

Reviewed: https://review.opendev.org/c/openstack/kolla-ansible/+/855240
Committed: https://opendev.org/openstack/kolla-ansible/commit/3558ba61c707bd71ce1fd1cd7e6719ac5d878a51
Submitter: "Zuul (22348)"
Branch: stable/yoga

commit 3558ba61c707bd71ce1fd1cd7e6719ac5d878a51
Author: LinPeiWen <email address hidden>
Date: Wed Aug 10 21:02:10 2022 +0800

    keystone: Remove redundant 'when'

    In a multi-controller node, the presence of "run_once: True"
    and "when: inventory_hostname == groups['keystone'][-1]"
    will cause the task to be skipped

    Closes-Bug: #1987982

    Change-Id: I6a8f4ca285cda0675711b631aeed7ae4c992d879
    (cherry picked from commit aa80f81d304c4734f8556740871d57d86f0190f7)

tags: added: in-stable-yoga
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to kolla-ansible (stable/victoria)

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

commit e4e6b2d33dd09bfc0138e067d01af02f2d377f8f
Author: LinPeiWen <email address hidden>
Date: Wed Aug 10 21:02:10 2022 +0800

    keystone: Remove redundant 'when'

    In a multi-controller node, the presence of "run_once: True"
    and "when: inventory_hostname == groups['keystone'][-1]"
    will cause the task to be skipped

    Closes-Bug: #1987982

    Change-Id: I6a8f4ca285cda0675711b631aeed7ae4c992d879
    (cherry picked from commit aa80f81d304c4734f8556740871d57d86f0190f7)

tags: added: in-stable-victoria
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to kolla-ansible (stable/wallaby)

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

commit 42c3a6abfdafef18aee40841d0fb43c43096cde9
Author: LinPeiWen <email address hidden>
Date: Wed Aug 10 21:02:10 2022 +0800

    keystone: Remove redundant 'when'

    In a multi-controller node, the presence of "run_once: True"
    and "when: inventory_hostname == groups['keystone'][-1]"
    will cause the task to be skipped

    Closes-Bug: #1987982

    Change-Id: I6a8f4ca285cda0675711b631aeed7ae4c992d879
    (cherry picked from commit aa80f81d304c4734f8556740871d57d86f0190f7)

tags: added: in-stable-wallaby
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to kolla-ansible (stable/xena)

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

commit 62931b310e696b7b87efd7caba250e3907ce673b
Author: LinPeiWen <email address hidden>
Date: Wed Aug 10 21:02:10 2022 +0800

    keystone: Remove redundant 'when'

    In a multi-controller node, the presence of "run_once: True"
    and "when: inventory_hostname == groups['keystone'][-1]"
    will cause the task to be skipped

    Closes-Bug: #1987982

    Change-Id: I6a8f4ca285cda0675711b631aeed7ae4c992d879
    (cherry picked from commit aa80f81d304c4734f8556740871d57d86f0190f7)

tags: added: in-stable-xena
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/kolla-ansible 12.7.0

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/kolla-ansible 13.4.0

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/kolla-ansible 14.4.0

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/kolla-ansible 15.0.0.0rc1

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/kolla-ansible ussuri-eol

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/kolla-ansible victoria-eol

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.