Examples of "communication packets" message in mysql error log

(Doc ID 2322952.1)

Last updated on DECEMBER 26, 2017

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Goal

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.

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.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms