[Kepler-Project] LuaSQL development status/financial assistance

2009-09-29 Thread Chad Phillips -- Apartment Lines
yes, i've actually already seen that documentation. the problem is that FreeSWITCH is controlling the thread, and my Lua script that leverages LuaSQL is being called by FreeSWITCH -- it obviously can't call pthread_exit() :) i did try recompiling LuaSQL itself and adding mysql_thread_end(

Re: [Kepler-Project] LuaSQL development status/financial assistance

2009-09-29 Thread Fabio Mascarenhas
Hi Chad, If you are using pthreads and the thread libmysqlclient then you need to call mysql_thread_end before you do pthread_exit, MySQL only does it for you on Win32... LuaSQL cannot call it because it has no idea what is the lifetime of your threads. See here: http://dev.mysql.com/doc/refman/5

[Kepler-Project] LuaSQL development status/financial assistance

2009-09-29 Thread Chad Phillips -- Apartment Lines
i wanted to add this to the discussion. it appears that there's an unresolved memory leak in libmysqlclient: http://bugs.mysql.com/bug.php?id=45002 unfortunately, my tests with libmysqlclient_r are even worse -- i'm not sure if that's because the LuaSQL code doesn't support libmysqlclient_r

Re: [Kepler-Project] LuaSQL development status/financial assistance

2009-09-27 Thread Chad Phillips -- Apartment Lines
On Sep 27, 2009, at 10:32 PM, gary ng wrote: the easiest is as you mentioned, tried to link with mysqlclient_r and see if it works. i've already been running it compiled w/ mysqlclient_r. i found this documentation related to using mysqlclient_r: "there is a special requirement by libmysql

Re: [Kepler-Project] LuaSQL development status/financial assistance

2009-09-27 Thread gary ng
. Not sure if you can do it in freeswitch though. --- On Mon, 9/28/09, Chad Phillips -- Apartment Lines wrote: > From: Chad Phillips -- Apartment Lines > Subject: [Kepler-Project] LuaSQL development status/financial assistance > To: "Kepler Project mailing list" > Date

[Kepler-Project] LuaSQL development status/financial assistance

2009-09-27 Thread Chad Phillips -- Apartment Lines
On Sep 27, 2009, at 9:56 PM, gary ng wrote: Does mod_lua create a new lua vm every time ? i've checked with one of the freeswitch devs, and his response was: "yeah, cus it's so small, a new one is created each time" I remembered I have encountered similar issue with mysql binding in the

Re: [Kepler-Project] LuaSQL development status/financial assistance

2009-09-27 Thread Chad Phillips -- Apartment Lines
On Sep 27, 2009, at 9:39 PM, Fabio Mascarenhas wrote: Hi Chad, Your script id doing everything correctly. This is extremely straightfoward code in LuaSQL, as you can see by looking at the source, and I doubt libmysqlclient, the library LuaSQL binds to, has a bug or leak on the triple mysql_init

Re: [Kepler-Project] LuaSQL development status/financial assistance

2009-09-27 Thread gary ng
, Chad Phillips -- Apartment Lines wrote: > From: Chad Phillips -- Apartment Lines > Subject: [Kepler-Project] LuaSQL development status/financial assistance > To: "Kepler Project mailing list" > Cc: "Scott Dunham" > Date: Monday, September 28, 2009, 8:51 AM >

Re: [Kepler-Project] LuaSQL development status/financial assistance

2009-09-27 Thread Fabio Mascarenhas
Hi Chad, Your script id doing everything correctly. This is extremely straightfoward code in LuaSQL, as you can see by looking at the source, and I doubt libmysqlclient, the library LuaSQL binds to, has a bug or leak on the triple mysql_init/mysql_real_connect/mysql_close. I think the LuaSQL probl

[Kepler-Project] LuaSQL development status/financial assistance

2009-09-27 Thread Chad Phillips -- Apartment Lines
On Sep 27, 2009, at 8:33 PM, Fabio Mascarenhas wrote: Hi Chad, It seems like your problem is not opening a connection for every request per se, but not closing these connections after you are done with them, which is triggering a resource leak. Could you provide more information about your set

Re: [Kepler-Project] LuaSQL development status/financial assistance

2009-09-27 Thread Fabio Mascarenhas
Hi Chad, It seems like your problem is not opening a connection for every request per se, but not closing these connections after you are done with them, which is triggering a resource leak. Could you provide more information about your setup: is it a web application, and if it is, what web server

[Kepler-Project] LuaSQL development status/financial assistance

2009-09-27 Thread Chad Phillips -- Apartment Lines
I'm opening and closing connections for every request -- I'm not sure if i can keep a persistent connection with my setup. Each phone call in FreeSWITCH runs in it's own thread, and Lua scripts are called at various points during the phone call. This script runs, talks to the database if

[Kepler-Project] LuaSQL development status/financial assistance

2009-09-27 Thread Chad Phillips -- Apartment Lines
Hi Jason, I"m using the very latest code you have on github -- the official release had an SQLite bug, as i recall. Can we arrange a time to talk via chat or phone? I'd really like to address this issue ASAP, and get somebody funded who can help me. :) Thanks, Chad Which LuaSQL ver

Re: [Kepler-Project] LuaSQL development status/financial assistance

2009-09-27 Thread Luís Eduardo Jason Santos
Which LuaSQL version are you using? Luís Eduardo Jason Santos On Sun, Sep 27, 2009 at 1:14 PM, Chad Phillips -- Apartment Lines < c...@apartmentlines.com> wrote: > Hello LuaSQL developers, > > I'm writing today with two goals in mind: > > 1. To gain a better understanding of the development/rele

Re: [Kepler-Project] LuaSQL development status/financial assistance

2009-09-27 Thread Jacob Jay
Are you opening and closing connections for every request, or using a connection pool/persistent connections? I'm not using LuaSQL in production but have done load testing at 1000's of queries per second with no issue using persistent connections (catching and re-opening connections closed

[Kepler-Project] LuaSQL development status/financial assistance

2009-09-27 Thread Chad Phillips -- Apartment Lines
Hello LuaSQL developers, I'm writing today with two goals in mind: 1. To gain a better understanding of the development/release status of the project. 2. To offer some financial assistance with development, specifically assistance to help fix an issue that is affecting anyone trying to use