Skip to content
zmathe edited this page Jan 14, 2019 · 32 revisions

AccountingSystem

PR https://github.com/DIRACGrid/DIRAC/pull/3701 merges the ObjectLoaders and TypeLoaders used in AccountingSystem and MonitoringSystem into a single one. Pay attention in case you use them.

alter table `ac_key_LHCb-Production_Job_FinalMinorStatus` MODIFY value VARCHAR(256) NOT NULL;

alter table `ac_in_LHCb-Production_Job` MODIFY FinalMinorStatus VARCHAR(256) NOT NULL;

WorkloadManagementSystem

Jobs parameters on ElasticSearch backend

TransformationSystem

PR https://github.com/DIRACGrid/DIRAC/pull/3703 replaces the TransformationInputDataQuery table with a new table TransformationMetaQuery, which stores both Input and Output MetaQueries. In order to guarantee backward compatibility, before deploying the release, it's necessary to rename the TransformationInputDataQuery table and create a view as following:

  ALTER TABLE `TransformationInputDataQuery` RENAME `TransformationMetaQuery`, 
  ADD COLUMN QueryType VARCHAR(8), 
  CHANGE COLUMN `ParameterName` `MetaDataName` VARCHAR(512) NOT NULL, 
  CHANGE COLUMN `ParameterValue` `MetaDataValue` blob NOT NULL,  
  CHANGE COLUMN `ParameterType` `MetaDataType` VARCHAR(8) NOT NULL;
  CREATE OR REPLACE VIEW `TransformationInputDataQuery` AS 
  SELECT TransformationID, 
  MetaDataName as ParameterName, 
  MetaDataValue as ParameterValue,  
  MetaDataType as ParamaterType
  from TransformationMetaDataQuery;

ProductionSystem

Clone this wiki locally