Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0018099Openbravo ERP02. Master data managementpublic2011-07-27 13:552011-08-22 17:25
adrianromero 
adrianromero 
urgentmajorrandom
closedfixed 
5
2.50MP31 
2.50MP332.50MP33 
Core
No
0018099: Sometimes a deadlock appear when syncrhonizing a and processing orders at the same time
When launching at the same time the job that imports orders in I_ORDER and the process of orders imported, a deadlock appears and the order imported is not processed automatically and must be manually processed
Launch the import orders job and the process of orders several times at the same time.
No tags attached.
depends on defect 00180612.40 closed adrianromero Java Client POS Sometimes a deadlock appear when syncrhonizing a and processing orders at the same time 
depends on backport 00181102.50MP33 closed adrianromero Openbravo ERP Try-2.50-api failed because two foreign keys has been removed 
related to defect 0017975 closed mtaal Openbravo ERP Orders Synchronization between POS and ERP fails when there are two (or more) shops invoking the web service 
Issue History
2011-07-27 13:55adrianromeroNew Issue
2011-07-27 13:55adrianromeroAssigned To => adrianromero
2011-07-27 13:55adrianromeroModules => Core
2011-07-27 13:56adrianromeroStatusnew => scheduled
2011-07-27 13:56adrianromerofix_in_branch => pi
2011-07-27 13:56adrianromeroRelationship addeddepends on 0018061
2011-07-27 13:59adrianromeroTarget Version2.50MP32 => 2.50MP33
2011-07-27 13:59adrianromerofix_in_branchpi =>
2011-07-28 10:14adrianromeroRelationship addeddepends on 0018110
2011-07-28 10:19hgbotCheckin
2011-07-28 10:19hgbotNote Added: 0039472
2011-07-28 10:21hgbotCheckin
2011-07-28 10:21hgbotNote Added: 0039474
2011-07-28 10:21hgbotStatusscheduled => resolved
2011-07-28 10:21hgbotResolutionopen => fixed
2011-07-28 10:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/086ee81793cff740574594d083648c8589b8b6ae [^]
2011-07-28 10:26adrianromeroNote Added: 0039476
2011-07-28 11:05adrianromeroRelationship addedrelated to 0017975
2011-08-02 13:43adrianromeroIssue cloned0018158
2011-08-22 17:25jonalegriaesarteNote Added: 0040392
2011-08-22 17:25jonalegriaesarteStatusresolved => closed
2011-08-22 17:25jonalegriaesarteFixed in Version => 2.50MP33

Notes
(0039472)
hgbot   
2011-07-28 10:19   
Repository: erp/stable/api-checks-2.50
Changeset: fe875614d260f23876e0b36d254aefb5caefe29b
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Jul 28 10:19:01 2011 +0200
URL: http://code.openbravo.com/erp/stable/api-checks-2.50/rev/fe875614d260f23876e0b36d254aefb5caefe29b [^]

Fixes issue 0018110: Try-2.50-api failed because two foreign keys has been removed. Related to issue 18099

---
M model/model/tables/I_ORDER.xml
---
(0039474)
hgbot   
2011-07-28 10:21   
Repository: erp/stable/2.50
Changeset: 086ee81793cff740574594d083648c8589b8b6ae
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Wed Jul 27 13:58:06 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/086ee81793cff740574594d083648c8589b8b6ae [^]

Fixes issue 0018099: Sometimes a deadlock appear when syncrhonizing a and processing orders at the same time
It has been removed two unnecesary foreing keys to avoid the deadlock

---
M src-db/database/model/tables/I_ORDER.xml
---
(0039476)
adrianromero   
2011-07-28 10:26   
* Testing the issue

Fill the I_Order table with around 300 valid Order lines. This can be done using the integration job: https://code.openbravo.com/erp/pmods/org.openbravo.pos.sync/file/7a7809a5970d/resources/test_orders_2.ktr [^] [^]

Go to the Import Orders window and process the imported orders.

Simultaneously execute the integration job again.

Verify that both processes finish succesfully without any error and also verify that in the AD_PINSTANCE table there is not any execution that registered a deadlock

* Other areas affected

No other areas affected. Only the I_ORDER table definition has been modified.
(0040392)
jonalegriaesarte   
2011-08-22 17:25   
Verified