ReceiveHeader : Net packets out of order : received[0], expexted[1]

Antaeus · Post by **Antaeus** » Tue 17 Apr 2007 09:19

We performed multiple tests to track down the problem that you have encountered but with no success. Other users did not report us about this problem. So, we cannot solve it without your participation. Please provide any information that can get us closer to the problem.

Antaeus · Post by **Antaeus** » Thu 19 Apr 2007 08:56

Please specify some things:
- Do you use pooling in your application?
- Do you have in your application external modules (dll, bpl, etc.) that share connections?
- Do you use MyDAC in multiple threads?
- Describe in general the architecture of your application.

iad · Post by **iad** » Fri 20 Apr 2007 10:55

Antaeus wrote:Please specify some things:
- Do you use pooling in your application?
- Do you have in your application external modules (dll, bpl, etc.) that share connections?
- Do you use MyDAC in multiple threads?
- Describe in general the architecture of your application.

Here Answers:
Do you use pooling in your application? - No.
- Do you have in your application external modules (dll, bpl, etc.) that share connections? - No
- Do you use MyDAC in multiple threads? - Yes.
- Describe in general the architecture of your application.[/quote]
- 4-5 threads that connecting to the same DB in different MyDACconnections.
MySQL 5.027 Codegear 2007 ( also in BDS 2006)

Antaeus · Post by **Antaeus** » Mon 23 Apr 2007 15:56

We performed some more tests but the problem was not reproduced.
Unfortunately we cannot fix this problem if we do not have an example that reproduces it.

sander · Post by **sander** » Wed 23 Jan 2008 11:44

Antaeus wrote:We performed some more tests but the problem was not reproduced.
Unfortunately we cannot fix this problem if we do not have an example that reproduces it.

How to reproduce:
Create a MySQL table containing a blob.

In Delphi write code to insert data into the table using MyConnection & MyQuery. Make sure the data to insert into the blob is > 2000 bytes.
(MySQL stores all blob data over 2000 bytes in a hidden table)

It will fail if you use "Prepare" as in MyQuery.prepare.
I got the "out of order" error testing MyDac 4..5+

If you like I can supply you with example code.

iskywalker · Post by **iskywalker** » Fri 22 Feb 2008 10:46

I have the same error, but in a different comp:
ReceiveCompHeader: Net packets out of order: received[2], expected[1]
The problem occur only with a slow server... which we use as tests enviroment. it is quite annoying since it is a mydac cmd, so it should just expect true or false.
with a try and exception, the problem can be handled, but not sure, if it works on all cases

iskywalker · Post by **iskywalker** » Tue 22 Apr 2008 15:30

I solved my problem, seem that some function was trying to backup, i set in mysqladmin the option to allow extern lock to false, now it works ok.

Dimon · Post by **Dimon** » Wed 23 Apr 2008 13:59

It is good to see that this problem has been solved.

upscene · Post by **upscene** » Tue 03 Mar 2009 07:35

I just got this error as well:
ReceiveHeader: Net packets out of order: received[1], expected[2]

After that, I get:
Lost connection to MySQL server during query
Socket error on write. WSAGetLastError return 10054($2746)

I'm trying a Prepared INSERT with 2 blob columns.

Using MyDAC 5.50 for Delphi 7.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com

Billiardo · Post by **Billiardo** » Wed 29 Jul 2009 18:32

Hi dudes, I recently got this same problem, I'm testing MyDAC 5.70 with Delphi 2009 and MySQL 5.1.30 under Windows Vista Ultimate SP2 (x32).

This problem occurs when using threads with a same connection, I resolved creating one connection per one thread. In my case, I use threads 'cause I'm trying to cut short times when retrieving pictures (6) from my remote database, every pic weighs almost 700KB (I know, it's much).

But my question is: This problem about "ReceiveHeader : Net packets out of order : received[x], expected[y]", is it a bug from either MyDAC or MySQL?
Can you explain in a understandable way the background of this error?

Moreover, if you say that one connection cannot receive several queries at the same time, how does master/detail work then?

Thanks in advance

Pdta: excuse my english

Dimon · Post by **Dimon** » Thu 30 Jul 2009 13:35

You are right, one connection cannot execute several queries at the same time. Therefore you should use one connection per thread.
To create master/detail relationship you can execute both queries in one thread or use different connections for master and detail resultset.

dougedmunds · Post by **dougedmunds** » Sun 24 Jan 2010 00:19

Using Studio Express, Express edition 3.60.379.
mysql version: 5.5.1-m2-community
Dell Inspiron 6000, XP Home SP3, 1.5 gb memory

Tried running the tutorial on mysql website at
http://dev.mysql.com/doc/refman/5.5/en/ ... ables.html

Created table 'pet'

Saved a text file with 1 entry:
Whistler (tab) Gwen (tab) bird (tab) \N (tab) 1997-12-09 (tab) \N (return)

Ran this code in Studio Express

LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet LINES TERMINATED BY '\r\n';
(using my path).

It fails:
Net packets out of order: received [4], expected [5]

Ran the same line in a mysql terminal window and it loaded
the file, no packet issues.

Shalex · Post by **Shalex** » Mon 25 Jan 2010 14:24

The problem is fixed in the latest 4.00 version of dbForge Studio for MySQL. The latest 4.00.200 build is available for download now.

vga · Post by **vga** » Sat 06 Nov 2010 06:27

I got the same error message....

vga · Post by **vga** » Mon 08 Nov 2010 01:26

http://forum.delphi-treff.de/showthread ... er...-quot

Devart Forums

ReceiveHeader : Net packets out of order : received[0], expexted[1]

Net packets out of order

Still an issue - Express Edition on XP