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

Matt Riedemann mriedem at linux.vnet.ibm.com
Mon Mar 10 14:11:13 UTC 2014



On 3/9/2014 9:18 PM, Jay Pipes wrote:
> On Mon, 2014-03-10 at 10:05 +0800, ChangBo Guo wrote:
>>
>>
>>
>> 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.
>
> Yeah, that's what I understood the shadow tables were used for, I just
> didn't know what the long-term future of these tables was... curious if
> there's been any discussion about that.
>
> Best,
> -jay
>
>
>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>

I think Joe Gordon was working on something in the hopes of eventually 
killing the shadow tables but I can't remember exactly what that was now.

-- 

Thanks,

Matt Riedemann




More information about the OpenStack-dev mailing list