Last modified: 2014-07-16 12:18:43 UTC
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')
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 18.104.22.168 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.
Plus certain long pages can't be edited unless user has logged off, e.g. http://ar.wikipedia.org/wiki/اليمن
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 lots for me in under four seconds (Firefox 16.0.2), but 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)
Also see http://ar.wikipedia.org/wiki/%D9%86%D9%82%D8%A7%D8%B4_%D8%A7%D9%84%D9%82%D8%A7%D9%84%D8%A8:%D8%A7%D8%B3%D8%AA%D8%B4%D9%87%D8%A7%D8%AF
(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)
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