[openstack-dev] [nova][db] Thoughts on making instances.uuid non-nullable?
Jay Pipes
jaypipes at gmail.com
Mon Mar 10 02:18:33 UTC 2014
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
More information about the OpenStack-dev
mailing list