Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
10.1.14, 10.1.16
-
Debian Jessie - x86_64
Description
Hi all,
We have a 3 node MariaDB Galera (versions 10.1.1[4,6]) with two async replicas.
When we load mysql_tzinfo_to_sql on one of the nodes all others get their tables emptied out.
The beginning of the mysql_tzinfo_to_sql statement truncates relevant tables and DDL statements get replicated throughout a Galera cluster.
Following insert statement, however, do not get replicated.
This may be because mysql_tzinfo_to_sql is expecting MyISAM tables and asks for replication of following DML commands but on MariaDB 10.1.1[4,6] these tables are on Aria.
After changing the tz load statement to:
root@db_host ~ # mysql_tzinfo_to_sql /usr/share/zoneinfo | sed -i 's#TRUNCATE TABLE#DELETE FROM#g' | mysql mysql it works flawlessly.
Thanks.
Attachments
Issue Links
- duplicates
-
MDEV-18778 mysql_tzinfo_to_sql does not work correctly in MariaDB Galera
- Closed