Error Message: "Got an error reading communication packets"
Posted by: Mar K
Date: June 07, 2017 03:38AM

Hello folks,

the MySQL database server on my server is constantly generating errors.
Here is a section out of the error log

=====
170607 8:48:01 [Warning] Aborted connection 13351 to db: 'db' user: 'dbUser' host: 'HostName' (Got an error reading communication packets)
170607 8:48:46 [Warning] Aborted connection 13353 to db: 'db' user: 'dbUser' host: 'HostName' (Got an error reading communication packets)
170607 8:48:46 [Warning] Aborted connection 13352 to db: 'db' user: 'dbUser' host: 'HostName' (Got an error reading communication packets)
170607 8:52:11 [Warning] Aborted connection 13355 to db: 'db' user: 'dbUser' host: 'HostName' (Got an error reading communication packets)
170607 8:56:23 [Warning] Aborted connection 13360 to db: 'db' user: 'dbUser' host: 'HostName' (Got an error reading communication packets)
=====

So I googled for a solution and I ended up in increasing the value of the server variable 'max_allowed_packet'.
I already increased this variable to the maximum value of 1073741824 and restartet the server, but it didn't change anything. The error message gets still written to the log file.

The server is MySQL 5.1.24 and the OS of the server is Windows Server 2008.

Hope you can help me with that, since I have no idea why the message is still logged into the file.

Thanks
Kind Regards
Mar K

Options: ReplyQuote


Subject
Written By
Posted
Error Message: "Got an error reading communication packets"
June 07, 2017 03:38AM


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.