Add a new column for the Key ID in the table TAPE_POOL
Introduction
At the moment, the script cta-get-encryption-key queries cta-admin
(whish interacts with the ctafrontend) to query for the encryption Key ID. As mentioned in https://gitlab.cern.ch/cta/operations/-/issues/839, this dependency on the ctafrontend can cause some HA related problems.
Fortunately, we can simplify bypass this check - simplify the script a lot - by passing the Key ID directly from the Tape Server. The Tape Server has access to the catalogue, therefore there is no reason not to get this field there.
Task
Part of this work requires adding the column Key ID to the table TAPE_POOL.
We can use the same definition for the Key ID that exists in the table TAPE. This change should be included in the next catalogue version v12.0.