Seems like a reasonable fix - if you'd like to submit a pull request I'll merge it.
Thanks On Wed, Apr 23, 2014 at 7:23 PM, Ciaran Bradley <[email protected]>wrote: > Hi, > > I'm not entirely sure whether this is technically a Mezzanine issue or a > Django issue. I noticed recently after a deploy (Python 2.7, Mezzanine > 3.0.9, Django 1.6, Postgres 9.3 on a Debian 7 box) that I was generating > big Postgres log files, filled with this event: > > https://gist.github.com/ciaranbradley/11207009 > > I tracked it down to the poll_twitter command running in cron. The command > was working as expected, but it would generate a new entry each time it > ran. After finding this similar issue: > > > http://stackoverflow.com/questions/16841505/django-resetting-postgres-connection > > I applied the technique to the poll_twitter command last night and the > problem seems to be gone. My poll_twitter now looks like this: > > https://gist.github.com/ciaranbradley/11207319 > > The command still seems to be up and running as normal and my log file > loves me again. > > I don't see a specific instruction on Django docs to ensure you close the > database connection when you create a command, so it might be fair to > assume that the engine should close the connection gracefully after a > command is run. Also I note that my deploy is low traffic (just a sandbox > at the minute) so I suspect that higher traffic sites might be immune if > the command uses an already open persistent connection. But that's just > pure speculation on my part. > > Is anyone else experiencing similar? > > Thanks > > Ciaran > > > -- > You received this message because you are subscribed to the Google Groups > "Mezzanine Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Stephen McDonald http://jupo.org -- You received this message because you are subscribed to the Google Groups "Mezzanine Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
