Changeset 9485


Ignore:
Timestamp:
05/10/13 13:27:25 (8 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.

Location:
branches/HivePerformance/sources
Files:
1 added
2 edited

Legend:

Unmodified
Added
Removed
  • branches/HivePerformance/sources/HeuristicLab.Services.Hive.DataAccess/3.3/HeuristicLab.Services.Hive.DataAccess-3.3.csproj

    r8957 r9485  
    149149  <ItemGroup>
    150150    <Content Include="SQL Scripts\Initialize Hive Database.sql" />
     151    <Content Include="SQL Scripts\Migrate to Filestream.sql" />
    151152    <Content Include="SQL Scripts\Prepare Hive Database.sql" />
    152153  </ItemGroup>
  • branches/HivePerformance/sources/HeuristicLab.Services.Hive/3.3/OptimizedHiveDao.cs

    r9434 r9485  
    241241
    242242    public bool SlaveHasToShutdownComputer(Guid slaveId) {
    243       return Db.ExecuteQuery<int>(DowntimeQueryString, slaveId, DateTime.Now, DowntimeType.Shutdown).First() > 0;
     243      return Db.ExecuteQuery<int>(DowntimeQueryString, slaveId, DateTime.Now, DowntimeType.Shutdown.ToString()).FirstOrDefault() > 0;
    244244    }
    245245
    246246    public bool SlaveIsAllowedToCalculate(Guid slaveId) {
    247       return Db.ExecuteQuery<int>(DowntimeQueryString, slaveId, DateTime.Now, DowntimeType.Offline).First() == 0;
     247      return Db.ExecuteQuery<int>(DowntimeQueryString, slaveId, DateTime.Now, DowntimeType.Offline.ToString()).FirstOrDefault() == 0;
    248248    }
    249249    #endregion
Note: See TracChangeset for help on using the changeset viewer.