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