<div dir="ltr"><div><font size="4">I found this bug maybe helpful for you : <a href="https://bugs.launchpad.net/neutron/+bug/1209301">https://bugs.launchpad.net/neutron/+bug/1209301</a><br></font></div><font size="4">This bug is still relevant.</font></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><font face="comic sans ms, sans-serif" size="4"><b><i>Best Regards！</i></b></font></div><font face="comic sans ms, sans-serif" size="4"><b><i>Chao Yan<br><font>--------------<br></font></i></b></font><font face="comic sans ms, sans-serif" size="4"><b><i><font>My twitter：Andy Yan <a href="https://twitter.com/yanchao727" target="_blank">@yanchao727</a></font></i></b></font><br><font face="comic sans ms, sans-serif" size="4"><b><i><font>My Weibo：<a href="http://weibo.com/herewearenow" target="_blank">http://weibo.com/herewearenow</a><br>--------------</font><br></i></b></font></div></div></div>
<br><div class="gmail_quote">2015-01-30 6:31 GMT+08:00 Thanukrishnamurthy Madhusudhanan <span dir="ltr"><<a href="mailto:thanukrishnamurthy.madhusudha@oracle.com" target="_blank">thanukrishnamurthy.madhusudha@oracle.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
After updating the neutron package to Juno I ran neutron db
migration to complete the upgrade process.<br>
<br>
The neutron alembic db migration scripts fail with sqlite database.<br>
Reason for the failure:<br>
- 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.<br>
- alembic also does not provide any workaround to circumvent the
sqlite limitations.<br>
<br>
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.<br>
<br>
There are no issues with neutron db migration with MYSQL backend.<br>
<br>
When I checked it with Anna Kamyshnikova I got the following
response:<br>
<br>
<snip><br>
<div><i>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 </i><i><a href="https://bugs.launchpad.net/neutron/+bug/1241952" target="_blank">https://bugs.launchpad.net/neutron/+bug/1241952</a></i><i>
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></div>
<div><i><br>
</i></div>
<div><i>I think that openstack mailing list is better place to
discuss this issues, so I suggest to forward this messages with
my answer there.</i></div>
<i><br>
</i><i>Regards, </i>
<div><i>Ann</i></div>
<br>
<snip><br>
<br>
My questions are:<br>
- Is sqlite a supported database for openstack? <br>
- Is it formally documented that sqlite is NOT a supported openstack
database?<br>
- Are there any workarounds or bug fixes done to solve this problem
in havana or later?<br>
<br>
<br>
Thank you,<br>
Thanu<br>
</div>
<br>_______________________________________________<br>
Mailing list: <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
Post to : <a href="mailto:openstack@lists.openstack.org">openstack@lists.openstack.org</a><br>
Unsubscribe : <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
<br></blockquote></div><br></div>