DescriptionAlvaro Lopez Ortega
2015-07-31 13:44:12 UTC
Description of problem:
The DB associated with an OpenStack deployment (mariadb) acts as a system backend, storing configuration and historical data for certain OpenStack services, including Compute, Identity Service, and Block Storage.
It's important to put practices in place for maintaining the size of the database with regards to automatic purging of unneeded data.
Identity Service (Keystone) does it with a crontab entry like this:
0 */1 * * * /usr/bin/keystone-manage token_flush >/dev/null 2>&1
We ought to do something similar with the rest of the components:
0 */12 * * * /usr/bin/nova-manage db archive_deleted_rows >/dev/null 2>&1
0 */24 * * * /usr/bin/cinder-manage db purge 1 >/dev/null 2>&1
The related upstream bugs, reviews and blueprints follow:
https://bugs.launchpad.net/nova/+bug/1183523https://review.openstack.org/#/c/200224/8https://review.openstack.org/#/c/184645/https://blueprints.launchpad.net/glance/+spec/database-purge
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.
For information on the advisory, and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.
https://access.redhat.com/errata/RHBA-2015:2677