Problem with MySQL

stojo303 · Post by **stojo303** » Fri 14 Oct 2011 17:42

Hello,

I have a user using a MySQL database which throws the following error:

ReceiveHeader:_Net packets out of order:_received[7], expected[1].

What does this mean and how can I prevent it?

Thanks in advance for any help.

Dimon · Post by **Dimon** » Mon 17 Oct 2011 16:36

Please give a more detailed description of the problem.
Also supply me the following information:
- the exact version of UniDAC. You can see it in the About sheet of TUniConnection Editor;
- the exact version of your IDE;
- the exact version of MySQL server.

stojo303 · Post by **stojo303** » Tue 18 Oct 2011 11:34

Hello,

I use Delphi 2010, MySQL 5.1.53 and UniDac 4.0.1 (registered).

Thanks in advance for your help.

Dimon · Post by **Dimon** » Thu 20 Oct 2011 14:50

I can not reproduce the problem.
Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create database objects.

stojo303 · Post by **stojo303** » Fri 21 Oct 2011 14:14

Dear Dimon,

I can unfortunately not do this, since the exception occurs in a quite complex operation.
Can you just let me know what it means and any hints to avoid it?

Thanks in advance

AndreyZ · Post by **AndreyZ** » Mon 24 Oct 2011 12:06

This error can occur because of many reasons. If you are developing a multithreaded appication, please check that you have connection (the TMyConnection component) in each thread. Also this error can occur if you prepare stored procedure. MySQL protocol has a bug. As a result you cannot prepare stored procedures that return resultsets. If the problem persists after checking these reasons, please try creating a small sample to demonstrate the problem and send it to andreyz*devart*com. We cannot solve this problem without a sample that demonstrates it. We are looking forward to hearing from you.