Page MenuHomePhabricator

Can't reopen table in wikidb-unittest_ (from SpecialPageFatalTest)
Open, Needs TriagePublic

Description

This is blocking the re-enablement of the "assert no runtime errors" step in CI, which checks that mw-error.log remains empty. This was accidentally removed a few months ago (T246358).

This error ocurrs five times on every build, and seem likely to have a single or identical root cause.

mw-dberror.log (1)
Fri Mar 20 18:07:26 UTC 2020	32a44f17c9c0	wikidb-unittest_	SpecialBrokenRedirects::reallyDoQuery	localhost:/workspace/db/quibble-mysql-fyqd_1b0/socket	1137	Can't reopen table: 'p1' (localhost:/workspace/db/quibble-mysql-fyqd_1b0/socket)	SELECT  p1.page_namespace AS `namespace`,p1.page_title AS `title`,rd_namespace,rd_title,rd_fragment  FROM `unittest_redirect` JOIN `unittest_page` `p1` ON ((rd_from=p1.page_id)) LEFT JOIN `unittest_page` `p2` ON ((rd_namespace=p2.page_namespace) AND (rd_title=p2.page_title))   WHERE (rd_namespace >= 0) AND (rd_interwiki IS NULL OR rd_interwiki = '') AND (p2.page_namespace IS NULL)  ORDER BY rd_namespace,rd_title,rd_from LIMIT 51  
#0 /workspace/src/includes/libs/rdbms/database/Database.php(1580): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /workspace/src/includes/libs/rdbms/database/Database.php(1159): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /workspace/src/includes/libs/rdbms/database/Database.php(1819): Wikimedia\Rdbms\Database->query(string, string)
#3 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#4 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(313): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#5 /workspace/src/includes/specialpage/QueryPage.php(459): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#6 /workspace/src/includes/specialpage/QueryPage.php(637): QueryPage->reallyDoQuery(integer, integer)
#7 /workspace/src/includes/specials/SpecialBrokenRedirects.php(173): QueryPage->execute(string)
#8 /workspace/src/tests/phpunit/includes/specials/SpecialPageExecutor.php(107): SpecialBrokenRedirects->execute(string)
#9 /workspace/src/tests/phpunit/includes/specials/SpecialPageExecutor.php(37): SpecialPageExecutor->getHTMLFromSpecialPage(SpecialBrokenRedirects, string)
#10 /workspace/src/tests/phpunit/structure/SpecialPageFatalTest.php(33): SpecialPageExecutor->executeSpecialPage(SpecialBrokenRedirects, string, NULL, string, User)
#11 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(1408): SpecialPageFatalTest->testSpecialPageDoesNotFatal(SpecialBrokenRedirects)
#12 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(1028): PHPUnit\Framework\TestCase->runTest()
#13 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestResult.php(691): PHPUnit\Framework\TestCase->runBare()
#14 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(756): PHPUnit\Framework\TestResult->run(SpecialPageFatalTest)
#15 /workspace/src/tests/phpunit/MediaWikiIntegrationTestCase.php(418): PHPUnit\Framework\TestCase->run(PHPUnit\Framework\TestResult)
#16 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): MediaWikiIntegrationTestCase->run(PHPUnit\Framework\TestResult)
#17 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#18 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#19 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#20 /workspace/src/vendor/phpunit/phpunit/src/TextUI/TestRunner.php(621): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#21 /workspace/src/vendor/phpunit/phpunit/src/TextUI/Command.php(200): PHPUnit\TextUI\TestRunner->doRun(PHPUnit\Framework\TestSuite, array, boolean)
#22 /workspace/src/tests/phpunit/phpunit.php(71): PHPUnit\TextUI\Command->run(array, boolean)
#23 /workspace/src/maintenance/doMaintenance.php(99): PHPUnitMaintClass->execute()
#24 /workspace/src/tests/phpunit/phpunit.php(130): require(string)
#25 {main}
mw-dberror.log (2)
Fri Mar 20 18:07:26 UTC 2020	32a44f17c9c0	wikidb-unittest_	SpecialDoubleRedirects::reallyDoQuery	localhost:/workspace/db/quibble-mysql-fyqd_1b0/socket	1137	Can't reopen table: 'ra' (localhost:/workspace/db/quibble-mysql-fyqd_1b0/socket)	SELECT  pa.page_namespace AS `namespace`,pa.page_title AS `title`,pb.page_namespace AS `b_namespace`,pb.page_title AS `b_title`,rb.rd_namespace AS `c_namespace`,rb.rd_title AS `c_title`,rb.rd_fragment AS `c_fragment`,rb.rd_interwiki AS `c_interwiki`  FROM `unittest_redirect` `ra`,`unittest_redirect` `rb`,`unittest_page` `pa`,`unittest_page` `pb`    WHERE (ra.rd_from = pa.page_id) AND (ra.rd_interwiki IS NULL OR ra.rd_interwiki = '') AND (pb.page_namespace = ra.rd_namespace) AND (pb.page_title = ra.rd_title) AND (rb.rd_from = pb.page_id)  ORDER BY ra.rd_namespace,ra.rd_title LIMIT 51  
#0 /workspace/src/includes/libs/rdbms/database/Database.php(1580): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /workspace/src/includes/libs/rdbms/database/Database.php(1159): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /workspace/src/includes/libs/rdbms/database/Database.php(1819): Wikimedia\Rdbms\Database->query(string, string)
#3 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#4 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(313): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#5 /workspace/src/includes/specialpage/QueryPage.php(459): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#6 /workspace/src/includes/specialpage/QueryPage.php(637): QueryPage->reallyDoQuery(integer, integer)
#7 /workspace/src/includes/specials/SpecialDoubleRedirects.php(208): QueryPage->execute(string)
#8 /workspace/src/tests/phpunit/includes/specials/SpecialPageExecutor.php(107): SpecialDoubleRedirects->execute(string)
#9 /workspace/src/tests/phpunit/includes/specials/SpecialPageExecutor.php(37): SpecialPageExecutor->getHTMLFromSpecialPage(SpecialDoubleRedirects, string)
#10 /workspace/src/tests/phpunit/structure/SpecialPageFatalTest.php(33): SpecialPageExecutor->executeSpecialPage(SpecialDoubleRedirects, string, NULL, string, User)
#11 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(1408): SpecialPageFatalTest->testSpecialPageDoesNotFatal(SpecialDoubleRedirects)
#12 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(1028): PHPUnit\Framework\TestCase->runTest()
#13 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestResult.php(691): PHPUnit\Framework\TestCase->runBare()
#14 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(756): PHPUnit\Framework\TestResult->run(SpecialPageFatalTest)
#15 /workspace/src/tests/phpunit/MediaWikiIntegrationTestCase.php(418): PHPUnit\Framework\TestCase->run(PHPUnit\Framework\TestResult)
#16 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): MediaWikiIntegrationTestCase->run(PHPUnit\Framework\TestResult)
#17 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#18 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#19 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#20 /workspace/src/vendor/phpunit/phpunit/src/TextUI/TestRunner.php(621): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#21 /workspace/src/vendor/phpunit/phpunit/src/TextUI/Command.php(200): PHPUnit\TextUI\TestRunner->doRun(PHPUnit\Framework\TestSuite, array, boolean)
#22 /workspace/src/tests/phpunit/phpunit.php(71): PHPUnit\TextUI\Command->run(array, boolean)
#23 /workspace/src/maintenance/doMaintenance.php(99): PHPUnitMaintClass->execute()
#24 /workspace/src/tests/phpunit/phpunit.php(130): require(string)
#25 {main}
mw-dberror.log (3)
Fri Mar 20 18:07:27 UTC 2020	32a44f17c9c0	wikidb-unittest_	WantedFilesPage::reallyDoQuery	localhost:/workspace/db/quibble-mysql-fyqd_1b0/socket	1137	Can't reopen table: 'img1' (localhost:/workspace/db/quibble-mysql-fyqd_1b0/socket)	SELECT  6 AS `namespace`,il_to AS `title`,COUNT(*) AS `value`  FROM `unittest_imagelinks` LEFT JOIN `unittest_page` ON ((il_to = page_title) AND page_namespace = 6) LEFT JOIN `unittest_redirect` ON ((page_id = rd_from) AND rd_namespace = 6 AND rd_interwiki = '') LEFT JOIN `unittest_image` `img1` ON ((il_to = img1.img_name)) LEFT JOIN `unittest_image` `img2` ON ((rd_title = img2.img_name))   WHERE img1.img_name IS NULL AND img2.img_name IS NULL  GROUP BY il_to ORDER BY value DESC,namespace,title LIMIT 51  
#0 /workspace/src/includes/libs/rdbms/database/Database.php(1580): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /workspace/src/includes/libs/rdbms/database/Database.php(1159): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /workspace/src/includes/libs/rdbms/database/Database.php(1819): Wikimedia\Rdbms\Database->query(string, string)
#3 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#4 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(313): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#5 /workspace/src/includes/specialpage/QueryPage.php(459): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#6 /workspace/src/includes/specialpage/QueryPage.php(637): QueryPage->reallyDoQuery(integer, integer)
#7 /workspace/src/tests/phpunit/includes/specials/SpecialPageExecutor.php(107): QueryPage->execute(string)
#8 /workspace/src/tests/phpunit/includes/specials/SpecialPageExecutor.php(37): SpecialPageExecutor->getHTMLFromSpecialPage(WantedFilesPage, string)
#9 /workspace/src/tests/phpunit/structure/SpecialPageFatalTest.php(33): SpecialPageExecutor->executeSpecialPage(WantedFilesPage, string, NULL, string, User)
#10 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(1408): SpecialPageFatalTest->testSpecialPageDoesNotFatal(WantedFilesPage)
#11 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(1028): PHPUnit\Framework\TestCase->runTest()
#12 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestResult.php(691): PHPUnit\Framework\TestCase->runBare()
#13 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(756): PHPUnit\Framework\TestResult->run(SpecialPageFatalTest)
#14 /workspace/src/tests/phpunit/MediaWikiIntegrationTestCase.php(418): PHPUnit\Framework\TestCase->run(PHPUnit\Framework\TestResult)
#15 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): MediaWikiIntegrationTestCase->run(PHPUnit\Framework\TestResult)
#16 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#17 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#18 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#19 /workspace/src/vendor/phpunit/phpunit/src/TextUI/TestRunner.php(621): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#20 /workspace/src/vendor/phpunit/phpunit/src/TextUI/Command.php(200): PHPUnit\TextUI\TestRunner->doRun(PHPUnit\Framework\TestSuite, array, boolean)
#21 /workspace/src/tests/phpunit/phpunit.php(71): PHPUnit\TextUI\Command->run(array, boolean)
#22 /workspace/src/maintenance/doMaintenance.php(99): PHPUnitMaintClass->execute()
#23 /workspace/src/tests/phpunit/phpunit.php(130): require(string)
#24 {main}
mw-dberror.log (4)
Fri Mar 20 18:07:27 UTC 2020	32a44f17c9c0	wikidb-unittest_	WantedPagesPage::reallyDoQuery	localhost:/workspace/db/quibble-mysql-fyqd_1b0/socket	1137	Can't reopen table: 'pg1' (localhost:/workspace/db/quibble-mysql-fyqd_1b0/socket)	SELECT  pl_namespace AS `namespace`,pl_title AS `title`,COUNT(*) AS `value`  FROM `unittest_pagelinks` LEFT JOIN `unittest_page` `pg1` ON ((pg1.page_namespace = pl_namespace) AND (pg1.page_title = pl_title)) LEFT JOIN `unittest_page` `pg2` ON ((pg2.page_id = pl_from))   WHERE (pg1.page_namespace IS NULL) AND (pl_namespace NOT IN (2,3)) AND (pg2.page_namespace != 8)  GROUP BY pl_namespace,pl_title HAVING (COUNT(*) > 0) AND (COUNT(*) > SUM(pg2.page_is_redirect)) ORDER BY value DESC,namespace,title LIMIT 51  
#0 /workspace/src/includes/libs/rdbms/database/Database.php(1580): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /workspace/src/includes/libs/rdbms/database/Database.php(1159): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /workspace/src/includes/libs/rdbms/database/Database.php(1819): Wikimedia\Rdbms\Database->query(string, string)
#3 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#4 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(313): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#5 /workspace/src/includes/specialpage/QueryPage.php(459): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#6 /workspace/src/includes/specialpage/QueryPage.php(637): QueryPage->reallyDoQuery(integer, integer)
#7 /workspace/src/includes/specials/SpecialWantedpages.php(48): QueryPage->execute(string)
#8 /workspace/src/tests/phpunit/includes/specials/SpecialPageExecutor.php(107): WantedPagesPage->execute(string)
#9 /workspace/src/tests/phpunit/includes/specials/SpecialPageExecutor.php(37): SpecialPageExecutor->getHTMLFromSpecialPage(WantedPagesPage, string)
#10 /workspace/src/tests/phpunit/structure/SpecialPageFatalTest.php(33): SpecialPageExecutor->executeSpecialPage(WantedPagesPage, string, NULL, string, User)
#11 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(1408): SpecialPageFatalTest->testSpecialPageDoesNotFatal(WantedPagesPage)
#12 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(1028): PHPUnit\Framework\TestCase->runTest()
#13 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestResult.php(691): PHPUnit\Framework\TestCase->runBare()
#14 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(756): PHPUnit\Framework\TestResult->run(SpecialPageFatalTest)
#15 /workspace/src/tests/phpunit/MediaWikiIntegrationTestCase.php(418): PHPUnit\Framework\TestCase->run(PHPUnit\Framework\TestResult)
#16 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): MediaWikiIntegrationTestCase->run(PHPUnit\Framework\TestResult)
#17 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#18 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#19 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#20 /workspace/src/vendor/phpunit/phpunit/src/TextUI/TestRunner.php(621): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#21 /workspace/src/vendor/phpunit/phpunit/src/TextUI/Command.php(200): PHPUnit\TextUI\TestRunner->doRun(PHPUnit\Framework\TestSuite, array, boolean)
#22 /workspace/src/tests/phpunit/phpunit.php(71): PHPUnit\TextUI\Command->run(array, boolean)
#23 /workspace/src/maintenance/doMaintenance.php(99): PHPUnitMaintClass->execute()
#24 /workspace/src/tests/phpunit/phpunit.php(130): require(string)
#25 {main}
mw-dberror.log (5)
Fri Mar 20 18:07:27 UTC 2020	32a44f17c9c0	wikidb-unittest_	SpecialListRedirects::reallyDoQuery	localhost:/workspace/db/quibble-mysql-fyqd_1b0/socket	1137	Can't reopen table: 'p1' (localhost:/workspace/db/quibble-mysql-fyqd_1b0/socket)	SELECT  p1.page_namespace AS `namespace`,p1.page_title AS `title`,rd_namespace,rd_title,rd_fragment,rd_interwiki,p2.page_id AS `redirid`  FROM `unittest_page` `p1` LEFT JOIN `unittest_redirect` ON ((rd_from=p1.page_id)) LEFT JOIN `unittest_page` `p2` ON ((p2.page_namespace=rd_namespace) AND (p2.page_title=rd_title))   WHERE p1.page_is_redirect = 1  ORDER BY p1.page_namespace,p1.page_title LIMIT 51  
#0 /workspace/src/includes/libs/rdbms/database/Database.php(1580): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /workspace/src/includes/libs/rdbms/database/Database.php(1159): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /workspace/src/includes/libs/rdbms/database/Database.php(1819): Wikimedia\Rdbms\Database->query(string, string)
#3 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#4 /workspace/src/includes/libs/rdbms/database/DBConnRef.php(313): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#5 /workspace/src/includes/specialpage/QueryPage.php(459): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#6 /workspace/src/includes/specialpage/QueryPage.php(637): QueryPage->reallyDoQuery(integer, integer)
#7 /workspace/src/includes/specials/SpecialListRedirects.php(149): QueryPage->execute(string)
#8 /workspace/src/tests/phpunit/includes/specials/SpecialPageExecutor.php(107): SpecialListRedirects->execute(string)
#9 /workspace/src/tests/phpunit/includes/specials/SpecialPageExecutor.php(37): SpecialPageExecutor->getHTMLFromSpecialPage(SpecialListRedirects, string)
#10 /workspace/src/tests/phpunit/structure/SpecialPageFatalTest.php(33): SpecialPageExecutor->executeSpecialPage(SpecialListRedirects, string, NULL, string, User)
#11 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(1408): SpecialPageFatalTest->testSpecialPageDoesNotFatal(SpecialListRedirects)
#12 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(1028): PHPUnit\Framework\TestCase->runTest()
#13 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestResult.php(691): PHPUnit\Framework\TestCase->runBare()
#14 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestCase.php(756): PHPUnit\Framework\TestResult->run(SpecialPageFatalTest)
#15 /workspace/src/tests/phpunit/MediaWikiIntegrationTestCase.php(418): PHPUnit\Framework\TestCase->run(PHPUnit\Framework\TestResult)
#16 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): MediaWikiIntegrationTestCase->run(PHPUnit\Framework\TestResult)
#17 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#18 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#19 /workspace/src/vendor/phpunit/phpunit/src/Framework/TestSuite.php(597): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#20 /workspace/src/vendor/phpunit/phpunit/src/TextUI/TestRunner.php(621): PHPUnit\Framework\TestSuite->run(PHPUnit\Framework\TestResult)
#21 /workspace/src/vendor/phpunit/phpunit/src/TextUI/Command.php(200): PHPUnit\TextUI\TestRunner->doRun(PHPUnit\Framework\TestSuite, array, boolean)
#22 /workspace/src/tests/phpunit/phpunit.php(71): PHPUnit\TextUI\Command->run(array, boolean)
#23 /workspace/src/maintenance/doMaintenance.php(99): PHPUnitMaintClass->execute()
#24 /workspace/src/tests/phpunit/phpunit.php(130): require(string)
#25 {main}

Related Objects

StatusSubtypeAssignedTask
OpenNone
OpenNone
OpenNone
OpenNone
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
DeclinedMarostegui
ResolvedMarostegui
OpenMarostegui
ResolvedMarostegui
DeclinedMarostegui
ResolvedMarostegui
ResolvedJclark-ctr
ResolvedKormat
OpenKormat
ResolvedMarostegui
ResolvedMarostegui
OpenMarostegui
OpenMarostegui
ResolvedMarostegui
OpenKormat
StalledNone
OpenNone
ResolvedJdforrester-WMF
OpenNone
OpenNone

Event Timeline

Krinkle created this task.Mar 20 2020, 6:31 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 20 2020, 6:31 PM
Anomie added a subscriber: Anomie.

The "underlying cause" is MySQL bug 10327: for some reason it's incapable of "opening" a temporary table multiple times in one query. Interestingly, it looks like MariaDB may have fixed that bug in 10.2 or 10.3, as I can't reproduce it locally or on db1107 but can on the other DBs that are still on 10.1.

I don't see how this ever didn't produce these log messages. The test in question appears to have existed since rMWb50c8848e6e8: Introduce SpecialPageFatalTest (merged July 2018). The query in SpecialBrokenRedirects triggering that MySQL bug appears to have been in place in various forms since rSVN9199: * links and brokenlinks tables merged to pagelinks; this will reduce pain. At a quick search, I don't see that either has ever had any code skipping the test for MySQL.

CCicalese_WMF added a subscriber: CCicalese_WMF.

This will be fixed when we upgrade to MariaDB version 10.3 (possibly 10.2) in CI.

This will be fixed when we upgrade to MariaDB version 10.3 (possibly 10.2) in CI.

That means we're going to be waiting a very long time. :-(

For CI to run 10.4 instead of 10.1, we'll have to move quibble from stretch to buster; we wouldn't drop strech CI running until all of production has moved over.

Have created T252432 to mark as blocking this, per your comment.

Change 597167 had a related patch set uploaded (by Krinkle; owner: Krinkle):
[mediawiki/core@master] phpunit: Acknowledge known dberror from SpecialPageFatalTest

https://gerrit.wikimedia.org/r/597167

Change 597167 merged by jenkins-bot:
[mediawiki/core@master] phpunit: Acknowledge known dberror from SpecialPageFatalTest

https://gerrit.wikimedia.org/r/597167