is this a bug?

Description:
Error log gets filled with spam like this: [Warning] Client failed to provide its character set. ‘latin1’ will be used as client character set.
[Warning] Client failed to provide its character set. ‘latin1’ will be used as client character set.
How to repeat:

  • HAProxy’s mysql-check option causes this warning as well. A solution for suppressing this warning would be helpful to keep error logs clean.
  • Simplest example, login to server with an 4.0.forever client.
    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.
    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

I am getting this error. I hope someone can point me to right direction. thanks

You might be affected by either of these bugs
http://bugs.mysql.com/bug.php?id=69160
http://bugs.mysql.com/bug.php?id=72543

At any rate, there is an existing forum thread which might be related to your problem http://www.percona.com/forums/questions-discussions/mysql-and-percona-server/13590-character-set-warning

Please note comment #11.

Hi jrivera…Thanks for pointing me to the right direction. You are great! :cool: