Bug #71176 MySQL 5.7.3 reports "(Got an error reading communication packets)"

• Submitted: 18 Dec 2013 15:45
• Modified: 25 Dec 2013 20:26
• Reporter: Oscar González
• Status: Not a Bug
• Category: MySQL Server: Windows
• Severity: S3 (Non-critical)
• Version: 5.7.3
• OS: Windows (Windows 7 Entreprise 64-bir)
• CPU Architecture: Any
• Tags: Connection, error, innodb, packet, user

[18 Dec 2013 15:45] Oscar González

Description:
MySQL 5.7.3 reports multiple "(Got an error reading communication packets)" messages

(Extract from error-log)
2013-12-17T15:36:41.809227Z 4 [Note] Aborted connection 4 to db: 'comcel' user: 'repgcrd' host: '10.215.178.146' (Got an error reading communication packets)
2013-12-17T15:36:41.809227Z 9 [Note] Aborted connection 9 to db: 'comcel' user: 'webgcrd' host: '10.215.178.146' (Got an error reading communication packets)
2013-12-17T15:38:22.008027Z 11 [Warning] IP address '128.14.171.13' could not be resolved: Host desconocido. 
2013-12-17T15:38:22.008027Z 11 [Note] Access denied for user 'webgcrd'@'128.14.171.13' (using password: NO)
2013-12-17T15:48:14.605227Z 12 [Note] Aborted connection 12 to db: 'comcel' user: 'webgcrd' host: '128.14.171.13' (Got an error reading communication packets)
2013-12-17T15:48:20.923227Z 14 [Note] Access denied for user 'webgcrd'@'128.14.171.13' (using password: NO)
2013-12-17T16:19:29.542641Z 147 [Note] Access denied for user 'repgcrd'@'abog01108151bp.comcel.com.co' (using password: NO)
2013-12-17T17:48:31.925767Z 15 [Note] Aborted connection 15 to db: 'comcel' user: 'webgcrd' host: '128.14.171.13' (Got an error reading communication packets)
2013-12-17T18:16:20.800019Z 16 [Note] Aborted connection 16 to db: 'comcel' user: 'webgcrd' host: '128.14.171.13' (Got an error reading communication packets)
2013-12-17T20:35:15.785168Z 441 [Note] Access denied for user 'repgcrd'@'abog02132205e.comcel.com.co' (using password: NO)
2013-12-17T20:36:54.196885Z 442 [Note] Aborted connection 442 to db: 'comcel' user: 'repgcrd' host: 'abog02132205e.comcel.com.co' (Got an error reading communication packets)
2013-12-18T00:27:57.144093Z 492 [Note] Aborted connection 492 to db: 'comcel' user: 'repgcrd' host: 'oboglvhtq1p.comcel.com.co' (Got an error reading communication packets)
2013-12-18T00:28:02.404619Z 493 [Note] Aborted connection 493 to db: 'comcel' user: 'repgcrd' host: 'oboglvhtq1p.comcel.com.co' (Got an error reading communication packets)
2013-12-18T00:59:15.432903Z 148 [Note] Aborted connection 148 to db: 'comcel' user: 'repgcrd' host: 'abog01108151bp.comcel.com.co' (Got an error reading communication packets)
2013-12-18T00:59:15.435904Z 149 [Note] Aborted connection 149 to db: 'comcel' user: 'repgcrd' host: 'abog01108151bp.comcel.com.co' (Got an error reading communication packets)
2013-12-18T01:17:24.332834Z 1 [Note] Aborted connection 1 to db: 'comcel' user: 'webgcrd' host: 'CBUC33128764P' (Got an error reading communication packets)
2013-12-18T01:17:24.468834Z 2 [Note] Aborted connection 2 to db: 'comcel' user: 'webgcrd' host: 'CBUC33128764P' (Got an error reading communication packets)
(Extract from error-log)

How to repeat:
I think the message appears every time an user disconnects from DB

[18 Dec 2013 16:49] MySQL Verification Team

Please check http://dev.mysql.com/doc/refman/5.1/en/communication-errors.html . Thanks.

[18 Dec 2013 16:50] MySQL Verification Team

Sorry use this link:

http://dev.mysql.com/doc/refman/5.7/en/communication-errors.html

[18 Dec 2013 19:24] Oscar González

I have read the indicated reference manual section, and double-checked my connection/disconnection procedures, and found no problems.

The weird thing here is these errors didn't happened on 5.6.10. They started after upgrading to 5.7.3, having the same my.ini configuration file in both versions.

Any ideas?

[18 Dec 2013 20:22] MySQL Verification Team

Please provide your my.ini file. Thanks.

[18 Dec 2013 21:21] Oscar González

my.ini file

Attachment: mysql57.ini (application/octet-stream, text), 15.15 KiB.

[25 Dec 2013 20:24] MySQL Verification Team

try reducing the value of this variable.
http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_log_error_verbo...

[25 Dec 2013 20:26] MySQL Verification Team

working as designed, there is not bug here as far as I could see.