Changeset 9485 for branches/HivePerformance/sources/HeuristicLab.Services.Hive/3.3

Timestamp:

05/10/13 13:27:25 (11 years ago)

Author:

pfleck

Message:

#2030

Fixed Bugs in Shutdown Queries.

Added SQL script for migrating to filestream based storage of task and plugin data.

To remove files after data removal turned on Auto-Shrink and set recovery-model to Simple.
Also set a checkpoint in the database.

File:

• branches/HivePerformance/sources/HeuristicLab.Services.Hive/3.3/OptimizedHiveDao.cs (modified) (1 diff)

branches/HivePerformance/sources/HeuristicLab.Services.Hive/3.3/OptimizedHiveDao.cs

@@ -241 +241 @@
 
     public bool SlaveHasToShutdownComputer(Guid slaveId) {
-      return Db.ExecuteQuery<int>(DowntimeQueryString, slaveId, DateTime.Now, DowntimeType.Shutdown).First() > 0;
+      return Db.ExecuteQuery<int>(DowntimeQueryString, slaveId, DateTime.Now, DowntimeType.Shutdown.ToString()).FirstOrDefault() > 0;
     }
 
     public bool SlaveIsAllowedToCalculate(Guid slaveId) {
-      return Db.ExecuteQuery<int>(DowntimeQueryString, slaveId, DateTime.Now, DowntimeType.Offline).First() == 0;
+      return Db.ExecuteQuery<int>(DowntimeQueryString, slaveId, DateTime.Now, DowntimeType.Offline.ToString()).FirstOrDefault() == 0;
     }
     #endregion