# character set warning **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [March 10, 2014, 3:08pm UTC](https://forums.percona.com/t/character-set-warning/3325 "2014-03-10T15:08:48Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![baoxiao](https://avatars.discourse-cdn.com/v4/letter/b/f6c823/32.png) [@baoxiao](https://forums.percona.com/u/baoxiao)\ **Post date:** [March 10, 2014, 3:08pm UTC](https://forums.percona.com/t/character-set-warning/3325/1 "2014-03-10T15:08:48Z")
I got lots of warnings in the error file: [Warning] Client failed to provide its character set. ‘latin1’ will be used as client character set How can I fixed it? the only connection is the slave replication. Thanks ---
**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\ **Post date:** [March 13, 2014, 1:57am UTC](https://forums.percona.com/t/character-set-warning/3325/2 "2014-03-13T01:57:11Z")
Hi, Which MySQL/Percona version you are using ? I’m not sure but you might be hitting this bug [url][MySQL Bugs: #69160: character set warning when using ssl](http://bugs.mysql.com/bug.php?id=69160%5B/url%5D) Can you provide some more details like which connector you are using with version? also my.cnf of master and slave? Thanks. ---
**Author:** ![PercUse](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@PercUse](https://forums.percona.com/u/PercUse)\ **Post date:** [May 16, 2014, 4:29am UTC](https://forums.percona.com/t/character-set-warning/3325/3 "2014-05-16T04:29:30Z")
Hi Folks, I have the same issue. The error log file start to be huge. I tried to disable the warnings from my.cnf using log-warnings=0 and log\_warnings\_suppress=1592 but without any result, warnings are still there. This error is generated because of Haproxy when he’s doing mysql-check. Any idea how to solve this issue or disable warnings? bug already reported by someone else: [url][MySQL Bugs: #72543: remove the spam warnings: Client failed to provide its character set](http://bugs.mysql.com/bug.php?id=72543%5B/url%5D) Installed packages: ii percona-toolkit 2.2.7 Advanced MySQL and system command-line tools ii percona-xtrabackup 2.1.9-744-1.precise Open source backup tool for InnoDB and XtraDB ii percona-xtradb-cluster-client-5.6 5.6.15-25.5-759.precise Percona Server database client binaries ii percona-xtradb-cluster-common-5.6 5.6.15-25.5-770.precise Percona Server database common files (e.g. /etc/mysql/my.cnf) ii percona-xtradb-cluster-galera-3.x 216.precise Galera components of Percona XtraDB Cluster ii percona-xtradb-cluster-server-5.6 5.6.15-25.5-759.precise Percona Server database server binaries Thanks in advance ---
**Author:** ![PercUse](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@PercUse](https://forums.percona.com/u/PercUse)\ **Post date:** [May 19, 2014, 12:28am UTC](https://forums.percona.com/t/character-set-warning/3325/4 "2014-05-19T00:28:34Z")
Any idea 😉 up … ---
**Author:** ![PercUse](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@PercUse](https://forums.percona.com/u/PercUse)\ **Post date:** [June 12, 2014, 12:47am UTC](https://forums.percona.com/t/character-set-warning/3325/5 "2014-06-12T00:47:38Z")
Hi Folks, after one month I’m still looking for a solution related to this issue. Anyone from Percona team have an idea about this bug? ---
**Author:** ![PercUse](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@PercUse](https://forums.percona.com/u/PercUse)\ **Post date:** [June 12, 2014, 9:24am UTC](https://forums.percona.com/t/character-set-warning/3325/6 "2014-06-12T09:24:34Z")
Hi TomD, Thanks for looking this case. Just FYI: Distro: Ubuntu Precise (12.04.4) Error log: - Size: -rw-r----- 1 mysql root 1.1G Jun 12 16:45 staging.err - Message: 2014-06-12 16:45:41 1243 [Warning] Client failed to provide its character set. ‘latin1’ will be used as client character set. Installed Packages related to Percona: percona-toolkit ---- 2.2.8 percona-xtrabackup ---- 2.1.9-744-1.precise percona-xtradb-cluster-client-5.6 ---- 5.6.15-25.5-759.precise percona-xtradb-cluster-common-5.6 ---- 5.6.15-25.5-770.precise percona-xtradb-cluster-galera-3.x ---- 216.precise percona-xtradb-cluster-server-5.6 ---- 5.6.15-25.5-759.precise haproxy ---- 1.5~dev26-2ppa1~precise Thanks in advance ---
**Author:** ![PercUse](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@PercUse](https://forums.percona.com/u/PercUse)\ **Post date:** [June 19, 2014, 9:00am UTC](https://forums.percona.com/t/character-set-warning/3325/7 "2014-06-19T09:00:41Z")
Hi TomD, Have you been able to reproduce the bug? Best regards, ---
**Author:** ![PercUse](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@PercUse](https://forums.percona.com/u/PercUse)\ **Post date:** [June 25, 2014, 12:28am UTC](https://forums.percona.com/t/character-set-warning/3325/8 "2014-06-25T00:28:24Z")
Hi TomD, Thanks for this info. Looking forward to have some news about this bug ---
**Author:** ![laurynas](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/laurynas/32/12_2.png) [@laurynas](https://forums.percona.com/u/laurynas)\ **Post date:** [June 25, 2014, 9:48am UTC](https://forums.percona.com/t/character-set-warning/3325/9 "2014-06-25T09:48:16Z")
I am sorry to say that we are not prioritising a fix for this bug at the moment and are leaving this for Oracle to address for the time being at [url][MySQL Bugs: #72543: remove the spam warnings: Client failed to provide its character set](http://bugs.mysql.com/bug.php?id=72543%5B/url%5D). One thing that could be done now is to file this bug (with a reference to #72543) on [url][https://bugs.launchpad.net/percona-server/[/url]](https://bugs.launchpad.net/percona-server/%5B/url%5D). Someone might comment with a workaround there, and we also may get an idea of how many users are affected, which influences prioritisation. ---
**Author:** ![PercUse](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@PercUse](https://forums.percona.com/u/PercUse)\ **Post date:** [June 30, 2014, 3:51am UTC](https://forums.percona.com/t/character-set-warning/3325/10 "2014-06-30T03:51:59Z")
Hi Iaurynas, No problem. As it’s upstream bug, you should just notify them to look at this.