Maniphest T419062

file_name AS
Closed, ResolvedPublicPRODUCTION ERROR
Actions

Assigned To

Authored By

	Zabe
	Mar 4 2026, 8:25 PM

Description

Error

service.version: 1.46.0-wmf.18
timestamp: 2026-03-04T19:55:08.992Z
labels.phpversion: 8.3.30
trace.id: bd9ddd0a-1a3e-4678-9f5b-2cad9a4eac8e
Find trace.id in Logstash

labels.normalized_message

[{reqId}] {exception_url}   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

Frame	Location	Call
from	/srv/mediawiki/php-1.46.0-wmf.18/includes/libs/Rdbms/Database/Database.php(1226)
#0	/srv/mediawiki/php-1.46.0-wmf.18/includes/libs/Rdbms/Database/Database.php(1210)	Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1	/srv/mediawiki/php-1.46.0-wmf.18/includes/libs/Rdbms/Database/Database.php(1184)	Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#2	/srv/mediawiki/php-1.46.0-wmf.18/includes/libs/Rdbms/Database/Database.php(641)	Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#3	/srv/mediawiki/php-1.46.0-wmf.18/includes/libs/Rdbms/Database/Database.php(1364)	Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4	/srv/mediawiki/php-1.46.0-wmf.18/includes/libs/Rdbms/Database/DBConnRef.php(129)	Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5	/srv/mediawiki/php-1.46.0-wmf.18/includes/libs/Rdbms/Database/DBConnRef.php(386)	Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6	/srv/mediawiki/php-1.46.0-wmf.18/includes/libs/Rdbms/QueryBuilder/SelectQueryBuilder.php(761)	Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#7	/srv/mediawiki/php-1.46.0-wmf.18/includes/Pager/IndexPager.php(468)	Wikimedia\Rdbms\SelectQueryBuilder->fetchResultSet()
#8	/srv/mediawiki/php-1.46.0-wmf.18/includes/Pager/IndexPager.php(259)	MediaWiki\Pager\IndexPager->reallyDoQuery(string, int, bool)
#9	/srv/mediawiki/php-1.46.0-wmf.18/includes/Pager/IndexPager.php(596)	MediaWiki\Pager\IndexPager->doQuery()
#10	/srv/mediawiki/php-1.46.0-wmf.18/includes/Specials/SpecialNewFiles.php(124)	MediaWiki\Pager\IndexPager->getBody()
#11	/srv/mediawiki/php-1.46.0-wmf.18/includes/SpecialPage/SpecialPage.php(711)	MediaWiki\Specials\SpecialNewFiles->execute(null)
#12	/srv/mediawiki/php-1.46.0-wmf.18/includes/SpecialPage/SpecialPageFactory.php(1712)	MediaWiki\SpecialPage\SpecialPage->run(null)
#13	/srv/mediawiki/php-1.46.0-wmf.18/includes/Actions/ActionEntryPoint.php(504)	MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, MediaWiki\Context\RequestContext)
#14	/srv/mediawiki/php-1.46.0-wmf.18/includes/Actions/ActionEntryPoint.php(144)	MediaWiki\Actions\ActionEntryPoint->performRequest()
#15	/srv/mediawiki/php-1.46.0-wmf.18/includes/MediaWikiEntryPoint.php(180)	MediaWiki\Actions\ActionEntryPoint->execute()
#16	/srv/mediawiki/php-1.46.0-wmf.18/index.php(44)	MediaWiki\MediaWikiEntryPoint->run()
#17	/srv/mediawiki/w/index.php(3)	require(string)
#18	{main}

Impact

Notes

Details

Request URL: https://wikimania2005.wikimedia.org/w/index.php?dir=*&mobileaction=*&offset=*&title=*

Related Changes in Gerrit:

Subject	Repo	Branch	Lines +/-
NewFilesPager: Properly support file schema migration read new	mediawiki/core	master	+25 -7
NewFilesPager: Properly support file schema migration read new	mediawiki/core	wmf/1.46.0-wmf.17	+25 -7
NewFilesPager: Properly support file schema migration read new	mediawiki/core	wmf/1.46.0-wmf.18	+25 -7

Customize query in gerrit

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		Ladsgroup	T28741 Migrate file tables to a modern layout (image/oldimage; file/filerevision; add primary keys)
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
			· · ·

Event Timeline

Zabe created this task.Mar 4 2026, 8:25 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 4 2026, 8:25 PM

Zabe added a parent task: T28741: Migrate file tables to a modern layout (image/oldimage; file/filerevision; add primary keys).Mar 4 2026, 8:27 PM

Change #1248093 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] NewFilesPager: Properly support file schema migration read new

https://gerrit.wikimedia.org/r/1248093

gerritbot added a project: Patch-For-Review.Mar 4 2026, 8:40 PM

Change #1248093 merged by jenkins-bot:

[mediawiki/core@master] NewFilesPager: Properly support file schema migration read new

https://gerrit.wikimedia.org/r/1248093

Change #1248123 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@wmf/1.46.0-wmf.18] NewFilesPager: Properly support file schema migration read new

https://gerrit.wikimedia.org/r/1248123

Change #1248125 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@wmf/1.46.0-wmf.17] NewFilesPager: Properly support file schema migration read new

https://gerrit.wikimedia.org/r/1248125

ReleaseTaggerBot added a project: MW-1.46-notes (1.46.0-wmf.19; 2026-03-10).Mar 4 2026, 11:00 PM

Zabe moved this task from Untriaged to Jan–Mar 2026 on the Wikimedia-production-error board.Mar 4 2026, 11:10 PM

Change #1248123 merged by jenkins-bot:

[mediawiki/core@wmf/1.46.0-wmf.18] NewFilesPager: Properly support file schema migration read new

https://gerrit.wikimedia.org/r/1248123

Change #1248125 merged by jenkins-bot:

[mediawiki/core@wmf/1.46.0-wmf.17] NewFilesPager: Properly support file schema migration read new

https://gerrit.wikimedia.org/r/1248125

Mentioned in SAL (#wikimedia-operations) [2026-03-05T00:10:07Z] <zabe@deploy2002> Started scap sync-world: Backport for [[gerrit:1248125|NewFilesPager: Properly support file schema migration read new (T419062)]], [[gerrit:1248123|NewFilesPager: Properly support file schema migration read new (T419062)]]

Mentioned in SAL (#wikimedia-operations) [2026-03-05T00:12:07Z] <zabe@deploy2002> zabe: Backport for [[gerrit:1248125|NewFilesPager: Properly support file schema migration read new (T419062)]], [[gerrit:1248123|NewFilesPager: Properly support file schema migration read new (T419062)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2026-03-05T00:18:59Z] <zabe@deploy2002> Finished scap sync-world: Backport for [[gerrit:1248125|NewFilesPager: Properly support file schema migration read new (T419062)]], [[gerrit:1248123|NewFilesPager: Properly support file schema migration read new (T419062)]] (duration: 08m 52s)

Zabe closed this task as Resolved.Mar 5 2026, 12:25 AM

Zabe claimed this task.

Zabe edited projects, added DBA; removed Patch-For-Review.

Zabe moved this task from Triage to Done on the DBA board.

ReleaseTaggerBot edited projects, added MW-1.46-notes (1.46.0-wmf.18; 2026-03-03); removed MW-1.46-notes (1.46.0-wmf.19; 2026-03-10).Mar 5 2026, 1:00 AM

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 ASClosed, ResolvedPublicPRODUCTION ERRORActions