QChris has uploaded a new change for review.
https://gerrit.wikimedia.org/r/78944
Change subject: Switch to changes table for gerrit's reviewer count file
......................................................................
Switch to changes table for gerrit's reviewer count file
The change_id table of our production database seems to miss the first
~6000 entries, which covers up to ~1st May 2012). Regardless of
whether this is gwtorm magic or it got corrupted at some point, we
cannot use it to get all change ids. So we switch to use the changes
table directly, eventhough this makes the query slightly more
expensive.
Bug: 52329
Change-Id: Ic15c39da0b7780baf54ba61807b13e5b1d4eb7be
---
M manifests/gerrit.pp
1 file changed, 1 insertion(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/44/78944/1
diff --git a/manifests/gerrit.pp b/manifests/gerrit.pp
index cf39d25..7f04437 100644
--- a/manifests/gerrit.pp
+++ b/manifests/gerrit.pp
@@ -343,7 +343,7 @@
cron { list_reviewer_counts:
# This is useful information about the distribution of
reviewers.
# Gerrit's rest api doesn't provide an easy way to get this
data.
- command => "ssh -p 29418 localhost gerrit gsql --format JSON -c
\"'SELECT change_id.s AS change_id, COUNT(DISTINCT
patch_set_approvals.account_id) AS reviewer_count FROM change_id LEFT JOIN
patch_set_approvals ON (change_id.s = patch_set_approvals.change_id) GROUP BY
change_id.s'\" > /var/www/reviewer-counts.json",
+ command => "ssh -p 29418 localhost gerrit gsql --format JSON -c
\"'SELECT changes.change_id AS change_id, COUNT(DISTINCT
patch_set_approvals.account_id) AS reviewer_count FROM changes LEFT JOIN
patch_set_approvals ON (changes.change_id = patch_set_approvals.change_id)
GROUP BY changes.change_id'\" > /var/www/reviewer-counts.json",
user => gerrit2,
hour => 1
}
--
To view, visit https://gerrit.wikimedia.org/r/78944
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic15c39da0b7780baf54ba61807b13e5b1d4eb7be
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: QChris <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
