SELECT bl_id,bt_address,bt_user,bt_user_text,bl_timestamp,bt_auto,bl_anon_only,bl_create_account,bl_enable_autoblock,bl_expiry,bl_deleted,bl_block_email,bl_allow_usertalk,bl_parent_block_id,bl_sitewide,bl_by_actor,block_by_actor.actor_user AS `bl_by`,block_by_actor.actor_name AS `bl_by_text`,comment_bl_reason.comment_text AS `bl_reason_text`,comment_bl_reason.comment_data AS `bl_reason_data`,comment_bl_reason.comment_id AS `bl_reason_cid` FROM `block` JOIN `block_target` ON ((bt_id=bl_target)) JOIN `actor` `block_by_actor` ON ((actor_id=bl_by_actor)) JOIN `comment` `comment_bl_reason` ON ((comment_bl_reason.comment_id = bl_reason_id)) WHERE (bt_user_text = 'Box')
Note index structure:
KEY `bt_ip_user_text` (`bt_ip_hex`(35),`bt_user_text`), KEY `bt_user` (`bt_user`)
The query can either be done on bt_user with a join, or it can be done with an explicit bt_ip_hex IS NULL.
Error
- mwversion: 1.42.0-wmf.21
- reqId: 51080980-92e0-4873-b9fd-874c9e423e45
- Find reqId in Logstash
normalized_message
Expectation (readQueryTime <= 5) by MediaWiki\Actions\ActionEntryPoint::execute not met (actual: {actualSeconds}) in trx #{trxId}:
{query}exception.trace
from /srv/mediawiki/php-1.42.0-wmf.21/includes/libs/rdbms/TransactionProfiler.php(525)
#0 /srv/mediawiki/php-1.42.0-wmf.21/includes/libs/rdbms/TransactionProfiler.php(334): Wikimedia\Rdbms\TransactionProfiler->reportExpectationViolated(string, Wikimedia\Rdbms\GeneralizedSql, double, string, string)
#1 /srv/mediawiki/php-1.42.0-wmf.21/includes/libs/rdbms/database/TransactionManager.php(615): Wikimedia\Rdbms\TransactionProfiler->recordQueryCompletion(Wikimedia\Rdbms\GeneralizedSql, double, boolean, integer, string, string)
#2 /srv/mediawiki/php-1.42.0-wmf.21/includes/libs/rdbms/database/Database.php(828): Wikimedia\Rdbms\TransactionManager->recordQueryCompletion(Wikimedia\Rdbms\GeneralizedSql, double, boolean, integer, string)
#3 /srv/mediawiki/php-1.42.0-wmf.21/includes/libs/rdbms/database/Database.php(716): Wikimedia\Rdbms\Database->attemptQuery(Wikimedia\Rdbms\Query, string, boolean)
#4 /srv/mediawiki/php-1.42.0-wmf.21/includes/libs/rdbms/database/Database.php(643): Wikimedia\Rdbms\Database->executeQuery(Wikimedia\Rdbms\Query, string, integer)
#5 /srv/mediawiki/php-1.42.0-wmf.21/includes/libs/rdbms/database/Database.php(1350): Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#6 /srv/mediawiki/php-1.42.0-wmf.21/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->select(array, array, string, string, array, array)
#7 /srv/mediawiki/php-1.42.0-wmf.21/includes/libs/rdbms/database/DBConnRef.php(351): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#8 /srv/mediawiki/php-1.42.0-wmf.21/includes/block/DatabaseBlockStore.php(518): Wikimedia\Rdbms\DBConnRef->select(array, array, string, string, array, array)
#9 /srv/mediawiki/php-1.42.0-wmf.21/includes/block/DatabaseBlockStore.php(804): MediaWiki\Block\DatabaseBlockStore->newLoad(MediaWiki\User\User, integer, boolean, MediaWiki\User\User)
#10 /srv/mediawiki/php-1.42.0-wmf.21/includes/block/DatabaseBlockStore.php(773): MediaWiki\Block\DatabaseBlockStore->newListFromTarget(MediaWiki\User\User, MediaWiki\User\User, boolean)
#11 /srv/mediawiki/php-1.42.0-wmf.21/includes/page/Article.php(1452): MediaWiki\Block\DatabaseBlockStore->newFromTarget(MediaWiki\User\User, MediaWiki\User\User)
#12 /srv/mediawiki/php-1.42.0-wmf.21/includes/page/Article.php(649): Article->showMissingArticle()
#13 /srv/mediawiki/php-1.42.0-wmf.21/includes/page/Article.php(563): Article->generateContentOutput(MediaWiki\User\User, ParserOptions, integer, MediaWiki\Output\OutputPage, array)
#14 /srv/mediawiki/php-1.42.0-wmf.21/includes/actions/ViewAction.php(78): Article->view()
#15 /srv/mediawiki/php-1.42.0-wmf.21/includes/actions/ActionEntryPoint.php(733): ViewAction->show()
#16 /srv/mediawiki/php-1.42.0-wmf.21/includes/actions/ActionEntryPoint.php(510): MediaWiki\Actions\ActionEntryPoint->performAction(Article, MediaWiki\Title\Title)
#17 /srv/mediawiki/php-1.42.0-wmf.21/includes/actions/ActionEntryPoint.php(145): MediaWiki\Actions\ActionEntryPoint->performRequest()
#18 /srv/mediawiki/php-1.42.0-wmf.21/includes/MediaWikiEntryPoint.php(199): MediaWiki\Actions\ActionEntryPoint->execute()
#19 /srv/mediawiki/php-1.42.0-wmf.21/index.php(58): MediaWiki\MediaWikiEntryPoint->run()
#20 /srv/mediawiki/w/index.php(3): require(string)
#21 {main}