Database table cleanup (tracking)
Open, LowPublicFeature
Actions

Assigned To

None

Authored By

	brion
	Dec 16 2008, 1:51 AM

Description

Tracking some issues requiring running of maintenance/cleanup scripts on Wikimedia sites...

Version: unspecified
Severity: enhancement
See Also:

Wikimedia-maintenance-script-run tasks
T54921 More specific, for dropping unused tables

Details

Reference: bz16660

Related Objects
Search...

View Standalone Graph

This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Status	Subtype	Assigned	Task
			· · ·
Open	Feature	None	T18660 Database table cleanup (tracking)
Resolved		None	T3919 fr.wikipedia.org: Date of next version is earlier than date of current version for some articles
Declined		None	T18614 subcat count > 0 for cats with no subcats on dewiki
Resolved		None	T18629 Corrupt protections in page_restrictions table
Resolved		None	T18658 Run refreshLinks.php on WMF wikis
Resolved		None	T14969 Incomplete Renameuser cases on Wikipedia
Open		None	T2323 Edits from various users active before 2003 are missing from Special:Contributions
Resolved		Legoktm	T5507 Invalid usernames on Wikimedia web sites
Open		None	T18674 Broken revisions with rev_page=0
Resolved		None	T16816 Edits reversed in page history
Resolved		None	T18666 Run namespaceDupes.php for French Wikinews
Duplicate		None	T4219 Incorrect revision dates on some revisions in various Wikimedia Foundation wikis
Declined		None	T9679 Revisions are switched in edit history
Resolved		None	T4559 Bogus MediaWiki: message entries in page history
Declined		None	T2781 UTF-8 Bug: umlaut misdisplayed
Resolved		FriedhelmW	T6312 Username of all whitespaces in German Wikipedia dump file
Resolved		tstarling	T18841 Data corruption apparently related to recompressTracked.php on wikis with $wgLegacyEncoding set
Stalled		None	T15196 Screen all previously uploaded SVG files for invalid structure
Resolved		None	T3444 Some categorized pages are (multi) listed as uncategorized
Resolved		None	T17152 Ghost categories in wanted categories
Duplicate		None	T6744 Error in editing timestamp?
Invalid		None	T11900 Duplicate rows in externallinks table
Resolved		None	T20488 Run refreshCategoryCounts.php on all WMF wikis
Resolved		None	T7230 Usernames with initial-lowercase letters need to be cleaned up across Wikimedia projects
Resolved		None	T7280 Invalid titles cannot be unwatched via Special:Watchlist/edit
Resolved		None	T8871 Database error: Edits not in correct order (afterwards)
Resolved		None	T19343 LogEventsList.php's getQueryInfo() INNER JOIN neglects log_user=0, causing deleteBatch.php's 'Delete page script' entries to be skipped
Resolved		RobH	T15729 Undelete page with invalid title at en.wikipedia
Resolved		RobH	T19476 Run 'fix redirects' for nl.wikipedia (possibly more sites need it)
Resolved		RobH	T14168 Ghost entries in bgwiki.categorylinks; wanted categories affected
Invalid		None	T17779 Recalculate statistic data
Resolved		None	T12667 Category link tables sometimes contain orphaned entries
Open	Feature	None	T17889 Write and run script to find non-existent images on Wikimedia wikis
Resolved		None	T19716 Some categories remain in Wantedcategories but they are empty
Resolved		None	T22641 Add namespace aliases for zhwiki.
Resolved		None	T19751 clean up null filenames from database by update.php
Invalid		None	T12834 site_stats.ss_good_articles and site_stats.ss_total_pages not synchronized with the real count
Duplicate	BUG REPORT	None	T24392 Revisions existing in both archive and revision tables
Resolved		tstarling	T18012 Schema change rotation script
Resolved		aaron	T5732 The logging table needs a log_user_text field so that events from anonymous users can be logged
Resolved		RobH	T19802 Update commons image count
Duplicate		None	T18036 Number of category members (PAGESINCATEGORY) is inaccurate for large categories
Resolved		tstarling	T22757 Corruption of text from early 2005 due to HistoryBlobStub pointers broken by recompressTracked.php
Resolved		None	T16365 Entries in the image table with invalid titles
Declined		None	T29711 Run populateLogUsertext.php on Wikimedia wikis
Resolved		None	T16672 Diff and revision unshowable, and user denies to have done this edit
Resolved		RobH	T18514 Special:Allpages for namespace 0 sometimes shows project namespace pages (namespaceDupes.php?)
Resolved		None	T28223 Errors in the revision table
Resolved		Krenair	T26675 Revision 186704908 on en.wikipedia.org, Fatal exception: unknown "cluster16"
Declined		None	T24936 Job queue issues with categories
Invalid		None	T31782 [DO NOT USE] Maintenance scripts waiting to be run on Wikimedia wikis (tracking) [superseded by #WMF-maintenance-script-run]
Resolved		None	T21919 Article count in Special:Statistics incorrect
Declined		tstarling	T21990 text of revisions in the archive table that were deleted before Wikipedia started using MediaWiki 1.5 is corrupt
Resolved		Krenair	T22017 Special:Statistics shows -1 active users
Resolved		None	T22143 Please repair broken kshwiki site stats.
Open	Feature	None	T25235 Renameuser: Migrate old log entries
Resolved		• werdna	T25236 Set all le_type to 'abusefilter' where le_type = 'abusefilte'
Open		None	T28741 Migrate file tables to a modern layout (image/oldimage; file/file_revision; add primary keys)
Resolved		None	T30465 Incubator needs database maintenance
Resolved		None	T25430 Clean up leftovers of WP: alias on dewiki
Resolved		None	T32185 Global account not appearing on Special:GlobalUsers – do maintenance/runBatchedQuery.php
Resolved		ArielGlenn	T25529 populateSha1 for some images on commons
Resolved		None	T19057 Images with wrong SHA1
Resolved		Reedy	T23881 Update archive table for old user renames
Resolved		None	T23962 Run refreshLinks.php --redirects-only on all wikis
Resolved		None	T30701 Run script on all wikis to mark revisions older than Apr 2008 as new when they are
Stalled	Feature	None	T24097 Populate user.user_registration DB field on every wiki
Resolved		hashar	T30805 incorrect interwiki link zh-classic because of wrong database data
Resolved		None	T25847 Clean up table user_newtalk
Resolved		None	T36014 ipblocks.ipb_address has inconsistent format
Declined		None	T29480 Fix page_props and iwlinks: run refreshLinks.php
Resolved		None	T30628 cleanup iwlinks table on WMF wikis
Resolved		Ladsgroup	T42626 Standardise type of timestamp database fields (MySQL)
Open		None	T41011 redirect, pagelinks and page.page_is_redirect table information out of sync
Stalled		None	T36320 Remove obsolete recentchanges.rc_new database field
Resolved		None	T42866 Remove $wgOldChangeTagsIndex
Resolved		None	T42867 Update change tag indexes
Resolved		Reedy	T48183 Populate archive.ar_len on all Wikimedia wikis
Resolved		None	T14188 Run maintenance/populateRevisionLength.php on all WMF wikis
Resolved		None	T33204 Remove old user.user_options
Invalid		None	T33218 Run convertUserOptions on all Wikimedia Wikis
Resolved		Anomie	T33223 Remove old archive.ar_text/archive.ar_flags
Declined		None	T34858 Do not parse .js/.css pages and save their parsed content in database tables
Resolved		Umherirrender	T36960 drop unused fields recentchanges.rc_moved_to_ns and recentchanges.rc_moved_to_title
Resolved		None	T36981 Rerun populateParentId from some IDs (English Wikipedia)
Resolved		None	T45913 Please create and run a maintenance script to consolidate some user rights changes made at Meta-Wiki
Resolved		Krinkle	T45917 Delete all redundant "MediaWiki" pages for system messages
Resolved		bd808	T63223 run maintenance script to repair EducationProgram summary data
Resolved		Legoktm	T63876 Attach all broken autocreated local accounts to their global account
Resolved		Legoktm	T71291 Run migrateAccount.php without --safe or --auto
Resolved		Nemo_bis	T73559 Spurious entry in globalimagelinks for File:France_demographie.png
Resolved		Legoktm	T76512 Remove invalid emails from the database
Resolved		Legoktm	T89482 Figure out what to do with non-existent wikis that are still connected to SUL
Resolved		Legoktm	T75181 Remove HHVM and PHP7 revision tags
Resolved		Umherirrender	T92775 Clean up broken CheckUser block log parameters
Invalid		ArielGlenn	T68676 Around 1% of usernames lack valid userid (is 0 instead)
Invalid		None	T112369 Revisions where rev_user_text differs from user_name
Resolved		None	T24907 Inconsistent values of rev_user_text on pl.wikipedia due to incomplete renames (apparently)
Open		None	T106941 Early edits on en.wiki with rev_user = 0 and truncated rev_user_text
Resolved		ArielGlenn	T29992 user names show up in <ip> tags
Resolved		None	T5631 security gap: IP style user names - IP range style user names - hijacking these accounts
Resolved		Krenair	T117440 Clean up "gadget--%" rows from user_properties on Wikimedia wikis
Open		None	T54778 Clean up skin user preferences in user_properties table on Wikimedia wikis
			Restricted Task
Open		None	T123313 Some revisions on Chinese Wikisource have timestamps from January 1970 and January 2001
Declined		None	T29807 Restore missing CheckUser logs
Declined		None	T87716 Missing rows from categorylinks on production servers (dewiki)
Resolved		KartikMistry	T172364 Remove cx_drafts table from production
			Restricted Task
			Restricted Task
Open		None	T174513 Maintenance script to cleanup querycache
Resolved		LSobanski	T54921 Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking)
Open		None	T112377 Revisions on enwiki from July 2004 with incorrect rev_user
Open		None	T108434 Some rows (from the year 2004) in SQL databases have text in latin1 encoding
Resolved		Ammarpad	T270033 Fix and enforce table prefix usage in columns and indexes in core
			· · ·

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes

• bzimport set Reference to bz16660.Nov 21 2014, 10:28 PM

• bzimport added a subscriber: Unknown Object (MLST).

brion created this task.Dec 16 2008, 1:51 AM

Bug 25762 has been marked as a duplicate of this bug. ***

Who is running such multi-wiki scripts now? Priyanka Dhanda seems to have left the WMF, if wiki is up-to-date, and she had a script for such tasks which she used some times.

Copying the meaning of this tracking bug from bug 16614:

(Aryeh Gregor in comment #2)

Re dependency on 16660: this should really be fixed so that it doesn't happen
again/automatically fixes itself, not just by running a script on Wikimedia.

(Brion Vibber in reply to comment #2)