|[CDO] What does CDO_VERSION -2 signify? [message #903101]
||Tue, 21 August 2012 21:29
| Warwick Burrows
Registered: July 2009
Location: Austin, TX
When I deleted a model object from the CDO server then looked at the object's table to see if it was gone I found that the original table entry for the object was still there and a second entry has been added for the same CDO_ID but with the CDO_VERSION set to -2. The second entry also seems to be empty of any values as if values like strings have been released. What does this entry signify and will the object get purged at a later time? Is there a setting to perform immediate deletes?
[Updated on: Tue, 21 August 2012 21:34]
Report message to a moderator
|Re: [CDO] What does CDO_VERSION -2 signify? [message #903463 is a reply to message #903460]
||Thu, 23 August 2012 13:22
| Eike Stepper
Registered: July 2009
Am 23.08.2012 19:04, schrieb Warwick Burrows:|
> Hey Eike,
> Thanks for the bug reference. I read the bug description and it was mentioned that the behaviour of not deleting the
> entry (and signifying it as version -2) is a desirable behaviour for the branching implementation, correct?
> Why is that? It was inferred in the description but not explained.
In branching mode objects that have been deleted in branch X can be "resurrected" by merging them from a branch (point)
Y where they're still alive. IIRC the revision caches need to distinguish between the two situations (1) object has been
deleted and (2) object has never existed. I'm not 100% sure anymore, though.
> If that's so then won't the CDO server database only ever continue to grow until it becomes too large to manage?
Yes, I think that's the case even for auditing.
> I'm not using branching and so don't really need those entries. Would there be any problem with my removing those
> entries using an sql script e.g. Regularly remove all rows for any cdo id that has a -2 version?
I think that should be okay for nonauditing (which includes non-branching).
> Or is there a better way to manually remove them? Will the CDO server have any issues with my removing table entries
> that are deleted outside of the cdo client/server session?
I don't think so. You may note that I'm "thinking" a lot here. Finding all this out for sure is almost identical to
addrressing the bug I've cited ;-)
Powered by FUDForum
. Page generated in 0.01839 seconds