[openstack-dev] [nova][db] Thoughts on making instances.uuid non-nullable?

ChangBo Guo glongwave at gmail.com
Mon Mar 10 02:05:26 UTC 2014


2014-03-10 4:47 GMT+08:00 Jay Pipes <jaypipes at gmail.com>:

>
>
>  > 3. This would make the instances and shadow_instances tables have
> > different schemas, i.e. instances.uuid would be nullable=False in
> > instances but nullable=True in shadow_instances.  Maybe this doesn't
> matter.
>
> No, I don't think this matters much, to be honest. I'm not entirely sure
> what the long-term purpose of the shadow tables are in Nova -- perhaps
> someone could clue me in to whether the plan is to keep them around?
>
> As I know the tables shadow_*  are used  by command ' nova-manage db
archive_deleted_rows' , which moves  records with "deleted=True" to table
shadow_* . That means these tables are used by other  process, So, I think
we need other tables to store the old records in your migration .




-- 
ChangBo Guo(gcb)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20140310/5d74a936/attachment.html>


More information about the OpenStack-dev mailing list