Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0018099
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 02. Master data managementmajorrandom2011-07-27 13:552011-08-22 17:25
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version2.50MP33
StatusclosedFix in branchFixed in SCM revision086ee81793cf
ProjectionnoneETAnoneTarget Version2.50MP33
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.50MP31SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018099: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 00180612.40 closedadrianromero Java Client POS Sometimes a deadlock appear when syncrhonizing a and processing orders at the same time 
depends on backport 00181102.50MP33 closedadrianromero Openbravo ERP Try-2.50-api failed because two foreign keys has been removed 
related to defect 0017975 closedmtaal Openbravo ERP Orders Synchronization between POS and ERP fails when there are two (or more) shops invoking the web service 

-  Notes
(0039472)
hgbot (developer)
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 (developer)
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 (manager)
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 (reporter)
2011-08-22 17:25

 Verified

- Issue History
Date Modified Username Field Change
2011-07-27 13:55 adrianromero New Issue
2011-07-27 13:55 adrianromero Assigned To => adrianromero
2011-07-27 13:55 adrianromero Modules => Core
2011-07-27 13:56 adrianromero Status new => scheduled
2011-07-27 13:56 adrianromero fix_in_branch => pi
2011-07-27 13:56 adrianromero Relationship added depends on 0018061
2011-07-27 13:59 adrianromero Target Version 2.50MP32 => 2.50MP33
2011-07-27 13:59 adrianromero fix_in_branch pi =>
2011-07-28 10:14 adrianromero Relationship added depends on 0018110
2011-07-28 10:19 hgbot Checkin
2011-07-28 10:19 hgbot Note Added: 0039472
2011-07-28 10:21 hgbot Checkin
2011-07-28 10:21 hgbot Note Added: 0039474
2011-07-28 10:21 hgbot Status scheduled => resolved
2011-07-28 10:21 hgbot Resolution open => fixed
2011-07-28 10:21 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/086ee81793cff740574594d083648c8589b8b6ae [^]
2011-07-28 10:26 adrianromero Note Added: 0039476
2011-07-28 11:05 adrianromero Relationship added related to 0017975
2011-08-02 13:43 adrianromero Issue cloned 0018158
2011-08-22 17:25 jonalegriaesarte Note Added: 0040392
2011-08-22 17:25 jonalegriaesarte Status resolved => closed
2011-08-22 17:25 jonalegriaesarte Fixed in Version => 2.50MP33

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker