Database downgrade fails on SQLite

[Simon Chang]

The 009_add_deleted_flag_to_instance.py script in migrate_repo fails to downgrade a SQLite database properly. The instances.drop_column('deleted') line in the downgrade() function actually drops the instance table before dropping the "deleted" column. The instance table shouldn't have been deleted in the first place.

Error trace:
http://paste.openstack.org/show/89406/

Steps to replicate the issue:
1) Comment out the sql_connection line in /etc/trove/trove.conf, forcing trove-manage to use the default SQLite database option.
2) trove-manage db_sync
3) trove-manage db_downgrade 8

[Amrith Kumar (amrith)]

Updating importance to "Low" (bugscrub, 2014-10-23)

[Amrith Kumar (amrith)]

Simon, any updates on this?

[Simon Chang (changsimon)]

There has been proposals that openstack as a whole shouldn't support downgrade. I think we should set the status of this one to 'Won't Fix'.

[Amrith Kumar (amrith)]

Thanks Simon, good point.