While installing MariaDB 10.0.5 (compiled from source on MacOSX) using MySQL Sandbox, I got this error:
$HOME/opt/mysql/ma10.0.5/scripts/mysql_install_db --no-defaults --user=$USER --basedir=$HOME/opt/mysql/ma10.0.5 --datadir=$HOME/sandboxes/msb_ma10_0_5/data --tmpdir=$HOME/sandboxes/msb_ma10_0_5/tmp --lower_case_table_names=2
error while creating grant tables
Installing MariaDB/MySQL system tables in '$HOME/sandboxes/msb_ma10_0_5/data' ...
-
-
- ( ... many [Note] lines removed for clarity)
2013-11-12 05:58:58 12461e000 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
However, the table is in the data directory, and the database server starts fine.
This bug prevents MySQL Sandbox from using MariaDB
{"report":{"fcp":953.2000000476837,"ttfb":216.40000009536743,"pageVisibility":"visible","entityId":26410,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"1530cc0d-a474-455b-863b-9eeac637cd96","navigationType":0,"readyForUser":1019,"redirectCount":0,"resourceLoadedEnd":1150,"resourceLoadedStart":237,"resourceTiming":[{"duration":168.29999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":237,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":237,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":405.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":168.29999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":237.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":237.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":405.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":199.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":237.5,"connectEnd":237.5,"connectStart":237.5,"domainLookupEnd":237.5,"domainLookupStart":237.5,"fetchStart":237.5,"redirectEnd":0,"redirectStart":0,"requestStart":237.5,"responseEnd":436.7000000476837,"responseStart":436.7000000476837,"secureConnectionStart":237.5},{"duration":274.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":237.70000004768372,"connectEnd":237.70000004768372,"connectStart":237.70000004768372,"domainLookupEnd":237.70000004768372,"domainLookupStart":237.70000004768372,"fetchStart":237.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":237.70000004768372,"responseEnd":512.2999999523163,"responseStart":512.2999999523163,"secureConnectionStart":237.70000004768372},{"duration":278.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":238,"connectEnd":238,"connectStart":238,"domainLookupEnd":238,"domainLookupStart":238,"fetchStart":238,"redirectEnd":0,"redirectStart":0,"requestStart":238,"responseEnd":516.5999999046326,"responseStart":516.5999999046326,"secureConnectionStart":238},{"duration":278.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":238.09999990463257,"connectEnd":238.09999990463257,"connectStart":238.09999990463257,"domainLookupEnd":238.09999990463257,"domainLookupStart":238.09999990463257,"fetchStart":238.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":238.09999990463257,"responseEnd":516.9000000953674,"responseStart":516.9000000953674,"secureConnectionStart":238.09999990463257},{"duration":278.89999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":238.40000009536743,"connectEnd":238.40000009536743,"connectStart":238.40000009536743,"domainLookupEnd":238.40000009536743,"domainLookupStart":238.40000009536743,"fetchStart":238.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":238.40000009536743,"responseEnd":517.2999999523163,"responseStart":517.2999999523163,"secureConnectionStart":238.40000009536743},{"duration":342.2000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":238.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":238.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":580.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":279.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":238.70000004768372,"connectEnd":238.70000004768372,"connectStart":238.70000004768372,"domainLookupEnd":238.70000004768372,"domainLookupStart":238.70000004768372,"fetchStart":238.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":238.70000004768372,"responseEnd":517.7999999523163,"responseStart":517.7999999523163,"secureConnectionStart":238.70000004768372},{"duration":342,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":238.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":238.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":580.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":279.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":239.09999990463257,"connectEnd":239.09999990463257,"connectStart":239.09999990463257,"domainLookupEnd":239.09999990463257,"domainLookupStart":239.09999990463257,"fetchStart":239.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":239.09999990463257,"responseEnd":518.5,"responseStart":518.5,"secureConnectionStart":239.09999990463257},{"duration":448.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":239.90000009536743,"connectEnd":239.90000009536743,"connectStart":239.90000009536743,"domainLookupEnd":239.90000009536743,"domainLookupStart":239.90000009536743,"fetchStart":239.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":239.90000009536743,"responseEnd":688,"responseStart":688,"secureConnectionStart":239.90000009536743},{"duration":910.0999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":239.90000009536743,"connectEnd":239.90000009536743,"connectStart":239.90000009536743,"domainLookupEnd":239.90000009536743,"domainLookupStart":239.90000009536743,"fetchStart":239.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":239.90000009536743,"responseEnd":1150,"responseStart":1149.9000000953674,"secureConnectionStart":239.90000009536743},{"duration":97,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":592.4000000953674,"connectEnd":592.4000000953674,"connectStart":592.4000000953674,"domainLookupEnd":592.4000000953674,"domainLookupStart":592.4000000953674,"fetchStart":592.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":592.4000000953674,"responseEnd":689.4000000953674,"responseStart":689.2999999523163,"secureConnectionStart":592.4000000953674},{"duration":341.59999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":870.4000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":870.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1212,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":72,"responseStart":216,"responseEnd":218,"domLoading":235,"domInteractive":1173,"domContentLoadedEventStart":1173,"domContentLoadedEventEnd":1212,"domComplete":1639,"loadEventStart":1639,"loadEventEnd":1639,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1152.0999999046326},{"name":"bigPipe.sidebar-id.end","time":1152.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":1153.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":1154.2999999523163},{"name":"activityTabFullyLoaded","time":1225.5999999046326}],"measures":[],"correlationId":"e74120ab396f23","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":91,"dbReadsTimeInMs":8,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
It happens because gtid_slave_pos table is created at the very beginning of mysql_system_tables.sql, before InnoDB stats tables. I suggest moving it to the end of the script (it can also be as a workaround until it's released), something like
=== modified file 'scripts/mysql_system_tables.sql'
— scripts/mysql_system_tables.sql 2013-11-04 07:43:56 +0000
+++ scripts/mysql_system_tables.sql 2013-11-12 08:42:35 +0000
@@ -21,11 +21,7 @@
set sql_mode='';
— We want this to be created with the default storage engine.
— This way, if InnoDB is used we get crash safety, and if MyISAM is used
— we avoid mixed-engine transactions.
-CREATE TABLE IF NOT EXISTS gtid_slave_pos (domain_id INT UNSIGNED NOT NULL, sub_id BIGINT UNSIGNED NOT NULL, server_id INT UNSIGNED NOT NULL, seq_no BIGINT UNSIGNED NOT NULL, PRIMARY KEY (domain_id, sub_id)) comment='Replication slave GTID position';
-
+set @storage_engine.saved = @@storage_engine;
set storage_engine=myisam;
CREATE TABLE IF NOT EXISTS db ( Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(80) binary DEFAULT '' NOT NULL, Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Event_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Trigger_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, PRIMARY KEY Host (Host,Db,User), KEY User (User) ) engine=MyISAM CHARACTER SET utf8 COLLATE utf8_bin comment='Database privileges';
@@ -227,3 +223,12 @@
CREATE TABLE IF NOT EXISTS column_stats (db_name varchar(64) NOT NULL, table_name varchar(64) NOT NULL, column_name varchar(64) NOT NULL, min_value varchar(255) DEFAULT NULL, max_value varchar(255) DEFAULT NULL, nulls_ratio decimal(12,4) DEFAULT NULL, avg_length decimal(12,4) DEFAULT NULL, avg_frequency decimal(12,4) DEFAULT NULL, hist_size tinyint unsigned, hist_type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB'), histogram varbinary(255), PRIMARY KEY (db_name,table_name,column_name) ) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin comment='Statistics on Columns';
CREATE TABLE IF NOT EXISTS index_stats (db_name varchar(64) NOT NULL, table_name varchar(64) NOT NULL, index_name varchar(64) NOT NULL, prefix_arity int(11) unsigned NOT NULL, avg_frequency decimal(12,4) DEFAULT NULL, PRIMARY KEY (db_name,table_name,index_name,prefix_arity) ) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin comment='Statistics on Indexes';
+
+-- We want this to be created with the default storage engine.
+-- This way, if InnoDB is used we get crash safety, and if MyISAM is used
+-- we avoid mixed-engine transactions.
+set storage_engine = @storage_engine.saved;
+
+CREATE TABLE IF NOT EXISTS gtid_slave_pos (domain_id INT UNSIGNED NOT NULL, sub_id BIGINT UNSIGNED NOT NULL, server_id INT UNSIGNED NOT NULL, seq_no BIGINT UNSIGNED NOT NULL, PRIMARY KEY (domain_id, sub_id)) comment='Replication slave GTID position';
+