Page MenuHomePhabricator

Database query error when querying namespace-specific contributions done by user with a large number of edits
Closed, DuplicatePublicPRODUCTION ERROR

Description

Error
  • mwversion: 1.38.0-wmf.18 (cb91132)
  • reqId: 602a0e84-0cfc-4c34-b91d-b406c639f445
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1969: Query execution was interrupted (max_statement_time exceeded) (db1146:3314)
Function: IndexPager::buildQueryInfo (contributions page unfiltered)
Query: SET STATEMENT max_statement_time=
exception.trace
from /srv/mediawiki/php-1.38.0-wmf.18/includes/libs/rdbms/database/Database.php(1799)
#0 /srv/mediawiki/php-1.38.0-wmf.18/includes/libs/rdbms/database/Database.php(1783): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /srv/mediawiki/php-1.38.0-wmf.18/includes/libs/rdbms/database/Database.php(1758): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /srv/mediawiki/php-1.38.0-wmf.18/includes/libs/rdbms/database/Database.php(1302): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /srv/mediawiki/php-1.38.0-wmf.18/includes/libs/rdbms/database/Database.php(2002): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /srv/mediawiki/php-1.38.0-wmf.18/includes/libs/rdbms/database/DBConnRef.php(69): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5 /srv/mediawiki/php-1.38.0-wmf.18/includes/libs/rdbms/database/DBConnRef.php(319): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 /srv/mediawiki/php-1.38.0-wmf.18/includes/specials/pagers/ContribsPager.php(300): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#7 /srv/mediawiki/php-1.38.0-wmf.18/includes/pager/IndexPager.php(284): ContribsPager->reallyDoQuery(string, integer, boolean)
#8 /srv/mediawiki/php-1.38.0-wmf.18/includes/pager/IndexPager.php(756): IndexPager->doQuery()
#9 /srv/mediawiki/php-1.38.0-wmf.18/includes/specials/SpecialContributions.php(330): IndexPager->getNumRows()
#10 /srv/mediawiki/php-1.38.0-wmf.18/includes/poolcounter/PoolCounterWorkViaCallback.php(74): SpecialContributions->{closure}()
#11 /srv/mediawiki/php-1.38.0-wmf.18/includes/poolcounter/PoolCounterWork.php(162): PoolCounterWorkViaCallback->doWork()
#12 /srv/mediawiki/php-1.38.0-wmf.18/includes/specials/SpecialContributions.php(355): PoolCounterWork->execute()
#13 /srv/mediawiki/php-1.38.0-wmf.18/includes/specialpage/SpecialPage.php(671): SpecialContributions->execute(NULL)
#14 /srv/mediawiki/php-1.38.0-wmf.18/includes/specialpage/SpecialPageFactory.php(1378): SpecialPage->run(NULL)
#15 /srv/mediawiki/php-1.38.0-wmf.18/includes/MediaWiki.php(314): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext)
#16 /srv/mediawiki/php-1.38.0-wmf.18/includes/MediaWiki.php(903): MediaWiki->performRequest()
#17 /srv/mediawiki/php-1.38.0-wmf.18/includes/MediaWiki.php(563): MediaWiki->main()
#18 /srv/mediawiki/php-1.38.0-wmf.18/index.php(53): MediaWiki->run()
#19 /srv/mediawiki/php-1.38.0-wmf.18/index.php(46): wfIndexMain()
#20 /srv/mediawiki/w/index.php(3): require(string)
#21 {main}
Impact
Notes

I received another error message for the same request URL, which might be helpful:

MediaWiki internal error.

Original exception: [96b4faa4-4e71-4b01-bcb6-23ef3c8600f3] 2022-01-22 14:31:42: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

Exception caught inside exception handler.

Set $wgShowExceptionDetails = true; at the bottom of LocalSettings.php to show detailed debugging information.

Target user of the query is Wikimedia Commons Welcome, which has 10356744 edits on commonswiki.

Details

Request URL
https://commons.wikimedia.org/w/index.php?target=Wikimedia+Commons+Welcome&namespace=0&tagfilter=&start=&end=&limit=50&title=Special%3AContributions

Event Timeline

Zabe set Phatality ID to fc4a5a263c5220d621b32d6719534b453b0758cde2540ad7f14092fc0c7215f8.
Zabe subscribed.
Bugreporter closed this task as a duplicate of Restricted Task.Jan 23 2022, 1:00 PM