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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0042004
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorsometimes2019-10-14 12:182019-11-14 11:18
ReporterrafademiguelView Statuspublic 
Assigned Toranjith_qualiantech_com 
PrioritynormalResolutionfixedFixed in VersionRR20Q1
StatusclosedFix in branchFixed in SCM revision45c5ddcea929
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0042004: Populate table obretco_productcategory causes problems with high concurrency

DescriptionTable obretco_productcategory is populated via ProductListEventHandler.java. This feature was implemented in Issue 30553 for High Volumes. 6 month ago the feature was implemented also to standard WebPOS (not only High Volumes).

The problem appears with high concurrency. For example in an Asynch EDL Process that inserts records in obretco_prol_product. The ProductListEventHandler checks if the product category of the product inserted in obretco_prol_product is present in obretco_productcategory and if it doesn't exists then insert the product category in the table obretco_productcategory for that assortment.

With high concurrency asynchronous processes (running in parallel) two (or more) executions identify the category as missing at the same time and try to insert it at the same time. First one success but subsequent ones produces an: ERROR: duplicate key value violates unique constraint "obretco_productcategory_un"
Steps To ReproduceYou need a process that insert records in obretco_prol_product in paralell with high concurrency. For example an EDL asynch process.

Then try to insert several products with a product category not present in the table obretco_productcategory for that assorment.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
caused by feature request 0030553RR15Q4 closedSandrahuguet High volume products: make reading product categories more efficient 

-  Notes
(0115478)
hgbot (developer)
2019-11-08 13:13

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 42c29a6aca5b046d753da006a66ddc89808b90ad
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Fri Nov 08 17:34:00 2019 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/42c29a6aca5b046d753da006a66ddc89808b90ad [^]

Fixed issue 42004 : Assortment should be locked until Product Event Handler completes

---
M src/org/openbravo/retail/posterminal/event/ProductListEventHandler.java
---
(0115595)
ranjith_qualiantech_com (developer)
2019-11-14 09:47

 Tests failing in https://ci.openbravo.com/job/mod-simple/46448/ [^]
(0115596)
hgbot (developer)
2019-11-14 10:26

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 45c5ddcea929bbe59d9f61f7be1891cd0499ace2
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Thu Nov 14 14:55:53 2019 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/45c5ddcea929bbe59d9f61f7be1891cd0499ace2 [^]

Fixed issue 42004 : Validating assortment before saving assortment product category

---
M src/org/openbravo/retail/posterminal/event/ProductListEventHandler.java
---

- Issue History
Date Modified Username Field Change
2019-10-14 12:18 rafademiguel New Issue
2019-10-14 12:18 rafademiguel Assigned To => Retail
2019-10-14 12:18 rafademiguel Triggers an Emergency Pack => No
2019-10-14 12:19 rafademiguel Relationship added caused by 0030553
2019-10-14 12:24 guillermogil Resolution time => 1572822000
2019-10-30 15:19 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2019-10-30 19:08 ranjith_qualiantech_com Status new => scheduled
2019-11-08 13:13 hgbot Checkin
2019-11-08 13:13 hgbot Note Added: 0115478
2019-11-08 13:13 hgbot Status scheduled => resolved
2019-11-08 13:13 hgbot Resolution open => fixed
2019-11-08 13:13 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/42c29a6aca5b046d753da006a66ddc89808b90ad [^]
2019-11-12 16:14 marvintm Review Assigned To => marvintm
2019-11-12 16:14 marvintm Status resolved => closed
2019-11-12 16:14 marvintm Fixed in Version => RR20Q1
2019-11-14 09:47 ranjith_qualiantech_com Note Added: 0115595
2019-11-14 09:47 ranjith_qualiantech_com Status closed => new
2019-11-14 09:47 ranjith_qualiantech_com Resolution fixed => open
2019-11-14 09:47 ranjith_qualiantech_com Fixed in Version RR20Q1 =>
2019-11-14 09:47 ranjith_qualiantech_com Status new => scheduled
2019-11-14 10:26 hgbot Checkin
2019-11-14 10:26 hgbot Note Added: 0115596
2019-11-14 10:26 hgbot Status scheduled => resolved
2019-11-14 10:26 hgbot Resolution open => fixed
2019-11-14 10:26 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/42c29a6aca5b046d753da006a66ddc89808b90ad [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/45c5ddcea929bbe59d9f61f7be1891cd0499ace2 [^]
2019-11-14 11:18 marvintm Status resolved => closed
2019-11-14 11:18 marvintm Fixed in Version => RR20Q1

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker