Client failed to provide its character set

[Hassan El Jacifi]

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

[Hassan El Jacifi (waver)]

http://bugs.mysql.com/bug.php?id=72543

[Hassan El Jacifi (waver)]

Hi Folks,

Bug still present on the last release:

ii percona-xtradb-cluster-client-5.6 5.6.21-25.8-938.precise Percona XtraDB Cluster database client binaries
ii percona-xtradb-cluster-common-5.6 5.6.21-25.8-938.precise Percona XtraDB Cluster database common files (e.g. /etc/mysql/my.cnf)
ii percona-xtradb-cluster-galera-3.x 3.8.3390.precise Galera components of Percona XtraDB Cluster
ii percona-xtradb-cluster-server 5.6.15-25.2-645.precise Percona Server database server
ii percona-xtradb-cluster-server-5.6 5.6.21-25.8-938.precise Percona XtraDB Cluster database server binaries

[Hassan El Jacifi (waver)]

Hi,

With the last Haproxy (1.5.9) you can now use the new mysqlcheck format:

From:
option mysql-check user username
To:
option mysql-check user username post-41

https://github.com/sekh/haproxy1.5-dev/commit/6639a7cf0d25a0611a49a28a2d0108882b744ebb

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1518