mysql-router containers on Openstack-base not working
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Canonical Juju |
Expired
|
Medium
|
Unassigned |
Bug Description
as seen below...
When i deploy bundle.yaml mysql-router service does not connect other services to the database.
ceph-radosgw/0* waiting idle 0/lxd/1 192.168.15.59 80/tcp Incomplete relations: identity
cinder/0* waiting executing 1/lxd/1 192.168.15.46 8776/tcp Incomplete relations: database, identity
cinder-ceph/0* active idle 192.168.15.46 Unit is ready
cinder-
glance/0* error idle 2/lxd/1 192.168.15.61 9292/tcp hook failed: "shared-
glance-
keystone/0* maintenance executing 0/lxd/2 192.168.15.50 5000/tcp Migrating the keystone database
keystone-
mysql-innodb-
mysql-innodb-
mysql-innodb-
neutron-api/0* error idle 1/lxd/3 192.168.15.45 9696/tcp hook failed: "shared-
neutron-
neutron-
nova-cloud-
nova-
nova-compute/0 active idle 0 192.168.15.40 Unit is ready
ntp/1* active idle 192.168.15.40 123/udp chrony: Ready
ovn-chassis/1* waiting idle 192.168.15.40 'certificates' awaiting server certificate data, 'ovsdb' incomplete
nova-compute/1 active idle 1 192.168.15.42 Unit is ready
ntp/0 active idle 192.168.15.42 123/udp chrony: Ready
ovn-chassis/0 waiting idle 192.168.15.42 'certificates' awaiting server certificate data, 'ovsdb' incomplete
nova-compute/2* active idle 2 192.168.15.41 Unit is ready
ntp/2 active idle 192.168.15.41 123/udp chrony: Ready
ovn-chassis/2 waiting idle 192.168.15.41 'certificates' awaiting server certificate data, 'ovsdb' incomplete
openstack-
dashboard-
ovn-central/0* waiting idle 0/lxd/5 192.168.15.47 6641/tcp,6642/tcp 'ovsdb-peer' incomplete, 'certificates' awaiting server certificate data
ovn-central/1 waiting idle 1/lxd/5 192.168.15.56 6641/tcp,6642/tcp 'ovsdb-peer' incomplete, 'certificates' awaiting server certificate data
ovn-central/2 waiting idle 2/lxd/3 192.168.15.54 6641/tcp,6642/tcp 'ovsdb-peer' incomplete, 'certificates' awaiting server certificate data
placement/0* waiting idle 2/lxd/4 192.168.15.51 8778/tcp 'identity-service' incomplete
placement-
rabbitmq-server/0* active idle 2/lxd/5 192.168.15.52 5672/tcp Unit is ready
vault/0* blocked idle 0/lxd/6 192.168.15.58 8200/tcp Vault service not running
vault-
Can you include the version of Juju that you are running and the bundle that you are trying to deploy? mysql-router/ 0* blocked idle 192.168.15.45 Failed to connect to MySQL
It would also be helpful to include any logs associated with the failures. I do see:
neutron-
But that doesn't include enough information to understand why it is failing to connect to MySQL.
It does appear that MySQL is available: cluster/ 0 active idle 0/lxd/3 192.168.15.48 Unit is ready: Mode: R/O, Cluster is ONLINE and can tolerate up to ONE failure. cluster/ 1 active idle 1/lxd/2 192.168.15.43 Unit is ready: Mode: R/O, Cluster is ONLINE and can tolerate up to ONE failure. cluster/ 2* active idle 2/lxd/2 192.168.15.60 Unit is ready: Mode: R/W, Cluster is ONLINE and can tolerate up to ONE failure.
mysql-innodb-
mysql-innodb-
mysql-innodb-
There is nothing that indicates this is a bug in Juju (vs a bug in the charm, vs configuration, etc).
Though if it is something that "it worked yesterday with Juju 2.9.25 and fails today with 2.9.27" that could be something that we changed.