Indexes are missing in sqlite

Bug #1191838 reported by Viktor Serhieiev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Compute (nova)
Fix Released
Low
Viktor Serhieiev

Bug Description

When we create indexes (in migration `133_folsom.py`) we do it only for mysql and postgresql.

1114 # Common indexes
1115 if migrate_engine.name == 'mysql' or migrate_engine.name == 'postgresql':
1116 for index in indexes:
1117 index.create(migrate_engine)

Tags: db sqlite
Changed in nova:
assignee: nobody → Victor Sergeyev (vsergeyev)
Revision history for this message
David Ripton (dripton) wrote :

This isn't really important because we don't really expect anyone to use SQLite in production, but feel free to add indexes if you want.

Changed in nova:
importance: Undecided → Low
status: New → Confirmed
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to nova (master)

Fix proposed to branch: master
Review: https://review.openstack.org/33608

Changed in nova:
status: Confirmed → In Progress
Changed in nova:
assignee: Victor Sergeyev (vsergeyev) → Roman Podolyaka (rpodolyaka)
Changed in nova:
assignee: Roman Podolyaka (rpodolyaka) → Victor Sergeyev (vsergeyev)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to nova (master)

Reviewed: https://review.openstack.org/33608
Committed: http://github.com/openstack/nova/commit/8f4a7e298bcb6bc1f0332309497a5c3ae7fd1c7e
Submitter: Jenkins
Branch: master

commit 8f4a7e298bcb6bc1f0332309497a5c3ae7fd1c7e
Author: Victor Sergeyev <email address hidden>
Date: Wed Jun 19 11:03:43 2013 +0300

    Add indexes to sqlite

    Migration `133_folsom.py` do not create indexes for sqlite.
    Added missed indexes with tests.

    Fixes bug 1191838

    Change-Id: I018e29ba46f2017241c13742169896625944194e

Changed in nova:
status: In Progress → Fix Committed
Thierry Carrez (ttx)
Changed in nova:
milestone: none → havana-3
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in nova:
milestone: havana-3 → 2013.2
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.