The first openstack overcloud deploy fails with Failed containers: mysql_wait_bundle

Issue

• The first openstack overcloud deploy command failed with the following error message.

  $ openstack overcloud deploy ...
     :
  2022-01-01 11:42:40.632765 | aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa |       TASK | Create containers managed by Podman for /var/lib/tripleo-config/container-startup-config/step_2
  2022-01-01 12:13:10.534363 |                                      |    WARNING | ERROR: Can't run container mysql_wait_bundle
  
  Error: '/usr/bin/clustercheck >/dev/null' returned 1 instead of one of [0]
  Error: /Stage[main]/Tripleo::Profile::Pacemaker::Database::Mysql_bundle/Exec[galera-ready]/returns: change from 'notrun' to ['0'] failed: '/usr/bin/clustercheck > /dev/null' returned 1 instead of one of [0]
  Error: Could not prefetch mysql_user provider 'mysql': Execution of '/usr/bin/mysql --defaults-extra-file=/root/.my.cnf -NBe SELECT CONCAT(User, '@',Host) AS User FROM mysql.user' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
  
  Error: Could not prefetch mysql_database provider 'mysql': Execution of '/usr/bin/mysql --defaults-extra-file=/root/.my.cnf -NBe show databases' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
  
  Error: Could not prefetch mysql_grant provider 'mysql': Execution of '/usr/bin/mysql --defaults-extra-file=/root/.my.cnf -NBe SELECT CONCAT(User, '@',Host) AS User FROM mysql.user' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
  
  Warning: /Stage[main]/Placement::Db::Mysql/Openstacklib::Db::Mysql[placement]/Openstacklib::Db::Mysql::Host_access[placement_%]/Mysql_user[placement@%]: Skipping because of failed dependencies
  Warning: /Stage[main]/Placement::Db::Mysql/Openstacklib::Db::Mysql[placement]/Openstacklib::Db::Mysql::Host_access[placement_%]/Mysql_grant[placement@%/placement.*]: Skipping because of failed dependencies                                                                                                                                                                        
  + rc=6
  + set -e
  + set +ux
  2022-01-01 12:13:10.536117 | aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa |      FATAL | Create containers managed by Podman for /var/lib/tripleo-config/container-startup-config/step_2 | overcloud-controller-0 | error={"changed": false, "msg": "Failed containers: mysql_wait_bundle"}
     :