[MDEV-10439] mysql_tzinfo_to_sql DDL clears other tables on Galera cluster Created: 2016-07-26  Updated: 2022-04-20  Resolved: 2022-04-19

Status: Closed
Project: MariaDB Server
Component/s: Admin statements
Affects Version/s: 10.1.14, 10.1.16
Fix Version/s: 10.2.27, 10.1.42, 10.3.18, 10.4.8

Type: Bug Priority: Minor
Reporter: tiago caxias Assignee: Daniel Black
Resolution: Duplicate Votes: 0
Labels: galera, timezones
Environment:

Debian Jessie - x86_64


Issue Links:
Duplicate
duplicates MDEV-18778 mysql_tzinfo_to_sql does not work cor... Closed

 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.



 Comments   
Comment by Daniel Black [ 2020-08-05 ]

is the MDEV-18778 solution of changing to innodb, replicating the insert statement and changing back to aria acceptable?

Generated at Thu Feb 08 07:42:14 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.