Page MenuHomePhabricator
Create Task
Maniphest T417301

Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'img_name' in 'WHERE' Function: MediaWiki\FileRepo\File\LocalFile::loadExtraFromDB Query: SELECT * FROM (SELECT fr_metadata AS `img_metadata` FROM `file` JOIN `filere
Closed, ResolvedPublicPRODUCTION ERROR
Actions

Description

Error
  • service.version: 1.46.0-wmf.15
  • timestamp: 2026-02-12T11:42:22.144Z
  • labels.phpversion: 8.3.30
  • trace.id: 7ce93954-2b87-4909-a90b-eb2d70a3e966
  • Find trace.id in Logstash
labels.normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'img_name' in 'WHERE'
Function: MediaWiki\FileRepo\File\LocalFile::loadExtraFromDB
Query: SELECT  *  FROM (SELECT  fr_metadata AS `img_metadata`  FROM `file` JOIN `filere
FrameLocationCall
from/srv/mediawiki/php-1.46.0-wmf.15/includes/libs/Rdbms/Database/Database.php(1226)
#0/srv/mediawiki/php-1.46.0-wmf.15/includes/libs/Rdbms/Database/Database.php(1210)Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1/srv/mediawiki/php-1.46.0-wmf.15/includes/libs/Rdbms/Database/Database.php(1184)Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#2/srv/mediawiki/php-1.46.0-wmf.15/includes/libs/Rdbms/Database/Database.php(641)Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#3/srv/mediawiki/php-1.46.0-wmf.15/includes/libs/Rdbms/Database/Database.php(1364)Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4/srv/mediawiki/php-1.46.0-wmf.15/includes/libs/Rdbms/Database/Database.php(1374)Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5/srv/mediawiki/php-1.46.0-wmf.15/includes/libs/Rdbms/Database/DBConnRef.php(129)Wikimedia\Rdbms\Database->selectRow(array, array, array, string, array, array)
#6/srv/mediawiki/php-1.46.0-wmf.15/includes/libs/Rdbms/Database/DBConnRef.php(407)Wikimedia\Rdbms\DBConnRef->__call(string, array)
#7/srv/mediawiki/php-1.46.0-wmf.15/includes/libs/Rdbms/QueryBuilder/SelectQueryBuilder.php(809)Wikimedia\Rdbms\DBConnRef->selectRow(array, array, array, string, array, array)
#8/srv/mediawiki/php-1.46.0-wmf.15/includes/FileRepo/File/LocalFile.php(572)Wikimedia\Rdbms\SelectQueryBuilder->fetchRow()
#9/srv/mediawiki/php-1.46.0-wmf.15/includes/FileRepo/File/LocalFile.php(546)MediaWiki\FileRepo\File\LocalFile->loadExtraFieldsWithTimestamp(Wikimedia\Rdbms\DBConnRef, string)
#10/srv/mediawiki/php-1.46.0-wmf.15/includes/FileRepo/File/LocalFile.php(715)MediaWiki\FileRepo\File\LocalFile->loadExtraFromDB()
#11/srv/mediawiki/php-1.46.0-wmf.15/includes/FileRepo/File/LocalFile.php(1196)MediaWiki\FileRepo\File\LocalFile->load(int)
#12/srv/mediawiki/php-1.46.0-wmf.15/includes/FileRepo/File/File.php(790)MediaWiki\FileRepo\File\LocalFile->getMetadataItems(array)
#13/srv/mediawiki/php-1.46.0-wmf.15/extensions/PdfHandler/includes/PdfHandler.php(329)MediaWiki\FileRepo\File\File->getMetadataItem(string)
#14/srv/mediawiki/php-1.46.0-wmf.15/includes/FileRepo/File/File.php(2091)MediaWiki\Extension\PdfHandler\PdfHandler->formatMetadata(MediaWiki\FileRepo\File\LocalFile, MediaWiki\Context\RequestContext)
#15/srv/mediawiki/php-1.46.0-wmf.15/includes/Page/ImagePage.php(131)MediaWiki\FileRepo\File\File->formatMetadata(MediaWiki\Context\RequestContext)
#16/srv/mediawiki/php-1.46.0-wmf.15/includes/Actions/ViewAction.php(71)MediaWiki\Page\ImagePage->view()
#17/srv/mediawiki/php-1.46.0-wmf.15/includes/Actions/ActionEntryPoint.php(739)MediaWiki\Actions\ViewAction->show()
#18/srv/mediawiki/php-1.46.0-wmf.15/includes/Actions/ActionEntryPoint.php(510)MediaWiki\Actions\ActionEntryPoint->performAction(MediaWiki\Page\ImagePage, MediaWiki\Title\Title)
#19/srv/mediawiki/php-1.46.0-wmf.15/includes/Actions/ActionEntryPoint.php(144)MediaWiki\Actions\ActionEntryPoint->performRequest()
#20/srv/mediawiki/php-1.46.0-wmf.15/includes/MediaWikiEntryPoint.php(180)MediaWiki\Actions\ActionEntryPoint->execute()
#21/srv/mediawiki/php-1.46.0-wmf.15/index.php(44)MediaWiki\MediaWikiEntryPoint->run()
#22/srv/mediawiki/w/index.php(3)require(string)
#23{main}
Notes

Started with 1.46.0-wmf.15. Very low volume

Details

Request URL
https://test.wikipedia.org/wiki/File:Zionism_9204_Peace_Conference_1920_copy.pdf
Related Changes in Gerrit:
SubjectRepoBranchLines +/-
Math: Use mi element for \\operatorname in MathML to fix spacing issues.mediawiki/extensions/Mathmaster+8 -1
Fix Unknown column 'img_name' error in LocalFile metadata loadingmediawiki/coremaster+1 -1
file: Stop setting 'omit-nonlazy' while loading extra rows from the dbmediawiki/corewmf/1.46.0-wmf.15+3 -3
file: Stop setting 'omit-nonlazy' while loading extra rows from the dbmediawiki/coremaster+3 -3
Customize query in gerrit

Related Objects

Event Timeline

jnuche created this task.Feb 12 2026, 4:40 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 12 2026, 4:40 PM
jnuche moved this task from Untriaged to Jan–Mar 2026 on the Wikimedia-production-error board.Feb 12 2026, 4:41 PM
Reedy renamed this task from Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'img_name' in 'WHERE'Function: MediaWiki\FileRepo\File\LocalFile::loadExtraFromDBQuery: SELECT * FROM (SELECT fr_metadata AS `img_metadata` FROM `file` JOIN `filere to Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'img_name' in 'WHERE' Function: MediaWiki\FileRepo\File\LocalFile::loadExtraFromDB Query: SELECT * FROM (SELECT fr_metadata AS `img_metadata` FROM `file` JOIN `filere.Feb 12 2026, 4:43 PM
Maintenance_bot added a project: Commons.Feb 12 2026, 5:30 PM
Zabe merged a task: T417300: PHP Deprecated: Caller from MediaWiki\Exception\MWExceptionHandler::rollbackPrimaryChanges ignored an error originally raised from MediaWiki\FileRepo\File\LocalFile::loadExtraFromDB: [1054] Unknown column 'img_name' in 'WHERE'.Feb 12 2026, 6:25 PM
Zabe subscribed.
Zabe claimed this task.Feb 12 2026, 7:06 PM
Zabe added a project: DBA.
Zabe moved this task from Triage to In progress on the DBA board.
Marostegui subscribed.Feb 12 2026, 7:07 PM

Where is that?

Marostegui added a comment.Feb 12 2026, 7:08 PM
This comment was removed by Marostegui.
Marostegui added a comment.Feb 12 2026, 7:10 PM

I delete the above comment as I confused the column with: T415786
None of the s3 hosts have that column.

Ladsgroup subscribed.Feb 12 2026, 7:14 PM

@Marostegui The ticket is due to T416548: Start reading from file table on wmf production we just need to make some changes to the code. Basically part of larger work of T28741: Migrate file tables to a modern layout (image/oldimage; file/filerevision; add primary keys)

gerritbot added a comment.Feb 12 2026, 8:08 PM

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

[mediawiki/core@master] file: Stop setting 'omit-nonlazy' while loading extra rows from the db

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

gerritbot added a project: Patch-For-Review.Feb 12 2026, 8:08 PM
gerritbot added a comment.Feb 12 2026, 11:47 PM

Change #1239222 merged by jenkins-bot:

[mediawiki/core@master] file: Stop setting 'omit-nonlazy' while loading extra rows from the db

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

ReleaseTaggerBot added a project: MW-1.46-notes (1.46.0-wmf.16; 2026-02-17).Feb 13 2026, 12:01 AM
gerritbot added a comment.Feb 13 2026, 12:02 AM

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

[mediawiki/core@wmf/1.46.0-wmf.15] file: Stop setting 'omit-nonlazy' while loading extra rows from the db

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

gerritbot added a comment.Feb 13 2026, 12:13 AM

Change #1239267 merged by jenkins-bot:

[mediawiki/core@wmf/1.46.0-wmf.15] file: Stop setting 'omit-nonlazy' while loading extra rows from the db

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

Stashbot added a comment.Feb 13 2026, 12:13 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-13T00:13:51Z] <zabe@deploy2002> Started scap sync-world: Backport for [[gerrit:1239267|file: Stop setting 'omit-nonlazy' while loading extra rows from the db (T417301)]]

Stashbot added a comment.Feb 13 2026, 12:15 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-13T00:15:55Z] <zabe@deploy2002> zabe: Backport for [[gerrit:1239267|file: Stop setting 'omit-nonlazy' while loading extra rows from the db (T417301)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Stashbot added a comment.Feb 13 2026, 12:22 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-13T00:22:07Z] <zabe@deploy2002> Finished scap sync-world: Backport for [[gerrit:1239267|file: Stop setting 'omit-nonlazy' while loading extra rows from the db (T417301)]] (duration: 08m 15s)

Zabe closed this task as Resolved.Feb 13 2026, 12:26 AM
Maintenance_bot moved this task from In progress to Done on the DBA board.Feb 13 2026, 12:29 AM
Maintenance_bot removed a project: Patch-For-Review.
ReleaseTaggerBot edited projects, added MW-1.46-notes (1.46.0-wmf.15; 2026-02-10); removed MW-1.46-notes (1.46.0-wmf.16; 2026-02-17).Feb 13 2026, 1:00 AM
gerritbot added a comment.Feb 13 2026, 5:24 AM

Change #1239285 had a related patch set uploaded (by Prakhar0804; author: Prakhar0804):

[mediawiki/core@master] Fix Unknown column 'img_name' error in LocalFile metadata loading

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

gerritbot added a project: Patch-For-Review.Feb 13 2026, 5:24 AM
gerritbot added a comment.Feb 13 2026, 5:59 AM

Change #1239295 had a related patch set uploaded (by Prakhar0804; author: Prakhar0804):

[mediawiki/extensions/Math@master] Math: Use mi element for \\operatorname in MathML to fix spacing issues (T417301)

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

gerritbot added a comment.Feb 20 2026, 5:13 AM

Change #1239295 had a related patch set uploaded (by Pppery; author: Prakhar0804):

[mediawiki/extensions/Math@master] Math: Use mi element for \\operatorname in MathML to fix spacing issues.

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

gerritbot added a comment.Feb 26 2026, 2:22 AM

Change #1239285 abandoned by Zabe:

[mediawiki/core@master] Fix Unknown column 'img_name' error in LocalFile metadata loading

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

gerritbot added a comment.Tue, Mar 31, 10:00 AM

Change #1239295 abandoned by Physikerwelt:

[mediawiki/extensions/Math@master] Math: Use mi element for \\operatorname in MathML to fix spacing issues.

Reason:

Issue has been resolved T417301

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

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits