MySQL Forums
Forum List  »  Quality Assurance

Random Connection Issues - Error Log Lockups?
Posted by: Sam Kimmel
Date: November 11, 2013 12:27PM

Over the past week we've had a couple times when our IIS web server has been randomly and intermittently unable to communicate with the MySQL database server. They are VMs on the same physical box, so it shouldn't be a networking thing. There are no hops when doing a tracert.

The error being reported in our logs is that the sites are unable to connect to MySQL. So I went to the MySQL error log to see if anything was going on there.

What I found is that we are getting thousands of these warnings in our error log:

"Client failed to provide its character set. 'utf8' will be used as client character set"

It appears that this may happening for every MySQL query. The log grows 2-3MB per hour.

1) Is it possible this Warning logging is reaching critical mass during high traffic periods and is essentially tying up the server due to read/write locks?

2) Why is the warning happening?

3) How do I stop it from continuing?

We ported our databases from MySQL 4 using mysqldump. These errors did not exist in the old version of the DB.

Options: ReplyQuote

Written By
Random Connection Issues - Error Log Lockups?
November 11, 2013 12:27PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.