Character set '#255' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file;,Error_code: 22

Question

Hi, Anyone encounter this error? Character set '#255' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file;,Error_code: 22

We've been creating a replication between RDS Aurora MySQL5.7  to EC2 MySQL5.7  with GTID = ON and enforce_gtid_consistency = ON. It woks but after few hours of replication we always got the error above. We already tried different troubleshooting, configuration,  tried replicating using new binlog position, modified some of the parameters on both mysql aurora and mysql 5.7 but none of them work.. Any solutions you can provide that we should try? Thank you.

Answer

HI there,

The below error message is usually observed when the charset and collation are not matching between the source and the replica server.

>>> Character set '#255' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file;,Error_code: 22

Make sure that the collation and charset matches in both replica and the source instance using below queries:

SHOW VARIABLES LIKE '%character_set%';
SHOW VARIABLES LIKE '%collation%';

Also make sure that the replica instance on EC2 instance is running on same major version (version 5.7).

Use the parameter group to make any modification to the parameters in the source RDS MySQL instance and update the my.cnf file on EC2 mysql instance to make any changes to the parameters in your replica instance.

Character set '#255' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file;,Error_code: 22

Relevanter Inhalt