Page MenuHomePhabricator
Create Task
Maniphest 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
Closed, ResolvedPublicPRODUCTION ERROR
Actions

Description

Error
  • service.version: 1.46.0-wmf.16
  • timestamp: 2026-02-25T01:44:46.888Z
  • labels.phpversion: 8.3.30
  • trace.id: 6191214a-7fd0-425b-8e3f-a019481d4827
  • Find trace.id in Logstash
labels.normalized_message
[{reqId}] {exception_url}   PHP Deprecated: Caller from MediaWiki\Exception\MWExceptionHandler::rollbackPrimaryChanges ignored an error originally raised from MediaWiki\Pager\IndexPager::buildQueryInfo (MediaWiki\Specials\Pager\ImageListPager): [1054] Unk
FrameLocationCall
from/srv/mediawiki/php-1.46.0-wmf.16/includes/Debug/MWDebug.php(372)
#0[internal function]MediaWiki\Exception\MWExceptionHandler::handleError(int, string, string, int)
#1/srv/mediawiki/php-1.46.0-wmf.16/includes/Debug/MWDebug.php(372)trigger_error(string, int)
#2/srv/mediawiki/php-1.46.0-wmf.16/includes/DB/MWLBFactory.php(417)MediaWiki\Debug\MWDebug::sendRawDeprecated(string, bool, string)
#3/srv/mediawiki/php-1.46.0-wmf.16/includes/libs/Rdbms/Database/TransactionManager.php(175)MediaWiki\DB\MWLBFactory::logDeprecation(string)
#4/srv/mediawiki/php-1.46.0-wmf.16/includes/libs/Rdbms/Database/Database.php(1012)Wikimedia\Rdbms\TransactionManager->assertTransactionStatus(Wikimedia\Rdbms\DatabaseMySQL, Closure, string)
#5/srv/mediawiki/php-1.46.0-wmf.16/includes/libs/Rdbms/Database/Database.php(629)Wikimedia\Rdbms\Database->assertQueryIsCurrentlyAllowed(string, string)
#6/srv/mediawiki/php-1.46.0-wmf.16/includes/libs/Rdbms/Database/Database.php(2401)Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#7/srv/mediawiki/php-1.46.0-wmf.16/includes/libs/Rdbms/Database/Database.php(2571)Wikimedia\Rdbms\Database->commit(string, string)
#8/srv/mediawiki/php-1.46.0-wmf.16/includes/libs/Rdbms/LoadBalancer/LoadBalancer.php(1677)Wikimedia\Rdbms\Database->flushSnapshot(string)
#9/srv/mediawiki/php-1.46.0-wmf.16/includes/libs/Rdbms/LBFactory/LBFactory.php(359)Wikimedia\Rdbms\LoadBalancer->flushReplicaSnapshots(string)
#10/srv/mediawiki/php-1.46.0-wmf.16/includes/Exception/MWExceptionHandler.php(158)Wikimedia\Rdbms\LBFactory->rollbackPrimaryChanges(string)
#11/srv/mediawiki/php-1.46.0-wmf.16/includes/Exception/MWExceptionHandler.php(183)MediaWiki\Exception\MWExceptionHandler::rollbackPrimaryChanges()
#12/srv/mediawiki/php-1.46.0-wmf.16/includes/Exception/MWExceptionHandler.php(223)MediaWiki\Exception\MWExceptionHandler::rollbackPrimaryChangesAndLog(Wikimedia\Rdbms\DBQueryError, string)
#13/srv/mediawiki/php-1.46.0-wmf.16/includes/MediaWikiEntryPoint.php(200)MediaWiki\Exception\MWExceptionHandler::handleException(Wikimedia\Rdbms\DBQueryError, string)
#14/srv/mediawiki/php-1.46.0-wmf.16/includes/Actions/ActionEntryPoint.php(80)MediaWiki\MediaWikiEntryPoint->handleTopLevelError(Wikimedia\Rdbms\DBQueryError)
#15/srv/mediawiki/php-1.46.0-wmf.16/includes/MediaWikiEntryPoint.php(186)MediaWiki\Actions\ActionEntryPoint->handleTopLevelError(Wikimedia\Rdbms\DBQueryError)
#16/srv/mediawiki/php-1.46.0-wmf.16/index.php(44)MediaWiki\MediaWikiEntryPoint->run()
#17/srv/mediawiki/w/index.php(3)require(string)
#18{main}
Impact
Notes

Details

Request URL
https://fi.wikiversity.org/w/index.php?asc=*&offset=*&title=*
Related Changes in Gerrit:
SubjectRepoBranchLines +/-
ImageListPager: Use correct name field for batch lookupsmediawiki/corewmf/1.46.0-wmf.17+2 -1
ImageListPager: Use correct name field for batch lookupsmediawiki/corewmf/1.46.0-wmf.18+2 -1
ImageListPager: Use correct name field for batch lookupsmediawiki/coremaster+2 -1
ImageListPager: Properly support file schema migration read newmediawiki/corewmf/1.46.0-wmf.17+70 -15
ImageListPager: Properly support file schema migration read newmediawiki/coremaster+70 -15
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.
StatusSubtypeAssignedTask
· · ·
OpenLadsgroupT28741 Migrate file tables to a modern layout (image/oldimage; file/filerevision; add primary keys)
ResolvedPRODUCTION ERRORZabeT418327 PHP Deprecated: Caller from MediaWiki\Exception\MWExceptionHandler::rollbackPrimaryChanges ignored an error originally raised from MediaWiki\Pager\IndexPager::buildQueryInfo (MediaWiki\Specials\Pager\ImageListPager): [1054] Unk
· · ·

Event Timeline

Zabe created this task.Feb 25 2026, 1:46 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 25 2026, 1:46 AM
Zabe added a parent task: T28741: Migrate file tables to a modern layout (image/oldimage; file/filerevision; add primary keys).Feb 25 2026, 1:46 AM
Zabe added a project: MediaWiki-File-management.
Zabe added a comment.Feb 25 2026, 1:49 AM
Error 1054 from MediaWiki\Pager\IndexPager::buildQueryInfo (MediaWiki\Specials\Pager\ImageListPager), Unknown column 'img_timestamp' in 'WHERE' SELECT  fr_timestamp AS `img_timestamp`,file_name AS `img_name`,fr_size AS `img_size`,CASE WHEN file_latest = fr_id THEN 'yes' ELSE 'no' END AS `top`,comment_fr_description.comment_text AS `fr_description_text`,comment_fr_description.comment_data AS `fr_description_data`,comment_fr_description.comment_id AS `fr_description_cid`,'fr_description' AS `description_field`,actor_user,actor_name  FROM `file` JOIN `filerevision` ON ((fr_file=file_id)) JOIN `actor` ON ((actor_id=fr_actor)) JOIN `comment` `comment_fr_description` ON ((comment_fr_description.comment_id = fr_description_id))   WHERE file_deleted = 0 AND fr_deleted = 0 AND (file_latest = fr_id) AND (img_timestamp > '20140418171019' OR (img_timestamp = '20140418171019' AND (img_name > 'GNG-kollaasi2.png')))  ORDER BY img_timestamp,img_name LIMIT 51
Maintenance_bot added a project: Commons.Feb 25 2026, 2:30 AM
Umherirrender merged a task: T418384: Database error on second page of betacommons Special:NewFiles: Unknown column 'img_timestamp' in 'where clause'.Feb 25 2026, 3:39 PM
Umherirrender added a subscriber: AlexisJazz.
gerritbot added a comment.Feb 25 2026, 3:40 PM

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

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

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

gerritbot added a project: Patch-For-Review.Feb 25 2026, 3:40 PM
Zabe claimed this task.Feb 25 2026, 3:46 PM
Zabe added a project: DBA.
Zabe moved this task from Triage to In progress on the DBA board.
Marostegui subscribed.Feb 25 2026, 4:45 PM
In T418327#11649216, @Zabe wrote:
Error 1054 from MediaWiki\Pager\IndexPager::buildQueryInfo (MediaWiki\Specials\Pager\ImageListPager), Unknown column 'img_timestamp' in 'WHERE' SELECT  fr_timestamp AS `img_timestamp`,file_name AS `img_name`,fr_size AS `img_size`,CASE WHEN file_latest = fr_id THEN 'yes' ELSE 'no' END AS `top`,comment_fr_description.comment_text AS `fr_description_text`,comment_fr_description.comment_data AS `fr_description_data`,comment_fr_description.comment_id AS `fr_description_cid`,'fr_description' AS `description_field`,actor_user,actor_name  FROM `file` JOIN `filerevision` ON ((fr_file=file_id)) JOIN `actor` ON ((actor_id=fr_actor)) JOIN `comment` `comment_fr_description` ON ((comment_fr_description.comment_id = fr_description_id))   WHERE file_deleted = 0 AND fr_deleted = 0 AND (file_latest = fr_id) AND (img_timestamp > '20140418171019' OR (img_timestamp = '20140418171019' AND (img_name > 'GNG-kollaasi2.png')))  ORDER BY img_timestamp,img_name LIMIT 51

Anything we (DBAs) can help with here?

Zabe added a comment.Feb 25 2026, 5:58 PM
In T418327#11651529, @Marostegui wrote:
In T418327#11649216, @Zabe wrote:
Error 1054 from MediaWiki\Pager\IndexPager::buildQueryInfo (MediaWiki\Specials\Pager\ImageListPager), Unknown column 'img_timestamp' in 'WHERE' SELECT  fr_timestamp AS `img_timestamp`,file_name AS `img_name`,fr_size AS `img_size`,CASE WHEN file_latest = fr_id THEN 'yes' ELSE 'no' END AS `top`,comment_fr_description.comment_text AS `fr_description_text`,comment_fr_description.comment_data AS `fr_description_data`,comment_fr_description.comment_id AS `fr_description_cid`,'fr_description' AS `description_field`,actor_user,actor_name  FROM `file` JOIN `filerevision` ON ((fr_file=file_id)) JOIN `actor` ON ((actor_id=fr_actor)) JOIN `comment` `comment_fr_description` ON ((comment_fr_description.comment_id = fr_description_id))   WHERE file_deleted = 0 AND fr_deleted = 0 AND (file_latest = fr_id) AND (img_timestamp > '20140418171019' OR (img_timestamp = '20140418171019' AND (img_name > 'GNG-kollaasi2.png')))  ORDER BY img_timestamp,img_name LIMIT 51

Anything we (DBAs) can help with here?

Amir reviewing my patch :)

(once his vacation is over)

Zabe moved this task from Untriaged to Jan–Mar 2026 on the Wikimedia-production-error board.Feb 25 2026, 8:20 PM
gerritbot added a comment.Mar 2 2026, 1:56 PM

Change #1243869 merged by jenkins-bot:

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

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

gerritbot added a comment.Mar 2 2026, 1:58 PM

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

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

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

ReleaseTaggerBot added a project: MW-1.46-notes (1.46.0-wmf.18; 2026-03-03).Mar 2 2026, 3:01 PM
gerritbot added a comment.Mar 3 2026, 12:07 AM

Change #1247068 merged by jenkins-bot:

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

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

Stashbot added a comment.Mar 3 2026, 12:08 AM

Mentioned in SAL (#wikimedia-operations) [2026-03-03T00:08:40Z] <zabe@deploy2002> Started scap sync-world: Backport for [[gerrit:1247068|ImageListPager: Properly support file schema migration read new (T418327)]]

Stashbot added a comment.Mar 3 2026, 12:10 AM

Mentioned in SAL (#wikimedia-operations) [2026-03-03T00:10:29Z] <zabe@deploy2002> zabe: Backport for [[gerrit:1247068|ImageListPager: Properly support file schema migration read new (T418327)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Stashbot added a comment.Mar 3 2026, 12:13 AM

Mentioned in SAL (#wikimedia-operations) [2026-03-03T00:13:11Z] <zabe@deploy2002> Started scap sync-world: T418327

gerritbot added a comment.Mar 3 2026, 12:17 AM

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

[mediawiki/core@master] ImageListPager: Use correct name field for batch lookups

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

Stashbot added a comment.Mar 3 2026, 12:18 AM

Mentioned in SAL (#wikimedia-operations) [2026-03-03T00:18:12Z] <zabe@deploy2002> Finished scap sync-world: T418327 (duration: 05m 01s)

ReleaseTaggerBot edited projects, added MW-1.46-notes (1.46.0-wmf.17; 2026-02-24); removed MW-1.46-notes (1.46.0-wmf.18; 2026-03-03).Mar 3 2026, 1:00 AM
gerritbot added a comment.Mar 3 2026, 3:05 AM

Change #1247188 merged by jenkins-bot:

[mediawiki/core@master] ImageListPager: Use correct name field for batch lookups

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

Maintenance_bot removed a project: Patch-For-Review.Mar 3 2026, 3:30 AM
ReleaseTaggerBot edited projects, added MW-1.46-notes (1.46.0-wmf.19; 2026-03-10); removed MW-1.46-notes (1.46.0-wmf.17; 2026-02-24).Mar 3 2026, 4:00 AM
gerritbot added a comment.Mar 3 2026, 11:40 AM

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

[mediawiki/core@wmf/1.46.0-wmf.18] ImageListPager: Use correct name field for batch lookups

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

gerritbot added a project: Patch-For-Review.Mar 3 2026, 11:40 AM
gerritbot added a comment.Mar 3 2026, 3:49 PM

Change #1247569 merged by jenkins-bot:

[mediawiki/core@wmf/1.46.0-wmf.18] ImageListPager: Use correct name field for batch lookups

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

Stashbot added a comment.Mar 3 2026, 3:50 PM

Mentioned in SAL (#wikimedia-operations) [2026-03-03T15:50:37Z] <zabe@deploy2002> Started scap sync-world: Backport for [[gerrit:1247569|ImageListPager: Use correct name field for batch lookups (T418327)]]

Stashbot added a comment.Mar 3 2026, 3:54 PM

Mentioned in SAL (#wikimedia-operations) [2026-03-03T15:54:19Z] <zabe@deploy2002> zabe: Backport for [[gerrit:1247569|ImageListPager: Use correct name field for batch lookups (T418327)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Stashbot added a comment.Mar 3 2026, 4:00 PM

Mentioned in SAL (#wikimedia-operations) [2026-03-03T16:00:06Z] <zabe@deploy2002> Finished scap sync-world: Backport for [[gerrit:1247569|ImageListPager: Use correct name field for batch lookups (T418327)]] (duration: 09m 28s)

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 3 2026, 4:00 PM
Maintenance_bot removed a project: Patch-For-Review.Mar 3 2026, 4:30 PM
gerritbot added a comment.Mar 5 2026, 12:58 AM

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

[mediawiki/core@wmf/1.46.0-wmf.17] ImageListPager: Use correct name field for batch lookups

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

gerritbot added a project: Patch-For-Review.Mar 5 2026, 12:58 AM
gerritbot added a comment.Mar 5 2026, 1:20 AM

Change #1248154 merged by jenkins-bot:

[mediawiki/core@wmf/1.46.0-wmf.17] ImageListPager: Use correct name field for batch lookups

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

Stashbot added a comment.Mar 5 2026, 1:21 AM

Mentioned in SAL (#wikimedia-operations) [2026-03-05T01:21:39Z] <zabe@deploy2002> Started scap sync-world: Backport for [[gerrit:1248154|ImageListPager: Use correct name field for batch lookups (T418327)]], [[gerrit:1248153|Revert^2 "ImageListPager: Properly support file schema migration read new"]]

Stashbot added a comment.Mar 5 2026, 1:23 AM

Mentioned in SAL (#wikimedia-operations) [2026-03-05T01:23:39Z] <zabe@deploy2002> zabe: Backport for [[gerrit:1248154|ImageListPager: Use correct name field for batch lookups (T418327)]], [[gerrit:1248153|Revert^2 "ImageListPager: Properly support file schema migration read new"]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Stashbot added a comment.Mar 5 2026, 1:29 AM

Mentioned in SAL (#wikimedia-operations) [2026-03-05T01:29:00Z] <zabe@deploy2002> Finished scap sync-world: Backport for [[gerrit:1248154|ImageListPager: Use correct name field for batch lookups (T418327)]], [[gerrit:1248153|Revert^2 "ImageListPager: Properly support file schema migration read new"]] (duration: 07m 21s)

Zabe closed this task as Resolved.Mar 5 2026, 1:30 AM
Zabe removed a project: Patch-For-Review.
Zabe moved this task from In progress to Done on the DBA board.
ReleaseTaggerBot edited projects, added MW-1.46-notes (1.46.0-wmf.17; 2026-02-24); removed MW-1.46-notes (1.46.0-wmf.18; 2026-03-03).Mar 5 2026, 2:00 AM
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