Looking at our DB-related kibana errors I've noticed a background noise of this recurring error:
Wikimedia\Rdbms\Database::tableName: use of subqueries is not supported this way.
Those are the first affected websites (count of errors) in the last 2 days:
Website | Count |
commons.wikimedia.org | 9588 |
www.mediawiki.org | 6996 |
fr.wikisource.org | 5485 |
he.wikipedia.org | 5023 |
fr.wiktionary.org | 2434 |
ca.wikipedia.org | 2111 |
bg.wiktionary.org | 1985 |
ru.wiktionary.org | 1898 |
pl.wikisource.org | 1567 |
jobrunner.discovery.wmnet | 1176 |
it.wikisource.org | 1168 |
pt.wikinews.org | 1142 |
kn.wikibooks.org | 960 |
Example of full logged error:
https://logstash.wikimedia.org/app/kibana#/doc/logstash-*/logstash-2018.03.30/mediawiki?id=AWJ3luG7U5mXXxqDcR1H&_g=()
Stack trace:
#0 /srv/mediawiki/php-1.31.0-wmf.27/includes/libs/rdbms/database/Database.php(2200): Wikimedia\Rdbms\Database->tableName() #1 /srv/mediawiki/php-1.31.0-wmf.27/includes/libs/rdbms/database/Database.php(2311): Wikimedia\Rdbms\Database->tableNameWithAlias() #2 /srv/mediawiki/php-1.31.0-wmf.27/includes/libs/rdbms/database/Database.php(1521): Wikimedia\Rdbms\Database->tableNamesWithIndexClauseOrJOIN() #3 /srv/mediawiki/php-1.31.0-wmf.27/includes/libs/rdbms/database/Database.php(1495): Wikimedia\Rdbms\Database->selectSQLText() #4 /srv/mediawiki/php-1.31.0-wmf.27/includes/specials/SpecialWhatlinkshere.php(184): Wikimedia\Rdbms\Database->select() #5 /srv/mediawiki/php-1.31.0-wmf.27/includes/specials/SpecialWhatlinkshere.php(188): Closure$SpecialWhatLinksHere::showIndirectLinks() #6 /srv/mediawiki/php-1.31.0-wmf.27/includes/specials/SpecialWhatlinkshere.php(292): SpecialWhatLinksHere->showIndirectLinks() #7 /srv/mediawiki/php-1.31.0-wmf.27/includes/specials/SpecialWhatlinkshere.php(98): SpecialWhatLinksHere->showIndirectLinks() #8 /srv/mediawiki/php-1.31.0-wmf.27/includes/specialpage/SpecialPage.php(522): SpecialWhatLinksHere->execute() #9 /srv/mediawiki/php-1.31.0-wmf.27/includes/specialpage/SpecialPageFactory.php(568): SpecialPage->run() #10 /srv/mediawiki/php-1.31.0-wmf.27/includes/MediaWiki.php(288): SpecialPageFactory::executePath() #11 /srv/mediawiki/php-1.31.0-wmf.27/includes/MediaWiki.php(861): MediaWiki->performRequest() #12 /srv/mediawiki/php-1.31.0-wmf.27/includes/MediaWiki.php(524): MediaWiki->main() #13 /srv/mediawiki/php-1.31.0-wmf.27/index.php(42): MediaWiki->run() #14 /srv/mediawiki/w/index.php(3): include() #15 {main}