On 15 September 2017 at 15:24, Ralph Bean <rb...@redhat.com> wrote: >> That is a major code change on a Friday. What is the DB upgrade parts >> and if there are further changes/problems what is the backout plan? > > The db change is here: > https://pagure.io/fm-orchestrator/pull-request/686#_1,18 > > Two new added columns. > > The MBS (like many of our other apps) uses `alembic` to manage db migrations. > The plan to upgrade involves using this playbook, which will use > `mbs-upgradedb` (a small wrapper around alembic). > https://infrastructure.fedoraproject.org/cgit/ansible.git/tree/playbooks/manual/upgrade/mbs.yml#n102
Thanks that helps me evaluate the change. > > If it fails, I'll back it out with `alembic downgrade -1`. > > If *that* fails, having the additional columns shouldn't hurt anything, so we > can downgrade the software but keep the advanced schema until we figure out > how to resolve that (likely manual sql statements, but it shouldn't come to > that[1]). > > -Ralph > > [1] - He says on a Friday afternoon, he says. Turns off pager/phone/etc. +1 :) > _______________________________________________ > infrastructure mailing list -- infrastructure@lists.fedoraproject.org > To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org -- Stephen J Smoogen. _______________________________________________ infrastructure mailing list -- infrastructure@lists.fedoraproject.org To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org