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 <[email protected]>:
> > Of course, i will try this afternoon.
> >
> >
> >
> > El 07/07/2012, a las 03:33, Massimo Di Pierro <
> [email protected]>
> > 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 <[email protected]>:
> >> > 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
> >> >> <[email protected]>
> >> >> 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. 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
> >> >>> # see:
> >> >>> 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.
>
