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.
I suposse that apache opens a thread in each request.
But with a direct mysql connection (using the mysql library included in
gluon) we can close all the connections without problems.
El 08/07/12 00:06, Massimo Di Pierro escribió:
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 import BaseAdapter
BaseAdapter.close_all_instances('commit')
2012/7/7 Daniel Gonzale <dgzabal...@gmail.com
<mailto:dgzabal...@gmail.com>>:
> Of course, i will try this afternoon.
>
>
>
> El 07/07/2012, a las 03:33, Massimo Di Pierro
<massimo.dipie...@gmail.com <mailto: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 Pierro <massimo.dipie...@gmail.com
<mailto: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 apllication?
>> >>
>> >> Thanks everyone
>> >>
>> >>
>> >>
>> >> El 06/07/2012, a las 04:32, Massimo Di Pierro
>> >> <massimo.dipie...@gmail.com
<mailto: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
>> >>
>> >> 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 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')
>> >>>
>> >>>
>> >>> This is not enough, as was documented on issue
>> >>> http://code.google.com/p/web2py/issues/detail?id=731
<http://code.google.com/p/web2py/issues/detail?id=731>. The code that
>> >>> works
>> >>> for me for sqlite is as follows:
>> >>>
>> >>> def closebase(base):
>> >>> if not base: return
>> >>> # see:
http://code.google.com/p/web2py/issues/detail?id=731
<http://code.google.com/p/web2py/issues/detail?id=731>
>> >>> # see:
>> >>>
https://groups.google.com/d/topic/web2py/hmsupVHdDHo/discussion
<https://groups.google.com/d/topic/web2py/hmsupVHdDHo/discussion>
>> >>> # was: base._adapter.close()
>> >>> from gluon.dal import thread
>> >>> thread.instances.remove(base._adapter)
>> >>> base._adapter.close()
>> >>>
>> >>> and then I call closebase(db); db = None which is enough
for me with
>> >>> sqlite -- but apparently, the original poster has tried
that, and that
>> >>> is
>> >>> not sufficient for mysql.
