Devart Forums

Posted: **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

Posted: **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.

Posted: **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.

Posted: **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

Posted: **Mon 19 Dec 2016 09:08**

Thanks for update. It fixed our problem.
Filip

Devart Forums

Loading data from more threads not working

Loading data from more threads not working

Re: Loading data from more threads not working

Re: Loading data from more threads not working

Re: Loading data from more threads not working

Re: Loading data from more threads not working