| Bug #15551 | Mysql server fails to insert data | ||
|---|---|---|---|
| Submitted: | 7 Dec 2005 13:46 | Modified: | 7 Mar 2010 19:30 |
| Reporter: | Samnan ur Rehman | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | mysql-5.0.16 | OS: | Windows (Windows 2003 + SP1) |
| Assigned to: | Aleksey Kishkin | CPU Architecture: | Any |
[7 Dec 2005 14:16]
Aleksey Kishkin
Samnan, Could you provide exact query you submitted and table definitions?
[8 Dec 2005 8:08]
Samnan ur Rehman
table definition and a sample query that fails
Attachment: desc.txt (text/plain), 13.38 KiB.
[12 Dec 2005 19:12]
Aleksey Kishkin
well it works without crash on linux. Going to test it on windows.
[14 Dec 2005 11:02]
Aleksey Kishkin
on windows 2003sp1 it also works without crash. If you have any ideas how to reproduce this bug please let us know. For now I am changing status to 'cant repeat' and we will return to this bug if we find repeatable testcase.
[7 Mar 2010 19:30]
Samnan ur Rehman
I found out that the issue was in the my.ini file. The max_allowed_packet configuration item was mistyped during editing as: max_allowed_packet = M This was causing the problem, I am not sure why. I did not get any warning in mysql error log at startup about this, and the latest mysql version still has the same issue. The value gets reset to 1024 without any warning in the log file.
Description: Used mysqld-nt --install to install server used php5 to do a simple insert query in a text field table contains 5-10 fields mostly integrers {both php5 am dmysql running on same server} when inserting anydata using php that is around 4-8 kb, the insertion fails and error returned is : mysql server has gone away the connection remain ok and other queries from same connection execute perfectly normal. How to repeat: try to insert any data over 4-5 kb in a text field from php always fails with error mysql server has gone away.