Page MenuHomePhabricator
Create Task
Maniphest T175338

Fatal: Wikimedia\Rdbms\DBQueryError on Special:AbuseFilter/examine: "Error: 1054 Unknown column 'rev_id' in 'field list' (10.64.16.191)"
Closed, ResolvedPublicPRODUCTION ERROR
Actions

Description

Trying to examine past edits from a user on mediawiki.org gives an exception:

[WbJgwgpAEKkAACsqsGoAAAAI] 2017-09-08 09:20:02: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

https://www.mediawiki.org/wiki/Special:AbuseFilter/examine?wpSearchUser=Babaji33&wpSearchPeriodStart=&wpSearchPeriodEnd=&submit=1

Details

Related Changes in Gerrit:
SubjectAuthorRepoBranchLines +/-
Select proper db fields in AbuseFilterExaminePagerChadmediawiki/extensions/AbuseFilterwmf/1.30.0-wmf.17+1 -1
Select proper db fields in AbuseFilterExaminePagerHasharmediawiki/extensions/AbuseFiltermaster+1 -1
Customize query in gerrit

Related Objects

Event Timeline

Ciencia_Al_Poder created this task.Sep 8 2017, 9:20 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 8 2017, 9:20 AM
Peachey88 added a project: Regression.Sep 8 2017, 9:39 AM
Aklapper added a comment.Sep 8 2017, 9:41 AM
WbJgwgpAEKkAACsqsGoAAAAI
Function: IndexPager::buildQueryInfo (AbuseFilterExaminePager)
Error: 1054 Unknown column 'rev_id' in 'field list' (10.64.16.191)
#0 /srv/mediawiki/php-1.30.0-wmf.17/includes/libs/rdbms/database/Database.php(979): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#1 /srv/mediawiki/php-1.30.0-wmf.17/includes/libs/rdbms/database/Database.php(1343): Wikimedia\Rdbms\Database->query(string, string)
#2 /srv/mediawiki/php-1.30.0-wmf.17/includes/pager/IndexPager.php(368): Wikimedia\Rdbms\Database->select(string, array, array, string, array, array)
#3 /srv/mediawiki/php-1.30.0-wmf.17/includes/pager/IndexPager.php(225): IndexPager->reallyDoQuery(string, integer, boolean)
#4 /srv/mediawiki/php-1.30.0-wmf.17/includes/pager/IndexPager.php(608): IndexPager->doQuery()
#5 /srv/mediawiki/php-1.30.0-wmf.17/includes/pager/ReverseChronologicalPager.php(35): IndexPager->isNavigationBarShown()
#6 /srv/mediawiki/php-1.30.0-wmf.17/extensions/AbuseFilter/includes/Views/AbuseFilterViewExamine.php(68): ReverseChronologicalPager->getNavigationBar()
#7 /srv/mediawiki/php-1.30.0-wmf.17/extensions/AbuseFilter/includes/Views/AbuseFilterViewExamine.php(57): AbuseFilterViewExamine->showResults()
#8 /srv/mediawiki/php-1.30.0-wmf.17/extensions/AbuseFilter/includes/Views/AbuseFilterViewExamine.php(26): AbuseFilterViewExamine->showSearch()
#9 /srv/mediawiki/php-1.30.0-wmf.17/extensions/AbuseFilter/includes/special/SpecialAbuseFilter.php(115): AbuseFilterViewExamine->show()
#10 /srv/mediawiki/php-1.30.0-wmf.17/includes/specialpage/SpecialPage.php(522): SpecialAbuseFilter->execute(string)
#11 /srv/mediawiki/php-1.30.0-wmf.17/includes/specialpage/SpecialPageFactory.php(578): SpecialPage->run(string)
#12 /srv/mediawiki/php-1.30.0-wmf.17/includes/MediaWiki.php(287): SpecialPageFactory::executePath(Title, RequestContext)
#13 /srv/mediawiki/php-1.30.0-wmf.17/includes/MediaWiki.php(848): MediaWiki->performRequest()
#14 /srv/mediawiki/php-1.30.0-wmf.17/includes/MediaWiki.php(523): MediaWiki->main()
#15 /srv/mediawiki/php-1.30.0-wmf.17/index.php(43): MediaWiki->run()
#16 /srv/mediawiki/w/index.php(3): include(string)
#17 {main}
Aklapper renamed this task from Fatal: Wikimedia\Rdbms\DBQueryError on Special:AbuseFilter/examine to Fatal: Wikimedia\Rdbms\DBQueryError on Special:AbuseFilter/examine: "Error: 1054 Unknown column 'rev_id' in 'field list' (10.64.16.191)".Sep 8 2017, 9:41 AM
Aklapper triaged this task as High priority.
Aklapper mentioned this in T175353: Special:AbuseFilter/examine gives a DBQueryError when trying to examine edits.Sep 8 2017, 12:19 PM
Aklapper merged a task: T175353: Special:AbuseFilter/examine gives a DBQueryError when trying to examine edits.
Aklapper added subscribers: Mbch331, WhitePhosphorus, Xiplus, Wong128hk.
hashar added subscribers: • demon, Anomie, hashar.Sep 8 2017, 12:34 PM

I think that got fixed by @demon via 3f4ba191f68bd16e45ee9643a584a8f2ab3fb9d0

Might have been introduced by cfa98448c3d44d92a60c352984990ec2cdcb3f2f

gerritbot subscribed.Sep 8 2017, 12:42 PM

Change 376709 had a related patch set uploaded (by Hashar; owner: Hashar):
[mediawiki/extensions/AbuseFilter@master] Select proper db fields in AbuseFilterExaminePager

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

gerritbot added a project: Patch-For-Review.Sep 8 2017, 12:42 PM
Antigng subscribed.Sep 8 2017, 12:47 PM

The problem seems to be a side effect of this.

• Suhadakashter closed this task as a duplicate of T175367: Page wikipedia.Sep 8 2017, 2:07 PM
• Suhadakashter closed this task as a duplicate of T175367: Page wikipedia.
Reedy reopened this task as Open.Sep 8 2017, 2:11 PM
Anomie added a comment.Sep 8 2017, 2:14 PM
In T175338#3591301, @hashar wrote:

I think that got fixed by @demon via 3f4ba191f68bd16e45ee9643a584a8f2ab3fb9d0

The opposite, actually.

gerritbot added a comment.Sep 8 2017, 2:21 PM

Change 376709 merged by jenkins-bot:
[mediawiki/extensions/AbuseFilter@master] Select proper db fields in AbuseFilterExaminePager

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

gerritbot added a comment.Sep 8 2017, 3:49 PM

Change 376742 had a related patch set uploaded (by Chad; owner: Hashar):
[mediawiki/extensions/AbuseFilter@wmf/1.30.0-wmf.17] Select proper db fields in AbuseFilterExaminePager

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

gerritbot added a comment.Sep 8 2017, 3:58 PM

Change 376742 merged by jenkins-bot:
[mediawiki/extensions/AbuseFilter@wmf/1.30.0-wmf.17] Select proper db fields in AbuseFilterExaminePager

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

ReleaseTaggerBot added a project: MW-1.30-release-notes (WMF-deploy-2017-09-05 (1.30.0-wmf.17)).Sep 8 2017, 4:01 PM
Stashbot subscribed.Sep 8 2017, 4:04 PM

Mentioned in SAL (#wikimedia-operations) [2017-09-08T16:04:37Z] <demon@tin> Synchronized php-1.30.0-wmf.17/extensions/AbuseFilter/includes/Views/AbuseFilterViewExamine.php: T175338, followup (duration: 00m 46s)

• demon closed this task as Resolved.Sep 8 2017, 4:05 PM
• demon claimed this task.
• Phabricator_maintenance added a project: RelEng-Archive-FY201718-Q1.Dec 21 2017, 7:00 PM
• mmodell changed the subtype of this task from "Task" to "Production Error".Aug 28 2019, 11:09 PM
Aklapper removed a subscriber: Anomie.Oct 16 2020, 5:40 PM
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