Maniphest T391969

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

Assigned To

Authored By

	RichSmith
	Apr 15 2025, 1:30 PM

Description

Error

mwversion: 1.44.0-wmf.24
reqId: baebe548-0f35-4438-94a7-d76dcef00025
Find reqId in Logstash

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

Frame	Location	Call
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

Related Objects

Mentioned In: T391343: CVE-2025-6589: With MultiBlocks enabled and a user who is suppressed via a MultiBlock, a user without 'hideuser' can see the hidden username in the BlockList

Event Timeline

RichSmith created this task.Apr 15 2025, 1:30 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 15 2025, 1:30 PM

Aklapper triaged this task as Unbreak Now! priority.Apr 15 2025, 1:44 PM

Aklapper added projects: Multiblocks, Community-Tech, MediaWiki-Blocks.

Restricted Application added a project: Trust and Safety Product Team. · View Herald TranscriptApr 15 2025, 1:44 PM

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.

TheresNoTime subscribed.Apr 15 2025, 1:55 PM

TheresNoTime mentioned this in T391343: CVE-2025-6589: With MultiBlocks enabled and a user who is suppressed via a MultiBlock, a user without 'hideuser' can see the hidden username in the BlockList.Apr 15 2025, 2:08 PM

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:

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

Still seeing it on e.g.:

(etc)
but not https://test.wikipedia.org/wiki/Special:BlockList (.25)

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.

Jdforrester-WMF subscribed.Apr 15 2025, 2:56 PM

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

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