[master][train] nothing provides libmysqlclient.so.21()(64bit) needed by collectd-mysql-5.11.0-2.el8.x86_64

[Bhagyashri Shewale]

[train] build-containers-ubi-8-push-train is failing while
building collectd containers

Logs from collectd-build.log [1.]
STEP 5: RUN dnf -y install collectd collectd-amqp1 collectd-apache collectd-bind collectd-ceph collectd-chrony collectd-connectivity collectd-curl collectd-curl_json collectd-curl_xml collectd-dbi collectd-disk collectd-dns collectd-generic-jmx collectd-ipmi collectd-iptables collectd-log_logstash collectd-mcelog collectd-memcachec collectd-mysql collectd-netlink collectd-openldap collectd-ovs-events collectd-ovs-stats collectd-ping collectd-procevent collectd-python collectd-sensors collectd-sensubility collectd-smart collectd-snmp collectd-snmp-agent collectd-sysevent collectd-utils collectd-virt collectd-write_http collectd-write_kafka collectd-write_prometheus python3-collectd-gnocchi python3-sqlalchemy-collectd && dnf clean all && rm -rf /var/cache/dnf
Updating Subscription Management repositories.
Unable to read consumer identity
Subscription Manager is operating in container mode.
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Last metadata expiration check: 0:00:09 ago on Fri 18 Sep 2020 04:21:22 AM UTC.
Package collectd-5.11.0-2.el8.x86_64 is already installed.
Error:
 Problem: cannot install the best candidate for the job
  - nothing provides libmysqlclient.so.21()(64bit) needed by collectd-mysql-5.11.0-2.el8.x86_64
  - nothing provides libmysqlclient.so.21(libmysqlclient_21.0)(64bit) needed by collectd-mysql-5.11.0-2.el8.x86_64
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)

It also impacted master jobs. [2]

Here is the tcib yaml file used: https://opendev.org/openstack/tripleo-common/src/branch/stable/train/container-images/tcib/base/collectd/collectd.yaml

[1]:https://logserver.rdoproject.org/openstack-periodic-integration-stable2/opendev.org/openstack/tripleo-ci/master/periodic-tripleo-ci-build-containers-ubi-8-push-train/8611bc6/logs/buildah-builds/container-builds/915984bc-5a11-4959-9ffa-d3986586faf4/base/collectd/collectd-build.log

[2]: https://storage.gra.cloud.ovh.net/v1/AUTH_dcaab5e32b234d56b626f72581e3644c/zuul_opendev_logs_109/752605/1/check/tripleo-ci-centos-8-standalone/1093f59/logs/undercloud/home/zuul/container-builds/f944c506-1f5a-4c7d-bca6-83694a5f6209/base/collectd/collectd-build.log

[chandan kumar (chkumar246)]

 ykarel | chandankumar, mrunge libmysqlclient is provided by mysql-libs rpm which is part of mysql:8 stream (which is default and auto picked)
mrunge | right. so the question is, if just drop mysql and use mariadb instead
 ykarel | with recent updates module seems corrupted as rpms missing from those

[OpenStack Infra (hudson-openstack)]

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

[Alfredo Moralejo (amoralej)]

From RDO side we are preparing a temporary fix by adding a repo with missing CentOS8 packages and add it to delorean-deps.repo. Currently testing it in https://review.opendev.org/#/c/750620/

[Alfredo Moralejo (amoralej)]

Container build job passed with the fix repo in https://review.opendev.org/#/c/750620/, i've applied it to delorean-deps.repo. This should workaround the issue until it's properly fixed in CentOS repos.

[Alfredo Moralejo (amoralej)]

Sent workaround to https://review.rdoproject.org/r/29472 . In the meanwhile i've applied it manually.

[wes hayutin (weshayutin)]

FYI https://review.opendev.org/#/c/752621/1/container-images/tcib/base/collectd/collectd.yaml

[Matthias Runge (mrunge)]

I've rebuilt collectd with mariadb instead of mysql. https://review.rdoproject.org/r/#/c/29458/

[Matthias Runge (mrunge)]

https://lists.centos.org/pipermail/centos-devel/2020-September/056063.html

[OpenStack Infra (hudson-openstack)]

Change abandoned by Matthias Runge (<email address hidden>) on branch: master
Review: https://review.opendev.org/752621
Reason: not needed anymore

[Matthias Runge (mrunge)]

This was fixed in centos itself, there is nothing to do left here.