Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Looks like it is indeed just one thread per CLR instance within the process - at the moment, anyway. Here's some code to show that:</p> <p>Test.cs:</p> <pre><code>using System; class Test { static void Main() { AppDomain.CreateDomain("First") .ExecuteAssembly("ShowFinalizerThread.exe"); AppDomain.CreateDomain("Second") .ExecuteAssembly("ShowFinalizerThread.exe"); } } </code></pre> <p>ShowFinalizerThread.cs:</p> <pre><code>using System; using System.Threading; class ShowFinalizerThread { static Random rng = new Random(); ~ShowFinalizerThread() { Console.WriteLine("Thread/domain: {0}/{1}", Thread.CurrentThread.ManagedThreadId, AppDomain.CurrentDomain.FriendlyName); if (rng.Next(10) == 0) { Console.WriteLine("Hanging!"); Thread.Sleep(2000); } } static void Main() { new Thread(LoopForever).Start(); } static void LoopForever() { while (true) { new ShowFinalizerThread(); GC.Collect(); GC.WaitForPendingFinalizers(); Thread.Sleep(300); }; } } </code></pre> <p>Compile each as a console app, then run test.exe (from the command line is easiest, IMO). You'll see that one app domain's finalizer blocks another.</p> <p>In the future I wouldn't be surprised to see one finalizer thread per <em>core</em> rather than per AppDomain - but it sounds like you'll still have problems :(</p> <p>You have my deepest sympathy (though not a solution) - once I tracked down a deadlock in an Oracle Blob. We were able to fix that by disposing of it properly, but I know not everything works that nicely - and it was a real pain even finding that one!</p>
    singulars
    1. This table or related slice is empty.
    1. POWhat is the scope of finalizer thread - per application domain or per process?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJon Skeet
    1. USJon Skeet
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhat is the scope of finalizer thread - per application domain or per process?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI believe it's one thread per CLR instance. Starting with 2.0 and silverlight you can now have more than one CLR per process.
      singulars
      1. PO
      1. USJaredPar
    2. CO@JaredPar - you're right on it...[CLR Inside Out: In-Process Side-by-Side](http://msdn.microsoft.com/en-us/magazine/ee819091.aspx)
      singulars
      1. PO
      1. USDave Black
    3. CO@JaredPar: Will edit.
      singulars
      1. PO
      1. USJon Skeet
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload