SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[7.0.136 beta] Database Load Generator unresponsive

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[7.0.136 beta] Database Load Generator unresponsive
Author Message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post [7.0.136 beta] Database Load Generator unresponsive Reply with quote
When I try to use Database Load Generator with a simple stored proc it remains in a unresponsive state and crashes SSMS just before finshing
Wed Jul 09, 2014 4:58 am View user's profile Send private message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Reply with quote
Also wuth a simple select from a table with no rows I get
Code:

09.07.2014 12:14:32   Database load started.
09.07.2014 12:14:32   4 Threads started.
09.07.2014 12:14:37   Worker processes results: successful - 26149; failed - 0
09.07.2014 12:14:42   Worker processes results: successful - 49028; failed - 0
09.07.2014 12:14:47   Worker processes results: successful - 75369; failed - 0
09.07.2014 12:14:52   Worker processes results: successful - 101519; failed - 0
09.07.2014 12:14:57   Worker processes results: successful - 127970; failed - 0
09.07.2014 12:15:02   Worker processes results: successful - 149320; failed - 0
09.07.2014 12:15:07   Worker processes results: successful - 171771; failed - 0
09.07.2014 12:15:12   Worker processes results: successful - 198043; failed - 0
09.07.2014 12:15:17   Worker processes results: successful - 223476; failed - 0
09.07.2014 12:15:22   Worker processes results: successful - 249842; failed - 0
09.07.2014 12:15:27   Worker processes results: successful - 273597; failed - 0
09.07.2014 12:15:32   New Worker Process failed. 299188  successful executions. 1  failed execution.
09.07.2014 12:15:32       Average duration: 0,80
09.07.2014 12:15:32       1 fail: Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed.
09.07.2014 12:15:32   Database load completed.
09.07.2014 12:15:32     Successful worker process executions: 0.
09.07.2014 12:15:32     Failed worker process executions: 1.
09.07.2014 12:15:32   Database load ended.

and with a select from a table with 400000 rows I get
Code:

09.07.2014 12:47:09   Database load started.
09.07.2014 12:47:10   4 Threads started.
09.07.2014 12:47:14   Worker processes results: successful - 0; failed - 0
09.07.2014 12:47:19   Worker processes results: successful - 0; failed - 0
09.07.2014 12:47:24   Worker processes results: successful - 0; failed - 0
09.07.2014 12:47:30   Worker processes results: successful - 0; failed - 0
09.07.2014 12:47:35   Worker processes results: successful - 0; failed - 0
09.07.2014 12:50:40   New Worker Process failed. 4  failed executions.
09.07.2014 12:50:40       Average duration: 210039,43
09.07.2014 12:50:40       2 fails: Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed.
09.07.2014 12:50:40       2 fails: Object reference not set to an instance of an object. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed. Invalid attempt to call NextResult when reader is closed.
09.07.2014 12:50:40   Database load completed.
09.07.2014 12:50:40     Successful worker process executions: 0.
09.07.2014 12:50:40     Failed worker process executions: 1.
09.07.2014 12:50:40   Database load ended.

Wed Jul 09, 2014 6:02 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
thank you.


Quote:
with a select from a table with 400000 rows I get

I don't see a single query completed. Looks like all queries failed because they took longer to run than what you allowed for a worker process in its properties and so they got eventually aborted. . Could you please verify your SELECT statement and test parameters?

Code:
Invalid attempt to call NextResult when reader is closed

I have submitted a bug report for this issue.

As for the stored procedure crashing SSMS, could you please provide more details? Please reproduce this issue and then locate %APPDATA%\SQL Assistant\7.0\SQLAssist.log file and open it in the Notepad. there should be an exception stack trace recorded in that file. Please post the exception data.
Wed Jul 09, 2014 8:30 am View user's profile Send private message
ssandu



Joined: 26 Feb 2007
Posts: 95
Country: Romania

Post Reply with quote
Sorry but no errors.
With a new installation of latest version there is not an SQLAssist.log file
The only error appears in event viewer as Application Hang for ssms.exe with no useful details.
Maybe you can reproduce.
Thu Jul 10, 2014 4:12 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
I hope the team would be able to reproduce that issue.
Thu Jul 10, 2014 8:44 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.