Yep that seems to have worked.<div><br></div><div>To recap I was using the luasql.mysql library, and have moved to using freeswitch.Dbh using the mysql "_r" thread safe odbc driver with unixodbc.</div><div><br></div>
<div>Thanks everyone for your help.</div><div><br></div><div>Pete<br><br><div class="gmail_quote">On 15 March 2011 14:30, Pete Kelly <span dir="ltr"><<a href="mailto:pkelly@gmail.com">pkelly@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">I have gone with Freeswitch's inbuilt odbc implementation, and I have the _r libs in use for the drivers.<div><br>
</div><div>Fingers crossed it helps matters, should know in a few days.<div><div></div><div class="h5"><br><br><div class="gmail_quote">
On 14 March 2011 16:25, Anthony Minessale <span dir="ltr"><<a href="mailto:anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
also make sure to use the _r version of any libs you use such as<br>
myodbc or mysqlclient<br>
<br>
look in /etc/odbcinst.ini and chances are its not the _r one<br>
<br>
# Driver from the MyODBC package<br>
# Setup from the unixODBC package<br>
[MySQL]<br>
Description = ODBC for MySQL<br>
Driver = /usr/lib64/libmyodbc3.so<br>
Setup = /usr/lib64/libodbcmyS.so<br>
FileUsage = 1<br>
<br>
<br>
/usr/lib64/libmyodbc3.so needs to be /usr/lib64/libmyodbc3_r.so<br>
<div><div></div><div><br>
<br>
<br>
<br>
On Mon, Mar 14, 2011 at 10:27 AM, Steven Ayre <<a href="mailto:steveayre@gmail.com" target="_blank">steveayre@gmail.com</a>> wrote:<br>
> Try using the freeswitch.Dbh interface:<br>
> <a href="http://wiki.freeswitch.org/wiki/Lua_freeswitch_dbh" target="_blank">http://wiki.freeswitch.org/wiki/Lua_freeswitch_dbh</a><br>
> It gives you a ODBC interface through freeswitch's odbc support, plus you<br>
> get the benefit of the connection caching.<br>
> -Steve<br>
><br>
><br>
> On 14 March 2011 14:28, Pete Kelly <<a href="mailto:pkelly@gmail.com" target="_blank">pkelly@gmail.com</a>> wrote:<br>
>><br>
>><br>
>> On 14 March 2011 13:16, Steven Ayre <<a href="mailto:steveayre@gmail.com" target="_blank">steveayre@gmail.com</a>> wrote:<br>
>>><br>
>>> If you use mod_lcr, we were getting a memory leak in that a few weeks ago<br>
>>> which is fixed in the latest git.<br>
>><br>
>> No we are not. I am going to try strengthening up the code which closes<br>
>> the DB connections. If that fails then I will compile and try the ODBC<br>
>> driver.<br>
>><br>
>>><br>
>>> -Steve<br>
>>><br>
>>> On 14 March 2011 09:30, Pete Kelly <<a href="mailto:pkelly@gmail.com" target="_blank">pkelly@gmail.com</a>> wrote:<br>
>>>><br>
>>>> Hi<br>
>>>> We are using Freeswitch (from git sources) in a production environment<br>
>>>> to handle an IVR system using a simple set of dialplans and lua scripts.<br>
>>>> OpenSIPS 1.6 and mysql are also installed and running as part of the same<br>
>>>> IVR application.<br>
>>>> However over time (approx 1 week) the memory usage of Freeswitch<br>
>>>> increases, eventually creeping into swap space forcing us to restart<br>
>>>> Freeswitch. The IVR handles approx 40 concurrent calls constantly, and we<br>
>>>> have instances of the IVR running on a 32bit Etch and 64bit Lenny boxes -<br>
>>>> both exhibit the same issue.<br>
>>>> We have also tried the Sangoma freeswitch branch in case that contained<br>
>>>> any fixes, however we see the same issues.<br>
>>>> Can anybody advise if this is a known issue with Freeswitch? Is it a<br>
>>>> memory leak or is it possible to limit the amount of memory Freeswitch will<br>
>>>> use, forcing it to garbage collect when it reaches the limit?<br>
>>>> Any advice on where to look/debug next would be appreciated.<br>
>>>> Thanks<br>
>>>> Pete<br>
>>>><br>
>>>><br>
>>>> _______________________________________________<br>
>>>> FreeSWITCH-users mailing list<br>
>>>> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
>>>> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>>>> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>>>> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>>>><br>
>>><br>
>>><br>
>>> _______________________________________________<br>
>>> FreeSWITCH-users mailing list<br>
>>> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
>>> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>>> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>>> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>>><br>
>><br>
>><br>
>> _______________________________________________<br>
>> FreeSWITCH-users mailing list<br>
>> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>><br>
><br>
><br>
> _______________________________________________<br>
> FreeSWITCH-users mailing list<br>
> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
><br>
<br>
<br>
<br>
</div></div>--<br>
Anthony Minessale II<br>
<br>
FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>
ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>
Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br>
<br>
AIM: anthm<br>
<a href="mailto:MSN%3Aanthony_minessale@hotmail.com" target="_blank">MSN:anthony_minessale@hotmail.com</a><br>
GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
<br>
FreeSWITCH Developer Conference<br>
<a href="mailto:sip%3A888@conference.freeswitch.org" target="_blank">sip:888@conference.freeswitch.org</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">googletalk:conf+888@conference.freeswitch.org</a><br>
pstn:+19193869900<br>
<div><div></div><div><br>
_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div>