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.