Bug #4729 Max Allowed Packet Size

• Submitted: 23 Jul 2004 19:48
• Modified: 23 Aug 2004 22:07
• Reporter: Joshua Wilson
• Status: No Feedback
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 4.1.3
• OS: Linux (RedHat Linux 3.0 update 2)
• Assigned to: Assigned Account
• CPU Architecture: Any

[23 Jul 2004 19:48] Joshua Wilson

Description:
max_allowed_packet size is set to 200M,

But when I try and pull a row from the table that is 26M. 
I get 

Error: 2020  Message: Got packet bigger than 'max_allowed_packet' bytes

This is happening on two different development servers.

I get the row back inside the mysql CLI, but through php I get the above error.

How to repeat:
create a connection to php and exceute the following

Select * FROM Download where DownloadId=1;

[23 Jul 2004 19:51] Joshua Wilson

It will also not let anything great than 16M be inserted or extracted from the database.

[23 Jul 2004 20:30] Dean Ellis

Verify that your PHP is linked against a 4.0 or newer MySQL client library.  The 3.23 library (which PHP bundles) has a max_allowed_packet limit of 16MB.

[23 Jul 2004 22:07] Joshua Wilson

I have tried to use the 4.13-shared dynamic libraries rpm. Once I use that and remove the shared-compat with th 3.23 libraries then I can no longer connect to the database.

[24 Jul 2004 0:09] Dean Ellis

The shared library RPM does not necessarily control which MySQL client PHP is linked to; check the MySQL section in the output of phpinfo() to see what client it is using.

[14 Feb 2005 22:54] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".