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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0033643
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Retail Modules] StoreServerminorhave not tried2016-08-07 10:292016-09-14 11:26
ReportermtaalView Statuspublic 
Assigned Tomtaal 
PrioritynormalResolutionfixedFixed in VersionRR16Q4
StatusclosedFix in branchFixed in SCM revision46b650105936
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToSandrahuguet
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033643: Too many reads of mobile server definition during standard webpos request

DescriptionDoing a standard webpos request to the server (for example to read products) results in many queries for the same mobile server definition (for the central or current store server). For example see the call stack here [1] which was reported to be called 16 times during one request. Although hibernate should cache the object still many requests seem to be done.


        at org.openbravo.dal.service.OBDal.get(OBDal.java:298)
        at org.openbravo.mobile.core.servercontroller.MobileServerController.getThisServerDefinition(MobileServerController.java:311)
        at org.openbravo.mobile.core.servercontroller.MobileServerController.serverHasTransitioningStatus(MobileServerController.java:283)
Steps To ReproducePreferably install multi-server but it also shows up for non-multi-server
Enable sql logging
Log into webpos
Proposed SolutionCache common values such as the current server offline/online state, the same for the central server
TagsNo tags attached.
Attached Filesdiff file icon 33643.diff [^] (13,201 bytes) 2016-08-07 10:30 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0089833)
hgbot (developer)
2016-09-08 10:00

Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 46b650105936a4001c6409a74b517c4b65e8173c
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Thu Sep 08 09:57:56 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/46b650105936a4001c6409a74b517c4b65e8173c [^]

Fixes issue 33643: Too many reads of mobile server definition during standard webpos request
Cache some information to prevent reads, read only status instead of full object

Note: reads of mobileserverdefinition can't be prevented as the system needs to read latest
status of a server from the db

---
M src/org/openbravo/mobile/core/servercontroller/MobileServerController.java
---
(0089946)
Sandrahuguet (developer)
2016-09-14 11:26

Reviewed and tested

- Issue History
Date Modified Username Field Change
2016-08-07 10:29 mtaal New Issue
2016-08-07 10:29 mtaal Assigned To => mtaal
2016-08-07 10:29 mtaal Triggers an Emergency Pack => No
2016-08-07 10:30 mtaal File Added: 33643.diff
2016-08-08 09:28 shuehner Issue Monitored: shuehner
2016-08-31 01:16 mtaal Target Version RR16Q4 => RR17Q1
2016-08-31 01:16 mtaal Target Version RR17Q1 =>
2016-09-08 10:00 hgbot Checkin
2016-09-08 10:00 hgbot Note Added: 0089833
2016-09-08 10:00 hgbot Status new => resolved
2016-09-08 10:00 hgbot Resolution open => fixed
2016-09-08 10:00 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/46b650105936a4001c6409a74b517c4b65e8173c [^]
2016-09-08 10:07 mtaal Review Assigned To => Sandrahuguet
2016-09-14 11:26 Sandrahuguet Note Added: 0089946
2016-09-14 11:26 Sandrahuguet Status resolved => closed
2016-09-14 11:26 Sandrahuguet Fixed in Version => RR16Q4


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker