Red Gate forums :: View topic - SQL Compare program does not exit completely.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

SQL Compare program does not exit completely.

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
skuhn



Joined: 30 Dec 2011
Posts: 19

PostPosted: Tue Mar 27, 2012 2:19 pm    Post subject: SQL Compare program does not exit completely. Reply with quote

Hi,
I just happened to look at the Task Manager today and found that I had five instances of RedGate.SQLCompare.UI.exe running, though I had no visual instances running. I likely ran SQL Compare five times yesterday and though I closed it each time, it appears that some thread is still alive despite having closed the application.

I'm running Windows 7 64-Bit, SQL Compare 10.1.0.102 Professional Edition, SQL Server 2005/2008, Source Gear Vault 5.1.

Considering I've had other issues with SQL Compare complaining about being unable to delete files, I wonder if this is related. (I'm thinking that the instances that will not close out are holding onto files.)

Thanks,
Scott Kuhn
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Fri Mar 30, 2012 10:38 am    Post subject: Reply with quote

Hi Scott,

I suspect there is a potential problem caused if you have an error in SQL Compare. If you get an error dialog, SQL Compare should terminate the main UI thread and that should also kill all of the background threads. However, if the threads were not properly configured as "background" by us, they may be left behind.

If you still have this problem, please let me know and I will send instructions to attach a debugger and we'll see what these threads are actually doing and hopefully I can trace that back to some code and have a look.
Back to top
View user's profile Send private message
skuhn



Joined: 30 Dec 2011
Posts: 19

PostPosted: Fri Mar 30, 2012 1:08 pm    Post subject: SQL Compare program does not exit completely. Reply with quote

Hi Brian,
I've used the Red Flag debugger before. I generated a trace/debug file this morning if you want to send me instructions on how to send it then I will.

Basically all I did was open a project and run the compare. I did not have any differences so I just stopped there and closed SQL Compare. However, it was still running in the background. I detached the debugger at that point and saved the file.

Thanks,
Scott
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Fri Mar 30, 2012 2:02 pm    Post subject: Reply with quote

Hi Scott,

I think in this case you want to attach to the zombie SQL Compare and then use Actions->Dump Stacks and CTRL-C and paste into an email.

I should be able to decode the "nonsense" stack trace and find the offending thread.
Back to top
View user's profile Send private message
skuhn



Joined: 30 Dec 2011
Posts: 19

PostPosted: Fri Mar 30, 2012 2:19 pm    Post subject: Stack Window Reply with quote

Possibly related to Vault...


Attached to pid:9088

Thread 3820 [Status=Wait UserTime=15 Wait Reason=UserRequest]
Callstack for Thread 3820

Thread 4308 [Status=Wait UserTime=0 Wait Reason=UserRequest]
Callstack for Thread 4308
System.Threading.WaitHandle.WaitOne (source line information unavailable)
System.Threading.WaitHandle.WaitOne (source line information unavailable)
System.Threading.WaitHandle.WaitOne (source line information unavailable)
System.Management.MTAHelper.WorkerThread (source line information unavailable)
System.Threading.ThreadHelper.ThreadStart_Context (source line information unavailable)
System.Threading.ExecutionContext.Run (source line information unavailable)
System.Threading.ThreadHelper.ThreadStart (source line information unavailable)

Thread 8080 [Status=Wait UserTime=31 Wait Reason=EventPairLow]
Callstack for Thread 8080

Thread 9256 [Status=Wait UserTime=0 Wait Reason=UserRequest]
Callstack for Thread 9256

Thread 9408 [Status=Wait UserTime=0 Wait Reason=ExecutionDelay]
Callstack for Thread 9408

Thread 1004 [Status=Wait UserTime=0 Wait Reason=ExecutionDelay]
Callstack for Thread 1004
System.Drawing.ImageAnimator.AnimateImages50ms (source line information unavailable)
System.Threading.ThreadHelper.ThreadStart_Context (source line information unavailable)
System.Threading.ExecutionContext.Run (source line information unavailable)
System.Threading.ThreadHelper.ThreadStart (source line information unavailable)

Thread 7708 [Status=Wait UserTime=15 Wait Reason=ExecutionDelay]
Callstack for Thread 7708
VaultClientOperationsLib.WatcherThread.Start (source line information unavailable)
System.Threading.ThreadHelper.ThreadStart_Context (source line information unavailable)
System.Threading.ExecutionContext.Run (source line information unavailable)
System.Threading.ThreadHelper.ThreadStart (source line information unavailable)

Thread 5280 [Status=Wait UserTime=0 Wait Reason=ExecutionDelay]
Callstack for Thread 5280
VaultClientOperationsLib.WatcherThread.Start (source line information unavailable)
System.Threading.ThreadHelper.ThreadStart_Context (source line information unavailable)
System.Threading.ExecutionContext.Run (source line information unavailable)
System.Threading.ThreadHelper.ThreadStart (source line information unavailable)

Thread 5344 [Status=Wait UserTime=639 Wait Reason=UserRequest]
Callstack for Thread 5344

Thread 7672 [Status=Wait UserTime=0 Wait Reason=ExecutionDelay]
Callstack for Thread 7672
VaultClientOperationsLib.WatcherThread.Start (source line information unavailable)
System.Threading.ThreadHelper.ThreadStart_Context (source line information unavailable)
System.Threading.ExecutionContext.Run (source line information unavailable)
System.Threading.ThreadHelper.ThreadStart (source line information unavailable)

Thread 9248 [Status=Wait UserTime=0 Wait Reason=ExecutionDelay]
Callstack for Thread 9248
VaultClientOperationsLib.WatcherThread.Start (source line information unavailable)
System.Threading.ThreadHelper.ThreadStart_Context (source line information unavailable)
System.Threading.ExecutionContext.Run (source line information unavailable)
System.Threading.ThreadHelper.ThreadStart (source line information unavailable)
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Mon Apr 16, 2012 4:22 pm    Post subject: Reply with quote

Sorry, we are not able to work out why this is happening to you. Closing the program window should terminate all threads, even if they are executing. I'm vaguely aware that if there is an exception on one of the threads, it may be left hanging - however that should only leave one thread as far as I know.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
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