summaryrefslogtreecommitdiffstats
path: root/roles/koschei
diff options
context:
space:
mode:
authorMichael Simacek <msimacek@redhat.com>2016-11-21 13:49:01 +0100
committerMichael Simacek <msimacek@redhat.com>2016-11-21 13:49:01 +0100
commit09588e69d3962fe08e350e0dde67e2f28dde4d43 (patch)
tree5daf450074eb8ac451f19233ebf5375f0f1e88c7 /roles/koschei
parented66e8b38a1f9ccc969f78574a2127eb068b098e (diff)
downloadansible-09588e69d3962fe08e350e0dde67e2f28dde4d43.tar.gz
ansible-09588e69d3962fe08e350e0dde67e2f28dde4d43.tar.xz
ansible-09588e69d3962fe08e350e0dde67e2f28dde4d43.zip
Log dead rows in koschei cleanup cronjob
Diffstat (limited to 'roles/koschei')
-rw-r--r--roles/koschei/backend/templates/cron-db-cleanup.j23
1 files changed, 1 insertions, 2 deletions
diff --git a/roles/koschei/backend/templates/cron-db-cleanup.j2 b/roles/koschei/backend/templates/cron-db-cleanup.j2
index 6a870363f..2ff33b8f0 100644
--- a/roles/koschei/backend/templates/cron-db-cleanup.j2
+++ b/roles/koschei/backend/templates/cron-db-cleanup.j2
@@ -1,5 +1,4 @@
SHELL=/bin/bash
MAILTO=sysadmin-koschei-members@fedoraproject.org
0 3 * * * koschei koschei-admin cleanup --older-than 6 >/dev/null
-#0 4,10,16,22 * * * koschei psql -h {{ koschei_pgsql_hostname }} -d koschei -U koscheiadmin <<< 'VACUUM ANALYZE package; VACUUM FULL ANALYZE package;'
-*/5 * * * * koschei psql -h {{ koschei_pgsql_hostname }} -d koschei -U koscheiadmin <<< 'VACUUM ANALYZE package' >/dev/null
+*/5 * * * * koschei koschei-admin psql <<< 'VACUUM FULL ANALYZE VERBOSE package' 2>&1 | awk '/DETAIL/{print$2}' > /var/log/vaccum.log