Last modified: 2014-03-31 10:02:03 UTC
Most of the time I get "504 Gateway Time-out" if I try to get the oldest abuse filter modification(s) using the API (try the URL above). The analogous query without "&ledir=newer" works perfectly.
It looks like the query is probably timing out because it's searching through all log entries in order by date for the first one with the specified action; since AbuseFilter is relatively recent, that's a lot to go through before it finds one. We should use the type_action index (instead of 'times') when leaction is given, but apparently that was never added to WMF wikis. So I'm marking this as depending on bug 49199.
I knew there was a previous bug like this one. Gerrit change #59418 (from bug 46713) should fix this too.
The given url works for me, maybe the remove of FORCE INDEX in Gerrit change #85436 was the fix.
No response this 3 weeks, so FIXED per comment 3
Change 59418 abandoned by Matthias Mullie: (bug 46713) Getting AFTv5 logs via API times out on English Wikipedia Reason: Looks like the forced indexes are gone, no need for this anymore https://gerrit.wikimedia.org/r/59418