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
