Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 2331327

Summary: Minor upgrade to RHOSP 17.1.4 is blocked by "Check if Galera needs upgrade" check
Product: Red Hat OpenStack Reporter: Alex Stupnikov <astupnik>
Component: openstack-tripleo-heat-templatesAssignee: Lukas Bezdicka <lbezdick>
Status: CLOSED MIGRATED QA Contact: Archana Singh <arcsingh>
Severity: high Docs Contact:
Priority: urgent    
Version: 17.1 (Wallaby)CC: dciabrin, dhill, jbadiapa, jelle.hoylaerts.ext, jiehuang, jpretori, kgilliga, lbezdick, mburns, schhabdi, toneata
Target Milestone: z5Keywords: Triaged
Target Release: 17.1   
Hardware: All   
OS: All   
Whiteboard:
Fixed In Version: openstack-tripleo-heat-templates-14.3.1-17.1.20241216090808.e7c7ce3.el9osttrunk Doc Type: Bug Fix
Doc Text:
Cause: As part of fixing https://bugzilla.redhat.com/show_bug.cgi?id=2269509 the upgrade process for mysql was reworked. In some circumstances, this change results the in-place update process failing. Consequence: The in-place update fails and cannot be recovered without applying a hotfix. Fix: The assertion has been made more robust, resolving the issue for both in-place upgrades and in-place updates. Result: The in-place update & upgrade processes now work correctly.
Story Points: ---
Clone Of: Environment:
Last Closed: 2024-12-23 16:22:41 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Alex Stupnikov 2024-12-10 09:51:19 UTC
Description of problem:
Minor upgrade in customer's deployment (openstack overcloud update run) is blocked with the following error:
2024-12-09 17:19:07,011 p=1046527 u=stack n=ansible | 2024-12-09 17:19:07.010699 | 566fb166-00a2-8ae7-20cc-000000000146 |      FATAL | assert | hostname | error={
    "assertion": "mysql_upgrade_needed.stdout != \"mysql already upgraded\"",
    "changed": false,
    "evaluated_to": false,
    "msg": "MYSQL upgrade run was skipped during FFWD. RHBZ#2269509 you need to run openstack overcloud upgrade run --limit mysql --playbook <stack>/upgrade_steps_playbook.yaml --stack <stack>. This will cause temporary API outage!"
}

This error is logged despite the fact that in ansible debug logs we see that UPGRADE_SCRIPT was executed successfully and returns "mysql already upgraded" as an output.

This problem has potential to impact many customers.


Version-Release number of selected component (if applicable): RHOSP 17.1.4


How reproducible: Run minor upgrade towards RHOSP 17.1.4


Actual results: upgrade is blocked because of error in description despite the fact that mariadb container was updated properly


Expected results: update works as expected if mysql is up to date