Re: "ResourceWarning: unclosed" error using mysql-connector-python

2014-07-04 Thread Zemian Deng
No problem. Thanks for the reply. On Fri, Jul 4, 2014 at 12:51 AM, cercatrova2 wrote: > On 04/07/14 05:09, Zemian Deng wrote: > > Hum... I am surprised that no one has experienced this warning msg yet, or > maybe I can't catch anyone to reply. > > For those are curi

Re: Mysql connections after started django app

2014-07-04 Thread Zemian Deng
causing the problem. But good to hear PostgreSQL doesn't have the same issue though. On Fri, Jul 4, 2014 at 1:06 AM, cercatrova2 wrote: > On 04/07/14 05:04, Zemian Deng wrote: > > Hi, > > In my django settings.py I have set CONN_MAX_AGE=0 to use with MySQL DB, > wh

Re: Mysql connections after started django app

2014-07-04 Thread Zemian Deng
. On Fri, Jul 4, 2014 at 10:46 AM, cercatrova2 wrote: > On 04/07/14 16:11, Zemian Deng wrote: > > @cercatrova2, > > Yes, my original problem also was (and still is) with "MySQL Connection > not available" after the 8 hours timeout inactivity on webfaction hosting.

Re: Mysql connections after started django app

2014-07-04 Thread Zemian Deng
s. > > https://docs.djangoproject.com/en/1.6/ref/databases/ > > https://docs.djangoproject.com/en/1.6/ref/settings/#std:setting-CONN_MAX_AGE > > Cheers > > François > > > On Jul 4, 2014, at 10:46 AM, cercatrova2 wrote: > > > On 04/07/14 16:11, Zemian

Re: Mysql connections after started django app

2014-07-07 Thread Zemian Deng
nections. Setting up a > connection to MySQL is very fast so there should be performance issues if > you set CONN_MAX_AGE to something like 60 (again check my.cnf). > > Cheers > > François > > > On Jul 4, 2014, at 12:39 PM, Zemian Deng > > wrote: > > > Tha

"ResourceWarning: unclosed" error using mysql-connector-python

2014-06-11 Thread Zemian Deng
Hi there, I am using mysql-connector-python (1.1.6) with Django (1.6.5) and myapp is working fine. But each SQL call to DB will result the following warning messages: Exception ignored in: ResourceWarning: unclosed Has anyone seen this and know a way to resolve it? Also, FYI, I am using th

Re: "ResourceWarning: unclosed" error using mysql-connector-python

2014-06-12 Thread Zemian Deng
Anyone? On Tuesday, June 10, 2014 11:26:18 PM UTC-4, Zemian Deng wrote: > > Hi there, > > I am using mysql-connector-python (1.1.6) with Django (1.6.5) and myapp > is working fine. But each SQL call to DB will result the following warning > messages: > > Exc

"ResourceWarning: unclosed" error using mysql-connector-python

2014-06-23 Thread Zemian Deng
Hi there, I am using mysql-connector-python (1.1.6) with Django (1.6.5) and myapp is working fine. But each SQL call to DB will result the following warning messages: Exception ignored in: ResourceWarning: unclosed Has anyone seen this and know a way to resolve it? Also, FYI, I am using th

Mysql connections after started django app

2014-07-03 Thread Zemian Deng
Hi, In my django settings.py I have set CONN_MAX_AGE=0 to use with MySQL DB, which I understood as closing conn after each request. However when I start a simple "mysite" tutorial with "python manage.py runserver", I see immediately 3 connections in mysql that will not close but in Sleep mode.

Re: "ResourceWarning: unclosed" error using mysql-connector-python

2014-07-03 Thread Zemian Deng
UTC-4, Zemian Deng wrote: > > Anyone? > > On Tuesday, June 10, 2014 11:26:18 PM UTC-4, Zemian Deng wrote: >> >> Hi there, >> >> I am using mysql-connector-python (1.1.6) with Django (1.6.5) and myapp >> is working fine. But each SQL call to DB