[web2py] Re: Standalone DAL leaves mysql connections opened

2012-07-18 Thread Phyo Arkar
I am also having same problem , web2py DAL do not close connection and fails after too many connection on mysql opened. I do not have any problem before versions 1.99.1 or 1.99.2 . is that new bug introduced after 1.99.4 ? coz we are happening at 1.99.4 and up. On Friday, June 22, 2012

Re: [web2py] Re: Standalone DAL leaves mysql connections opened

2012-07-09 Thread Daniel González Zaballos
No (or at least not me), the many connections are from the web navigator, that send many get / options or propfind requests for dav/svn, when i try only one time to access. Its the same if I use a dav or svn client, and with the file explorer included in the application they send many request.

Re: [web2py] Re: Standalone DAL leaves mysql connections opened

2012-07-07 Thread Daniel Gonzale
Of course, i will try this afternoon. El 07/07/2012, a las 03:33, Massimo Di Pierro massimo.dipie...@gmail.com escribió: Meanwhile, can you check the new db.close() in trunk? On Friday, 6 July 2012 15:40:57 UTC-5, demetrio wrote: Mail with the code sended :) 2012/7/6 Massimo Di

Re: [web2py] Re: Standalone DAL leaves mysql connections opened

2012-07-07 Thread Daniel Gonzalez Zaballos
It's not working :( In the best scenario i can leave one connection opened in a whole request (with other combinations it leaves at least 10 more or less) only with: self.db.commit() from gluon.dal import BaseAdapter BaseAdapter.close_all_instances('commit') 2012/7/7 Daniel Gonzale

Re: [web2py] Re: Standalone DAL leaves mysql connections opened

2012-07-07 Thread Massimo Di Pierro
Are you using threads? On Saturday, July 7, 2012 9:21:51 AM UTC-5, demetrio wrote: It's not working :( In the best scenario i can leave one connection opened in a whole request (with other combinations it leaves at least 10 more or less) only with: self.db.commit() from gluon.dal

Re: [web2py] Re: Standalone DAL leaves mysql connections opened

2012-07-06 Thread Daniel Gonzale
I will try this weekend. Massimo did you received the code of the apllication? Thanks everyone El 06/07/2012, a las 04:32, Massimo Di Pierro massimo.dipie...@gmail.com escribió: Looks like I prematurely close the issue. There is now a db.close() in trunk. Please check it out. massimo

Re: [web2py] Re: Standalone DAL leaves mysql connections opened

2012-07-06 Thread Massimo Di Pierro
I do not recall. Can you resend it please. My personal inbox is a bit messy. On Friday, 6 July 2012 05:51:04 UTC-5, demetrio wrote: I will try this weekend. Massimo did you received the code of the apllication? Thanks everyone El 06/07/2012, a las 04:32, Massimo Di Pierro

Re: [web2py] Re: Standalone DAL leaves mysql connections opened

2012-07-06 Thread Daniel Gonzalez Zaballos
Mail with the code sended :) 2012/7/6 Massimo Di Pierro massimo.dipie...@gmail.com: I do not recall. Can you resend it please. My personal inbox is a bit messy. On Friday, 6 July 2012 05:51:04 UTC-5, demetrio wrote: I will try this weekend. Massimo did you received the code of the

Re: [web2py] Re: Standalone DAL leaves mysql connections opened

2012-07-06 Thread Massimo Di Pierro
Meanwhile, can you check the new db.close() in trunk? On Friday, 6 July 2012 15:40:57 UTC-5, demetrio wrote: Mail with the code sended :) 2012/7/6 Massimo Di Pierro massimo.dipie...@gmail.com: I do not recall. Can you resend it please. My personal inbox is a bit messy. On

[web2py] Re: Standalone DAL leaves mysql connections opened

2012-07-05 Thread nick name
On Thursday, June 28, 2012 10:47:15 AM UTC-4, Massimo Di Pierro wrote: why not simply? db.commit() db.close() if db in an on object attribute like self.db you can do if self.db: self.db.commit() self.db.close() self.db = 0 you can also do:

[web2py] Re: Standalone DAL leaves mysql connections opened

2012-07-05 Thread Massimo Di Pierro
Looks like I prematurely close the issue. There is now a db.close() in trunk. Please check it out. massimo On Thursday, 5 July 2012 13:05:47 UTC-5, nick name wrote: On Thursday, June 28, 2012 10:47:15 AM UTC-4, Massimo Di Pierro wrote: why not simply? db.commit() db.close() if db in an

[web2py] Re: Standalone DAL leaves mysql connections opened

2012-06-28 Thread Massimo Di Pierro
why not simply? db.commit() db.close() if db in an on object attribute like self.db you can do if self.db: self.db.commit() self.db.close() self.db = 0 you can also do: BaseAdapter.close_all_instances('commit') On Friday, 22 June 2012 11:23:47 UTC-5, demetrio wrote: Hi

Re: [web2py] Re: Standalone DAL leaves mysql connections opened

2012-06-28 Thread Daniel González Zaballos
It does not work. If I use the self.db = 0 sometimes i get this error (and connections are open): mod_wsgi (pid=1419): Exception occurred processing WSGI script '/home/demetrio/devel/python_virtual_2.6/web2py/applications/forge2/scripts/auth.py'. Traceback (most recent call last): File

Re: [web2py] Re: Standalone DAL leaves mysql connections opened

2012-06-28 Thread Massimo DiPierro
Can I see the code? On Jun 28, 2012, at 10:08 AM, Daniel González Zaballos wrote: It does not work. If I use the self.db = 0 sometimes i get this error (and connections are open): mod_wsgi (pid=1419): Exception occurred processing WSGI script