Bug #49321 Got an error reading communication packets

Submitted: 2 Dec 2009 1:34 Modified: 13 Dec 2009 8:19
Reporter: Michael Heuberger Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.1 (Comminity Server) OS:Windows (7)
Assigned to: CPU Architecture:Any
Tags: Communicatipn Packets, network, php

[2 Dec 2009 1:34] Michael Heuberger
Description:
Good day

After searching the web and your forum for many hours I haven't found a solution to the following problem:

By random I am getting Internal Server Errors. Sometimes now. When checking the log files on MySQL Server I am seeing lines like this:

"091202 14:18:14 [Warning] Aborted connection 29 to db: 'bk_website' user: 'robot' host: 'localhost' (Got an error reading communication packets)"

I am developping my own website on localhost on Zend Server. The PHP code connects to the MySQL Server which is also on localhost.

I found out that the faster I click on the test website, meaning the more DB connections are made, the higher the chance is that the connection will be aborted.

I tried to tweak some ini settings but none of these seems to work.

How to repeat:
I am happy to send you the source code and my ini files so that you can reproduce.

Suggested fix:
I have no fix. I hope you can point me where the problem lies.
[2 Dec 2009 1:35] Michael Heuberger
Changed version and OS.
[2 Dec 2009 1:35] Michael Heuberger
The current ini file with all the settings ...

Attachment: my.ini (application/octet-stream, text), 8.86 KiB.

[2 Dec 2009 2:08] MySQL Verification Team
I was experiencing the same issue on Windows Vista 64-bit and the cause (at least how I fixed the issue) was a problem with network connection settings with a missed default gateway.
[2 Dec 2009 2:10] Michael Heuberger
Thank you Miguel.

Can you tell me how exactly you fixed that issue under Windows?
[2 Dec 2009 11:02] MySQL Verification Team
I edited the connection properties (IPV4) the field default gateway 192.168.0.XX which is the IP of the router in my local lan. Anyway it was network issue.
[2 Dec 2009 11:09] Michael Heuberger
Mmmhhh... this makes no sense because I am running everything on localhost. Your trick won't work for me.

By the way, I found out that the PHP-CGI.exe was also crashing when that error happened. So I assume it's rater a PHP problem than a MySQL one. Because that Zend's PHP-CGI.exe hasn't been tested for Windows 7 yet...
[2 Dec 2009 11:36] MySQL Verification Team
Yes I wasn't sure about the cause I just commented you about my case when I fixed the connection properties the issue stopped.
[13 Dec 2009 8:19] Sveta Smirnova
Thank you for the update.

Closing as "Not a Bug" as cause is not MySQL.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.