Our subclass of EOEditingContext creates a new EO and relates it to all the 
EO's in the inserted and updated lists.

On Sep 24, 2010, at 1:37 PM, Chuck Hill wrote:

> How is trans_id updated?
> 
> 
> On Sep 24, 2010, at 8:56 AM, Ken Anderson wrote:
> 
>> All,
>> 
>> I have an odd problem I'm wondering if anyone else has seen before.
>> 
>> I have apps that do high throughput processing of data - many times a 
>> second.  It is single threaded, and uses a single EOF stack.  I'm sure it's 
>> single threaded because the requests are coming in via an inbound queue, not 
>> any kind of front end.
>> 
>> Every once in a while under significantly high load, I get a few optimistic 
>> lock exceptions in a row, on rows that are only being touched by this app.  
>> We audit every update, and I can look into the audit tables and verify that 
>> nothing else has modified the record except this app.
>> 
>> It's almost like the snapshot has not been recorded properly before the next 
>> request is processed, so EOF thinks something else updated the value.
>> 
>> Our locking is implemented on a single column, trans_id, which is updated 
>> with every save.  The audit table also saves the trans_id that's responsible 
>> for moving the record into audit, and all the values match in succession.
>> 
>> Has anyone had anything like this happen?  Running 5.4.3 on Linux.  and 
>> no... no Wonder.
>> 
>> Ken _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list      ([email protected])
>> Help/Unsubscribe/Update your Subscription:
>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
>> 
>> This email sent to [email protected]
> 
> -- 
> Chuck Hill             Senior Consultant / VP Development
> 
> Practical WebObjects - for developers who want to increase their overall 
> knowledge of WebObjects or who are trying to solve specific problems.    
> http://www.global-village.net/products/practical_webobjects
> 
> 
> 
> 
> 
> 
> 

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to