Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034440Retail ModulesWeb POSpublic2016-11-09 09:502017-03-02 21:26
Reporterlorenzofidalgo 
Assigned Tomario_castello 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionmain 
Target VersionFixed in VersionRR17Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034440: [RR16Q4][HighVol] Click several times in Layaways search button and/or in SEARCH search button creates heavy postgres processes
DescriptionWhen POS user clicks in the magnifier button (search) from areas like SEARCH or Layaways, it creates several heavy processes that take very long time to finish (or they just do not finish). It induces the POS gets stuck.
This issue has been reproduced in a RR16Q4 release with Store Server and HighVol. This behaviour can been appreciated in the following video: https://drive.google.com/open?id=0Bz1bUfkEffVISURjYm5DbEV6NkU [^]
Steps To Reproduce0-Log in to the server machine and use "top" command to control the CPU usage of the server machine.
1-Go to SEARCH tab and click several times (e.g. 6 times) in Search button. Now go to dropdown menu, select Layaways option and click several times (e.g. 6 times) in search button. It will get stuck. You can go again to SEARCH tab and click again in search button. Check it is stuck and no results are shown.
3-Check the usage of the server machine (step 0): Many postgres processes that will not finish have been created. Even after login out those processes are still there. You can eve wait some time after executing this queries and check those postgres processes are still running.
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0034041 closed mario_castello [SER QA 1773] Modals dialogs show *Loading* and *No results* simultaneously if the query is slow 
depends on backport 0035412RR17Q1 closed mario_castello [RR16Q4][HighVol] Click several times in Layaways search button and/or in SEARCH search button creates heavy postgres processes 
has duplicate design defect 0032099 closed Sandrahuguet [RR16Q1] It is possible to jam the search of products clicking in the magnifier. It should be disabled while POS is searching 
related to defect 0035624 closed mario_castello Refactor some code in mobile.core and posterminal modules 
related to defect 0035646 closed mario_castello Click several times in Gift cards selector is allowed in hgvol 
Attached Filespng HeavyPostgresProcessesTop.png (148,487) 2016-11-09 09:50
https://issues.openbravo.com/file_download.php?file_id=10026&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2016-11-09 09:50lorenzofidalgoNew Issue
2016-11-09 09:50lorenzofidalgoAssigned To => Retail
2016-11-09 09:50lorenzofidalgoFile Added: HeavyPostgresProcessesTop.png
2016-11-09 09:50lorenzofidalgoOBNetwork customer => No
2016-11-09 09:50lorenzofidalgoTriggers an Emergency Pack => No
2016-11-09 09:53lorenzofidalgoDescription Updatedbug_revision_view_page.php?rev_id=13575#r13575
2016-11-09 10:01lorenzofidalgoPriorityhigh => normal
2016-11-09 10:33lorenzofidalgoSummary[RR16Q4][HighVol] Click several times in Layaways search button and/or in Browse search button creates heavy postgres processes => [RR16Q4][HighVol] Click several times in Layaways search button and/or in SEARCH search button creates heavy postgres processes
2016-11-09 10:33lorenzofidalgoDescription Updatedbug_revision_view_page.php?rev_id=13583#r13583
2016-11-09 10:33lorenzofidalgoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=13585#r13585
2017-01-11 16:02mario_castelloAssigned ToRetail => mario_castello
2017-01-11 16:03mario_castelloStatusnew => acknowledged
2017-01-11 18:13mario_castelloStatusacknowledged => scheduled
2017-01-11 18:33mario_castelloRelationship addedrelated to 0034041
2017-01-11 22:14hgbotCheckin
2017-01-11 22:14hgbotNote Added: 0093375
2017-01-11 22:14hgbotStatusscheduled => resolved
2017-01-11 22:14hgbotResolutionopen => fixed
2017-01-11 22:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/022f718665ebf2066eb684e6707e6191e72b8e9c [^]
2017-01-12 09:08hgbotCheckin
2017-01-12 09:08hgbotNote Added: 0093376
2017-01-12 13:14jorge-garciaNote Added: 0093389
2017-01-12 13:14jorge-garciaStatusresolved => new
2017-01-12 13:14jorge-garciaResolutionfixed => open
2017-01-12 14:37mario_castelloStatusnew => acknowledged
2017-01-12 14:38mario_castelloStatusacknowledged => scheduled
2017-01-16 14:40hgbotCheckin
2017-01-16 14:40hgbotNote Added: 0093592
2017-01-16 14:40hgbotStatusscheduled => resolved
2017-01-16 14:40hgbotResolutionopen => fixed
2017-01-16 14:40hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/022f718665ebf2066eb684e6707e6191e72b8e9c [^] => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/930ff2f4e112e0965c9c95b935dce93a277e121d [^]
2017-01-16 14:40hgbotCheckin
2017-01-16 14:40hgbotNote Added: 0093593
2017-01-25 10:20marvintmReview Assigned To => marvintm
2017-01-25 10:20marvintmStatusresolved => closed
2017-01-25 10:20marvintmFixed in Version => RR17Q2
2017-01-31 15:35lorenzofidalgoNote Added: 0093960
2017-01-31 15:35lorenzofidalgoStatusclosed => new
2017-01-31 15:35lorenzofidalgoResolutionfixed => open
2017-01-31 15:35lorenzofidalgoFixed in VersionRR17Q2 =>
2017-01-31 15:51mario_castelloStatusnew => acknowledged
2017-01-31 15:51mario_castelloStatusacknowledged => scheduled
2017-02-06 14:35hgbotCheckin
2017-02-06 14:35hgbotNote Added: 0094086
2017-02-06 14:35hgbotStatusscheduled => resolved
2017-02-06 14:35hgbotResolutionopen => fixed
2017-02-06 14:35hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/930ff2f4e112e0965c9c95b935dce93a277e121d [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a2699d1a752d30819f1c4216eb7698e78e6e25c2 [^]
2017-02-06 14:36hgbotCheckin
2017-02-06 14:36hgbotNote Added: 0094087
2017-02-08 09:28marvintmStatusresolved => closed
2017-02-08 09:28marvintmFixed in Version => RR17Q2
2017-03-02 16:41shuehnerTag Attached: Performance
2017-03-02 16:45marvintmStatusclosed => new
2017-03-02 16:45marvintmResolutionfixed => open
2017-03-02 16:45marvintmFixed in VersionRR17Q2 =>
2017-03-02 16:45marvintmStatusnew => scheduled
2017-03-02 16:45marvintmStatusscheduled => resolved
2017-03-02 16:45marvintmFixed in Version => RR17Q2
2017-03-02 16:45marvintmResolutionopen => fixed
2017-03-02 16:45marvintmStatusresolved => closed
2017-03-02 21:19hgbotCheckin
2017-03-02 21:19hgbotNote Added: 0094701
2017-03-02 21:26hgbotCheckin
2017-03-02 21:26hgbotNote Added: 0094704
2017-03-07 10:35marvintmRelationship addedhas duplicate 0032099
2017-03-27 16:46mario_castelloRelationship addedrelated to 0035624
2017-03-31 17:16mario_castelloRelationship addedrelated to 0035646

Notes
(0093375)
hgbot   
2017-01-11 22:14   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 022f718665ebf2066eb684e6707e6191e72b8e9c
Author: Mario Castello <mario.castello <at> peoplewalking.com>
Date: Wed Jan 11 11:16:35 2017 -0600
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/022f718665ebf2066eb684e6707e6191e72b8e9c [^]

Fixed issue 34440: Click several times in Layaways search button and/or in SEARCH search button creates heavy postgres processes

- Added new function disableFilterButtons to disable the filters buttons
- Added name for filters buttons
- Call the function in the search process for disabled/enabled the filters buttons during the execution process

---
M web/org.openbravo.mobile.core/source/retail/component/ob-retail-searchproductcharacteristic.js
---
(0093376)
hgbot   
2017-01-12 09:08   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 8bd8db795fa59aeb1cb73218a0cf3441cbf1b185
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Thu Jan 12 08:52:35 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/8bd8db795fa59aeb1cb73218a0cf3441cbf1b185 [^]

Related to issue 34440: Click several times in Layaways search button and/or in SEARCH search button creates heavy postgres processes

Backed out changeset 022f718665eb

---
M web/org.openbravo.mobile.core/source/retail/component/ob-retail-searchproductcharacteristic.js
---
(0093389)
jorge-garcia   
2017-01-12 13:14   
Critical error in the integration of try-retail. Backout done
(0093592)
hgbot   
2017-01-16 14:40   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 930ff2f4e112e0965c9c95b935dce93a277e121d
Author: Mario Castello <mario.castello <at> peoplewalking.com>
Date: Wed Jan 11 11:16:35 2017 -0600
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/930ff2f4e112e0965c9c95b935dce93a277e121d [^]

Fixed issue 34440: Click several times in Layaways search button and/or in SEARCH search button creates heavy postgres processes

- Added new function disableFilterButtons to disable the filters buttons
- Added name for filters buttons
- Call the function in the search process for disabled/enabled the filters buttons during the execution process

---
M web/org.openbravo.mobile.core/source/retail/component/ob-retail-searchproductcharacteristic.js
---
(0093593)
hgbot   
2017-01-16 14:40   
Repository: tools/automation/pi-mobile
Changeset: f818ac500fca04409b0f4fd8a91b2a7fe01e603e
Author: Mario Castello <mario.castello <at> peoplewalking.com>
Date: Wed Jan 11 11:14:18 2017 -0600
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/f818ac500fca04409b0f4fd8a91b2a7fe01e603e [^]

Verifies issue 34440: Fixed names of filters buttons in search panel

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/TestIdPack.java
---
(0093960)
lorenzofidalgo   
2017-01-31 15:35   
This issue is still reproducible using the "Pay Open Tickets" search button.
(0094086)
hgbot   
2017-02-06 14:35   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: a2699d1a752d30819f1c4216eb7698e78e6e25c2
Author: Mario Castello <mario.castello <at> peoplewalking.com>
Date: Tue Jan 31 10:28:50 2017 -0600
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a2699d1a752d30819f1c4216eb7698e78e6e25c2 [^]

Fixed issue 34440: Click several times in Pay Open Tickets search button creates heavy postgres processes

- Pay Open Tickets popup
- Added new function disableFilterButtons to disable the filters buttons
- Added name for filters buttons
- Call the function in the search process for disabled/enabled the filters buttons during the execution process

---
M web/org.openbravo.retail.posterminal/js/components/modalmultiorders.js
---
(0094087)
hgbot   
2017-02-06 14:36   
Repository: tools/automation/pi-mobile
Changeset: 7cc3283e1ce34453d150cbb6f000ff346d460dd0
Author: Mario Castello <mario.castello <at> peoplewalking.com>
Date: Tue Jan 31 10:41:43 2017 -0600
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/7cc3283e1ce34453d150cbb6f000ff346d460dd0 [^]

Verifies issue 34440: Fixed names of filters buttons in Pay Open Tickets popup

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/TestIdPack.java
---
(0094701)
hgbot   
2017-03-02 21:19   
Repository: retail/backports/3.0RR17Q1/org.openbravo.mobile.core
Changeset: 90f1940fdbae6e0e490e7be58d343a3d585d16aa
Author: Mario Castello <mario.castello <at> peoplewalking.com>
Date: Wed Jan 11 11:16:35 2017 -0600
URL: http://code.openbravo.com/retail/backports/3.0RR17Q1/org.openbravo.mobile.core/rev/90f1940fdbae6e0e490e7be58d343a3d585d16aa [^]

Fixed issue 35412, backport of issue 34440: Click several times in Layaways search button and/or in SEARCH search button creates heavy postgres processes

- Added new function disableFilterButtons to disable the filters buttons
- Added name for filters buttons
- Call the function in the search process for disabled/enabled the filters buttons during the execution process

---
M web/org.openbravo.mobile.core/source/retail/component/ob-retail-searchproductcharacteristic.js
---
(0094704)
hgbot   
2017-03-02 21:26   
Repository: retail/backports/3.0RR17Q1/org.openbravo.retail.posterminal
Changeset: 4a74cb1d7d17a7ce5e95f175e047d28052f09cdc
Author: Mario Castello <mario.castello <at> peoplewalking.com>
Date: Tue Jan 31 10:28:50 2017 -0600
URL: http://code.openbravo.com/retail/backports/3.0RR17Q1/org.openbravo.retail.posterminal/rev/4a74cb1d7d17a7ce5e95f175e047d28052f09cdc [^]

Fixed issue 35412, backport of issue 34440: Click several times in Pay Open Tickets search button creates heavy postgres processes

- Pay Open Tickets popup
- Added new function disableFilterButtons to disable the filters buttons
- Added name for filters buttons
- Call the function in the search process for disabled/enabled the filters buttons during the execution process

---
M web/org.openbravo.retail.posterminal/js/components/modalmultiorders.js
---