I found this bug maybe helpful for you : https://bugs.launchpad.net/neutron/+bug/1209301 This bug is still relevant. *Best Regards!* *Chao Yan--------------**My twitter:Andy Yan @yanchao727 <https://twitter.com/yanchao727>* *My Weibo:http://weibo.com/herewearenow <http://weibo.com/herewearenow>--------------* 2015-01-30 6:31 GMT+08:00 Thanukrishnamurthy Madhusudhanan < thanukrishnamurthy.madhusudha at oracle.com>: > Hello, > > After updating the neutron package to Juno I ran neutron db migration to > complete the upgrade process. > > The neutron alembic db migration scripts fail with sqlite database. > Reason for the failure: > - sqlite support very basic ALTER TABLE functionality. The only 2 > operations that are supported by ALTER TABLE are renaming a table and > adding a new column. > - alembic also does not provide any workaround to circumvent the sqlite > limitations. > > When I checked nova, I see that there are some alter table operations done > by the db migration scripts and those scripts are passing without any > issues. nova uses sqlalchemy and looks like it has a way to workaround the > sqlite limitation. > > There are no issues with neutron db migration with MYSQL backend. > > When I checked it with Anna Kamyshnikova I got the following response: > > <snip> > *At this moment Neutron is tested and expected to work on MySQL and > PostgreSQL dialects only. Also I saw a couple of patches fixing it to work > on DB2. Here is an open bug **https://bugs.launchpad.net/neutron/+bug/1241952 > <https://bugs.launchpad.net/neutron/+bug/1241952>** about sqlite support. > Per Salvatore comment if we want to support SQLite it requires blueprint > and a rather big peace of work. I can start looking in this direction and > researching what should be done, but it definitely will go into next > release as Kilo have already been closed for blueprints.* > > *I think that openstack mailing list is better place to discuss this > issues, so I suggest to forward this messages with my answer there.* > > *Regards, * > *Ann* > > <snip> > > My questions are: > - Is sqlite a supported database for openstack? > - Is it formally documented that sqlite is NOT a supported openstack > database? > - Are there any workarounds or bug fixes done to solve this problem in > havana or later? > > > Thank you, > Thanu > > _______________________________________________ > Mailing list: > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack > Post to : openstack at lists.openstack.org > Unsubscribe : > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack > > -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.openstack.org/pipermail/openstack/attachments/20150130/dc88d33c/attachment.html>