Last modified: 2014-10-10 18:42:48 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 T56122, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 54122 - Opening Commons Delinker command page on wiki sometimes returns HTTP 504: Gateway Timeout -- SQL query sometimes super slow
Opening Commons Delinker command page on wiki sometimes returns HTTP 504: Gat...
Status: RESOLVED FIXED
Product: Wikimedia
Classification: Unclassified
General/Unknown (Other open bugs)
unspecified
All All
: High normal (vote)
: ---
Assigned To: Nobody - You can work on this!
: ops, performance
Depends on:
Blocks: commons
  Show dependency treegraph
 
Reported: 2013-09-14 12:00 UTC by Rainer Rillke @commons.wikimedia
Modified: 2014-10-10 18:42 UTC (History)
6 users (show)

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


Attachments

Description Rainer Rillke @commons.wikimedia 2013-09-14 12:00:11 UTC
Requesting https://commons.wikimedia.org/wiki/User:CommonsDelinker/commands?action=edit often returns 

HTTP 504: Gateway Timeout. 

This does not happen when requesting the page with a high frequence but if you do it e.g. once an hour. Just look at https://commons.wikimedia.org/w/index.php?title=User:Rillke/CDC_mystery&action=history where I dump the profiling report of this page using https://commons.wikimedia.org/wiki/User:Rillke/profile.js -- about every third request fails.

Other users experience this issue as well:
https://commons.wikimedia.org/w/index.php?title=Commons:Administrators%27_noticeboard&oldid=104206956#Extremely_slow_performance_to_open_edit_interface_of_COM:CDC

If I remember correctly, this is an issue for a long time. Updating the page via API often works without any issues (but is slow). The page is regularly queried and updated by a bot: http://toolserver.org/~delinker/helper.txt
Comment 1 Nemo 2013-09-16 14:35:11 UTC
Isn't this just the "standard" timeout for (uncached/just edited) pages with a lot of templates, like [[m:User:Cbrown1023/Logos]]?
Comment 2 Rainer Rillke @commons.wikimedia 2013-09-16 20:03:27 UTC
(In reply to comment #1)
The issue is that there were not a lot of templates on the page at the time the requests failed:
Exmaple:
17:40, 14 September 2013 ( https://commons.wikimedia.org/w/index.php?title=User:Rillke/CDC_mystery&oldid=104315333 )

https://commons.wikimedia.org/w/index.php?title=User:CommonsDelinker/commands&oldid=104314668 ( https://commons.wikimedia.org/w/index.php?title=User:CommonsDelinker/commands&action=edit&oldid=104314668 )
CPU time usage	0.656 seconds
Real time usage	0.767 seconds
Preprocessor visited node count	1285/1000000
Preprocessor generated node count	4672/1500000
Post-expand include size	60326/2048000 bytes
Template argument size	29773/2048000 bytes
Highest expansion depth	12/40
Expensive parser function count	33/500
Comment 3 Rainer Rillke @commons.wikimedia 2013-09-17 06:23:12 UTC
So here is the complete message:
<head><title>504 Gateway Time-out</title></head>
<body bgcolor="white">
<center><h1>504 Gateway Time-out</h1></center>
<hr><center>nginx/1.1.19</center>
</body>
</html>
----
https://commons.wikimedia.org/w/index.php?title=User:Rillke/CDC_mystery&oldid=104491400 22:37, 16 September 2013
----
If you need a special response header for debugging, please let me know.
Comment 4 Rainer Rillke @commons.wikimedia 2013-09-17 21:21:06 UTC
And I found something interesting:
* https://commons.wikimedia.org/w/index.php?title=User:Rillke/CDC_mystery&oldid=104442630
* https://commons.wikimedia.org/w/index.php?title=User:Rillke/CDC_mystery&oldid=104401867


The following took ~50s!

query: SELECT log_id,log_type,log_action,log_timestamp,log_user,log_user_text,log_namespace,log_title,log_comment,log_params,log_deleted,user_id,user_name,user_editcount,ts_tags FROM `logging` FORCE INDEX (page_time,user_time,log_user_type_time) LEFT JOIN `user`
Comment 5 Rainer Rillke @commons.wikimedia 2013-09-17 21:25:15 UTC
Also:
* https://commons.wikimedia.org/w/index.php?title=User:Rillke/CDC_mystery&oldid=104293543
Comment 6 Rainer Rillke @commons.wikimedia 2013-09-17 21:29:04 UTC
Can a tech please confirm this is an instance of Bug 53577 ?
Comment 7 Andre Klapper 2013-09-18 23:12:17 UTC
Sean: Could you answer comment 6, please? Thanks in advance!
Comment 8 Sean Pringle 2013-09-19 17:51:13 UTC
The truncated query in comment #6 comes from the same class as bug 53577 but forces different indexes. So, possibly it's the same type of problem, but need to see a complete example.
Comment 9 Rainer Rillke @commons.wikimedia 2013-10-12 12:25:15 UTC
(In reply to comment #8)
Is there anything I could help with?
Comment 10 Nemo 2014-03-13 13:27:41 UTC
This error is not in the tool's code though, adding keyword
Comment 11 Rainer Rillke @commons.wikimedia 2014-03-13 13:34:08 UTC
There is nothing the maintainers of the tool can do here, so it shouldn't be a bug of the tool, IMHO.
Comment 12 Andre Klapper 2014-03-14 11:41:55 UTC
I see. Thanks for correcting me!
Comment 13 Andre Klapper 2014-09-21 21:51:47 UTC
Is that still an issue experienced?
Comment 14 Andre Klapper 2014-10-10 16:33:04 UTC
Is that still an issue experienced?
Comment 15 Steinsplitter 2014-10-10 18:42:48 UTC
(In reply to Andre Klapper from comment #14)
> Is that still an issue experienced?

Sorry for the late reply.. Nope. Worked fine in the last months.

(Maybe a other software change fixed this, closing now as RES - FIX)

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


Navigation
Links