Examples of "communication packets" message in mysql error log
Last updated on DECEMBER 26, 2017
Applies to:MySQL Server - Version 5.7 and later
Information in this document applies to any platform.
Sometimes mysqld error log shows lots of "Aborted connection" messages like below.
Usually 'Got timeout' messages are caused by the value set in mysqld (interactive_timeout, net_read_timeout, net_write_timeout, wait_timeout) and 'Got an error' messages are caused by abnormally terminated connections or malformed packet.
It mainly comes from 4 reasons.
- Inactivity connection is timing out over wait_timeout or interactive_timeout.
- Connection is terminated abnormally.
- Network delay or outage.
- The row has more data than max_allowed_packet of client.
You may check applications which can be closing the connection properly using well implemented exception handling, and there is any network settings that can affect to connection or problem (outage, delay) there.
Let's learn when those messages happening with following examples.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms