Page MenuHomePhabricator

Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'img_actor'
Closed, ResolvedPublicPRODUCTION ERROR

Description

Error
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'img_actor' in 'on clause' (10.64.16.174)
Function: IndexPager::buildQueryInfo (ImageListPager)
Query: SELECT  oi_timestamp AS `img_timestamp`,oi_name AS `img_name`,oi_si
exception.trace
from /srv/mediawiki/php-1.37.0-wmf.3/includes/libs/rdbms/database/Database.php(1738)
#0 /srv/mediawiki/php-1.37.0-wmf.3/includes/libs/rdbms/database/Database.php(1722): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.37.0-wmf.3/includes/libs/rdbms/database/Database.php(1697): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-1.37.0-wmf.3/includes/libs/rdbms/database/Database.php(1260): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-1.37.0-wmf.3/includes/libs/rdbms/database/Database.php(1948): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/php-1.37.0-wmf.3/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5 /srv/mediawiki/php-1.37.0-wmf.3/includes/libs/rdbms/database/DBConnRef.php(313): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 /srv/mediawiki/php-1.37.0-wmf.3/includes/specials/pagers/ImageListPager.php(381): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#7 /srv/mediawiki/php-1.37.0-wmf.3/includes/pager/IndexPager.php(280): ImageListPager->reallyDoQuery(string, integer, boolean)
#8 /srv/mediawiki/php-1.37.0-wmf.3/includes/pager/IndexPager.php(788): IndexPager->doQuery()
#9 /srv/mediawiki/php-1.37.0-wmf.3/includes/pager/TablePager.php(310): IndexPager->isNavigationBarShown()
#10 /srv/mediawiki/php-1.37.0-wmf.3/includes/pager/TablePager.php(112): TablePager->getNavigationBar()
#11 /srv/mediawiki/php-1.37.0-wmf.3/includes/specials/SpecialListFiles.php(124): TablePager->getFullOutput()
#12 /srv/mediawiki/php-1.37.0-wmf.3/includes/specialpage/SpecialPage.php(646): SpecialListFiles->execute(string)
#13 /srv/mediawiki/php-1.37.0-wmf.3/includes/specialpage/SpecialPageFactory.php(1397): SpecialPage->run(string)
#14 /srv/mediawiki/php-1.37.0-wmf.3/includes/MediaWiki.php(313): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext)
#15 /srv/mediawiki/php-1.37.0-wmf.3/includes/MediaWiki.php(916): MediaWiki->performRequest()
#16 /srv/mediawiki/php-1.37.0-wmf.3/includes/MediaWiki.php(550): MediaWiki->main()
#17 /srv/mediawiki/php-1.37.0-wmf.3/index.php(53): MediaWiki->run()
#18 /srv/mediawiki/php-1.37.0-wmf.3/index.php(46): wfIndexMain()
#19 /srv/mediawiki/w/index.php(3): require(string)
#20 {main}
Impact

Happened over 75 times in the last 15 minutes

Notes

Details

Request URL
https://commons.wikimedia.org/w/index.php?title=*&ilshowall=*

Event Timeline

jeena renamed this task from Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'img_actor' in 'on clause' (10.64.16.174)Function: IndexPager::buildQueryInfo (ImageListPager)Query: SELECT oi_timestamp AS `img_timestamp`,oi_name AS `img_name`,oi_size AS `img_size`,'no' AS `top`,comment_oi_description.comment_text AS `oi_description_text`,comment_oi_description.comment_data AS `oi_description_data`,comment_oi_description.comment_id AS `oi_description_cid`,'oi_description' AS `description_field`,actor_user,actor_name FROM `oldimage` JOIN `comment` `comment_oi_description` ON ((comment_oi_description.comment_id = oi_description_id)) JOIN `actor` ON ((actor_id=img_actor)) WHERE actor_name = 'RandomUserGuy1738' AND oi_deleted = 0 ORDER BY oi_timestamp DESC,oi_name DESC LIMIT 51 to Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'img_actor' .Wed, Apr 28, 7:34 PM
jeena triaged this task as Unbreak Now! priority.Wed, Apr 28, 7:44 PM
Krinkle moved this task from Untriaged to Apr 2021 on the Wikimedia-production-error board.
Krinkle added a subscriber: Krinkle.

Likely fallout from Actor migration work.

Change 683440 had a related patch set uploaded (by Tim Starling; author: Tim Starling):

[mediawiki/core@master] Fix query error in ImageListPager

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

Change 683440 merged by jenkins-bot:

[mediawiki/core@master] Fix query error in ImageListPager

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

Change 683403 had a related patch set uploaded (by Tim Starling; author: Tim Starling):

[mediawiki/core@wmf/1.37.0-wmf.3] Fix query error in ImageListPager

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

Change 683403 merged by jenkins-bot:

[mediawiki/core@wmf/1.37.0-wmf.3] Fix query error in ImageListPager

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

Mentioned in SAL (#wikimedia-operations) [2021-04-29T00:40:58Z] <tstarling@deploy1002> Synchronized php-1.37.0-wmf.3/includes/specials/pagers/ImageListPager.php: T281405 (duration: 01m 08s)