Page MenuHomePhabricator

Wikitech-static search DBQueryError
Closed, InvalidPublicPRODUCTION ERROR

Description

[b5c21d045f40646ea556464d] /w/index.php?search=broken&title=Special%3ASearch&go=Go Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

Error 144: Table './wikitech/searchindex' is marked as crashed and last (automatic?) repair failed
Function: SearchMySQL::searchInternal
Query: SELECT page_id,page_namespace,page_title FROM `page` JOIN `searchindex` ON ((page_id=si_page)) WHERE ( MATCH(si_title) AGAINST('+broken ' IN BOOLEAN MODE) ) AND page_namespace = 0 ORDER BY MATCH(si_title) AGAINST('+broken ' IN NATURAL LANGUAGE MODE) DESC LIMIT 21

Backtrace:

from /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1198)
#0 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1182): Wikimedia\Rdbms\Database->getQueryException()
#1 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1156): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
#2 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(647): Wikimedia\Rdbms\Database->reportQueryError()
#3 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1345): Wikimedia\Rdbms\Database->query()
#4 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(127): Wikimedia\Rdbms\Database->select()
#5 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(351): Wikimedia\Rdbms\DBConnRef->__call()
#6 /srv/mediawiki/w/includes/libs/rdbms/querybuilder/SelectQueryBuilder.php(744): Wikimedia\Rdbms\DBConnRef->select()
#7 /srv/mediawiki/w/includes/search/SearchMySQL.php(200): Wikimedia\Rdbms\SelectQueryBuilder->fetchResultSet()
#8 /srv/mediawiki/w/includes/search/SearchMySQL.php(189): SearchMySQL->searchInternal()
#9 /srv/mediawiki/w/includes/search/SearchDatabase.php(70): SearchMySQL->doSearchTitleInDB()
#10 /srv/mediawiki/w/includes/search/SearchEngine.php(163): SearchDatabase->doSearchTitle()
#11 /srv/mediawiki/w/includes/search/SearchEngine.php(194): SearchEngine->{closure}()
#12 /srv/mediawiki/w/includes/search/SearchEngine.php(162): SearchEngine->maybePaginate()
#13 /srv/mediawiki/w/includes/specials/SpecialSearch.php(469): SearchEngine->searchTitle()
#14 /srv/mediawiki/w/includes/specials/SpecialSearch.php(246): MediaWiki\Specials\SpecialSearch->showResults()
#15 /srv/mediawiki/w/includes/specialpage/SpecialPage.php(728): MediaWiki\Specials\SpecialSearch->execute()
#16 /srv/mediawiki/w/includes/specialpage/SpecialPageFactory.php(1724): MediaWiki\SpecialPage\SpecialPage->run()
#17 /srv/mediawiki/w/includes/actions/ActionEntryPoint.php(504): MediaWiki\SpecialPage\SpecialPageFactory->executePath()
#18 /srv/mediawiki/w/includes/actions/ActionEntryPoint.php(146): MediaWiki\Actions\ActionEntryPoint->performRequest()
#19 /srv/mediawiki/w/includes/MediaWikiEntryPoint.php(200): MediaWiki\Actions\ActionEntryPoint->execute()
#20 /srv/mediawiki/w/index.php(58): MediaWiki\MediaWikiEntryPoint->run()
#21 {main}

Related Objects

Event Timeline

Is this still a thing ? Doesn't wikitech use cirrussearch ?

Doesn't wikitech use cirrussearch ?

Yes, Wikitech does use CirrusSearch. This task looks to be about wikitech-static.wikimedia.org based on the title. I had actually thought that wikitech-static was using a non-MediaWiki stack these days, but apparently that is still a work in progress (T376400: Redesign wikitech-static).

Pppery subscribed.

https://wikitech-static.wikimedia.org/ is now using that non-MediaWiki stack so this is obsolete.