Loading data from more threads not working

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
filip.cevela
Posts: 2
Joined: Fri 25 Nov 2016 09:17

Loading data from more threads not working

Post by filip.cevela » Fri 25 Nov 2016 09:49

Hello,
we are using your MySQL DevArt component for connecting and loading data from MySQL and after upgrading to latest version we have a problem with loading big data in more threads. I prepared sample project for demonstration.
OneDrive link
Main problem is in Cancel command. With this command we got this error: "Query execution was interrupted"

Code: Select all

StackTrace :    at Devart.Data.MySql.bh.a()
	   at Devart.Data.MySql.bh.i()
	   at Devart.Data.MySql.ah.a(ad[]& A_0, Int32& A_1, Boolean A_2)
	   at Devart.Data.MySql.ah.a(Byte[] A_0, Int32 A_1, Boolean A_2, String A_3)
	   at Devart.Data.MySql.h.e()
	   at Devart.Data.MySql.h.m()
	   at Devart.Data.MySql.MySqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
	   at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
	   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
	   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
	   at System.Data.Common.DbCommand.ExecuteReader()
In previous version it worked without problem. I will appreciate and help. Thanks

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Loading data from more threads not working

Post by Pinturiccio » Mon 28 Nov 2016 11:03

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Loading data from more threads not working

Post by Pinturiccio » Wed 07 Dec 2016 09:35

We have fixed the bug with the "Query execution was interrupted" exception after invoking the Cancel method of MySqlCommand. We will post here when the corresponding build of dotConnect for MySQL is available for download.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Loading data from more threads not working

Post by Pinturiccio » Mon 12 Dec 2016 10:49

New version of dotConnect for MySQL 8.7 is released.
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to viewtopic.php?t=34691

filip.cevela
Posts: 2
Joined: Fri 25 Nov 2016 09:17

Re: Loading data from more threads not working

Post by filip.cevela » Mon 19 Dec 2016 09:08

Thanks for update. It fixed our problem.
Filip

Post Reply