MySQL 8.0.22 version compatibility issue with ProxySQL

[Anish Kumar A K]

 the query behind is mysql> select member_role from performance_schema.replication_group_members where member_host = @@hostname and member_role='PRIMARY'; ERROR 1267 (HY000): Illegal mix of collations (ascii_general_ci,IMPLICIT) and (utf8_general_ci,SYSCONST) for operation '=' #3178

2020-11-27 16:01:24 MySQL_HostGroups_Manager.cpp:3846:update_group_replication_set_offline(): [WARNING] Group Replication: setting host vildb0114197:3306 offline because: viable_candidate=NO

2020-11-27 16:01:24 [INFO] Dumping current MySQL Servers structures for hostgroup ALL

select * from sys.gr_member_routing_candidate_status;

ERROR 1267 (HY000): Illegal mix of collations (ascii_general_ci,IMPLICIT) and (utf8_general_ci,SYSCONST) for operation '='

[Anish Kumar A K]

Identifed the root cause . after changing the query , it is working in mysql .

mysql> select member_role from performance_schema.replication_group_members where member_host = CAST(@@hostname as char) and member_role='PRIMARY';

+-------------+

| member_role |

+-------------+

| PRIMARY     |

+-------------+

1 row in set (0.00 sec)

But ProxySQL should have the changes . Expecting the changes from proxySQL plugins and ProxySQL latest release .

[Anish Kumar A K]

The issue is closed .