Hi,
I have some questions related with exchange plan and data lock.
While DeleteChangeRecords of exchange plan or while executing ExchangeMessageWriter or ExchangeMessageReader methods is data objects (for example "catalogRef. item example") are locked?
Why I ask it, I have at the moment such situation:
For example: I have central base and 3 sub bases.
On central base created a node for each sub base. for that we can see witch changes are related on witch base.
On sub bases there is background job witch access to central base web service and read and write own changes.
So sometimes I got an error such as:
Quote |
---|
{CommonModule.BayiSenkronizasyon_Sunucu.Module(114)}: Error calling context method (DeleteChangeRecords): Lock conflict during transaction: ERROR: deadlock detected DETAIL: Process 61212 waits for ApplicationExclusiveLock on relation 10776316 of database 329082; blocked by process 61211. Process 61211 waits for ApplicationExclusiveLock on relation 10967341 of database 329082; blocked by process 61212. HINT: See server log for query details. |
or
Quote |
---|
{CommonModule.BayiSenkronizasyon_Sunucu.Module(610)}: Error calling context method (EndWrite): Lock conflict during transaction: ERROR: deadlock detected DETAIL: Process 61326 waits for ApplicationExclusiveLock on relation 10967341 of database 329082; blocked by process 61301. Process 61301 waits for ApplicationExclusiveLock on relation 10967341 of database 329082; blocked by process 61326. HINT: See server log for query details. |