Bionic Queen verified using [Test Case]
Test Output:
root@juju-01d5ff-lp1768824-sru-5:~# dpkg -l| grep designate
ii designate-agent 1:6.0.1-0ubuntu1.2
all OpenStack DNS as a Service - agent
ii designate-api 1:6.0.1-0ubuntu1.2
all OpenStack DNS as a Service - API server
ii designate-central 1:6.0.1-0ubuntu1.2
all OpenStack DNS as a Service - central daemon
ii designate-common 1:6.0.1-0ubuntu1.2
all OpenStack DNS as a Service - common files
ii designate-mdns 1:6.0.1-0ubuntu1.2
all OpenStack DNS as a Service - mdns
ii designate-pool-manager 1:6.0.1-0ubuntu1.2
all OpenStack DNS as a Service - pool manager
ii designate-sink 1:6.0.1-0ubuntu1.2
all OpenStack DNS as a Service - sink
ii designate-zone-manager 1:6.0.1-0ubuntu1.2
all OpenStack DNS as a Service - zone manager
ii python-designate 1:6.0.1-0ubuntu1.2
all OpenStack DNS as a Service - Python libs
ii python-designateclient 2.9.0-0ubuntu1
all client library for the OpenStack Designate API - Python 2.7
root@juju-01d5ff-lp1768824-sru-5:~# mysql -h$host -u${service} -p$passwd
${service} -e'select count(*) from service_statuses where
service_name="pool_manager"'
mysql: [Warning] Using a password on the command line interface can be insecure.
+----------+
| count(*) |
+----------+
| 1 |
+----------+
root@juju-01d5ff-lp1768824-sru-5:~# ts=`date '+%Y-%m-%d %H:%M:%S'`
root@juju-01d5ff-lp1768824-sru-5:~# svc_host=`mysql -B -h$host -u${service}
-p$passwd ${service} -e 'select hostname from service_statuses where
service_name="pool_manager";'| tail -n 1`
mysql: [Warning] Using a password on the command line interface can be insecure.
root@juju-01d5ff-lp1768824-sru-5:~# mysql -h$host -u${service} -p$passwd
${service} -e "insert into service_statuses values ('1234', '$ts', '$ts',
'pool_manager', '$svc_host', '$ts', 'UP', '{}', '{}');"
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1062 (23000) at line 1: Duplicate entry
'pool_manager-juju-01d5ff-lp1768824-sru-5' for key 'unique_service_status'
root@juju-01d5ff-lp1768824-sru-5:~# mysql -h$host -u${service} -p$passwd
${service} -e "select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where
CONSTRAINT_TYPE='UNIQUE';"| grep service_statuses
mysql: [Warning] Using a password on the command line interface can be insecure.
def designate unique_service_status designate
service_statuses UNIQUE
** Tags removed: verification-needed-bionic
** Tags added: verification-done-bionic
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1768824
Title:
[SRU] service_statuses table running full in Designate database
To manage notifications about this bug go to:
https://bugs.launchpad.net/cloud-archive/+bug/1768824/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
