-
Notifications
You must be signed in to change notification settings - Fork 176
DIRAC v7r0
zmathe edited this page Jan 14, 2019
·
32 revisions
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;
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;