Not the answer you need?
Register and ask your own question!

Intermittent "Got an error reading communication packets"

redleafredleaf EntrantInactive User Role Beginner
I am getting these sporadically. A dozen a day or so. I've googled for advice and don't see anything helpful.

140204 17:14:11 [Warning] Aborted connection 10533 to db: 'aaa' user: 'aaa' host: 'localhost' (Got an error reading communication packets)

The client reports:
"Mysql::Error: Lost connection to MySQL server during query: SELECT * FROM `events` WHERE (( (events.user_id = 73 OR events.other_user_id = 73) ) AND ( events.type in ('Note','IncludedInBlast','OutgoingEmail','ContactEdited','ReferralNote') )) ORDER BY events.created_at DESC LIMIT 5"

Everything runs on one computer, no external networking. Client connects with Unix socket.

Host OS: Ubuntu 12.04
Version: '5.5.35-33.0-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Percona Server (GPL), Release 33.0

The timeouts are beyond any reasonable period:
+
+
+
| Variable_name | Value |
+
+
+
| interactive_timeout | 100000 |
| wait_timeout | 100000 |
+
+
+

The packet size is well beyond any single field value:
+
+
+
| Variable_name | Value |
+
+
+
| max_allowed_packet | 25165824 |
+
+
+


The question: where else can I look for the reason?

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.