Hi,

I've never seen memleaks on luasql using the following code:

Feel free to use it and modify/improve ;)

----------------------------------------------- mysql.lua -----------------------------------------------

require 'luasql.mysql'

DB = {}
DB.__index = DB

function DB.create()
        local db = {}
        setmetatable(db,DB)
        db.env = assert( luasql.mysql() )
        db.con = assert( db.env:connect('DB','USER','PASSWORD','HOST') )
        return db
end

function DB:query(query)
        local q,r = self.con:execute(query)
        if q == nil then
                return nil
        else
                return q
        end
end

function DB:fetch(cur)
        if (cur ~= nil) then
                return cur:fetch({},"a");
        else
                return nil;
        end
end

function DB:close()
        self.con:close()
        self.env:close()
end

----------------------------------------------- /mysql.lua -----------------------------------------------

Exemple usage ( in a global do ... end block to ensure no data is global and everything is destroyed ):

local db = DB.create();
local r = db:query("SELECT * FROM test");
local f = db:fetch(r);
db:close();

Le 14/03/2011 15:28, Pete Kelly a écrit :

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