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
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ 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]
