[MDEV-5282] installation using mysql_install_db fails, but it shouldn't Created: 2013-11-12 Updated: 2013-11-13 Resolved: 2013-11-13 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 10.0.5 |
| Fix Version/s: | 10.0.6 |
| Type: | Bug | Priority: | Blocker |
| Reporter: | Giuseppe Maxia | Assignee: | Kristian Nielsen |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | gtid, installer, sandbox | ||
| Environment: |
installation using MySQL Sandbox, which in turn uses mysql_install_db |
||
| Description |
|
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
However, the table is in the data directory, and the database server starts fine. This bug prevents MySQL Sandbox from using MariaDB |
| Comments |
| Comment by Elena Stepanova [ 2013-11-12 ] |
|
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' set sql_mode=''; — We want this to be created with the default storage engine. 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'; 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'; |
| Comment by Giuseppe Maxia [ 2013-11-12 ] |
|
With the workaround suggested by Elena, installation works as expected. |
| Comment by Kristian Nielsen [ 2013-11-13 ] |
|
Pushed to 10.0 |