MySQL : Net packets out of order
A couple of weeks ago I come across an error which was very frustrating. I got this error when I try to connect a database with Toad or via Sphinx. I googled around alot to find an answer but the only answer I found out was in mysql forums which only declared that this is a "network problem". I even reinstalled mysql to find a fix for it. It didnt work.
So I rechecked every possible step that would cause a problem, and found out the problem started when I use mysql-dump output to load my data. I got the mysql-dump again and retired from my production server. It didnt work aswell. Then I tried yesterdays backups from production which worked fine. So what happened between yesterday and today that I get a net packets out of order error ?
I created a "view" !
Views, stored procedures, triggers are created with mysql users id and even though it can be recreated via backup its problematic if the user unique id doesnt match between servers.
So if you get a "net packets out of order" error, and if you got the error after a restore drop and recreate your views, stored procedures, triggers not to get an error in some programs (while others working perfectly well).
I saw the same error comes up in .NET aswell (while I am searching in google ), but I didnt really check if its caused by this error.