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

Bug 1907949

Summary: [OSP16.1] Upcoming mariadb-10.3.27 has stricter innodb checks that will make a 13->16.1 FFU fail
Product: Red Hat OpenStack Reporter: Michele Baldessari <michele>
Component: puppet-tripleoAssignee: Michele Baldessari <michele>
Status: CLOSED ERRATA QA Contact: pkomarov
Severity: urgent Docs Contact:
Priority: urgent    
Version: 16.1 (Train)CC: ariveral, dabarzil, dciabrin, jfrancoa, jjoyce, jpretori, jschluet, kthakre, lmiccini, mariel, pkomarov, ravsingh, slinaber, tkajinam, tvignaud, vgrosu
Target Milestone: z4Keywords: Triaged
Target Release: 16.1 (Train on RHEL 8.2)   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: puppet-tripleo-11.5.0-1.20201114030107.el8ost Doc Type: No Doc Update
Doc Text:
Story Points: ---
Clone Of:
: 1915447 (view as bug list) Environment:
Last Closed: 2021-03-17 15:36:33 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:
Bug Depends On:    
Bug Blocks: 1915447    

Description Michele Baldessari 2020-12-15 15:06:48 UTC
Description of problem:
Seen during an FFU where we upgrade mariadb to 10.3.27 which is scheduled to be released in RHEL due to CVE fixes and some SST fixes (https://bugzilla.redhat.com/show_bug.cgi?id=1899022 amongst others)

The FFU will fail on the first controller with:
[root@controller-0 stdouts]# more nova_db_sync.log
2020-12-14T11:54:54.186418426+00:00 stdout F ERROR: Could not access cell0.
2020-12-14T11:54:54.186418426+00:00 stdout F Has the nova_api database been created?
2020-12-14T11:54:54.186418426+00:00 stdout F Has the nova_cell0 database been created?
2020-12-14T11:54:54.186418426+00:00 stdout F Has "nova-manage api_db sync" been run?
2020-12-14T11:54:54.186418426+00:00 stdout F Has "nova-manage cell_v2 map_cell0" been run?
2020-12-14T11:54:54.186418426+00:00 stdout F Is [api_database]/connection set in nova.conf?
2020-12-14T11:54:54.186418426+00:00 stdout F Is the cell0 database connection URL correct?
2020-12-14T11:54:54.186418426+00:00 stdout F Error: (pymysql.err.InternalError) (1118, 'Row size too large.
The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, c
heck the manual.
 You have to change some columns to TEXT or BLOBs')
2020-12-14T11:54:54.186418426+00:00 stdout F [SQL:
2020-12-14T11:54:54.186418426+00:00 stdout F ALTER TABLE instances ADD hidden BOOL]
2020-12-14T11:54:54.186418426+00:00 stdout F (Background on this error at: http://sqlalche.me/e/2j85)

Comment 28 errata-xmlrpc 2021-03-17 15:36:33 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (Red Hat OpenStack Platform 16.1.4 director bug fix advisory), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2021:0817