Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [CDO] What does CDO_VERSION -2 signify?
[CDO] What does CDO_VERSION -2 signify? [message #903101] Wed, 22 August 2012 01:29 Go to next message
Warwick Burrows is currently offline Warwick Burrows
Messages: 87
Registered: July 2009
Location: Austin, TX
Member
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: Wed, 22 August 2012 01:34]

Report message to a moderator

Re: [CDO] What does CDO_VERSION -2 signify? [message #903148 is a reply to message #903101] Wed, 22 August 2012 08:26 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5545
Registered: July 2009
Senior Member
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 17:04 Go to previous messageGo to next message
Warwick Burrows is currently offline Warwick Burrows
Messages: 87
Registered: July 2009
Location: Austin, TX
Member
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 17:22 Go to previous message
Eike Stepper is currently offline Eike Stepper
Messages: 5545
Registered: July 2009
Senior Member
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: Sat Oct 25 19:08:04 GMT 2014

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

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