Page MenuHomePhabricator

Error: 1137 Can't reopen table: 'w1'
Closed, DeclinedPublic

Description

I think, this is more CI related than the extension...

16:40:22 1) MergeUserTest::testBasicMerge
16:40:22 DBQueryError: A database error has occurred. Did you forget to run maintenance/update.php after upgrading?  See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
16:40:22 Query: SELECT  w2.wl_namespace,w2.wl_title  FROM `unittest_watchlist` `w1` INNER JOIN `unittest_watchlist` `w2` ON ((w1.wl_namespace = w2.wl_namespace) AND (w1.wl_title = w2.wl_title))  WHERE w1.wl_user = '4' AND w2.wl_user = '2'   FOR UPDATE
16:40:22 Function: MergeUser::deduplicateWatchlistEntries
16:40:22 Error: 1137 Can't reopen table: 'w1' (127.0.0.1:3306)
16:40:22 
16:40:22 
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/includes/db/Database.php:937
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/includes/db/Database.php:904
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/includes/db/Database.php:1237
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/extensions/UserMerge/MergeUser.php:325
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/extensions/UserMerge/MergeUser.php:224
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/extensions/UserMerge/MergeUser.php:46
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/extensions/UserMerge/tests/phpunit/MergeUserTest.php:40
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/tests/phpunit/MediaWikiTestCase.php:389
16:40:22 
16:40:22 2) MergeUserTest::testMergeOfUserGroups
16:40:22 DBQueryError: A database error has occurred. Did you forget to run maintenance/update.php after upgrading?  See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
16:40:22 Query: SELECT  w2.wl_namespace,w2.wl_title  FROM `unittest_watchlist` `w1` INNER JOIN `unittest_watchlist` `w2` ON ((w1.wl_namespace = w2.wl_namespace) AND (w1.wl_title = w2.wl_title))  WHERE w1.wl_user = '7' AND w2.wl_user = '6'   FOR UPDATE
16:40:22 Function: MergeUser::deduplicateWatchlistEntries
16:40:22 Error: 1137 Can't reopen table: 'w1' (127.0.0.1:3306)
16:40:22 
16:40:22 
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/includes/db/Database.php:937
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/includes/db/Database.php:904
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/includes/db/Database.php:1237
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/extensions/UserMerge/MergeUser.php:325
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/extensions/UserMerge/MergeUser.php:224
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/extensions/UserMerge/MergeUser.php:46
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/extensions/UserMerge/tests/phpunit/MergeUserTest.php:56
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/tests/phpunit/MediaWikiTestCase.php:389
16:40:22 
16:40:22 3) MergeUserTest::testMergeEditcount
16:40:22 DBQueryError: A database error has occurred. Did you forget to run maintenance/update.php after upgrading?  See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
16:40:22 Query: SELECT  w2.wl_namespace,w2.wl_title  FROM `unittest_watchlist` `w1` INNER JOIN `unittest_watchlist` `w2` ON ((w1.wl_namespace = w2.wl_namespace) AND (w1.wl_title = w2.wl_title))  WHERE w1.wl_user = '11' AND w2.wl_user = '10'   FOR UPDATE
16:40:22 Function: MergeUser::deduplicateWatchlistEntries
16:40:22 Error: 1137 Can't reopen table: 'w1' (127.0.0.1:3306)
16:40:22 
16:40:22 
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/includes/db/Database.php:937
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/includes/db/Database.php:904
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/includes/db/Database.php:1237
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/extensions/UserMerge/MergeUser.php:325
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/extensions/UserMerge/MergeUser.php:224
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/extensions/UserMerge/MergeUser.php:46
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/extensions/UserMerge/tests/phpunit/MergeUserTest.php:94
16:40:22 /mnt/jenkins-workspace/workspace/mwext-testextension-php55/src/tests/phpunit/MediaWikiTestCase.php:389
16:40:22 
16:40:22 FAILURES!
\\\

Event Timeline

hashar subscribed.

That is similar to T101702, namely you can join twice on temporary tables:

https://dev.mysql.com/doc/refman/5.0/en/temporary-table-problems.html