[web2py] Re: web2py Scheduler with Postgres creates "idle in transaction" connections

2015-02-19 Thread stingpan
I actually get an error using your trick: Traceback (most recent call last): File "gluon/scheduler.py", line 1512, in main() File "gluon/scheduler.py", line 1506, in main utc_time=options.utc_time) File "gluon/scheduler.py", line 588, in __init__ self.define_tables(db, migrate=m

[web2py] web2py Scheduler with Postgres creates "idle in transaction" connections

2015-02-18 Thread stingpan
web2py version: 2.9.12-stable Postgres server: 9.1 I have 3 databases for my application, only one is designated for Scheduler and its tables. What I noticed is that when I start scheduler (using upstart deployment and running "start web2py-scheduler" as root), all 3 databases are immediately c