Error 2006 from Wikimedia\Rdbms\DatabaseMysqlBase::setBigSelects
Closed, DeclinedPublicPRODUCTION ERROR
Actions

Assigned To

Authored By

	Sgs
	Dec 13 2021, 10:54 PM

Description

Error

mwversion: 1.38.0-wmf.9
reqId: 6a893e774c9d470183d3a468
Find reqId in Logstash

normalized_message

Error 2006 from Wikimedia\Rdbms\DatabaseMysqlBase::setBigSelects, {error} {sql1line} {db_server}

exception.trace

from /srv/mediawiki/php-1.38.0-wmf.9/includes/libs/rdbms/database/Database.php(1813)
#0 /srv/mediawiki/php-1.38.0-wmf.9/includes/libs/rdbms/database/Database.php(1791): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /srv/mediawiki/php-1.38.0-wmf.9/includes/libs/rdbms/database/Database.php(1327): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /srv/mediawiki/php-1.38.0-wmf.9/includes/libs/rdbms/database/DatabaseMysqlBase.php(1154): Wikimedia\Rdbms\Database->query(string, string, integer)
#3 /srv/mediawiki/php-1.38.0-wmf.9/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\DatabaseMysqlBase->setBigSelects()
#4 /srv/mediawiki/php-1.38.0-wmf.9/includes/libs/rdbms/database/DBConnRef.php(770): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#5 /srv/mediawiki/php-1.38.0-wmf.9/includes/logging/LogPager.php(486): Wikimedia\Rdbms\DBConnRef->setBigSelects()
#6 /srv/mediawiki/php-1.38.0-wmf.9/extensions/GrowthExperiments/includes/NewcomerTasks/AddImage/ImageRecommendationSubmissionLog.php(28): LogPager->doQuery()
#7 /srv/mediawiki/php-1.38.0-wmf.9/extensions/GrowthExperiments/includes/NewcomerTasks/TaskSuggester/QualityGateDecorator.php(126): GrowthExperiments\NewcomerTasks\AddImage\ImageRecommendationSubmissionLog->count()
#8 /srv/mediawiki/php-1.38.0-wmf.9/extensions/GrowthExperiments/includes/NewcomerTasks/TaskSuggester/QualityGateDecorator.php(104): GrowthExperiments\NewcomerTasks\TaskSuggester\QualityGateDecorator->getImageRecommendationTasksDoneByUserForCurrentDay(User, RequestContext)
#9 /srv/mediawiki/php-1.38.0-wmf.9/extensions/GrowthExperiments/includes/NewcomerTasks/TaskSuggester/QualityGateDecorator.php(68): GrowthExperiments\NewcomerTasks\TaskSuggester\QualityGateDecorator->isImageRecommendationDailyTaskLimitExceeded(User, RequestContext, GrowthExperiments\NewcomerTasks\TaskType\ImageRecommendationTaskType)
#10 /srv/mediawiki/php-1.38.0-wmf.9/extensions/GrowthExperiments/maintenance/refreshLinkRecommendations.php(141): GrowthExperiments\NewcomerTasks\TaskSuggester\QualityGateDecorator->suggest(User, array, array, integer, integer, array)
#11 /srv/mediawiki/php-1.38.0-wmf.9/maintenance/doMaintenance.php(108): GrowthExperiments\Maintenance\RefreshLinkRecommendations->execute()
#12 /srv/mediawiki/php-1.38.0-wmf.9/extensions/GrowthExperiments/maintenance/refreshLinkRecommendations.php(309): require_once(string)
#13 /srv/mediawiki/multiversion/MWScript.php(116): require_once(string)
#14 {main}

Impact

The exception happened during the execution of a maintenance script. Not sure how relevant is this and if it should be investigated further

Notes

Related Objects

Mentioned In: T298485: MW scripts should reload the database config

Event Timeline

Sgs created this task.Dec 13 2021, 10:54 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 13 2021, 10:54 PM

Adding Performance-Team and DBA for awareness, but marking as resolved as this only occurred a handful of times.

kostajh closed this task as Resolved.Dec 14 2021, 11:43 AM

kostajh claimed this task.

kostajh moved this task from Inbox to Triaged on the Growth-Team board.

It looks like the script didn't reload the config. db1123 was depooled and restarted around that time yesterday. Script not reloading the config is a recurring thing in our environment and usually it is not a big deal until we have to depool hosts (or do master switchovers).

Krinkle changed the task status from Resolved to Declined.Jan 12 2022, 4:12 PM

Krinkle mentioned this in T298485: MW scripts should reload the database config.

Krinkle edited projects, added Performance-Team (Radar); removed Performance-Team.

Error 2006 from Wikimedia\Rdbms\DatabaseMysqlBase::setBigSelectsClosed, DeclinedPublicPRODUCTION ERRORActions