dbTalk Databases Forums  

ASA11 - dbextclr11.exe memory is growing until system crash!

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss ASA11 - dbextclr11.exe memory is growing until system crash! in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
at
 
Posts: n/a

Default ASA11 - dbextclr11.exe memory is growing until system crash! - 09-08-2009 , 05:08 AM






I have written some procedures in C#. They are called from triggers,
stored procedures etc.

When processing some thousand records the dbextclr11.exe process (CLR
run in ASA) consumes more and more memory (on my machine almost 2 GB and
has 16826 open handles!!). Then the SQL Code, calling the external
procedure fails with an out of memeory exception.

It looks like the garbage collector or any dispose() is never called.
Any idea how this can be prevented??

Tom

Reply With Quote
  #2  
Old   
Karim Khamis [Sybase iAnywhere]
 
Posts: n/a

Default Re: ASA11 - dbextclr11.exe memory is growing until system crash! - 09-08-2009 , 08:22 AM






I believe this problem has been fixed in SA 11.0.1 build 2306 and the
fix will be available in the next SA 11.0.1 EBF.

Karim
at wrote:
Quote:
I have written some procedures in C#. They are called from triggers,
stored procedures etc.

When processing some thousand records the dbextclr11.exe process (CLR
run in ASA) consumes more and more memory (on my machine almost 2 GB and
has 16826 open handles!!). Then the SQL Code, calling the external
procedure fails with an out of memeory exception.

It looks like the garbage collector or any dispose() is never called.
Any idea how this can be prevented??

Tom

Reply With Quote
  #3  
Old   
at
 
Posts: n/a

Default Re: ASA11 - dbextclr11.exe memory is growing until system crash! - 09-08-2009 , 10:13 AM



Karim, thanks for that info. I currently run 2299 dated Aug 24th. Any
idea when the next fix is released?

Tom

Karim Khamis [Sybase iAnywhere] schrieb:
Quote:
I believe this problem has been fixed in SA 11.0.1 build 2306 and the
fix will be available in the next SA 11.0.1 EBF.

Karim

Reply With Quote
  #4  
Old   
Karim Khamis [Sybase iAnywhere]
 
Posts: n/a

Default Re: ASA11 - dbextclr11.exe memory is growing until system crash! - 09-08-2009 , 03:07 PM



Tom,

It all depends upon how the internal testing goes. Assuming testing goes
well, an EBF with the fix should be available in a few weeks.

Karim
at wrote:
Quote:
Karim, thanks for that info. I currently run 2299 dated Aug 24th. Any
idea when the next fix is released?

Tom

Karim Khamis [Sybase iAnywhere] schrieb:
I believe this problem has been fixed in SA 11.0.1 build 2306 and the
fix will be available in the next SA 11.0.1 EBF.

Karim

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.