|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #50300 PHP Warning: Error while sending QUERY packet
Submitted: 2009-11-25 21:17 UTC Modified: 2009-12-11 22:36 UTC
From: tejas dot net+php at gmail dot com Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 5.3.1 OS: CentOS v5
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: tejas dot net+php at gmail dot com
New email:
PHP Version: OS:


 [2009-11-25 21:17 UTC] tejas dot net+php at gmail dot com
When using the mysql_* functions (mysqlnd), I sometimes get a warning 

PHP Warning:  Error while sending QUERY packet. PID=16717 in [FILE] on 
line [LINE]

The query seems to work just fine however.

Probably related to this bug here:
but I'm not using Mysqli or persistent connections.

FILE:LINE contains: return mysql_query( $sql, $this->_connection );

Is this a bug?


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2009-11-26 10:08 UTC]
Any chance you can log a possible query that might generate this warning? Along with the MySQL server version.

When replying, then change the status back to Open
 [2009-12-11 14:41 UTC] tejas dot net+php at gmail dot com
I guess this is a legitimate warning thrown by PHP.

After some debugging, I found that this happens if the connection is lost (my DB layer class normally does a mysql_ping to restore it, which is why I dont see any side-effects)
 [2009-12-11 22:36 UTC]
 [2012-02-25 17:25 UTC] noostroi at gmail dot com
I got this error when trying to store a file as a BLOB that was 
larger than the SQL query limit within MySQL.

It was set to 1Mb (the default, afaik), and I was uploading a 
2Mb file. 
Uploading a smaller sized file was working for me, which prompted 
me to investigate size limits.

Upping the limit to a suitable value (e.g. 10Mb) fixed the issue.

Exact setting that I changed was max_allowed_packet in /etc/my.cnf 
in the [mysqld] section. (MySQL version: 5.5.21, php version: 5.2.3
 (whatever came as default in Mac Snow Leopard) )

(Adding this info here, now, as I was linked to this page from 
the first page on a google search for the error text.)
 [2012-11-15 20:39 UTC] sokolukasz2 at gmail dot com
I have this warning when im starting new transaction after when i loast connection and reconnect to server again on error 2006(gone)
PHP Copyright © 2001-2023 The PHP Group
All rights reserved.
Last updated: Tue Mar 28 19:03:41 2023 UTC