Error Code: 2027 Malformed packet
Posted by:
nick way
Date: June 17, 2014 10:46AM
Something's gone wrong with my database - I've a feeling it may have been caused when I changed the charset from latin1_sweedish_ci to utf8_general_ci
If I run this query
select *
from tbl_alerts
where todotoday = 1
order by userid
I get this error Error Code: 2027 Malformed packet
If however I either add 'limit 500;' it's fine
Or if I remove the order by clause it's fine
I'm running MySql 5.6
I get this issue if I use Mysql workbench or if I use Heidi (and my application's not able to run the query either)
I've tried the Maintenance facility in Heidi and it says it's "OK" - but clearly something's up - it's not a massive table and we didn't have this issue last week!
Thanks in advance for any help you can offer.
Nick
Subject
Written By
Posted
Error Code: 2027 Malformed packet
June 17, 2014 10:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.