Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Not a Bug
-
Affects Version/s: 10.0.15
-
Fix Version/s: N/A
-
Component/s: Galera SST, Replication, Storage Engine - InnoDB
-
Labels:
Description
As the default engine is Innodb but still when in see mysql database all tables under it are using MyISAM , due to that galera replication is not working properly , whenever i delete or insert users ..
MariaDB [mysql]> show table status; +---------------------------+--------+--- -------------------+----------+---------- | Name | Engine | Ve Collation | Checksum | Create_op +---------------------------+--------+--- -------------------+----------+---------- | column_stats | MyISAM | utf8_bin | NULL | | columns_priv | MyISAM | utf8_bin | NULL | | db | MyISAM | utf8_bin | NULL | | event | MyISAM | utf8_general_ci | NULL | | func | MyISAM | utf8_bin | NULL | | general_log | CSV | utf8_general_ci | NULL | | gtid_slave_pos | InnoDB | latin1_swedish_ci | NULL | | help_category | MyISAM | utf8_general_ci | NULL | | help_keyword | MyISAM | utf8_general_ci | NULL | | help_relation | MyISAM | utf8_general_ci | NULL | | help_topic | MyISAM | utf8_general_ci | NULL | | host | MyISAM | utf8_bin | NULL | | index_stats | MyISAM | utf8_bin | NULL | | innodb_index_stats | InnoDB | utf8_bin | NULL | stats_per | innodb_table_stats | InnoDB | utf8_bin | NULL | stats_per | plugin | MyISAM | utf8_general_ci | NULL | | proc | MyISAM | utf8_general_ci | NULL | | procs_priv | MyISAM | utf8_bin | NULL | | proxies_priv | MyISAM | utf8_bin | NULL | | roles_mapping | MyISAM | utf8_bin | NULL | | servers | MyISAM | utf8_general_ci | NULL | | slow_log | CSV | utf8_general_ci | NULL | | table_stats | MyISAM | utf8_bin | NULL | | tables_priv | MyISAM | utf8_bin | NULL | | time_zone | MyISAM | utf8_general_ci | NULL | | time_zone_leap_second | MyISAM | utf8_general_ci | NULL | | time_zone_name | MyISAM | utf8_general_ci | NULL | | time_zone_transition | MyISAM | utf8_general_ci | NULL | | time_zone_transition_type | MyISAM | utf8_general_ci | NULL | | user | MyISAM | utf8_bin | NULL | +---------------------------+--------+---
even if i try to convert them to innodb it throws an error
MariaDB [mysql]> alter table user ENGINE=INNODB ;
ERROR 1025 (HY000): Error on rename of './mysql/#sql-1597_279' to './mysql/user' (errno: -1 "Internal error < 0 (Not system error)")
MariaDB [mysql]>
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
System tables are MyISAM so far, it's intentional and not a bug.
For advice on how to deal with them in Galera context, I recommend to ask the question at codership-team@googlegroups.com, as it's a common issue for all Galera-based clusters, not just MariaDB Galera cluster. You'll get wider expert opinion there.