Page MenuHomePhabricator

BacklinkCache::getLinks causes mysql client to run out memory
Closed, ResolvedPublic

Description

(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.


Version: 1.21.x
Severity: normal

Details

Reference
bz43452

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 1:09 AM
bzimport set Reference to bz43452.

Related URL: https://gerrit.wikimedia.org/r/57663 (Gerrit Change I0b9710fe222b3d2cb4dc9ab2eeb0758873a8066c)

Related URL: https://gerrit.wikimedia.org/r/59415 (Gerrit Change I0b9710fe222b3d2cb4dc9ab2eeb0758873a8066c)