Summary:	ASTERISK-10104: Memory leak when ODBC used for voicemail storage
Reporter:	Nick Barnes (bcnit)	Labels:
Date Opened:	2007-08-17 08:47:17	Date Closed:	2007-08-18 09:18:20
Priority:	Major	Regression?	No
Status:	Closed/Complete	Components:	Applications/app_voicemail
Versions:		Frequency of Occurrence
Related Issues:
Environment:		Attachments:
Description:	Using odbc for voicemail storage works perfectly, but results in Asterisk grabbing approximately 450kb/min of memory. Commenting out the  odbcstorage=  odbctable= lines in voicemail.conf and then restarting Asterisk results in no memory grabbing and (apart from the lack of voicemail), a perfectly stable Asterisk. An interesting aside is that when the memory usage gets really high (I saw this at 80%), SIP peers start disappearing - 'sip show peers' shows less and less devices (that's not that it shows more as 'UNREACHABLE' - they just disappear from the list completely). ****** ADDITIONAL INFORMATION ****** Sorry, but I don't know where to start with this - I can provide copies of voicemail.conf, SQL dumps of the database etc., but I'm not sure what will help and what won't.
Comments:	By: Tilghman Lesher (tilghman) 2007-08-17 11:01:37 What's the usage you have of voicemail? i.e. how many messages are typically left per minute, how often users check, how many phones on your system, etc. Also, do you leave VM to multiple mailboxes at once via your dialplan? By: Tilghman Lesher (tilghman) 2007-08-17 14:53:14 Also, what DB backend are you using? By: Digium Subversion (svnbot) 2007-08-18 09:12:50 Repository: asterisk Revision: 79947 ------------------------------------------------------------------------ r79947 | tilghman | 2007-08-18 09:12:50 -0500 (Sat, 18 Aug 2007) | 3 lines Don't allocate vmu for messagecount when we could just use the stack instead (closes issue ASTERISK-10114) Also, remove a useless (and leaky) SQLAllocHandle (closes issue ASTERISK-10104) ------------------------------------------------------------------------ By: Digium Subversion (svnbot) 2007-08-18 09:16:54 Repository: asterisk Revision: 79949 ------------------------------------------------------------------------ r79949 | tilghman | 2007-08-18 09:16:54 -0500 (Sat, 18 Aug 2007) | 11 lines Merged revisions 79947 via svnmerge from https://origsvn.digium.com/svn/asterisk/branches/1.4 ........ r79947 | tilghman | 2007-08-18 09:30:44 -0500 (Sat, 18 Aug 2007) | 3 lines Don't allocate vmu for messagecount when we could just use the stack instead (closes issue ASTERISK-10114) Also, remove a useless (and leaky) SQLAllocHandle (closes issue ASTERISK-10104) ........ ------------------------------------------------------------------------ By: Tilghman Lesher (tilghman) 2007-08-18 09:18:20 Please update to SVN branch 1.4 revision 79947 or later.  I have found an ODBC memory leak and fixed it in that revision.  If the leak is not solved with that revision, please reopen this bug and provide the requested information.