Bug #4948 MySQL server has gone away for query with size near max_allowed_packet

• Submitted: 9 Aug 2004 11:35
• Modified: 26 Aug 2004 19:44
• Reporter: [ name withheld ]
• Status: Not a Bug
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 3.23.47
• OS: FreeBSD (Free BSD 4.5)
• Assigned to: Timothy Smith
• CPU Architecture: Any

[9 Aug 2004 11:35] [ name withheld ]

Description:
Variable max_allowed_packet is 1048576

I send query (query size is 1048574) and have server respons error 2006.

If i send query with size 1048573  - it's OK

Query looks like:
INSERT INTO table (field1,field2,field3) VALUES (...), (...), (...), ...

This error i have with mysql client and PHP script

How to repeat:
always

[16 Aug 2004 14:12] [ name withheld ]

И в ответ тишина...

[20 Aug 2004 23:36] Timothy Smith

Hi, this isn't a server bug, but I'm wondering what part of the documentation indicates that the maximum query length is exactly max_allowed_packet.  We can change the documentation to be more correct.

[26 Aug 2004 11:37] [ name withheld ]

Please, tell me how can i build query with extended inserts if i don't know max query string length? How can i get it?

[26 Aug 2004 19:44] MySQL Verification Team

Thank you for writting this report.

This forum is not for free support.

This bug report forum is mainly for repeatable bug reports. For bug
reports like this one you should use the MySQL mailing list or buy
commercial support from MySQL AB.