[Openstack-operators] Slow db migration in havana

Michael Still mikal at stillhq.com
Tue Jun 11 10:29:05 UTC 2013


Hi.

I just wanted to make sure people are aware of a slow db migration
which landed in havana today. I discovered this while testing a CI
script I am working on which tests DB migrations.

The migration is number 186, which landed with this review
https://review.openstack.org/#/c/29251/11 -- it rewrites the block
device mapping tables, and will therefore affect people making heavy
use of volumes.

Here's a log of the test run:

http://openstack.stillhq.com/ci/If30afdb59d4c4268b97d3d10270df2cc729a0c4c/11/sqlalchemy_migration_nova_user_001/log.html

The interesting log entry is at:

http://openstack.stillhq.com/ci/If30afdb59d4c4268b97d3d10270df2cc729a0c4c/11/sqlalchemy_migration_nova_user_001/log.html#524

This migration takes just under 20 minutes with my test database of
45k block device mappings and 35k shadow block device mappings, on an
otherwise unloaded cloud instance.

Cheers,
Michael

PS: remember when I asked for test datasets? If you'd like to donate a
copy of a nova database to add to this test suite, please mail me
privately so we can negotiate.



More information about the OpenStack-operators mailing list