| Jakob_WMDE created this task. Jakob_WMDE added projects: Wikidata, Lexicographical data, Wikidata-Editor-Experience-Improvements-Iteration3. |
TASK DESCRIPTION
Special:WhatLinksHere uses self-join in SpecialWhatLinksHere::showIndirectLinks on temporary tables in tests and breaks with error 1137.
(Possibly incomplete) options:
- get rid of the self-join in SpecialWhatLinksHere.php
- get rid of temporary tables for all tests
- have a job running a set of tests without temporary tables
Hint: You can run the phpunit test runner with the --use-normal-tables flag
Goals:
- find and document possible solutions and document possible trade-offs
- if no solution can be found, escalate
See https://integration.wikimedia.org/ci/job/mwext-testextension-hhvm-composer-jessie/14933/consoleFull
16:21:52 1) Wikibase\Lexeme\Tests\MediaWiki\Specials\LexemeSpecialWhatLinksHereTest::testLexemeLanguageItemLink 16:21:52 Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 16:21:52 Query: SELECT page_id,page_namespace,page_title,rd_from,page_is_redirect FROM (SELECT /*! STRAIGHT_JOIN */ pl_from,rd_from FROM `unittest_pagelinks` LEFT JOIN `unittest_redirect` ON ((rd_from = pl_from) AND rd_title = 'Q123' AND (rd_interwiki = '' OR rd_interwiki IS NULL) AND rd_namespace = '120') INNER JOIN `unittest_page` ON ((pl_from = page_id)) WHERE pl_namespace = '120' AND pl_title = 'Q123' ORDER BY pl_from LIMIT 102 ) `temp_backlink_range` INNER JOIN `unittest_page` ON ((pl_from = page_id)) ORDER BY page_id LIMIT 51 16:21:52 Function: SpecialWhatLinksHere::showIndirectLinks 16:21:52 Error: 1137 Can't reopen table: 'unittest_page' (127.0.0.1:3306)
TASK DETAIL
EMAIL PREFERENCES
To: Jakob_WMDE
Cc: Ladsgroup, daniel, WMDE-leszek, Addshore, Tarrow, Pablo-WMDE, Jakob_WMDE, Mringgaard, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Wikidata-bugs, aude, Darkdadaah, Mbch331
Cc: Ladsgroup, daniel, WMDE-leszek, Addshore, Tarrow, Pablo-WMDE, Jakob_WMDE, Mringgaard, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Wikidata-bugs, aude, Darkdadaah, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
