Memory leak in ASP.NET pages showing a gridView accessing FirebirdSql.Data.FirebirdClient.dll

[Mark-418]

I have a memory leak issue.  I have two ASP.NET pages that just have a timer
that updates a label.  One page also has a gridView that shows a little
data.

The page with just the label stays at a set memory usage.  The page with the
GridView keeps slowly taking more and more memory.  On Server 2003 it will
eventually take up so much memory that IIS stops serving the page.  I get
the same issue on XP but have not let it run until it ran out of memory.

I have tried it with firebird 2.0 and updated to the latest release.  I had
FirebirdSql.Data.FirebirdClient.dll 2.1.0.0 and updated to the latest
release (2.5.0.0).  I am using Delphi 2007 to build the Asp.net pages.  I
have tried it on Win Server 2003 and XP.

Does anyone have any ideas on what I might be doing wrong?

Thanks,

Mark Bentley



-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Mercea Paul]

> I have a memory leak issue.  I have two ASP.NET pages that just have a
> timer
> that updates a label.  One page also has a gridView that shows a little
> data.
>
> The page with just the label stays at a set memory usage.  The page
> with the
> GridView keeps slowly taking more and more memory.  On Server 2003 it
> will
> eventually take up so much memory that IIS stops serving the page.  I
> get
> the same issue on XP but have not let it run until it ran out of
> memory.
>

[PM] What process consume the memory? IIS? FbServer?

Regards,
Paul



-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Mark-418]

Sorry about that.  On XP, the process is named "aspnet_wp.exe" and on
Windows Server 2003 it is "w3wp.exe".  Basically it is the task handling the
ASP.NET.  However, it only happens when I access the firebird database.

Thanks,

Mark

""Mercea Paul"" <paul.mercea@...> wrote in message
news:!&!AAAAAAAAAAAYAAAAAAAAACOM/cOGjJ1HlJWkT080kT/CgAAAEAAAAL2nuLEazMBMu/6zrdzBB0UBAAAAAA==@......

>> I have a memory leak issue.  I have two ASP.NET pages that just have a
>> timer
>> that updates a label.  One page also has a gridView that shows a little
>> data.
>>
>> The page with just the label stays at a set memory usage.  The page
>> with the
>> GridView keeps slowly taking more and more memory.  On Server 2003 it
>> will
>> eventually take up so much memory that IIS stops serving the page.  I
>> get
>> the same issue on XP but have not let it run until it ran out of
>> memory.
>>
>
> [PM] What process consume the memory? IIS? FbServer?
>
> Regards,
> Paul
>
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the
> world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider@...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Carlos Guzmán Álvarez ™]

Hello:

Sorry about that.  On XP, the process is named "aspnet_wp.exe" and on
Windows Server 2003 it is "w3wp.exe".  Basically it is the task handling the
ASP.NET.  However, it only happens when I access the firebird database.

Are you calling Dispose on all provider instances if classes classes that are implementing IDisposable ?? ( like FbCommand )
 

--
Carlos Guzmán Álvarez
Vigo-Spain

http://carlosga.wordpress.com

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Mercea Paul]

 
> Sorry about that.  On XP, the process is named "aspnet_wp.exe" and on
> Windows Server 2003 it is "w3wp.exe".  Basically it is the task
> handling the
> ASP.NET.  However, it only happens when I access the firebird database.
>
 [PM] Can you try to open your connection before execution and close your
connection after you finish to execute the commands?
See after that if the memory remain on same values or go down!

Regards,
Paul



-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider