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

Bug 1762726

Summary: [OSP13] Custom mysql hiera configs can break on the HA overcloud
Product: Red Hat OpenStack Reporter: Michele Baldessari <michele>
Component: puppet-tripleoAssignee: Michele Baldessari <michele>
Status: CLOSED CURRENTRELEASE QA Contact: nlevinki <nlevinki>
Severity: high Docs Contact:
Priority: high    
Version: 13.0 (Queens)CC: fiezzi, jjoyce, jschluet, lmiccini, slinaber, tvignaud
Target Milestone: z9Keywords: TestOnly, Triaged, ZStream
Target Release: 13.0 (Queens)   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: puppet-tripleo-8.5.1-2.el7ost Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2019-11-13 11:00:36 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 Michele Baldessari 2019-10-17 10:32:48 UTC
Description of problem:Currently when adding some tuning options via hiera, galera won't start because overriding even a single mysql option will reset the whole key in the hash. So for example, when adding:
    tripleo::profile::base::database::mysql::mysql_server_options:
      mysqld:
        # MySQL InnoDB equally divided in 1GB instances
        innodb_buffer_pool_instances: 2
        # Query network write timeout raised to 120 seconds
        net_write_timeout: 120
        # Query network read timeout raised to 120 seconds
        net_read_timeout: 120
        # MySQL connection timeout set to 8 hours
        connect_timeout: 28800

Things will break because all the wsrep options that are set normally will be overridden and galera will refuse to start

Comment 3 Lon Hohberger 2019-11-08 11:47:49 UTC
According to our records, this should be resolved by puppet-tripleo-8.5.1-3.el7ost.  This build is available now.