Consultor Eletrônico



Kbase P102789: Memory leak on _sqlsrv2 for Fathom\OpenEdge Management Trending Database
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   26/08/2009
Status: Verified

SYMPTOM(s):

_sqlsrv2 process consumming memory with updates.

_sqlsrv2 process grows until consumes all memory if 64-bit

_sqlsrv2 process terminates when it hits 2 gig of memory usage

_sqlsrv2 crashes database

Memory leak on _sqlsrv2 process

_sqlsrv2 process is connected to the Fathom Trend Database

_sqlsrv2 process is not freeing memory

FACT(s) (Environment):

UNIX
Windows
OpenEdge Management 3.x
OpenEdge 10.0x
OpenEdge 10.1A
OpenEdge 10.1B
OpenEdge 10.0B

CAUSE:

Bug# OE00125356

CAUSE:

The _sqlsrv2 process is not freeing memory allocated for cursor handles associated with SQL statements. The Trending Agent connect to the Fathom Trend Database using the JDBC driver. The JDBC driver is not sending the freecursor message.
This memory leak is particularly exploited by the types of constant updates done by the Fathom/OpenEdge Management Trending Agent.

FIX:

Upgrade to OpenEdge 10.1B01