Designate

  1. Bug #1768824
  2. Comment #2

Comment 2 for bug 1768824

Revision history for this message
Erik Olof Gunnar Andersson (eandersson) wrote : Re: service_statuses table running full in Designate database

The issue here is that the hostname and service_name under service_statuses are not unique. If for any reason a duplicate entry for a service gets created, the call to update will always fail, as it's excepting only a single database entry.

https://github.com/openstack/designate/blob/fb5c1a97797c66292151549b82519a682b6300b6/designate/storage/impl_sqlalchemy/migrate_repo/versions/097_add_services.py
https://github.com/openstack/designate/blob/fb5c1a97797c66292151549b82519a682b6300b6/designate/storage/impl_sqlalchemy/__init__.py#L1771

We need to update the schema to only allow a unique entry per hostname/service_name.