Page MenuHomePhabricator

Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'hu_deleted' in 'WHERE' Function: MediaWiki\Pager\IndexPager::buildQueryInfo (MediaWiki\Pager\BlockListPager)
Closed, ResolvedPublicPRODUCTION ERROR

Description

Error
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'hu_deleted' in 'WHERE'
Function: MediaWiki\Pager\IndexPager::buildQueryInfo (MediaWiki\Pager\BlockListPager)
Query: SELECT  bt_address,bt_user_text,bt_user,bt_auto,bt_ra
FrameLocationCall
from/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/Database.php(1232)
#0/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/Database.php(1216)Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/Database.php(1190)Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#2/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/Database.php(647)Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#3/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/Database.php(1367)Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/DBConnRef.php(127)Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/database/DBConnRef.php(351)Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6/srv/mediawiki/php-1.44.0-wmf.24/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(762)Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#7/srv/mediawiki/php-1.44.0-wmf.24/includes/pager/IndexPager.php(474)Wikimedia\Rdbms\SelectQueryBuilder->fetchResultSet()
#8/srv/mediawiki/php-1.44.0-wmf.24/includes/pager/IndexPager.php(289)MediaWiki\Pager\IndexPager->reallyDoQuery(string, int, bool)
#9/srv/mediawiki/php-1.44.0-wmf.24/includes/pager/IndexPager.php(746)MediaWiki\Pager\IndexPager->doQuery()
#10/srv/mediawiki/php-1.44.0-wmf.24/includes/specials/SpecialBlockList.php(342)MediaWiki\Pager\IndexPager->getNumRows()
#11/srv/mediawiki/php-1.44.0-wmf.24/includes/specials/SpecialBlockList.php(194)MediaWiki\Specials\SpecialBlockList->showList(MediaWiki\Pager\BlockListPager)
#12/srv/mediawiki/php-1.44.0-wmf.24/includes/specialpage/SpecialPage.php(729)MediaWiki\Specials\SpecialBlockList->execute(string)
#13/srv/mediawiki/php-1.44.0-wmf.24/includes/specialpage/SpecialPageFactory.php(1738)MediaWiki\SpecialPage\SpecialPage->run(string)
#14/srv/mediawiki/php-1.44.0-wmf.24/includes/actions/ActionEntryPoint.php(499)MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, MediaWiki\Context\RequestContext)
#15/srv/mediawiki/php-1.44.0-wmf.24/includes/actions/ActionEntryPoint.php(143)MediaWiki\Actions\ActionEntryPoint->performRequest()
#16/srv/mediawiki/php-1.44.0-wmf.24/includes/MediaWikiEntryPoint.php(202)MediaWiki\Actions\ActionEntryPoint->execute()
#17/srv/mediawiki/php-1.44.0-wmf.24/index.php(58)MediaWiki\MediaWikiEntryPoint->run()
#18/srv/mediawiki/w/index.php(3)require(string)
#19{main}
Impact

Unable to use Special:BlockList on ENWP, unknown if effecting other pages.

Notes

Checked on 2 different machines on different networks.

Details

MediaWiki Version
1.44.0-wmf.24
Request URL
https://en.wikipedia.org/wiki/Special:BlockList

Event Timeline

Aklapper renamed this task from DB Error to Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'hu_deleted' in 'WHERE' Function: MediaWiki\Pager\IndexPager::buildQueryInfo (MediaWiki\Pager\BlockListPager).Apr 15 2025, 1:46 PM
Aklapper updated the task description. (Show Details)
Aklapper set Release Version to 1.44.0-wmf.24.
sbassett changed the task status from Open to In Progress.Apr 15 2025, 2:23 PM
sbassett claimed this task.
sbassett lowered the priority of this task from Unbreak Now! to High.
sbassett subscribed.

Is anyone still seeing these? They were related to a bad security deployment, which was only in production from about 22:17 UTC to 22:29 UTC. Related logstash snapshots:

  1. https://logstash.wikimedia.org/goto/e4c0fae22e61069213f70cc91a10b6a8
  2. https://logstash.wikimedia.org/goto/c1969e322cea11913a3d4e0219caebcc

Is anyone still seeing these?

Per Logstash link above: Occurrences at Apr 15, 2025 @ 13:28:43 and Apr 15, 2025 @ 14:18:03 UTC today, just a few minutes ago

Ugh, yes, this is related to scap backport reapplying the bad patch from the earlier backport window :/ I've pulled the bad patch entirely from the deployment host now, pulled the patch from php-1.44.0-wmf.24 and am now re-deploying the previous good versions of the affected files.

The bad security patch has been undeployed (SAL) and entirely removed from the deployment hosts. Error rates are back to normal now.

Looks to be all working again, thanks @sbassett