# Intermittent "Got an error reading communication packets"

**URL:** <https://forums.percona.com/t/intermittent-got-an-error-reading-communication-packets/3250>\
**Category:** Other MySQL® Questions\
**Created:** [February 4, 2014, 5:18pm UTC](https://forums.percona.com/t/intermittent-got-an-error-reading-communication-packets/3250 "2014-02-04T17:18:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![redleaf](https://avatars.discourse-cdn.com/v4/letter/r/5fc32e/32.png) [@redleaf](https://forums.percona.com/u/redleaf)\
**Post date:** [February 4, 2014, 5:18pm UTC](https://forums.percona.com/t/intermittent-got-an-error-reading-communication-packets/3250/1 "2014-02-04T17:18:52Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [February 6, 2014, 2:22am UTC](https://forums.percona.com/t/intermittent-got-an-error-reading-communication-packets/3250/2 "2014-02-06T02:22:39Z")

</div>

Hi,

Can you provide more details like? full error.log file, explain output of that query, show create table events\G, show table status like ‘events’\G and his my.cnf settings?  
It would be also helpful if you can provide the output of pt-summary. It is very easy to download and use.  
[url][http://www.percona.com/doc/percona-toolkit/2.2/pt-summary.html[/url]](http://www.percona.com/doc/percona-toolkit/2.2/pt-summary.html%5B/url%5D)