Le 10/07/12 21:44, Jeroen De Dauw a écrit : > Hey, > > I got a unit test (added here: https://gerrit.wikimedia.org/r/#/c/14870/) > causing some error which I can't figure out the cause of. > > The error is "Error: 1137 Can't reopen table: 'unittest_smw_ids'", full > message here: http://dpaste.org/B2npZ/ > > Anyone an idea what might be going on?
That is a MySQL bug submitted in May 2005: http://bugs.mysql.com/bug.php?id=10327 Test: create temporary table tt (x int); select * from tt as t1, tt as t2; Trigger the 1137 error. Basically you cant reference the same temporary table more than once in the same query :/ Platonides had the issue with r102411: http://www.mediawiki.org/wiki/Special:Code/MediaWiki/102411#c29123 The workaround was to skip the query: http://www.mediawiki.org/wiki/Special:Code/MediaWiki/109024 :( -- Antoine "hashar" Musso _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
