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

Bug 2258601

Summary: [FFU 16.2 to 17.1.1] FFU fails finding pre-existing /var/lib/tripleo/transfer-flags/var-lib-mysql flag file
Product: Red Hat OpenStack Reporter: Flavio Piccioni <fpiccion>
Component: openstack-tripleoAssignee: Lukas Bezdicka <lbezdick>
Status: CLOSED DUPLICATE QA Contact: Joe H. Rahme <jhakimra>
Severity: high Docs Contact:
Priority: medium    
Version: 17.1 (Wallaby)CC: jmitterm, lbezdick, mburns, sathlang
Target Milestone: ---Keywords: Triaged
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2024-02-28 14:24:53 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 Flavio Piccioni 2024-01-16 13:30:31 UTC 
Description of problem:

with (2 years old) /var/lib/tripleo/transfer-flags/var-lib-mysql flag file already existing into the bootstrap controller, the 17 upgrade workflow skipped the db sync task, leading db_sync containers to fail


Version-Release number of selected component (if applicable):
16.2.5 FFU to 17.1.1

Actual results:
++ cat /run_command
+ CMD='/usr/bin/bootstrap_host_exec cinder_api su cinder -s /bin/bash -c '\''cinder-manage db sync --bump-versions'\'''
+ ARGS=
+ [[ ! -n '' ]]
+ . kolla_extend_start
+ echo 'Running command: '\''/usr/bin/bootstrap_host_exec cinder_api su cinder -s /bin/bash -c '\''cinder-manage db sync --bump-versions'\'''\'''
Running command: '/usr/bin/bootstrap_host_exec cinder_api su cinder -s /bin/bash -c 'cinder-manage db sync --bump-versions''
+ umask 0022
+ exec /usr/bin/bootstrap_host_exec cinder_api su cinder -s /bin/bash -c ''\''cinder-manage' db sync '--bump-versions'\'''
Error during database migration: (pymysql.err.OperationalError) (1709, 'Index column size too large. The maximum column size is 767 bytes')
[SQL: ALTER TABLE quota_usages ADD CONSTRAINT quota_usages_project_id_key UNIQUE (project_id, resource, race_preventer)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)

2024-01-09 12:42:12,440 p=933632 u=stack n=ansible | 2024-01-09 12:42:12.439796 | 00505697-5ab2-94ae-6dee-000000019a19 |      FATAL | Create containers managed by Podman for /var/lib/tripleo-config/container-startup-config/step_3 | qbctld01 | error={"changed": false, "msg": "Failed containers: glance_api_db_sync"}
2024-01-09 12:42:16,797 p=933632 u=stack n=ansible | 2024-01-09 12:42:16.797061 | 00505697-5ab2-94ae-6dee-000000019b57 |      FATAL | Create containers managed by Podman for /var/lib/tripleo-config/container-startup-config/step_3 | noctld01 | error={"changed": false, "msg": "Failed containers: glance_api_db_sync"}
2024-01-09 12:42:44,372 p=933632 u=stack n=ansible | 2024-01-09 12:42:44.372687 | 00505697-5ab2-94ae-6dee-000000019f8b |      FATAL | Create containers managed by Podman for /var/lib/tripleo-config/container-startup-config/step_3 | hhctld01 | error={"changed": false, "msg": "Failed containers: cinder_api_db_sync, glance_api_db_sync"}
Comment 3 Lukas Bezdicka 2024-02-28 14:24:53 UTC 
WA:
remove the /var/lib/tripleo/transfer-flags/var-lib-mysql flag file on the controllers and rerun upgrade run with --limit that lists all the nodes and undercloud in style of ctrl-0,ctrl-1,ctrl-2,undercloud-0

This issue is fixed in rhbz#2247606

*** This bug has been marked as a duplicate of bug 2247606 ***