Exchange Plan Between Central base and Several sub bases

Understanding basics of 1C:Enterprise platform. To start working with 1C:Enterprise platform visit Getting started page

#1
People who like this:0Yes/0No
Interested
Rating: 27
Joined: Apr 5, 2012
Company: 1TÇ Şirketi - Merv Bilgi İşlem Otomasyonu Yazılım Ltd. Şti.

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.

 
#2
People who like this:0Yes/0No
Interested
Rating: 27
Joined: Apr 5, 2012
Company: 1TÇ Şirketi - Merv Bilgi İşlem Otomasyonu Yazılım Ltd. Şti.

question is Is it possible to realize data exchange with several bases on one object at same time?

 
#3
People who like this:0Yes/0No
Active user
Rating: 4
Joined: Nov 19, 2012
Company:

Murat Yazlıyev,
It is possible.
To lower the risk of deadlocks and time-outs:
1) "Default transaction data lock control mode"  for configuration must be "Managed"
2) When you are reading\writing changes - set up a node property "Number of data element processed in a single transaction" is equal to 100-200.

 
#4
People who like this:0Yes/0No
Interested
Rating: 27
Joined: Apr 5, 2012
Company: 1TÇ Şirketi - Merv Bilgi İşlem Otomasyonu Yazılım Ltd. Şti.

When reading changes from exchange plan or when writing changes to exchange plan or when deleting changes from exchange plan is related object is locked by that proccess or session?

 
#5
People who like this:0Yes/0No
Active user
Rating: 4
Joined: Nov 19, 2012
Company:

Murat Yazlıyev,
Depends on "Default transaction data lock control mode" behavior is a bit different.
Generally speaking, all modified and read data\objects in transaction are locked to the end of transaction.
This is not some 1C feature. Check out 'transaction locking' in google.

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.