Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3
-
None
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/7682
main.join_cache 'innodb' w1 [ fail ]
|
Test ended at 2018-11-01 15:59:13
|
|
CURRENT_TEST: main.join_cache
|
mysqltest: At line 707: query 'SELECT City.Name, Country.Name, CountryLanguage.Language
|
FROM City,Country,CountryLanguage
|
WHERE City.Country=Country.Code AND
|
CountryLanguage.Country=Country.Code AND
|
City.Name LIKE 'L%' AND Country.Population > 3000000 AND
|
CountryLanguage.Percentage > 50 AND
|
LENGTH(Language) < LENGTH(City.Name) - 2' failed: 1030: Got error 14 "Bad address" from storage engine MyISAM
|
|
The result from queries just before the failure was:
|
< snip >
|
Panevezys Lithuania
|
EXPLAIN
|
SELECT City.Name, Country.Name, CountryLanguage.Language
|
FROM City,Country,CountryLanguage
|
WHERE City.Country=Country.Code AND
|
CountryLanguage.Country=Country.Code AND
|
City.Name LIKE 'L%' AND Country.Population > 3000000 AND
|
CountryLanguage.Percentage > 50 AND
|
LENGTH(Language) < LENGTH(City.Name) - 2;
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE CountryLanguage ALL PRIMARY,Percentage NULL NULL NULL 984 Using where
|
1 SIMPLE Country hash_ALL PRIMARY #hash#PRIMARY 3 world.CountryLanguage.Country 239 Using where; Using join buffer (flat, BNLH join)
|
1 SIMPLE City hash_ALL Country #hash#Country 3 world.CountryLanguage.Country 4079 Using where; Using join buffer (flat, BNLH join)
|
SELECT City.Name, Country.Name, CountryLanguage.Language
|
FROM City,Country,CountryLanguage
|
WHERE City.Country=Country.Code AND
|
CountryLanguage.Country=Country.Code AND
|
City.Name LIKE 'L%' AND Country.Population > 3000000 AND
|
CountryLanguage.Percentage > 50 AND
|
LENGTH(Language) < LENGTH(City.Name) - 2;
|