On Mon, Jul 24, 2017 at 11:59 PM, Dan Callaghan <dcallagh(a)redhat.com> wrote:
Excerpts from Don Zickus's message of 2017-07-24 09:54 -04:00:
> Thanks Dan! We did something like that last week, but we were using
> 'alembic upgrade/downgrade' instead of 'migration'. The upgrade
kept
> failing because of 'alembic no handlers found for logger
alembic.migration'
> or something. Thoughts there?
Sorry I actually meant to say "alembic revision". It is the command to
create a new migration script in the source tree based on the template.
I always get that command name wrong.
The "no handlers found" message is just pointless spew from the Python
logging subsystem, not an actual error. However the "alembic upgrade"
and "downgrade" commands won't work with Beaker, due to the hackery
needed to glue Alembic into all the existing database code which is
inherited from TurboGears.
The normal way to upgrade/downgrade the database schema on a Beaker
installation is using beaker-init (to upgrade) or
beaker-init --downgrade=<version> (to downgrade).
If you're running from a git checkout with a database configured in
dev.cfg, you can just do something like:
cd Server
PYTHONPATH=../Common:. python bkr/server/tools/init.py --debug
Thanks for the description
something flukey here for me.
I have auto generated 3dd091c46d50 as head using alembic revision, but
db version stays at f18df089261. Using methods described above,
including beaker-init (--downgrade)have no affect on the db version.
I can interact with the db with the alembic stamp command but only to
maniuplate the version_number. Other db changes do not seem to be
affected.
Thoughts?
alembic history
Rev: 3dd091c46d50 (head)
Parent: f18df089261
Path: bkr/server/alembic/versions/3dd091c46d50_.py
empty message
Revision ID: 3dd091c46d50
Revises: f18df089261
Create Date: 2017-07-25 18:03:04.320470
Rev: f18df089261
Parent: 4f7a4316565f
Path:
bkr/server/alembic/versions/f18df089261_associate_a_floating_ip_to_each_openstack_instance.py
associate a floating ip to each OpenStack instance
Revision ID: f18df089261
Revises: 4f7a4316565f
Create Date: 2016-12-05 05:59:28.858413
root@beaker-server-lc Server]# PYTHONPATH=../Common:. python
bkr/server/tools/init.py --debug
2017-07-25 18:06:40,981 __main__ INFO Upgrading schema to head revision
2017-07-25 18:06:40,981 alembic.migration INFO Context impl MySQLImpl.
2017-07-25 18:06:40,981 alembic.migration INFO Will assume
non-transactional DDL.
2017-07-25 18:06:40,987 __main__ INFO Upgrade completed
2017-07-25 18:06:40,987 __main__ INFO Populating tables with
pre-defined values if necessary
2017-07-25 18:06:41,225 __main__ INFO Pre-defined values populated
2017-07-25 18:06:41,226 __main__ INFO Exiting
SELECT * FROM alembic_version;
+-------------+
| version_num |
+-------------+
| f18df089261 |
+-------------+
--
Dan Callaghan <dcallagh(a)redhat.com>
Senior Software Engineer, Products & Technologies Operations
Red Hat
--
Shawn Doherty
Software Engineer, Kernel-HW
Red Hat
314 Littleton Rd
Westford, MA 01886
sdoherty(a)redhat.com T: 19785891080 INTERNAL:-8131080 IM: sdoherty