Skip to content

Upgrading Oracle database

Eric Vaandering edited this page May 19, 2020 · 8 revisions

Build the latest version of the rucio-upgrade container and push to docker hub. Dockerfile and instructions are here: https://github.com/dmwm/CMSKubernetes/tree/master/docker/rucio-upgrade

Get it running in the right cluster with kubectl apply -f int_upgrade.yaml (The file is here https://github.com/dmwm/CMSKubernetes/blob/master/kubernetes/rucio/int_upgrade.yaml for integration, look for or create one for other instances.) Login to the database or otherwise find the latest alembic version (from the table alembic_version) $ALEMVER

Log into the running pod kubectl exec -it rucio-upgrade-[hash]-[hash] /bin/bash Edit the resulting alembic.ini file to put the correct version_table_schema in

Run the command alembic upgrade $ALEMVER:head --sql
and save and inspect the results

Apply it with SQLPlus or another route after inspection

Remove the deployment from Kubernetes with kubectl delete deployment rucio-upgrade