Migration for creating missing indexes does not work with sqlite
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
subunit2sql |
Triaged
|
Low
|
Unassigned |
Bug Description
$ alembic upgrade head
INFO [alembic.migration] Context impl SQLiteImpl.
INFO [alembic.migration] Will assume non-transactional DDL.
INFO [alembic.migration] Running upgrade None -> 5ef013efbc2, create tests tables
INFO [alembic.migration] Running upgrade 5ef013efbc2 -> 1f92cfe8a6d3, create runs table
INFO [alembic.migration] Running upgrade 1f92cfe8a6d3 -> 3db7b49816d5, create test_runs table
INFO [alembic.migration] Running upgrade 3db7b49816d5 -> 163fd5aa1380, Create avg runtime column in test table
INFO [alembic.migration] Running upgrade 163fd5aa1380 -> 4ca26dac400e, Create metadata tables
INFO [alembic.migration] Running upgrade 4ca26dac400e -> 13d819bbb0ff, create missing indexes
Traceback (most recent call last):
File "/home/
load_
File "/home/
CommandLine
File "/home/
self.
File "/home/
**dict((k, getattr(options, k)) for k in kwarg)
File "/home/
script.
File "/home/
util.
File "/home/
module = load_module_
File "/home/
mod = imp.load_
File "subunit2sql/
run_
File "subunit2sql/
context.
File "<string>", line 7, in run_migrations
File "/home/
self.
File "/home/
change(**kw)
File "subunit2sql/
['test_id', 'run_id'])
File "<string>", line 7, in create_
File "/home/
schema=schema, **kw)
File "/home/
"No support for ALTER of constraints in SQLite dialect")
NotImplementedE
Environment:
$ pip freeze | egrep '(subunit|
alembic==0.6.5
oslo.config=
oslo.db==0.3.0
python-
subunit2sql=
Changed in subunit2sql: | |
status: | New → Triaged |
importance: | Undecided → Wishlist |
importance: | Wishlist → Low |
Related fix proposed to branch: master /review. openstack. org/109865
Review: https:/