Changeset 7185 for trunk/sources

Timestamp:

12/13/11 17:01:09 (13 years ago)

Author:

ascheibe

Message:

#1672

• possible fix for the slave hang problem: don't host the service on the thread it was created on
• added a trigger for deleting slavestatistics when statistics are deleted

Location:

trunk/sources

Files:

• HeuristicLab.Clients.Hive.Slave.Views/3.3/SlaveItem.cs (modified) (1 diff)
• HeuristicLab.Clients.Hive.Slave/3.3/DummyListener.cs (modified) (1 diff)
• HeuristicLab.Clients.Hive.Slave/3.3/SlaveCommunicationService.cs (modified) (1 diff)
• HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql (modified) (1 diff)

trunk/sources/HeuristicLab.Clients.Hive.Slave.Views/3.3/SlaveItem.cs

@@ -42 +42 @@
   }
 
-  [CallbackBehavior(ConcurrencyMode = ConcurrencyMode.Reentrant)]
+  [CallbackBehavior(ConcurrencyMode = ConcurrencyMode.Reentrant, UseSynchronizationContext = false)]
   [Item("SlaveItem", "Represents a slave which receives messages from the core")]
   public class SlaveItem : Item, ISlaveCommunicationCallbacks, IDisposable {

trunk/sources/HeuristicLab.Clients.Hive.Slave/3.3/DummyListener.cs

@@ -26 +26 @@
 namespace HeuristicLab.Clients.Hive.SlaveCore {
 
-  [CallbackBehavior(ConcurrencyMode = ConcurrencyMode.Reentrant)]
+  [CallbackBehavior(ConcurrencyMode = ConcurrencyMode.Reentrant, UseSynchronizationContext = false)]
   internal class DummyListener : ISlaveCommunicationCallbacks {
 

trunk/sources/HeuristicLab.Clients.Hive.Slave/3.3/SlaveCommunicationService.cs

@@ -26 +26 @@
 
 namespace HeuristicLab.Clients.Hive.SlaveCore {
+  [ServiceBehavior(UseSynchronizationContext = false)]
   public class SlaveCommunicationService : ISlaveCommunication {
     private static List<ISlaveCommunicationCallbacks> subscribers = new List<ISlaveCommunicationCallbacks>();

trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql

@@ -232 +232 @@
 GO
 
+
+ALTER TRIGGER [dbo].[tr_StatisticsDeleteCascade] ON [dbo].[Statistics] INSTEAD OF DELETE AS 
+BEGIN
+  DELETE SlaveStatistics FROM deleted, SlaveStatistics WHERE deleted.StatisticsId = SlaveStatistics.StatisticsId
+  -- should also remove UserStatistics here 
+  DELETE [Statistics] FROM deleted, [Statistics] WHERE deleted.StatisticsId = [Statistics].StatisticsId
+END
+GO
+
+
 -- ============================================================
 -- Description: Create indices to speed up execution of queries