Net packets out of order / Connection closed during query

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
inTrance
Posts: 10
Joined: Tue 04 Apr 2006 17:07

Net packets out of order / Connection closed during query

Post by inTrance » Fri 27 Oct 2006 16:03

Hello!

Again we've some problems with your lib. Inserting of binary data results in

- "Net packets out of order: received[2], expected[3]" exceptions on an intranet server

or in

- "Lost connection to MySQL server during query" exceptions on a local server

It helps to close and open the connection with EVERY record (we use parameters) - That can not be the real solution for this problem... Also the non-direct mode (libmysql) is a solution. The max_allowed_packets is high enough, we use a 5.0 server and all other tools work with this binary files.

We are a little bit displeased with your software. It's slower than the original connector and there are to many bugs, when you are a heavy user of the lib. I hope you can quickly find a solution for this...

Regards,

Sven Kolber

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 30 Oct 2006 08:26

"Net packets out of order: received[2], expected[3]" exceptions on an intranet server
1. Do you use Prepare method or non-direct mode (Direct=false)?
2. Make sure you close all data readers explicitly.
3. If you use Prepare() method of MySqlCommand class, call Dispose() after closing reader.
4. If you use connection pooling, call MySqlConnection.Ping() method before MySqlConnection.Open().
5. If above doesn't help and you use connection pooling, check if you can turn connection pooling off.

Please inform us whether our instructions helped you and which one solved the problem.
We are a little bit displeased with your software. It's slower than the original connector
According to our performance tests results, MySQLDirect .NET is no worse than Connector/NET provider by MySQL AB.
If you have an example of dramatic difference in speed, please send it to the address provided in the Readme file.
there are too many bugs
Describe in detail all the bugs you are complaining about.
Last edited by Alexey on Fri 03 Nov 2006 16:11, edited 2 times in total.

Post Reply