Error while evaluating a Resource Statement, Oslo::Db[heat_config]: has no parameter named 'mysql_enable_ndb'

[chandan kumar]

Most of the standalone gate jobs got impacted during standalone deploy with following errors:

[1.] standalone_deploy.log
++++++++
TIMING | tripleo_container_manage : Check podman create status | 0:21:05.507 | 2.33s
 [ERROR]: Container(s) which finished with wrong return code: ['container-
puppet-heat_api_cfn']
2020-08-27 04:30:34.758729 | fa163e1c-0945-78ce-80da-00000000189a | FATAL | Check containers status | standalone | error={"changed": false, "msg": "Failed container(s): ['container-puppet-heat_api_cfn'], check logs in /var/log/containers/stdouts/"}
++++++++

[2.] By looking at var/log/containers/stdouts/container-puppet-heat_api_cfn.log
++++++++
2020-08-27T04:30:08.290290961+00:00 stdout F include ::tripleo::packages
2020-08-27T04:30:08.290290961+00:00 stdout F include tripleo::profile::base::heat::api_cfn
2020-08-27T04:30:08.290290961+00:00 stdout F
2020-08-27T04:30:08.402154334+00:00 stdout F Running puppet
2020-08-27T04:30:08.402402349+00:00 stderr F + /usr/bin/puppet apply --summarize --detailed-exitcodes --color=false --modulepath=/etc/puppet/modules:/usr/share/openstack-puppet/modules --tags '"file,file_line,concat,augeas,cron,heat_config,file,concat,file_line"' /etc/config.pp
2020-08-27T04:30:08.402402349+00:00 stderr F + logger -s -t puppet-user
2020-08-27T04:30:20.150312889+00:00 stderr F <13>Aug 27 04:30:08 puppet-user: Warning: /etc/puppet/hiera.yaml: Use of 'hiera.yaml' version 3 is deprecated. It should be converted to version 5
2020-08-27T04:30:20.150312889+00:00 stderr F <13>Aug 27 04:30:20 puppet-user: (file: /etc/puppet/hiera.yaml)
2020-08-27T04:30:20.151711710+00:00 stderr F <13>Aug 27 04:30:20 puppet-user: Warning: Undefined variable '::deploy_config_name';
2020-08-27T04:30:20.151711710+00:00 stderr F <13>Aug 27 04:30:20 puppet-user: (file & line not available)
2020-08-27T04:30:20.208165262+00:00 stderr F <13>Aug 27 04:30:20 puppet-user: Warning: The function 'hiera' is deprecated in favor of using 'lookup'. See https://puppet.com/docs/puppet/6.14/deprecated_language.html
2020-08-27T04:30:20.208165262+00:00 stderr F <13>Aug 27 04:30:20 puppet-user: (file & line not available)
2020-08-27T04:30:20.293398052+00:00 stderr F <13>Aug 27 04:30:20 puppet-user: Warning: This method is deprecated, please use match expressions with Stdlib::Compat::Ipv6 instead. They are described at https://docs.puppet.com/puppet/latest/reference/lang_data_type.html#match-expressions. at ["/etc/puppet/modules/tripleo/manifests/profile/base/heat/authtoken.pp", 34]:["/etc/puppet/modules/tripleo/manifests/profile/base/heat.pp", 105]
2020-08-27T04:30:20.293398052+00:00 stderr F <13>Aug 27 04:30:20 puppet-user: (location: /etc/puppet/modules/stdlib/lib/puppet/functions/deprecation.rb:34:in `deprecation')
2020-08-27T04:30:21.943501287+00:00 stderr F <13>Aug 27 04:30:21 puppet-user: Error: Evaluation Error: Error while evaluating a Resource Statement, Oslo::Db[heat_config]: has no parameter named 'mysql_enable_ndb' (file: /etc/puppet/modules/heat/manifests/db.pp, line: 90) on node standalone.localdomain
2020-08-27T04:30:21.984213330+00:00 stderr F + rc=1
2020-08-27T04:30:21.984213330+00:00 stderr F + '[' false = false ']'
2020-08-27T04:30:21.984268585+00:00 stderr F + set +x
++++++++

It is caused by https://review.opendev.org/#/c/748086/ and similar changes are coming to multiple puppet modules as referenced here in the bug: https://launchpad.net/bugs/1892952

It is affecting tripleo.

as a short term solution, we are remove puppet-heat from delorean current repo defined in release file: https://github.com/openstack/tripleo-quickstart/blob/master/config/release/tripleo-ci/CentOS-8/master.yml#L105-L117

for proper fix, we need a promotion

Logs:
[1.] https://storage.bhs.cloud.ovh.net/v1/AUTH_dcaab5e32b234d56b626f72581e3644c/zuul_opendev_logs_244/747011/5/gate/tripleo-ci-centos-8-scenario001-standalone/244c833/logs/undercloud/home/zuul/standalone_deploy.log

[2.] http://storage.bhs.cloud.ovh.net/v1/AUTH_dcaab5e32b234d56b626f72581e3644c/zuul_opendev_logs_244/747011/5/gate/tripleo-ci-centos-8-scenario001-standalone/244c833/logs/undercloud/var/log/containers/stdouts/container-puppet-heat_api_cfn.log

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/748360

[OpenStack Infra (hudson-openstack)]

Change abandoned by wes hayutin (<email address hidden>) on branch: master
Review: https://review.opendev.org/748360
Reason: sorry.. https://opendev.org/openstack/puppet-oslo/src/branch/master/.zuul.yaml

[OpenStack Infra (hudson-openstack)]

Change abandoned by wes hayutin (<email address hidden>) on branch: master
Review: https://review.opendev.org/748360

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/748360
Committed: https://git.openstack.org/cgit/openstack/tripleo-quickstart/commit/?id=a24955cb7ee04cf0df2e04e06abdd330a38e87ab
Submitter: Zuul
Branch: master

commit a24955cb7ee04cf0df2e04e06abdd330a38e87ab
Author: yatinkarel <email address hidden>
Date: Thu Aug 27 11:16:48 2020 +0530

    Consume puppet-oslo from delorean current repo

    https://review.opendev.org/#/c/748067 added
    mysql_enable_ndb parameter, which is being added
    to almost all puppet modules [1]. Since puppet-oslo
    is not used from current repo, other puppet-modules
    using this param fails to find it and fails.

    Add puppet-oslo to be consumed from delorean current
    repo until there is promotion of puppet-oslo change.

    Also add to promotion-testing-hash-master.yml to keep
    the list in sync.

    [1] https://review.opendev.org/#/q/mysql_enable_ndb

    Closes-Bug: #1893173
    Change-Id: I7faae0b7b323a227545991f8e1b507bc9b2b5f0b