any resolutions on this? On Wednesday, July 18, 2012, Phyo Arkar wrote:
> > 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:47 PM UTC+6:30, demetrio wrote: >> >> >> Hi everyone, >> >> I have connected WebDAV and SVN auth with a wsgi script. I needed to use >> a standalone DAL. When you do a dav petition with the navigator it makes a >> lot of petitions. Well, the thing is that always there is a connection >> opened (i can see them with PhpMyAdmin) >> >> if self.db: >> self.db._adapter.close() >> >> seeing this issue: >> http://code.google.com/**p/web2py/issues/detail?id=731<http://code.google.com/p/web2py/issues/detail?id=731#c4> >> >> I have tried a lot of the lines that i found there >> >> something like: >> >> if self.db: >> from gluon.dal import BaseAdapter >> BaseAdapter.close_all_**instances(None) >> BaseAdapter.close_all_**instances('commit') >> BaseAdapter.close_all_**instances('rollback') >> >> something like: >> if self.db: >> from gluon.dal import thread as dal_thread >> dal_thread.instances.remove(**self.db._adapter) >> self.db._adapter.close() >> >> and even something desesperated like: >> if self.db: >> from gluon.dal import thread as dal_thread >> dal_thread.instances.remove(**self.db._adapter) >> self.db._adapter.close() >> self.db._adapter.close_all_**instances(None) >> self.db._adapter.close_all_**instances('commit') >> self.db._adapter.close_all_**instances('rollback') >> >> from gluon.dal import ConnectionPool >> ConnectionPool.close_all_**instances(None) >> ConnectionPool.close_all_**instances('commit') >> ConnectionPool.close_all_**instances('rollback') >> >> from gluon.dal import BaseAdapter >> BaseAdapter.close_all_**instances(None) >> BaseAdapter.close_all_**instances('commit') >> BaseAdapter.close_all_**instances('rollback') >> >> But always, in the best, it leaves at least one connection opened, and i >> don't know how to deal with it. >> >> I have using web2py 1.99.7 in both development and production >> environments. >> >> Any ideas? in this moment we are building a python mysql script, but we >> want to use DAL to make it runnable on any of the web2py/DAL supported db >> >> Thanks in advance >> > -- > > > > --
