Loading data from more threads not working

Loading data from more threads not working

Postby 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
filip.cevela
 
Posts: 2
Joined: Fri 25 Nov 2016 09:17

Re: Loading data from more threads not working

Postby 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: 1955
Joined: Wed 02 Nov 2011 09:44

Re: Loading data from more threads not working

Postby 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: 1955
Joined: Wed 02 Nov 2011 09:44

Re: Loading data from more threads not working

Postby 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 http://forums.devart.com/viewtopic.php?t=34691
Pinturiccio
Devart Team
 
Posts: 1955
Joined: Wed 02 Nov 2011 09:44

Re: Loading data from more threads not working

Postby filip.cevela » Mon 19 Dec 2016 09:08

Thanks for update. It fixed our problem.
Filip
filip.cevela
 
Posts: 2
Joined: Fri 25 Nov 2016 09:17


Return to dotConnect for MySQL