Migration workflow

Migration workflow steps

Restore test

Index:

uv run invenio rero es snapshot repository create backup /invenio/storage/prod/es-backup

uv run invenio rero es snapshot list backup |grep daily
uv run invenio rero es snapshot restore backup XXXXXX

Files [root@nagma.rero.ch]

rsync -avr --delete /data/sonar/prod/files/ /data/sonar/dev/files/  --exclude=lost+found/
chown -R debian9:debian9 /data/sonar/dev/files/*

DB kerosen

export kerosen

ssh root@kerosen
su - postgres
pg_dumpall > /database/dump/sonar_prod_20250923.sql
exit

#### import sonar dev
su - postgres
psql -f /database/dump/sonar_prod_20250923.sql
exit
exit

# v1.11.0 --> v1.12.0

DB migration 9 -> 17 ???

Alembic

uv run invenio alembic upgrade
# TODO: uv run invenio rero es index update-mapping

ConfigMap

• replace INVENIO_SQLALCHEMY_POOL_RECYCLE by INVENIO_SQLALCHEMY_ENGINE_OPTIONS: '{ "pool_recycle": 360 }'
• set the config in the sqlalchemy container/server by setting PGOPTIONS to -c statement_timeout=30s -c idle_in_transaction_session_timeout=60s