Last modified: 2014-03-10 09:18:22 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 T64276, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 62276 - rebuildtextindex.php doesnt remove wrong data in the searchindex table
rebuildtextindex.php doesnt remove wrong data in the searchindex table
Status: NEW
Product: MediaWiki
Classification: Unclassified
Maintenance scripts (Other open bugs)
1.22.3
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-03-05 21:37 UTC by Joerg
Modified: 2014-03-10 09:18 UTC (History)
2 users (show)

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


Attachments

Description Joerg 2014-03-05 21:37:33 UTC
When you have invalid data in the searchindex table, the maintenance script rebuildtextindex.php is there to fix that. However, this currently does not work:

The script currently does only update the _SQL index_, not the _rows_ of the searchindex table. So rows, which should not be there (e.g. as they point to a deleted page), will _stay_(!) in the index. That way the index is created based on wrong data.

rebuildtextindex.php should first rebuild the _actual table data_, before it recreates the SQL index (based on that data).
Comment 1 Joerg 2014-03-05 21:41:03 UTC
rebuildtextindex.php works correctly when you truncate the searchindex table before you run rebuildtextindex.php. Adding this step to rebuildtextindex.php should solve the issue.
Comment 2 Andre Klapper 2014-03-10 09:18:22 UTC
Thanks for taking the time to report this!

In case you are interested to provide a patch, see https://www.mediawiki.org/wiki/Developer_access

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


Navigation
Links