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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0032104
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2016-02-03 13:262016-02-22 09:21
ReporterlorenzofidalgoView Statuspublic 
Assigned ToSandrahuguet 
PrioritynormalResolutionfixedFixed in VersionRR16Q2
StatusclosedFix in branchFixed in SCM revisiona6b0049355bc
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionmainSCM revision 
Merge Request Status
Review Assigned Tomtaal
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0032104: [RR16Q1][HighVol] Create many search requests induces postgres processes jam the cpu of the machine

DescriptionIf users create many requests to search for products in Web POS, this induces the machine gets jammed by this queries. Many postgres processes appear in the server, collapsing the machine CPU.
Steps To Reproduce0-Log to the server machine and use "top" command to control the CPU usage of the server machine.
1-In a HighVol configured machine, login POS to CMS-1, VBS-1 and PS-1 with different devices/PCs to do the following testing:
2-Go with all the terminals to "Seach" tab and throw as many requests as you can clicking many times search (magnifier) button. Change the requests choosing different filters, like entering some strings or choosing different categories like "Backpack & travel" or "Lighting & Electronics".
3-After some time executing this queries, check the usage of the server machine (step 0): Many postgres processes that will not finish have been created. Even after login out with all terminals, those processes are still there.
TagsNo tags attached.
Attached Filespng file icon TopFromHighVol.png [^] (180,570 bytes) 2016-02-03 13:26

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0035646 closedmario_castello Click several times in Gift cards selector is allowed in hgvol 

-  Notes
(0084233)
hgbot (developer)
2016-02-16 11:00

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: a6b0049355bc8017a187fcb109be34a944dac695
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue Feb 16 10:50:16 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a6b0049355bc8017a187fcb109be34a944dac695 [^]

Fixed issue 32104 improved hqlcriterias query performance

improved hqlcriterias query performance using 'exist' instead of 'in'
in the subqueries.

---
M src/org/openbravo/retail/posterminal/BrandChHQLCriteria.java
M src/org/openbravo/retail/posterminal/BrandChValueHQLCriteria.java
M src/org/openbravo/retail/posterminal/BrandProductHQLCriteria.java
M src/org/openbravo/retail/posterminal/PCharacteristicHQLCriteria.java
M src/org/openbravo/retail/posterminal/ProductCharacteristicHQLCriteria.java
---
(0084250)
mtaal (viewer)
2016-02-16 14:03

 Not sure if it is related to the changes of this issue, but characteristic search has an issue:
- the list of available char values is not filtered anymore based on the list of valid products in the current search set.
- also the values of different characteristics are now used as an or filter on product search. For example if I select battery 20h I see 3 products, when I then also set material Aluminium I see many more products.

gr. Martin
(0084327)
Sandrahuguet (viewer)
2016-02-18 17:19

 not related with this changes, a new issue has been reported: https://issues.openbravo.com/view.php?id=32279 [^]
(0084359)
hgbot (developer)
2016-02-19 12:18

 Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 4a5588e09d63a4f647a45781ef94e6984c719008
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri Feb 19 12:06:52 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/4a5588e09d63a4f647a45781ef94e6984c719008 [^]

related to issue 32104 prevent unnecessary characteristic request

---
M web/org.openbravo.mobile.core/source/retail/component/ob-retail-searchproductcharacteristic.js
---
(0084385)
mtaal (viewer)
2016-02-22 09:21

 Reviewed, found issue is solved as separate mantis ticket

- Issue History
Date Modified Username Field Change
2016-02-03 13:26 lorenzofidalgo New Issue
2016-02-03 13:26 lorenzofidalgo Assigned To => Retail
2016-02-03 13:26 lorenzofidalgo File Added: TopFromHighVol.png
2016-02-03 13:26 lorenzofidalgo OBNetwork customer => No
2016-02-03 13:26 lorenzofidalgo Triggers an Emergency Pack => No
2016-02-03 13:26 lorenzofidalgo Steps to Reproduce Updated View Revisions
2016-02-03 13:26 lorenzofidalgo Reproducibility sometimes => always
2016-02-03 13:52 mtaal Assigned To Retail => Sandrahuguet
2016-02-16 10:50 Sandrahuguet Review Assigned To => mtaal
2016-02-16 10:50 Sandrahuguet Status new => scheduled
2016-02-16 11:00 hgbot Checkin
2016-02-16 11:00 hgbot Note Added: 0084233
2016-02-16 11:00 hgbot Status scheduled => resolved
2016-02-16 11:00 hgbot Resolution open => fixed
2016-02-16 11:00 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a6b0049355bc8017a187fcb109be34a944dac695 [^]
2016-02-16 14:03 mtaal Note Added: 0084250
2016-02-16 14:03 mtaal Status resolved => new
2016-02-16 14:03 mtaal Resolution fixed => open
2016-02-18 17:19 Sandrahuguet Note Added: 0084327
2016-02-18 17:19 Sandrahuguet Status new => scheduled
2016-02-19 12:18 hgbot Checkin
2016-02-19 12:18 hgbot Note Added: 0084359
2016-02-19 12:22 Sandrahuguet Status scheduled => resolved
2016-02-19 12:22 Sandrahuguet Resolution open => fixed
2016-02-22 09:21 mtaal Note Added: 0084385
2016-02-22 09:21 mtaal Status resolved => closed
2016-02-22 09:21 mtaal Fixed in Version => RR16Q2
2017-03-30 11:10 Sandrahuguet Relationship added related to 0035646

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker