<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body 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">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>
</body>
</html>