[kepler-dev] [Bug 5254] New: provenance database connections keep growing when using Reporting suite.

[bugzilla-daemon at ecoinformatics.org]

http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5254

           Summary: provenance database connections keep growing when
                    using Reporting suite.
           Product: Kepler
           Version: 2.1.0
          Platform: Other
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: reporting
        AssignedTo: barseghian at nceas.ucsb.edu
        ReportedBy: jianwu at sdsc.edu
         QAContact: kepler-dev at kepler-project.org
            Blocks: 5095
   Estimated Hours: 0.0


Every time a window is open, or a workflow is saved, running, a separate db
connection is gotten. but they are not released when a window is closed. It
will cause memory usage goes up.

We guess WorkflowRunManager.disconnect() should call SQLQueryV8.disconnect() to
close the connection. Currently, SQLQueryV8.disconnect() is not called by any
classes.

If we can reuse existing connections. The performance will be better than
creating and closing a new one.

This is one stack trace for db connection when a window is open:

DatabaseFactory.getConnectedDatabaseType(Map<String,String>, String) line: 154  
SQLQueryV8.<init>(Map<String,String>) line: 77    
WorkflowRunManager.connect() line: 135    
WorkflowRunManagerPanel.reconnect() line: 960    
WorkflowRunManagerPanel.resetProvenanceInfo(ProvenanceStore) line: 937    
WorkflowRunManagerPanel.initializeTab() line: 231    
TabPaneFactory.createTabPaneTabs(TableauFrame) line: 110    
TabManager.initializeTabs(TableauFrame) line: 87    
KeplerGraphFrame._initBasicGraphFrame() line: 377    
KeplerGraphFrame(BasicGraphFrame).<init>(NamedObj, Tableau, LibraryAttribute)
line: 224    
KeplerGraphFrame(ExtendedGraphFrame).<init>(CompositeEntity, Tableau,
LibraryAttribute) line: 95    
KeplerGraphFrame(ActorGraphFrame).<init>(CompositeEntity, Tableau,
LibraryAttribute) line: 135    
KeplerGraphFrame.<init>(CompositeEntity, Tableau, LibraryAttribute) line: 180   
KeplerGraphTableau.<init>(PtolemyEffigy, String, LibraryAttribute) line: 164    
KeplerGraphTableau$Factory.createTableau(Effigy) line: 227    
PtolemyTableauFactory.createTableau(Effigy) line: 100    
TableauFactory.createTableau(Effigy) line: 127    
Configuration.createPrimaryTableau(Effigy) line: 569    
TableauFrame$1.actionPerformed(ActionEvent) line: 519

-- 
Configure bugmail: http://bugzilla.ecoinformatics.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.