Page MenuHomePhabricator

Long delay in passing a request to long pages in Arabic Wikipedia
Closed, DeclinedPublic

Description

Author: slowclick

Description:
Hello, in Arabic wikipedia, many users report technical difficulties when they try to access the main page. some user have reported a very long delay (about 1-2 minutes) before they can load the main page. I was suspecting a server name indication since the secure server produced an error about the main page was not exit!
They experience the same issue after purge/bypass main page,s cache.
The errors occur per requesting the main page within the mediawiki interface using the main page's link, or by typing the address directly.
Here is some error they have reported:

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET /wikipedia/ar/wiki/الصفحة_الرئيسية.
Reason: Error reading from remote server

Apache/2.2.14 (Ubuntu) Server at secure.wikimedia.org Port 443

A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script

Query: UPDATE `user` SET user_touched = '20120911172013' WHERE user_id = '138585' AND (user_touched < '20120911172013')
Function: User::invalidateCache

while other pages can be modify/read naturally, a request to the main page made by a user who saved the main page,s path in his bookmark produce this error:

Request: GET http://ar.wikipedia.org/wiki/%D8%A7%D9%84%D8%B5%D9%81%D8%AD%D8%A9_%D8%A7%D9%84%D8%B1%D8%A6%D9%8A%D8%B3%D9%8A%D8%A9, from 62.76.41.63 via cp1004.eqiad.wmnet (squid/2.7.STABLE9) to 10.64.0.130 (10.64.0.130)
Error: ERR_READ_TIMEOUT, errno [No Error] at Fri, 14 Sep 2012 10:58:32 GMT

I,d like some one to investigate the issue and give me a recommendation and feedback, best regards.


Version: wmf-deployment
Severity: major

Details

Reference
bz40260

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 12:54 AM
bzimport set Reference to bz40260.
bzimport added a subscriber: Unknown Object (MLST).

Plus certain long pages can't be edited unless user has logged off, e.g. http://ar.wikipedia.org/wiki/اليمن

(In reply to comment #2)

http://ar.wikipedia.org/wiki/%D8%A7%D9%84%D9%8A%D9%85%D9%86 takes more than 10
seconds too load, very likely because it uses lots of templates (which would
make this a duplicate of bug 19262)

http://en.wikipedia.org/wiki/User_talk:Kaldari#Latency_in_Arabic_Wikipedia

NewPP limit report
Preprocessor visited node count: 40470/1000000
Preprocessor generated node count: 108070/1500000
Post‐expand include size: 825656/2048000 bytes
Template argument size: 579967/2048000 bytes
Highest expansion depth: 25/40
Expensive parser function count: 4/500

^ It doesn't look to be that bad..

But it takes over a minute for the html text

Removing the URL from the top as it upsets bugzilla

Antime / Zack: Is this still a problem for the main page? Loading time here was acceptable (less than 8 seconds) with a clean browser cache.

I also tried the Yemen article on https://ar.wikipedia.org/wiki/%D8%A7%D9%84%D9%8A%D9%85%D9%86?forceprofile=true three times, and the 3.8MB for that article taking always between 27 and 29 seconds in Firefox 30 with the "Network" tab of the "Developer tools" (but please do note that ?forceprofile=true makes it way slower!).

Top of profile output in its HTML source looks like this:

100.89% 1.450530 2 - WebStart.php-conf
100.77% 1.448705 2 - CommonSettings.php
100.00% 1.437702 1 - -total
95.20% 1.368729 1 - MediaWiki::main
75.44% 1.084556 1 - OutputPage::output
74.38% 1.069343 1 - Output-skin
74.33% 1.068663 1 - SkinTemplate::outputPage
67.01% 0.963423 1 - SkinTemplate::prepareQuickTemplate
55.46% 0.797374 1 - SkinTemplate::prepareQuickTemplate-stuff4
22.52% 0.323773 188 - hook: LanguageGetTranslatedLanguageNames
21.40% 0.307620 188 - LanguageNames::coreHook
18.26% 0.262488 1 - MediaWiki::performRequest
15.89% 0.228470 1 - MediaWiki::performAction
15.72% 0.226043 1 - Article::view
10.74% 0.154429 576 - MessageCache::get

Krinkle changed the task status from Open to Stalled.Mar 28 2017, 12:08 AM
Aklapper removed a subscriber: wikibugs-l-list.

Antime / Zack: Is this still a problem for the main page? Loading time here was acceptable (less than 8 seconds) with a clean browser cache.

Unfortunately closing this Phabricator task as no further information has been provided.

After you have provided the information asked for and if this still happens, please set the status of this task back to "Open" via the Add Action...Change Status dropdown. Thanks!