Description of problem: cinder cron job definition should have randomized sleep command like puppet-heat for decreasing DB spike or lock contention. Version-Release number of selected component (if applicable): Current puppet-cinder. Additional info: Current puppet-cinder configures the cron job like ~~~ # HEADER: This file was autogenerated at 2018-07-13 06:00:08 +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 ~~~ If many DB cron jobs are executed at the same time, it will trigger lock contention or DB spike. We should have randomized sleep in puppet-heat[0]. [0] https://github.com/openstack/puppet-heat/blob/master/manifests/cron/purge_deleted.pp#L70-L75
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-2019:1672