[MDEV-6130] mysql_tzinfo_to_sql in galera distribution adds "SET SESSION wsrep_replicate_myisam" Created: 2014-04-17  Updated: 2014-04-18  Resolved: 2014-04-18

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.36-galera
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Kolbe Kegel (Inactive) Assignee: Nirbhay Choubey (Inactive)
Resolution: Duplicate Votes: 0
Labels: galera


 Description   

The mysql_tzinfo_to_sql tool included with Galera distributions of MariaDB gives this as its first line of output:

SET SESSION wsrep_replicate_myisam=ON;

That is problematic since, wsrep_replication_myisam is not a session variable. This means that the tool will fail with this error:

ERROR 1229 (HY000) at line 1: Variable 'wsrep_replicate_myisam' is a GLOBAL variable and should be set with SET GLOBAL

Perhaps this should be used instead:

SET SESSION wsrep_on=0;

 Comments   
Comment by Nirbhay Choubey (Inactive) [ 2014-04-18 ]

Hi Kolbe,
It has already been addressed (s/SESSION/GLOBAL) in 5.5.36-galera. (MDEV#5534).
Setting @@session.wsrep_on=0 would stop the replication altogether (see lp:1161432).

Comment by Nirbhay Choubey (Inactive) [ 2014-04-18 ]

MDEV#5534

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