https://bugzilla.wikimedia.org/show_bug.cgi?id=43452

       Web browser: ---
            Bug ID: 43452
           Summary: BacklinkCache::getLinks causes mysql client to run out
                    memory
           Product: MediaWiki
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: Unprioritized
         Component: Database
          Assignee: [email protected]
          Reporter: [email protected]
    Classification: Unclassified
   Mobile Platform: ---

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to