MySQL InnoDB Cluster Charm deployment fails over libmysqlclient-dev pkg installtion failure due to libssl3 dependency

[Itai Levy]

Charmed Openstack deployment (Yoga / Jammy)

$ juju debug-log -i mysql-innodb-cluster/0
unit-mysql-innodb-cluster-0: 12:09:50 WARNING unit.mysql-innodb-cluster/0.install File "/var/lib/juju/agents/unit-mysql-innodb-cluster-0/charm/lib/charms/layer/basic.py", line 169, in bootstrap_charm_deps
unit-mysql-innodb-cluster-0: 12:09:50 WARNING unit.mysql-innodb-cluster/0.install apt_install(cfg.get('packages', []))
unit-mysql-innodb-cluster-0: 12:09:50 WARNING unit.mysql-innodb-cluster/0.install File "/var/lib/juju/agents/unit-mysql-innodb-cluster-0/charm/lib/charms/layer/basic.py", line 437, in apt_install
unit-mysql-innodb-cluster-0: 12:09:50 WARNING unit.mysql-innodb-cluster/0.install check_call(cmd + packages, env=env)
unit-mysql-innodb-cluster-0: 12:09:50 WARNING unit.mysql-innodb-cluster/0.install File "/usr/lib/python3.10/subprocess.py", line 369, in check_call
unit-mysql-innodb-cluster-0: 12:09:50 WARNING unit.mysql-innodb-cluster/0.install raise CalledProcessError(retcode, cmd)
unit-mysql-innodb-cluster-0: 12:09:50 WARNING unit.mysql-innodb-cluster/0.install subprocess.CalledProcessError: Command '['apt-get', '--option=Dpkg::Options::=--force-confold', '--assume-yes', 'install', 'libmysqlclient-dev']' returned non-zero exit status 100.
unit-mysql-innodb-cluster-0: 12:09:50 ERROR juju.worker.uniter.operation hook "install" (via explicit, bespoke hook script) failed: exit status 1
unit-mysql-innodb-cluster-0: 12:09:50 INFO juju.worker.uniter awaiting error resolution for "install" hook
unit-mysql-innodb-cluster-0: 12:11:20 INFO juju.worker.uniter awaiting error resolution for "install" hook

When trying to manually install the libmysqlclient-dev:

ubuntu@juju-743be9-0-lxd-1:~$ sudo apt-get install libmysqlclient-dev
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 libssl-dev : Depends: libssl3 (= 3.0.2-0ubuntu1.1) but 3.0.2-0ubuntu1.2 is to be installed
E: Unable to correct problems, you have held broken packages.

ubuntu@juju-743be9-0-lxd-1:~$ sudo apt-get --assume-yes install libssl3
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
libssl3 is already the newest version (3.0.2-0ubuntu1.2).
libssl3 set to manually installed.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.