Nova cron for archiving deleted rows isn't parametrable

[Emilien Macchi]

TripleO doesn't allow to configure the retention policy parameters for ::nova::cron::archive_deleted_rows so by default it only runs once a day, but we have got some feedback from real world deployments where it needs to happen more often.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/584998

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/584998
Committed: https://git.openstack.org/cgit/openstack/tripleo-heat-templates/commit/?id=0b5efadbf7ee4c1059a3bbc48470ad8d3a70108c
Submitter: Zuul
Branch: master

commit 0b5efadbf7ee4c1059a3bbc48470ad8d3a70108c
Author: Emilien Macchi <email address hidden>
Date: Mon Jul 23 14:39:49 2018 -0400

    nova: add parameters to configure nova::cron::archive_deleted_rows

    This patch adds new parameter to configure the crontab in charge of
    archiving the deleted rows in Nova database.
    The defaults were hard coded but now our operators can override it.
    New parameters:
      NovaCronDBArchivedMinute
      NovaCronDBArchivedHour
      NovaCronDBArchivedMonthday
      NovaCronDBArchivedMonth
      NovaCronDBArchivedWeekday

    Note: the default didn't change for backward compatibility.

    Closes-Bug: #1783155
    Change-Id: I786179e1604ccf192826b012992cc88dacdd2b87

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/queens
Review: https://review.openstack.org/587446

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/587446
Committed: https://git.openstack.org/cgit/openstack/tripleo-heat-templates/commit/?id=fb86ba19332f32ab9e65dab8440b15fad9ab2255
Submitter: Zuul
Branch: stable/queens

commit fb86ba19332f32ab9e65dab8440b15fad9ab2255
Author: Emilien Macchi <email address hidden>
Date: Mon Jul 23 14:39:49 2018 -0400

    nova: add parameters to configure nova::cron::archive_deleted_rows

    This patch adds new parameter to configure the crontab in charge of
    archiving the deleted rows in Nova database.
    The defaults were hard coded but now our operators can override it.
    New parameters:
      NovaCronDBArchivedMinute
      NovaCronDBArchivedHour
      NovaCronDBArchivedMonthday
      NovaCronDBArchivedMonth
      NovaCronDBArchivedWeekday

    Note: the default didn't change for backward compatibility.

    Closes-Bug: #1783155
    Change-Id: I786179e1604ccf192826b012992cc88dacdd2b87
    (cherry picked from commit 0b5efadbf7ee4c1059a3bbc48470ad8d3a70108c)

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/tripleo-heat-templates 9.0.0.0rc1 release candidate.

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/tripleo-heat-templates 8.0.6 release.