Inventory - inventory_lock usage

[Suresh Choppara]

Hi 

We are observing frequent deadlocks on inventory table. From our observation we are seeing blocked sessions at oracle side over dcs_inventory table. Below is the statement thatz being triggered and which is causing deadlocks.

UPDATE dcs_inventory SET inventory_lock = :1 WHERE catalog_ref_id = :2

Could someone provide the pointers on how/when the inventory_lock will be used from atg codebase?  

What could be the scenarios in which this column getz populated? 

How/Where in ATG inventory system uses this column data? and

What are the problems that we foresee if we turn this off? ( getRowLock=false in InventoryManager )

FYI: We got the cache-mode as simple for inventory repository (dcs_inventory). 

let me know if this requires further information for the pointers to be provided.

Regards,

Suresh

[Naga]

Suresh,

The repository inventory manager does the locking when purchaseItem processor is called in the fulfillment pipeline. Please check the implementation and its corresponding method comments to get a better idea on the same.

-Naga

--
You received this message because you are subscribed to the Google Groups "ATG_Tech" group.
To post to this group, send email to atg_...@googlegroups.com
To unsubscribe from this group, send email to atg_tech-u...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/atg_tech?hl=en

--
http://www.linkedin.com/in/nagarajanseshadri
http://sites.google.com/site/nagsesh
http://nagarajanseshadri.blogspot.com

[Suresh Choppara]

Hi Naga,

Thanks for information. Will cross check and will post with my findings.

Regards,

Suresh