Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1589951 - Incorrect setting in Cinder's db purge cron job
Incorrect setting in Cinder's db purge cron job
Status: CLOSED ERRATA
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-tripleo-heat-templates (Show other bugs)
11.0 (Ocata)
Unspecified Unspecified
medium Severity medium
: z3
: 12.0 (Pike)
Assigned To: Alan Bishop
Avi Avraham
: Triaged, ZStream
Depends On: 1564519
Blocks:
  Show dependency treegraph
 
Reported: 2018-06-11 13:29 EDT by Alan Bishop
Modified: 2018-08-20 09:02 EDT (History)
5 users (show)

See Also:
Fixed In Version: openstack-tripleo-heat-templates-7.0.12-1.el7ost
Doc Type: Bug Fix
Doc Text:
The default age for purging deleted database records has been corrected so that deleted records are purged from Cinder's database. Previously, the CinderCronDbPurgeAge value for Cinder's purge cron job used the wrong value and deleted records were not purged from Cinder's DB when they reached the desired default age.
Story Points: ---
Clone Of: 1564519
Environment:
Last Closed: 2018-08-20 09:01:30 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)


External Trackers
Tracker ID Priority Status Summary Last Updated
Launchpad 1761749 None None None 2018-06-11 13:29 EDT
OpenStack gerrit 564029 None None None 2018-06-11 13:29 EDT
Red Hat Product Errata RHSA-2018:2331 None None None 2018-08-20 09:02 EDT

  None (edit)
Description Alan Bishop 2018-06-11 13:29:15 EDT
+++ This bug was initially created as a clone of Bug #1564519 +++

Description of problem:
The default value for Cinder's db purge cron job is incorrect. The THT parameter is defaulting the db purge job's "age in days" to 0, when instead it should match the default value in puppet-cinder, which is 30.

Version-Release number of selected component (if applicable):


How reproducible: 
Always

Steps to Reproduce:
1. Deploy overcloud with default CinderCronDbPurgeAge
2.
3.

Actual results:

Display cinder's cron job on controller:

[root@overcloud-controller-0 logrotate.d]# crontab -u cinder -l                                                                                                            
# HEADER: This file was autogenerated at 2018-04-05 21:04:24 +0000 by puppet.
# HEADER: While it can still be managed manually, it is definitely not recommended.
# HEADER: Note particularly that the comments starting with 'Puppet Name' should
# HEADER: not be deleted, as doing so could cause duplicate cron jobs.
# Puppet Name: cinder-manage db purge
PATH=/bin:/usr/bin:/usr/sbin SHELL=/bin/sh
1 0 * * * cinder-manage db purge 0 >>/var/log/cinder/cinder-rowsflush.log 2>&1

The "0" after "db purge" is the age setting that is incorrect.

Expected results:

The age should default to 30.

Additional info:

--- Additional comment from Alan Bishop on 2018-06-11 12:22:04 EDT ---

Retargeting for OSP-13 since 11 is EOL.

--- Additional comment from Alan Bishop on 2018-06-11 13:27:50 EDT ---

Upstream patch should arrive via next RDO import (for 13z1).
Comment 6 Tzach Shefi 2018-07-02 04:03:59 EDT
Verified on:
openstack-tripleo-heat-templates-7.0.12-1.el7ost.noarch

Post deployment what was before 'db purge 0' is now 'db purge 30'.
Looking good to verify,

[root@controller-0 ~]# crontab -u cinder -l
# HEADER: This file was autogenerated at 2018-06-30 19:05:34 +0000 by puppet.                                                                                                                                                                
# HEADER: While it can still be managed manually, it is definitely not recommended.                                                                                                                                                          
# HEADER: Note particularly that the comments starting with 'Puppet Name' should                                                                                                                                                             
# HEADER: not be deleted, as doing so could cause duplicate cron jobs.                                                                                                                                                                       
# Puppet Name: cinder-manage db purge                                                                                                                                                                                                        
PATH=/bin:/usr/bin:/usr/sbin SHELL=/bin/sh                                                                                                                                                                                                   
1 0 * * * cinder-manage db purge 30 >>/var/log/cinder/cinder-rowsflush.log 2>&1
Comment 9 errata-xmlrpc 2018-08-20 09:01:30 EDT
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/RHSA-2018:2331

Note You need to log in before you can comment on or make changes to this bug.