Last modified: 2011-07-21 21:46:32 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 T22651, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 20651 - Maintenance.php function purgeRedundantText() not able to deal with big data set
Maintenance.php function purgeRedundantText() not able to deal with big data set
Status: NEW
Product: MediaWiki
Classification: Unclassified
Maintenance scripts (Other open bugs)
1.16.x
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2009-09-15 12:31 UTC by Kelson [Emmanuel Engelhart]
Modified: 2011-07-21 21:46 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Kelson [Emmanuel Engelhart] 2009-09-15 12:31:34 UTC 
deleteOldRevisions.php calls Maintenance.php function purgeRedundantText().

Running in on a big DB (more than 200.000 pages) the script dies like following:

Il database ha restituito il seguente errore "1153: Got a packet bigger than
'max_allowed_packet' bytes (localhost)".

I think the SQL reauests including "NOT IN ($set)" or "IN ($set)" are responsible for that because they can only accept a few hundreds or thousands of ids.

Please confirm if I'm right.
Comment 1 Mark A. Hershberger 2011-07-21 21:46:32 UTC 
Chad confirmed this.  Basically need to refactor so that the function handles smaller chunks of data.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links