Last modified: 2014-10-21 08:01:03 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T74228, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 72228 - At least one user is permanently unable to use Special:RecentChanges on translatewiki.net
At least one user is permanently unable to use Special:RecentChanges on trans...
Status: NEW
Product: MediaWiki
Classification: Unclassified
General/Unknown (Other open bugs)
unspecified
All All
: High critical (vote)
: ---
Assigned To: Nobody - You can work on this!
: code-update-regression, hhvm, i18n, performance, platformeng
Depends on:
Blocks: 39480
  Show dependency treegraph
 
Reported: 2014-10-19 10:27 UTC by Nemo
Modified: 2014-10-21 08:01 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Nemo 2014-10-19 10:27:26 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
Comment 1 Bawolff (Brian Wolff) 2014-10-19 20:50:33 UTC
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.
Comment 2 Nemo 2014-10-19 21:17:32 UTC
(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. ;)
Comment 3 Bawolff (Brian Wolff) 2014-10-19 23:33:59 UTC
(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
Comment 4 praveenp 2014-10-20 03:03:07 UTC
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.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links