Confluence will be unusable 23-July-2024 at 06:00 due to a Crowd upgrade.
The SQL for purging L1 data is:
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT
count(DATA_CATALOG_ADMIN.PurgeDatasetVersion(DatasetVersion))
FROM
DatasetGroup g
JOIN
VerDataset d
ON
(
d.DatasetGroup= g.DatasetGroup
)
JOIN
DatasetVersion dv
ON
(
dv.Dataset= d.Dataset
)
WHERE
g.DatasetLogicalFolder=39684091
and d.LatestVersion != dv.DatasetVersion
and Registered<sysdate-14
|
This does not actually delete data, it just puts it into the "to be deleted" table – DATASETLOCATIONPURGE. We should run this nightly as a "oracle cron" This is now run automatically as an Oracle "cron"-job.
To actually delete the files the script in ~glast/datacat/devprod/delete-datacat .csh must be run . This currently only exists in DEV and uses a SNAPSHOT version of the data catalog crawler software(as glastraw on fermilnx-v21).