MySQL Forums
Forum List  »  Newbie

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

Options: ReplyQuote


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.