Andrew Bogott has uploaded a new change for review. https://gerrit.wikimedia.org/r/204519
Change subject: Change the keystone token cleanup cron. ...................................................................... Change the keystone token cleanup cron. Now run hourly with a limit -- the previous query was so gigantic that it essentiall never finished; instead we have to whittle the table down gradually. Change-Id: I004f6bad81905c4026a6e778c5764f9e11ead04f --- M modules/openstack/manifests/database-server.pp 1 file changed, 2 insertions(+), 3 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/19/204519/1 diff --git a/modules/openstack/manifests/database-server.pp b/modules/openstack/manifests/database-server.pp index b81d8fd..d0fbccd 100644 --- a/modules/openstack/manifests/database-server.pp +++ b/modules/openstack/manifests/database-server.pp @@ -142,10 +142,9 @@ cron { 'run-jobs': user => 'root', - hour => 8, - minute => 0, + minute => 20, ensure => present, - command => "/usr/bin/mysql $keystone_db_name -u${keystone_db_user} -p${keystone_db_pass} -e 'DELETE FROM token WHERE NOT DATE_SUB(CURDATE(),INTERVAL 2 DAY) <= expires;'", + command => "/usr/bin/mysql $keystone_db_name -u${keystone_db_user} -p${keystone_db_pass} -e 'DELETE FROM token WHERE NOW() - INTERVAL 2 day > expires LIMIT 10000;'", } } -- To view, visit https://gerrit.wikimedia.org/r/204519 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I004f6bad81905c4026a6e778c5764f9e11ead04f Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Andrew Bogott <abog...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits