Page MenuHomePhabricator

Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'actor_user' in 'on clause'
Closed, ResolvedPublicPRODUCTION ERROR

Description

Error
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'actor_user' in 'on clause' (10.64.32.222:3311)
Function: SpecialWatchlist::doMainQuery
Query: SELECT  rc_id,rc_timestamp,rc_namespace,rc_title,rc_minor,rc_bot,rc_new,rc_
exception.trace
from /srv/mediawiki/php-1.37.0-wmf.4/includes/libs/rdbms/database/Database.php(1738)
#0 /srv/mediawiki/php-1.37.0-wmf.4/includes/libs/rdbms/database/Database.php(1722): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.37.0-wmf.4/includes/libs/rdbms/database/Database.php(1697): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-1.37.0-wmf.4/includes/libs/rdbms/database/Database.php(1260): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-1.37.0-wmf.4/includes/libs/rdbms/database/Database.php(1948): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/php-1.37.0-wmf.4/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.4/includes/libs/rdbms/database/DBConnRef.php(313): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 /srv/mediawiki/php-1.37.0-wmf.4/includes/specials/SpecialWatchlist.php(478): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#7 /srv/mediawiki/php-1.37.0-wmf.4/includes/specialpage/ChangesListSpecialPage.php(1032): SpecialWatchlist->doMainQuery(array, array, array, array, array, FormOptions)
#8 /srv/mediawiki/php-1.37.0-wmf.4/includes/specialpage/ChangesListSpecialPage.php(635): ChangesListSpecialPage->getRows()
#9 /srv/mediawiki/php-1.37.0-wmf.4/includes/specials/SpecialWatchlist.php(136): ChangesListSpecialPage->execute(NULL)
#10 /srv/mediawiki/php-1.37.0-wmf.4/includes/specialpage/SpecialPage.php(646): SpecialWatchlist->execute(NULL)
#11 /srv/mediawiki/php-1.37.0-wmf.4/includes/specialpage/SpecialPageFactory.php(1396): SpecialPage->run(NULL)
#12 /srv/mediawiki/php-1.37.0-wmf.4/includes/MediaWiki.php(313): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext)
#13 /srv/mediawiki/php-1.37.0-wmf.4/includes/MediaWiki.php(916): MediaWiki->performRequest()
#14 /srv/mediawiki/php-1.37.0-wmf.4/includes/MediaWiki.php(550): MediaWiki->main()
#15 /srv/mediawiki/php-1.37.0-wmf.4/index.php(53): MediaWiki->run()
#16 /srv/mediawiki/php-1.37.0-wmf.4/index.php(46): wfIndexMain()
#17 /srv/mediawiki/w/index.php(3): require(string)
#18 {main}
Impact

Unclear.

Notes

~17 of these in 1.37.0-wmf.4.

Details

Request URL
https://en.wikipedia.org/wiki/Special:Watchlist?userExpLevel=*&hidepreviousrevisions=*&hidecategorization=*&hideWikibase=*&limit=*&days=*&userExpLevel__newcomer_color=*&urlversion=*

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Change 685921 had a related patch set uploaded (by Ppchelko; author: Ppchelko):

[mediawiki/core@master] Reorder tables in SpecialWatchlist

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

Change 685890 had a related patch set uploaded (by Brennen Bearnes; author: Ppchelko):

[mediawiki/core@wmf/1.37.0-wmf.4] Reorder tables in SpecialWatchlist

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

Change 685890 merged by jenkins-bot:

[mediawiki/core@wmf/1.37.0-wmf.4] Reorder tables in SpecialWatchlist

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

Mentioned in SAL (#wikimedia-operations) [2021-05-06T22:11:18Z] <brennen@deploy1002> Synchronized php-1.37.0-wmf.4/includes/specials/SpecialWatchlist.php: Backport: [[gerrit:685890|Reorder tables in SpecialWatchlist (T282181)]] (duration: 00m 57s)

Duplicate of T281981?

That one is SpecialRecentchanges. This one is SpecialWatchlist. Similar code, and the same mistake was made in both during the same refactor. Fixed in separate tasks/commits.

Krinkle assigned this task to Pchelolo.

Change 685921 merged by jenkins-bot:

[mediawiki/core@master] Reorder tables in SpecialWatchlist

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