Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17743

main.join_cache failed in buildbot with "Bad address" from storage engine MyISAM

    XMLWordPrintable

Details

    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;
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.