Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032104Retail ModulesWeb POSpublic2016-02-03 13:262016-02-22 09:21
Reporterlorenzofidalgo 
Assigned ToSandrahuguet 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionmain 
Target VersionFixed in VersionRR16Q2 
Merge Request Status
Review Assigned Tomtaal
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032104: [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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0035646 closed mario_castello Click several times in Gift cards selector is allowed in hgvol 
Attached Filespng TopFromHighVol.png (180,570) 2016-02-03 13:26
https://issues.openbravo.com/file_download.php?file_id=9005&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2016-02-03 13:26lorenzofidalgoNew Issue
2016-02-03 13:26lorenzofidalgoAssigned To => Retail
2016-02-03 13:26lorenzofidalgoFile Added: TopFromHighVol.png
2016-02-03 13:26lorenzofidalgoTriggers an Emergency Pack => No
2016-02-03 13:26lorenzofidalgoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=10875#r10875
2016-02-03 13:26lorenzofidalgoReproducibilitysometimes => always
2016-02-03 13:52mtaalAssigned ToRetail => Sandrahuguet
2016-02-16 10:50SandrahuguetReview Assigned To => mtaal
2016-02-16 10:50SandrahuguetStatusnew => scheduled
2016-02-16 11:00hgbotCheckin
2016-02-16 11:00hgbotNote Added: 0084233
2016-02-16 11:00hgbotStatusscheduled => resolved
2016-02-16 11:00hgbotResolutionopen => fixed
2016-02-16 11:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a6b0049355bc8017a187fcb109be34a944dac695 [^]
2016-02-16 14:03mtaalNote Added: 0084250
2016-02-16 14:03mtaalStatusresolved => new
2016-02-16 14:03mtaalResolutionfixed => open
2016-02-18 17:19SandrahuguetNote Added: 0084327
2016-02-18 17:19SandrahuguetStatusnew => scheduled
2016-02-19 12:18hgbotCheckin
2016-02-19 12:18hgbotNote Added: 0084359
2016-02-19 12:22SandrahuguetStatusscheduled => resolved
2016-02-19 12:22SandrahuguetResolutionopen => fixed
2016-02-22 09:21mtaalNote Added: 0084385
2016-02-22 09:21mtaalStatusresolved => closed
2016-02-22 09:21mtaalFixed in Version => RR16Q2
2017-03-30 11:10SandrahuguetRelationship addedrelated to 0035646

Notes
(0084233)
hgbot   
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   
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   
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   
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   
2016-02-22 09:21   
Reviewed, found issue is solved as separate mantis ticket