Last modified: 2014-10-21 08:01:03 UTC
For several weeks now, at least one user reports to be unable to use Special:RecentChanges on translatewiki.net, because it results in a 504 Gateway Time-out error. https://translatewiki.net/wiki/Thread:Support/Special:RecentChanges This particularly affects translators, who need to know what's going on in their language. Operating a wiki without RecentChanges is like operating a railway station without signs for timetable or directions. The problem was surfaced when the entire wiki was switched to hhvm, which is set up to use a 10 seconds time out instead of the traditional 30 seconds. Database queries are often longer than that. Niklas was kind enough to spend some 30 min extracting some data to assess the frequency of errors. 12.08 <+Nikerabbit> 94 200 12.08 <+Nikerabbit> 21 302 12.08 <+Nikerabbit> 17 404 12.08 <+Nikerabbit> 12 502 12.08 <+Nikerabbit> 10 499 12.08 <+Nikerabbit> 1 504 12.12 <+Nikerabbit> looking at the user agents there are at most 5 real users who can have encountered *any kind* of error for special:rc 12.16 <+Nikerabbit> Nemo_bis: those users have encountered an issue that the page has been failed to deliver. it does not mean that is a permanent error
This is presumably happening for people doing RC queries for all translations in some obscure language that doesn't have very many translations? If so, and if that's really common on TranslateWiki, maybe CleanChanges extension should optimize for that - add a field to recetchanges table with just the language code of the page, and then add an index on (language, rc_namespace, rc_timestamp) or whatever is appropriate given whatever the query actually is.
(In reply to Bawolff (Brian Wolff) from comment #1) > This is presumably happening for people doing RC queries for all > translations in some obscure language that doesn't have very many > translations? Probably, except that "obscure" here is ml with tens of millions speakers, not Klingon. ;)
(In reply to Nemo from comment #2) > (In reply to Bawolff (Brian Wolff) from comment #1) > > This is presumably happening for people doing RC queries for all > > translations in some obscure language that doesn't have very many > > translations? > > Probably, except that "obscure" here is ml with tens of millions speakers, > not Klingon. ;) Never underestimate the Klingon empire. Also https://translatewiki.net/w/i.php?title=Special:RecentChanges&translations=only&trailer=%2Ftlh times out too
I am able to access Recent Changes page if I open the link https://translatewiki.net/w/i.php?title=Special:RecentChanges&translations=only&trailer=/ml in a private window. But if I increase the 'Days to show in recent changes' to 30 and 'Number of edits to show by default' to 500 ( https://translatewiki.net/w/i.php?title=Special:RecentChanges&days=30&from=&limit=500&translations=only&trailer=%2Fml ) page times out. I set those values in my special:preference page, so not visible in the rc page address. The values are also possible to set through Recent changes page interface also, so I hope nothing wrong using so.