[openstack-dev] [keystone] sqlite doesn't support migrations

Michael Still mikal at stillhq.com
Tue Jul 16 07:55:42 UTC 2013

On Tue, Jul 16, 2013 at 4:17 PM, Thomas Goirand <zigo at debian.org> wrote:

> Could you explain a bit more what could be done to fix it in an easy
> way, even if it's not efficient? I understand that ALTER doesn't work
> well. Though would we have the possibility to just create a new
> temporary table with the correct fields, and copy the existing content
> in it, then rename the temp table so that it replaces the original one?

There are a bunch of nova migrations that already work that way...
Checkout the *sqlite* files in


Rackspace Australia

More information about the OpenStack-dev mailing list