Openbravo Issue Tracking System - Java Client POS
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018061Java Client POS(No Category)public2011-07-22 10:572014-04-02 09:04
Reporteradrianromero 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityrandom
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version2.40Fixed in Version 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
OBNetwork customerOBPS
Support ticket12176
Regression introduced in release
Summary0018061: 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
blocks backport 00180992.50MP33 closed adrianromero Openbravo ERP Sometimes a deadlock appear when syncrhonizing a and processing orders at the same time 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-07-22 10:57adrianromeroNew Issue
2011-07-22 10:57adrianromeroAssigned To => adrianromero
2011-07-22 10:57adrianromeroOBNetwork customer => Yes
2011-07-22 10:57adrianromeroSupport ticket => 12176
2011-07-22 10:57adrianromeroStatusnew => scheduled
2011-07-22 10:57adrianromerofix_in_branch => pi
2011-07-27 10:04hgbotCheckin
2011-07-27 10:04hgbotNote Added: 0039421
2011-07-27 10:04hgbotStatusscheduled => resolved
2011-07-27 10:04hgbotResolutionopen => fixed
2011-07-27 10:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.importdata/rev/b602618e8ee7d2c5ccc606106567b18e548a60c4 [^]
2011-07-27 13:54adrianromerofix_in_branchpi =>
2011-07-27 13:56adrianromeroRelationship addedblocks 0018099
2011-07-27 14:14adrianromeroNote Added: 0039451
2011-07-28 10:26adrianromeroNote Edited: 0039451bug_revision_view_page.php?bugnote_id=0039451#r2514
2012-11-07 09:40priyamCategory02 - ERP-POS Integration => (No Category)
2014-04-02 09:04plujanNote Added: 0066032
2014-04-02 09:04plujanStatusresolved => closed

Notes
(0039421)
hgbot   
2011-07-27 10:04   
Repository: erp/mods/org.openbravo.importdata
Changeset: b602618e8ee7d2c5ccc606106567b18e548a60c4
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Jul 26 13:40:08 2011 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.importdata/rev/b602618e8ee7d2c5ccc606106567b18e548a60c4 [^]

Fixes issue 0018061: 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
---
(0039451)
adrianromero   
2011-07-27 14:14   
(edited on: 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.
(0066032)
plujan   
2014-04-02 09:04   
Closed as it was in Resolved for too long