db purge job for glance should be configured to avoid huge database size

[Takashi Kajinami]

Glance provides the command "glance-manage db purge"[1] to purge all soft deleted records.
This command should be executed periodically to avoid glance database becomes bigger by getting filled by soft-deleted records.
 [1] https://docs.openstack.org/glance/latest/admin/db.html#purging-the-database

Note that generally we should avoid "glance-manage db purge_images_table"[2] because of security risks caused by purging image ids.
 [2] https://docs.openstack.org/glance/latest/admin/db.html#purging-the-images-table

[OpenStack Infra (hudson-openstack)]

Related fix proposed to branch: master
Review: https://review.opendev.org/747346

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/747352

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/747346
Committed: https://git.openstack.org/cgit/openstack/puppet-tripleo/commit/?id=d1b78d79460e7aec2c7e153c4299d5a5b0ab54af
Submitter: Zuul
Branch: master

commit d1b78d79460e7aec2c7e153c4299d5a5b0ab54af
Author: Takashi Kajinami <email address hidden>
Date: Fri Aug 21 16:29:21 2020 +0900

    Add support for glance db purge job

    Related-Bug: #1892467
    Depends-on: https://review.opendev.org/#/c/746452/
    Change-Id: Ie9cd653cc6d66911d00f9a92db30f33e2e1d1ad9

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/tripleo-heat-templates/+/747352
Committed: https://opendev.org/openstack/tripleo-heat-templates/commit/37bb2ecceb6b83e1f0d88523b795e02660acf3f0
Submitter: "Zuul (22348)"
Branch: master

commit 37bb2ecceb6b83e1f0d88523b795e02660acf3f0
Author: Takashi Kajinami <email address hidden>
Date: Fri Aug 21 16:48:43 2020 +0900

    Add glance db purge job

    This patch introduces glance_api_cron container to run glance db purge
    job periodically, so that soft-deleted records are removed from glance
    database.

    Change-Id: Ic34f1d53c5f344a4e6605a00e5cccd671663a444
    Closes-Bug: #1892467
    Depends-on: https://review.opendev.org/#/c/746452/
    Depends-on: https://review.opendev.org/#/c/747346/

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/wallaby
Review: https://review.opendev.org/c/openstack/tripleo-heat-templates/+/796658

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/tripleo-heat-templates/+/796658
Committed: https://opendev.org/openstack/tripleo-heat-templates/commit/733f3ecbe4e4faa6d9d2c6fa613c82d36b69ecd2
Submitter: "Zuul (22348)"
Branch: stable/wallaby

commit 733f3ecbe4e4faa6d9d2c6fa613c82d36b69ecd2
Author: Takashi Kajinami <email address hidden>
Date: Fri Aug 21 16:48:43 2020 +0900

    Add glance db purge job

    This patch introduces glance_api_cron container to run glance db purge
    job periodically, so that soft-deleted records are removed from glance
    database.

    Change-Id: Ic34f1d53c5f344a4e6605a00e5cccd671663a444
    Closes-Bug: #1892467
    Depends-on: https://review.opendev.org/#/c/746452/
    Depends-on: https://review.opendev.org/#/c/747346/
    (cherry picked from commit 37bb2ecceb6b83e1f0d88523b795e02660acf3f0)

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Related fix proposed to branch: stable/train
Review: https://review.opendev.org/c/openstack/puppet-tripleo/+/853755

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/train
Review: https://review.opendev.org/c/openstack/tripleo-heat-templates/+/858150

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/tripleo-heat-templates/+/858150
Committed: https://opendev.org/openstack/tripleo-heat-templates/commit/067510228af6db0d4588237033b91b6948d2b4bc
Submitter: "Zuul (22348)"
Branch: stable/train

commit 067510228af6db0d4588237033b91b6948d2b4bc
Author: Takashi Kajinami <email address hidden>
Date: Fri Aug 21 16:48:43 2020 +0900

    Add glance_api_cron container

    This patch introduces glance_api_cron container to run all glance cron
    job periodically.
    In train, cache pruner doesn't run even though it's there in the cron
    file generated by puppet. As the new 'glance_api_cron' container
    executes the cache jobs as well, this backport has only
    'glance_api_cron' container changes & db purge changes are skipped
    (db purge support is not there in train).

    NOTE: We are not backporting db purge changes with this change because
    the support of db purge cron job is not available in stable/train.

    Conflicts:
          deployment/glance/glance-api-container-puppet.yaml

    Change-Id: Ic34f1d53c5f344a4e6605a00e5cccd671663a444
    Closes-Bug: #1892467
    Depends-on: https://review.opendev.org/c/openstack/puppet-tripleo/+/858141
    (cherry picked from commit 37bb2ecceb6b83e1f0d88523b795e02660acf3f0)
    (cherry picked from commit 733f3ecbe4e4faa6d9d2c6fa613c82d36b69ecd2)

[OpenStack Infra (hudson-openstack)]

Change abandoned by "Takashi Kajinami <email address hidden>" on branch: stable/train
Review: https://review.opendev.org/c/openstack/puppet-tripleo/+/853755
Reason: Let's clean up stale patches because train is being EOLed

[OpenStack Infra (hudson-openstack)]

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