Desktop version

Main > Forum > 1C:Enterprise Platform > Studying 1C:Enterprise platform > Exchange Plan Between Central base and Several sub bases

Forum

Search UsersRules
Exchange Plan Between Central base and Several sub bases
#1
Interested
Points:: 0
Joined:: Apr 5, 2012

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.

Profile
#2
Interested
Points:: 0
Joined:: Apr 5, 2012

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

Profile
#3
Active user
Points:: 0
Joined:: Nov 19, 2012

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.

Profile
#4
Interested
Points:: 0
Joined:: Apr 5, 2012

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?

Profile
#5
Active user
Points:: 0
Joined:: Nov 19, 2012

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.

Profile
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.