Page MenuHomePhabricator
Create Task
Maniphest T281405

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

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=*
SubjectRepoBranchLines +/-
Fix query error in ImageListPagermediawiki/corewmf/1.37.0-wmf.3+5 -4
Fix query error in ImageListPagermediawiki/coremaster+5 -4
Customize query in gerrit

Related Objects
Search...

Event Timeline

jeena created this task.Apr 28 2021, 7:34 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 28 2021, 7:34 PM
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' .Apr 28 2021, 7:34 PM
jeena triaged this task as Unbreak Now! priority.Apr 28 2021, 7:44 PM
jeena added a parent task: T278347: 1.37.0-wmf.3 deployment blockers.
• taavi merged a task: T281407: DB Error when attempting to go to user watchlist.Apr 28 2021, 7:46 PM
• taavi added a project: MediaWiki-File-management.
• taavi added a subscriber: Languageseeker.
• taavi added subscribers: tstarling, • taavi.Apr 28 2021, 7:48 PM

https://gerrit.wikimedia.org/r/c/mediawiki/core/+/680821 looks related, cc @tstarling

• taavi merged a task: T281411: Accessing [[Special:ListFiles]] triggers Database error in Wikimedia Commons.Apr 28 2021, 7:51 PM
• taavi added a subscriber: Ankry.
Maintenance_bot added a project: Commons.Apr 28 2021, 8:45 PM
Krinkle added a project: Platform Engineering.Apr 28 2021, 8:46 PM
Krinkle moved this task from Untriaged to Apr 2021 on the Wikimedia-production-error board.
Krinkle subscribed.

Likely fallout from Actor migration work.

• Pchelolo assigned this task to tstarling.Apr 28 2021, 8:47 PM
gerritbot added a comment.Apr 28 2021, 9:55 PM

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

gerritbot added a project: Patch-For-Review.Apr 28 2021, 9:55 PM
gerritbot added a comment.Apr 28 2021, 11:27 PM

Change 683440 merged by jenkins-bot:

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

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

ReleaseTaggerBot added a project: MW-1.37-notes (1.37.0-wmf.4; 2021-05-04).Apr 29 2021, 12:00 AM
gerritbot added a comment.Apr 29 2021, 12:09 AM

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

gerritbot added a comment.Apr 29 2021, 12:31 AM

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

Stashbot added a comment.Apr 29 2021, 12:40 AM

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)

tstarling closed this task as Resolved.Apr 29 2021, 12:43 AM
ReleaseTaggerBot edited projects, added MW-1.37-notes (1.37.0-wmf.3; 2021-04-27); removed MW-1.37-notes (1.37.0-wmf.4; 2021-05-04).Apr 29 2021, 1:00 AM
Maintenance_bot removed a project: Patch-For-Review.Apr 29 2021, 1:10 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