Apache Friends Support Forum

060726 2:59:40 [Warning] Aborted connection 54272 to db: 'my_db' user: 'xxxxx' host: 'localhost' (Got an error reading communication packets)
060726 2:59:40 [Warning] Aborted connection 54250 to db: 'my_db' user: 'xxxxx' host: 'localhost' (Got an error reading communication packets)
060726 2:59:40 [Warning] Aborted connection 54268 to db: 'my_db' user: 'xxxxx' host: 'localhost' (Got an error reading communication packets)
060726 2:59:40 [Warning] Aborted connection 54274 to db: 'my_db' user: 'xxxxx' host: 'localhost' (Got an error reading communication packets)

I have a lot of theses errors in the mysql log ...

Can someone help me to resolve this problem ?

Regards

There is a possible answer here:
http://mysqld.active-venture.com/Commun ... rrors.html

and here with much the same answers but worth a look:
http://dev.mysql.com/doc/refman/5.0/en/ ... rrors.html

Turning off persistant connections is another possibility.

These are warnings only so turning off the warnings will also fix the log file entries but will not fix the underlying issue.

Do a Google and copy/paste these keywords aborted connection to db to start with as I found a few usefull results with off shoot links in some off them.

Not much help I am afraid but it may be a starting point for your investigations. I have not encountered this issue before on any of my servers either the Windows XP Pro PC with an XAMPP server or on my DC Linux servers.

Good luck and post back if you find a more suitable answer.

I have upgrade the number of max_allowed_packets to 32MB.

It seems that a too long query can cause this problem.