Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035791Retail ModulesStoreServerpublic2017-04-18 11:412017-05-15 16:30
Reporterlorenzofidalgo 
Assigned ToAugustoMauch 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionmain 
Target VersionFixed in VersionRR17Q3 
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
Summary0035791: [RR17Q2][StoreServer][HighVol] Two "IDLE in transaction" processes appear just after restarting tomcat
DescriptionIn a RR17Q2 + Store Server+ HighVol context, just after restarting tomcat due to the machine went out of java memory, two 'IDLE in transaction' processes are shown. These processes are:
1) process id 4927 reading preferences
2) process id 4928 reading ad_org

The machine where this issue has been reproduced seems to be working ok except for those processes.
Steps To ReproduceN/A.
These 'IDLE in transaction' processes have appeared just after restarting tomcat in the aforementioned context. It is likely to be reproducible just restarting tomcat.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0035997RR17Q2.1 closed mtaal [RR17Q2][StoreServer][HighVol] Two "IDLE in transaction" processes appear just after restarting tomcat 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-04-18 11:41lorenzofidalgoNew Issue
2017-04-18 11:41lorenzofidalgoAssigned To => StoreServer
2017-04-18 11:41lorenzofidalgoTriggers an Emergency Pack => No
2017-04-24 11:58AugustoMauchAssigned ToStoreServer => AugustoMauch
2017-05-02 16:49hgbotCheckin
2017-05-02 16:49hgbotNote Added: 0096321
2017-05-02 16:53AugustoMauchReview Assigned To => mtaal
2017-05-02 16:55hgbotCheckin
2017-05-02 16:55hgbotNote Added: 0096322
2017-05-02 16:55hgbotStatusnew => resolved
2017-05-02 16:55hgbotResolutionopen => fixed
2017-05-02 16:55hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/bce9aa4440087952ec76f261163a111936059c9f [^]
2017-05-07 22:39mtaalNote Added: 0096440
2017-05-07 22:39mtaalStatusresolved => closed
2017-05-15 16:30mtaalNote Added: 0096606
2017-05-15 16:30mtaalStatusclosed => new
2017-05-15 16:30mtaalResolutionfixed => open
2017-05-15 16:30mtaalStatusnew => scheduled
2017-05-15 16:30mtaalStatusscheduled => resolved
2017-05-15 16:30mtaalFixed in Version => RR17Q3
2017-05-15 16:30mtaalResolutionopen => fixed
2017-05-15 16:30mtaalNote Added: 0096607
2017-05-15 16:30mtaalStatusresolved => closed

Notes
(0096321)
hgbot   
2017-05-02 16:49   
Repository: erp/pmods/org.openbravo.replication.symmetricds
Changeset: d3e746082b6f490a9e3687ddd12fb27cce8fc49e
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Tue May 02 16:48:30 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/d3e746082b6f490a9e3687ddd12fb27cce8fc49e [^]

Related with issue 35791: Fixes con leak in AbstractOrganizationBasedRouter

The AbstractOrganizationBasedRouter was missing a commitAndClose statement, that was already present in the analogous AbstractClientFilteredRouter. Both classes have gone through a small refactor to ensure that the commitAndClose is always executed in the finally block.

---
M src/org/openbravo/replication/symmetricds/extensions/AbstractClientFilteredRouter.java
M src/org/openbravo/replication/symmetricds/extensions/AbstractOrganizationBasedRouter.java
---
(0096322)
hgbot   
2017-05-02 16:55   
Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization
Changeset: bce9aa4440087952ec76f261163a111936059c9f
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Tue May 02 16:50:52 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/bce9aa4440087952ec76f261163a111936059c9f [^]

Fixes issue 35791: Fixes connection leak in StoreServerContextListener

The listener was missing a connectionAndClose statement. As it is not wrapped by a servlet filter, the connection is not closed automatically.

---
M src/org/openbravo/retail/storeserver/synchronization/StoreServerContextListener.java
---
(0096440)
mtaal   
2017-05-07 22:39   
Reviewed
(0096606)
mtaal   
2017-05-15 16:30   
change to new to create backport issue
(0096607)
mtaal   
2017-05-15 16:30   
closing again