Client failed to provide its character set

Bug #1335788 reported by Hassan El Jacifi on 2014-06-30
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Invalid
Undecided
Unassigned
5.5
Invalid
Undecided
Unassigned
5.6
Fix Released
Medium
Unassigned
5.7
Fix Released
Medium
Unassigned

Bug Description

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) wrote :
Changed in percona-server:
status: New → Confirmed
tags: added: upstream
Hassan El Jacifi (waver) wrote :

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) wrote :

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

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.