Comment 4 for bug 1280270

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

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:~$