I have a
mysql database (
Version 5.6.23-log running on windows) that is set up for use with Teamcity. When running a command against it using HeidiSQL I am getting an error:
SQL Error (2027): Malformed packet
This error only occurs if the result set is more than a certain number of rows (using LIMIT 14561 rows works, 14562 gives this error).
I believe this error is not due to Heidi since TeamCity is failing to start when running the same command.
I assume it is something to do with the data size becoming too large and something failing but I can't find any way to identify more specifically what the problem is and thus how to fix it.
If anybody can tell me what I can do to prevent this problem or at the very least how I might be able to better diagnose this problem I'd be most grateful.