[RFE] Add a playbook/task to cleanup sqlalchemy-collectd configuration in containers

[Sanjay Chari]

The SQLAlchemy collectd plugin adds additional configuration on many containers on controller hosts.

https://github.com/cloud-bulldozer/browbeat/blob/e31e989759fc34c276987143bf69352ad51bcc47/ansible/install/roles/collectd/tasks/main.yml#L71-L132

This configuration causes issues when overcloud deployment is run again.

sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.plugins:collectd
2022-05-25 07:50:13.051682 | | WARNING | Failure running exec 'keystone_bootstrap'. rc=1, stdout=, stderr=
2022-05-25 07:50:13.051993 | | WARNING | ERROR: Can't run container nova_db_sync
stderr: + sudo -E kolla_set_configs
sudo: unable to send audit message: Operation not permitted
2022-05-25 07:50:13.054830 | 0cc47afa-1a12-eb4d-d8d5-000000092d24 | FATAL | Create containers managed by Podman for /var/lib/tripleo-config/c
ontainer-startup-config/step_3 | controller-0 | error={"changed": false, "msg": "Failed containers: cinder_api_db_sync, glance_api_db_sync, heat_e
ngine_db_sync, keystone_db_sync, neutron_db_sync, keystone_bootstrap, nova_db_sync"}

We should have a playbook/task in Browbeat that cleans up the sqlalchemy-collectd configuration on these containers, so it doesn't cause issues with the next overcloud deployment.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/c/x/browbeat/+/843387

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/x/browbeat/+/843387
Committed: https://opendev.org/x/browbeat/commit/a71506b31cf8803d45ee4c7f8844491293327554
Submitter: "Zuul (22348)"
Branch: master

commit a71506b31cf8803d45ee4c7f8844491293327554
Author: Sanjay Chari <email address hidden>
Date: Thu May 26 11:43:59 2022 +0530

    Add playbook to clean up sqlalchemy collectd configuration

    Browbeat adds configuration for sqlalchemy collectd on the configuration files
    of many Openstack API containers on controller hosts. This causes issues in the
    next overcloud deployment. This patch adds a playbook to clean up sqlalchemy
    collectd configuration.

    Closes-Bug: #1975693
    Change-Id: I2574676aa444f76e11cec91d9e0e2a66282301ac