kolla-ansible

Mariadb deploy fails when using none standard port

Bug #2024554 reported by Adam Stackhouse
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
kolla-ansible
Fix Released
Low
Adam Stackhouse
Antelope
Fix Released
Low
Unassigned
Bobcat
Fix Released
Low
Adam Stackhouse
Yoga
Fix Released
Low
Unassigned
Zed
Fix Released
Low
Unassigned

Bug Description

This is a bug report to document a bug found with mariadb deployments when mariadb_port is changed.

The bug is caused when you set mariadb_port to a value other than 3306. This is because the task to check for wsrep status doesn't specify this var to be used so it always defaults to 3306.

https://opendev.org/openstack/kolla-ansible/src/branch/master/ansible/roles/mariadb/tasks/restart_services.yml#L34-L36

See original description
Revision history for this message
Adam Stackhouse (adstak46) wrote :
OpenStack Infra (hudson-openstack)
Changed in kolla-ansible:
status: New → In Progress
Maksim Malchuk (mmalchuk)
Changed in kolla-ansible:
assignee: nobody → Adam Stackhouse (adstak46)
Revision history for this message
Maksim Malchuk (mmalchuk) wrote :

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

description: updated
Maksim Malchuk (mmalchuk)
Changed in kolla-ansible:
importance: Undecided → Low
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/+/886581
Committed: https://opendev.org/openstack/kolla-ansible/commit/842e758221a63e4bc5adf31bec061ea7aa22b3cb
Submitter: "Zuul (22348)"
Branch: master

commit 842e758221a63e4bc5adf31bec061ea7aa22b3cb
Author: Adam Stackhouse <email address hidden>
Date: Wed Jun 21 10:13:23 2023 +0100

    Adding mariadb_port to wsrep sync status so alterative ports can be used

    Closes-Bug: #2024554
    Change-Id: Id6eae798784126d4dd53adef15bdce6b47b4601f

Changed in kolla-ansible:
status: In Progress → Fix Released
Maksim Malchuk (mmalchuk)
no longer affects: kolla-ansible/wallaby
no longer affects: kolla-ansible/xena
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla-ansible (stable/2023.1)

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

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

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

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/+/901918

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

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

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

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

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

Reviewed: https://review.opendev.org/c/openstack/kolla-ansible/+/901859
Committed: https://opendev.org/openstack/kolla-ansible/commit/011fe5e2846e56b9031636beac751fa6226aedec
Submitter: "Zuul (22348)"
Branch: stable/zed

commit 011fe5e2846e56b9031636beac751fa6226aedec
Author: Adam Stackhouse <email address hidden>
Date: Wed Jun 21 10:13:23 2023 +0100

    Adding mariadb_port to wsrep sync status so alterative ports can be used

    Closes-Bug: #2024554
    Change-Id: Id6eae798784126d4dd53adef15bdce6b47b4601f
    (cherry picked from commit 842e758221a63e4bc5adf31bec061ea7aa22b3cb)

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

Reviewed: https://review.opendev.org/c/openstack/kolla-ansible/+/901858
Committed: https://opendev.org/openstack/kolla-ansible/commit/5bce054a64518c0062b468bedb6fa478a5154c50
Submitter: "Zuul (22348)"
Branch: stable/2023.1

commit 5bce054a64518c0062b468bedb6fa478a5154c50
Author: Adam Stackhouse <email address hidden>
Date: Wed Jun 21 10:13:23 2023 +0100

    Adding mariadb_port to wsrep sync status so alterative ports can be used

    Closes-Bug: #2024554
    Change-Id: Id6eae798784126d4dd53adef15bdce6b47b4601f
    (cherry picked from commit 842e758221a63e4bc5adf31bec061ea7aa22b3cb)

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/+/901918
Committed: https://opendev.org/openstack/kolla-ansible/commit/69e8f94a733ef3b667e90ef20748535786a03f17
Submitter: "Zuul (22348)"
Branch: stable/yoga

commit 69e8f94a733ef3b667e90ef20748535786a03f17
Author: Adam Stackhouse <email address hidden>
Date: Wed Jun 21 10:13:23 2023 +0100

    Adding mariadb_port to wsrep sync status so alterative ports can be used

    Also added '-h {{ api_interface_address }}' because on Yoga version client
    tries to connect to the 'localhost' instead of bound address.

    Closes-Bug: #2024554
    Change-Id: Id6eae798784126d4dd53adef15bdce6b47b4601f
    (cherry picked from commit 842e758221a63e4bc5adf31bec061ea7aa22b3cb)

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/+/902489
Committed: https://opendev.org/openstack/kolla-ansible/commit/35c7a9eb9d2c6dc3c9b695f148319f53bf4b8fe7
Submitter: "Zuul (22348)"
Branch: master

commit 35c7a9eb9d2c6dc3c9b695f148319f53bf4b8fe7
Author: Maksim Malchuk <email address hidden>
Date: Sun Dec 3 00:46:40 2023 +0300

    Fix wsrep sync status task while switched to TCP/IP

    Followup on Id6eae798784126d4dd53adef15bdce6b47b4601f to fix an issue
    when a client with provided port set tries to connect 'localhost', so
    while we switch to TCP/IP we need to explicitly provide the host too.

    Partial-Bug: #2024554
    Change-Id: Ib08c159dadd69a1f44924d658f4afe1e794a18b0
    Signed-off-by: Maksim Malchuk <email address hidden>

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

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

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

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

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

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

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

Reviewed: https://review.opendev.org/c/openstack/kolla-ansible/+/904502
Committed: https://opendev.org/openstack/kolla-ansible/commit/8dee91bd2e585b590eb1b5bcfe7a843387f8b41a
Submitter: "Zuul (22348)"
Branch: stable/zed

commit 8dee91bd2e585b590eb1b5bcfe7a843387f8b41a
Author: Maksim Malchuk <email address hidden>
Date: Sun Dec 3 00:46:40 2023 +0300

    Fix wsrep sync status task while switched to TCP/IP

    Followup on Id6eae798784126d4dd53adef15bdce6b47b4601f to fix an issue
    when a client with provided port set tries to connect 'localhost', so
    while we switch to TCP/IP we need to explicitly provide the host too.

    Partial-Bug: #2024554
    Change-Id: Ib08c159dadd69a1f44924d658f4afe1e794a18b0
    Signed-off-by: Maksim Malchuk <email address hidden>
    (cherry picked from commit 35c7a9eb9d2c6dc3c9b695f148319f53bf4b8fe7)

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

Reviewed: https://review.opendev.org/c/openstack/kolla-ansible/+/904501
Committed: https://opendev.org/openstack/kolla-ansible/commit/2801ff6a11921d2e64c11253effad04e35409a51
Submitter: "Zuul (22348)"
Branch: stable/2023.1

commit 2801ff6a11921d2e64c11253effad04e35409a51
Author: Maksim Malchuk <email address hidden>
Date: Sun Dec 3 00:46:40 2023 +0300

    Fix wsrep sync status task while switched to TCP/IP

    Followup on Id6eae798784126d4dd53adef15bdce6b47b4601f to fix an issue
    when a client with provided port set tries to connect 'localhost', so
    while we switch to TCP/IP we need to explicitly provide the host too.

    Partial-Bug: #2024554
    Change-Id: Ib08c159dadd69a1f44924d658f4afe1e794a18b0
    Signed-off-by: Maksim Malchuk <email address hidden>
    (cherry picked from commit 35c7a9eb9d2c6dc3c9b695f148319f53bf4b8fe7)

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

Reviewed: https://review.opendev.org/c/openstack/kolla-ansible/+/904280
Committed: https://opendev.org/openstack/kolla-ansible/commit/3aa199cb478f538b81a94090f4c402f57ab808e3
Submitter: "Zuul (22348)"
Branch: stable/2023.2

commit 3aa199cb478f538b81a94090f4c402f57ab808e3
Author: Maksim Malchuk <email address hidden>
Date: Sun Dec 3 00:46:40 2023 +0300

    Fix wsrep sync status task while switched to TCP/IP

    Followup on Id6eae798784126d4dd53adef15bdce6b47b4601f to fix an issue
    when a client with provided port set tries to connect 'localhost', so
    while we switch to TCP/IP we need to explicitly provide the host too.

    Partial-Bug: #2024554
    Change-Id: Ib08c159dadd69a1f44924d658f4afe1e794a18b0
    Signed-off-by: Maksim Malchuk <email address hidden>
    (cherry picked from commit 35c7a9eb9d2c6dc3c9b695f148319f53bf4b8fe7)

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

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

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

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

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

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

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

Other bug subscribers

Remote bug watches

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