Last modified: 2013-04-16 22:16:23 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 T45452, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 43452 - BacklinkCache::getLinks causes mysql client to run out memory
BacklinkCache::getLinks causes mysql client to run out memory
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.21.x
All All
: Normal normal (vote)
: ---
Assigned To: Aaron Schulz
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2012-12-27 01:10 UTC by Aaron Schulz
Modified: 2013-04-16 22:16 UTC (History)
3 users (show)

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


Attachments

Description Aaron Schulz 2012-12-27 01:10:00 UTC
(from bug 37731)
> https://gerrit.wikimedia.org/r/#/c/32488/ added a limit to
> BacklinkCache::getNumLinks but some related jobs are still failing in
> BacklinkCache::getLinks like this:
> 
> Wed Dec 26 23:40:42 UTC 2012    mw14    commonswiki    
> BacklinkCache::getLinks
> 10.0.6.61       2008    MySQL client ran out of memory (10.0.6.61)     
> SELECT 
> /*! STRAIGHT_JOIN */ page_namespace,page_title,page_id  FROM
> `templatelinks`,`page`  WHERE tl_namespace = '10' AND tl_title = 'Date' AND
> (page_id=tl_from)  ORDER BY tl_from
> 
> That query returns 12384915 rows and would have to be batched.
Comment 1 Gerrit Notification Bot 2013-04-04 21:56:04 UTC
Related URL: https://gerrit.wikimedia.org/r/57663 (Gerrit Change I0b9710fe222b3d2cb4dc9ab2eeb0758873a8066c)
Comment 2 Gerrit Notification Bot 2013-04-16 16:02:44 UTC
Related URL: https://gerrit.wikimedia.org/r/59415 (Gerrit Change I0b9710fe222b3d2cb4dc9ab2eeb0758873a8066c)

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


Navigation
Links