memory leak - module did not release 208 resources

[Anon...@sybase.com]

We have noticed that every time dbsrv50 is unloaded from the server (
unload dbsrv50 ) that not all of the memory resources are being
released. Do you know of a fix or procedure we could do to allow
sqlanywhere to release all resources?

We unload sqlanywhere twice a day and over time this causes memory
leaks on our servers. The current version of sqlanywhere we are running is
sqlanywhere 5.5.02 Build # 1495 on netware 4.11

Below is sample messages from the log file:

Loading module DBSRV50.NLM
Sybase SQL Anywhere Network Server Version 5.5.02 Build #1495
Copyright by Sybase, Inc., 1988-1995. All rights reserved.
Auto-loading module DBEXTF50.NLM
dbextf50.nlm

7-27-00 5:16:06 am: SERVER-4.11-2715
Module did not release 208 resources
Module: Sybase SQL Anywhere Network Server
Resource: Small Memory Allocations
Description: Alloc Memory (Bytes)

7-27-00 9:00:06 pm: SERVER-4.11-2715
Module did not release 192 resources
Module: Sybase SQL Anywhere Network Server
Resource: Small Memory Allocations
Description: Alloc Memory (Bytes)

Please also send response to rober...@ca.pwcglobal.com

Thanks,
Rob

[Reg Domaratzki]

We have fixed many memory leaks in the engine in the last 4 years (that's
when 5502 was released). I would suggest downloading the v5505 maintenance
release and the latest 5505 ebf from the link in my signature.

--
Reg Domaratzki
Sybase iAnywhere Solutions
Please reply only to the newsgroup

ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

<Anon...@sybase.com> wrote in message
news:CB0351EB386DB2600063C3C385256942.0063C3D885256942@webforums...

[Jim Egan]

On 3.12 the memory leak was a killer. Supposedly on 4.x+ the leaks get
cleaned up. Is that not correct? (I was an admin on 3.12 but no longer
had to do that when 4 came out)

Having said that, can you explain why you have to shut down the database
server twice a day? To perform backups there is no need to shut it down
at all. In fact, I usually try to avoid shutting it down at all. There
are a number of different ways to do this if you are interested.
--
Jim Egan [TeamSybase]
Houston, TX
http://www.eganomics.com

Sybase Developers Network
http://sdn.sybase.com/sdn/mec/mec_home.stm

[Reg Domaratzki]

I think that a garbage collector runs every 15 minutes on Netware 4.x and
above that re-allocates lost memory.

--
Reg Domaratzki
Sybase iAnywhere Solutions
Please reply only to the newsgroup

ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio

-> Set "Platform Preview" and "Time Frame" to ALL and click "GO"

"Jim Egan" <dba...@eganomics.com> wrote in message
news:MPG.140b9bda1...@199.93.177.77...