Future of filearchive table
Open, Needs TriagePublic
Actions

Assigned To

None

Authored By

	Bugreporter
	Mon, May 11, 1:59 AM

Description

T28741: Migrate file tables to a modern layout (image/oldimage; file/filerevision; add primary keys) does not yet touched the filearchive table. One may expect this table should also be migrated to filerevision, but it depends on how we will do in T20493: RFC: Unify the various deletion systems. This task is just a placeholder before the two subtasks are resolved.

Even if we decided to keep this table, some optimization can be done, such as we should migrate fa_media_type, fa_major_mime and fa_minor_mime to filetypes table.

Related Objects
Search...

Status	Subtype	Assigned	Task
Open		None	T425897 Future of filearchive table
Open		Ladsgroup	T28741 Migrate file tables to a modern layout (image/oldimage; file/filerevision; add primary keys)
Resolved		Krinkle	T589 RFC: image and oldimage tables
Resolved		Ladsgroup	T368113 Design and merge the new tables of file tables
Resolved		mforns	T389800 Update Commons Impact Metrics to account for new File table
Resolved		Ladsgroup	T383093 Set beta cluster to write both in file schema and thoroughly test it
Resolved		Ladsgroup	T383491 Deploy new file tables in production
Resolved		Ladsgroup	T383492 Write the migration script
Resolved		Zabe	T383496 Add support for reading new file schema into MediaWiki
Resolved		Dreamy_Jazz	T383555 Add support for reading new file schema in MediaModeration
Resolved		Ladsgroup	T384481 Set new file tables to write both in production
Resolved		Ladsgroup	T385167 Run data migration script for file migration
Duplicate		None	T386133 Update Data Pipelines with new image table schema
Resolved		Zabe	T412164 Set beta cluster to read new in file schema and thoroughly test it
Open		Ladsgroup	T415330 Add support for stop writing to the old file db schema
Open		Zabe	T416548 Start reading from file table on wmf production
Open	PRODUCTION ERROR	None	T418007 Wikimedia\Rdbms\DBQueryError: Error 1062: Duplicate entry 'Savannah_River_(26769689014).jpg' for key 'file_name'Function: MediaWiki\FileRepo\File\LocalFile::acquireFileIdFromNameQuery: INSERT INTO `file` (file_name,file_lates
Resolved	PRODUCTION ERROR	Zabe	T418327 PHP Deprecated: Caller from MediaWiki\Exception\MWExceptionHandler::rollbackPrimaryChanges ignored an error originally raised from MediaWiki\Pager\IndexPager::buildQueryInfo (MediaWiki\Specials\Pager\ImageListPager): [1054] Unk
Resolved	PRODUCTION ERROR	Zabe	T419062 Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'img_timestamp' in 'WHERE'Function: MediaWiki\Pager\IndexPager::buildQueryInfo (MediaWiki\Specials\Pager\NewFilesPager)Query: SELECT /! STRAIGHT_JOIN / file_name AS
Resolved	PRODUCTION ERROR	Zabe	T422946 Expectation (readQueryTime <= 5) by MediaWiki\Actions\ActionEntryPoint::execute not met (actual: {actualSeconds}) in trx #{trxId}:{query}
Resolved	Security	Zabe	T423654 Expectation (readQueryTime <= 5) by MediaWiki\Actions\ActionEntryPoint::execute not met (actual: {actualSeconds}) in trx #{trxId}:{query}
Resolved	BUG REPORT	Ladsgroup	T423978 Special:Mediastatistics is being weird and not grouping similar file types together
Open		Zabe	T425191 Drop old image tables from wikireplicas
Resolved		Zabe	T426804 filerevision view should not filter out deleted file revisions
Open		None	T20493 RFC: Unify the various deletion systems