[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 10:53:

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 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 gluo

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 : > Of cour

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 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 Pierro : > > I do not rec

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 : > > I do not recall. Can you resend it please. My personal inbox is a bit > messy. > > > > > > On Friday, 6 July 2012

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 : > 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? >> >> Tha

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 > e

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 escribió: > Looks like I prematurely close the issue. There is now a db.close() in trunk. > Please check it out. > > massimo > > On Thursday, 5 Jul

[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() >>

[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: > > BaseAdapter.close_

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 > '/home/demetrio/devel/python_virtual

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 "/ho

[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 everyo