Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018099Openbravo ERP02. Master data managementpublic2011-07-27 13:552011-08-22 17:25
Reporteradrianromero 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityrandom
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP31 
Target Version2.50MP33Fixed in Version2.50MP33 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket12176
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018099: Sometimes a deadlock appear when syncrhonizing a and processing orders at the same time
DescriptionWhen 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
Steps To ReproduceLaunch the import orders job and the process of orders several times at the same time.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-07-27 13:55adrianromeroNew Issue
2011-07-27 13:55adrianromeroAssigned To => adrianromero
2011-07-27 13:55adrianromeroModules => Core
2011-07-27 13:55adrianromeroOBNetwork customer => Yes
2011-07-27 13:55adrianromeroSupport ticket => 12176
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