Skip to main content



      Home
Home » Modeling » EMF » [CDO] What does CDO_VERSION -2 signify?
[CDO] What does CDO_VERSION -2 signify? [message #903101] Tue, 21 August 2012 21:29 Go to next message
Eclipse UserFriend
Hi,

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?

Thanks,
Warwick

[Updated on: Tue, 21 August 2012 21:34] by Moderator

Re: [CDO] What does CDO_VERSION -2 signify? [message #903148 is a reply to message #903101] Wed, 22 August 2012 04:26 Go to previous messageGo to next message
Eclipse UserFriend
Hi Warwick,

I think you've hit:

312670: [DB] Delete objects completely from the database in non-branching mode
https://bugs.eclipse.org/bugs/show_bug.cgi?id=312670

It's really very annoying and quite old but apparently noone has found the time to address it, yet ;-(

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper




Am 22.08.2012 03:29, schrieb Warwick Burrows:
> Hi,
>
> When a 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
> release. What does this entry signify and will the object get purged at a later time? Is there a setting to perform
> immediate deletes?
>
> Thanks,
> Warwick
Re: [CDO] What does CDO_VERSION -2 signify? [message #903460 is a reply to message #903148] Thu, 23 August 2012 13:04 Go to previous messageGo to next message
Eclipse UserFriend
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. If that's so then won't the CDO server database only ever continue to grow until it becomes too large to manage?

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? 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?

Thanks,
Warwick
Re: [CDO] What does CDO_VERSION -2 signify? [message #903463 is a reply to message #903460] Thu, 23 August 2012 13:22 Go to previous message
Eclipse UserFriend
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?
Yes.

> 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 ;-)

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Previous Topic:Teneo/hibernate
Next Topic:Tabbed Properties
Goto Forum:
  


Current Time: Fri Jul 25 08:02:17 EDT 2025

Powered by FUDForum. Page generated in 0.04335 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top