Bug #45019 | changing max_allowed_packet value doesn't always allow us to send large queries | ||
---|---|---|---|
Submitted: | 21 May 2009 22:41 | Modified: | 25 Jun 2009 7:05 |
Reporter: | Anna Poplawski | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: General | Severity: | S2 (Serious) |
Version: | 5.0 and 5.1-34 | OS: | Windows (Windows 2003 Server on HP machine) |
Assigned to: | CPU Architecture: | Any | |
Tags: | long query, max_allowed_packet, query size |
[21 May 2009 22:41]
Anna Poplawski
[22 May 2009 7:31]
Sveta Smirnova
Thank you for the report. There could be a lot of reasons for such behavior. Most likely wrong max_allowed_packet settings for particular connection or some network problem. It can be MySQL bug also if everything set up correctly. But we can not define what happened from this description. Please when you have access to such machine try to catch more information: set log-warnings=2 in my.cnf, then collect error log and configuration file; provide output of SHOW VARIABLES LIKE 'max_allowed_packet' in the same session you run problem INSERT.
[22 May 2009 17:12]
Anna Poplawski
We already collected the information you requested. I'm sorry I left it out of the original bug report. We queried "show variables like 'max_allowed_packet'" in the mysql client before running the INSERT query. It always displayed the value that we specified in the my.ini file. We've tried setting it to 96M, 32M, and 8M. None of those allowed us to send an INSERT statement longer than 2.05MB. The exact INSERT query that failed on the Windows 2003 Server machine was executed successfully on Windows XP machines with the same max_allowed_packet setting. When we ran the query with log-warnings=2, the only thing that appeared in the error log file was "Aborted connection 10 to db: Got an error reading communication packets". (The actual number varied when we ran the query multiple times.)
[25 May 2009 7:05]
Sveta Smirnova
Thank you for the feedback. Could you also please upload output of SHOW CREATE TABLE problem_table and problem INSERT statement?
[25 Jun 2009 23:00]
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".