Page MenuHomePhabricator

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

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

Event Timeline

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

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

Zabe added a project: DBA.
Zabe moved this task from Triage to In progress on the DBA board.
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?

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)

Change #1243869 merged by jenkins-bot:

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

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

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

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

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)]]

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.

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

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

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

Change #1247188 merged by jenkins-bot:

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

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

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

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

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)]]

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.

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)

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

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

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"]]

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.

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 removed a project: Patch-For-Review.
Zabe moved this task from In progress to Done on the DBA board.