mysql_tzinfo_to_sql generates "'wsrep_replicate_myisam' is a GLOBAL variable" error

[George Lund]

With Percona 5.6:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot -p mysql
Enter password:
ERROR 1229 (HY000) at line 1: Variable 'wsrep_replicate_myisam' is a GLOBAL variable and should be set with SET GLOBAL

May be some kind of regression relating to Bug #1161432 ?

[Raghavendra D Prabhu (raghavendra-prabhu)]

Yes, it is related to that.

Looks like wsrep_replicate_myisam is no longer a session one.

Short term fix for this is to remove that fragment from tztime.cc and user has to set wsrep_replicate_myisam explicitly before.

Long term fix is to make wsrep_replicate_myisam a session var.

Workaround is to grep it out.

[Raghavendra D Prabhu (raghavendra-prabhu)]

Reported session var issue here https://bugs.launchpad.net/codership-mysql/+bug/1280280

[Raghavendra D Prabhu (raghavendra-prabhu)]

Removed the bit about 'set session .... myisam' from 5.6 release.

[Nilnandan Joshi (nilnandan-joshi)]

It's still there in PXC 5.5.37

[root@percona-pxc55-1 ~]# mysql -uroot -p -e "show variables like 'version%'"
Enter password:
+-------------------------+-----------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+-------------------------+-----------------------------------------------------------------------------------------------------+
| version | 5.5.37-35.0-55-log |
| version_comment | Percona XtraDB Cluster (GPL), Release rel35.0, Revision 756, WSREP version 25.10, wsrep_25.10.r3985 |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+-----------------------------------------------------------------------------------------------------+
[root@percona-pxc55-1 ~]# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot -p mysql
Enter password:
ERROR 1229 (HY000) at line 1: Variable 'wsrep_replicate_myisam' is a GLOBAL variable and should be set with SET GLOBAL
[root@percona-pxc55-1 ~]#

But resolved in latest PXC 5.6.19

nilnandan@debian:~$ mysql -uroot -p -e "show variables like 'version%'"
Enter password:
+-------------------------+--------------------------------------------------------------+
| Variable_name | Value |
+-------------------------+--------------------------------------------------------------+
| version | 5.6.19-67.0-56-log |
| version_comment | Percona XtraDB Cluster (GPL), Release 25.6, wsrep_25.6.r4111 |
| version_compile_machine | x86_64 |
| version_compile_os | debian-linux-gnu |
+-------------------------+--------------------------------------------------------------+
nilnandan@debian:~$
nilnandan@debian:~$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot -p mysql
Enter password:
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
nilnandan@debian:~$

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1619