Re: Django / Postrges problem

2009-03-26 Thread Malcolm Tredinnick
On Thu, 2009-03-26 at 02:17 -0700, Szymon wrote: > I've added some syslog stuff to determine when cron job is done... > and, it's strange. It seems that cron job is done after 5 seconds, but > commits are done 3 minutes later. > > Mar 26 10:10:01 ns204293 python: Job started > Mar 26 10:10:05

Re: Django / Postrges problem

2009-03-26 Thread Szymon
I've added some syslog stuff to determine when cron job is done... and, it's strange. It seems that cron job is done after 5 seconds, but commits are done 3 minutes later. Mar 26 10:10:01 ns204293 python: Job started Mar 26 10:10:05 ns204293 python: Job done And then Mar 26 10:13:08 ns204293

Re: Django / Postrges problem

2009-03-26 Thread Malcolm Tredinnick
On Thu, 2009-03-26 at 00:17 -0700, Szymon wrote: > On 25 Mar, 21:15, Antoni Aloy wrote: > > The obvious one: check your cron job .. Log your queries in postgres > > to see which querie consumes more time, it should be the cron job one. > > I did it some time ago, and

Re: Django / Postrges problem

2009-03-26 Thread Szymon
On 26 Mar, 08:17, Szymon wrote: > Mar 20 18:12:20 ns204293 postgres[27213]: [3-1] [27213]LOG:  process > 27213 acquired ExclusiveLock on tuple (21,19) of relation 197227 of > database 98304 after 42887.468 ms Ah, and such entries too: Mar 20 14:33:49 ns204293 postgres[7044]:

Re: Django / Postrges problem

2009-03-26 Thread Szymon
On 25 Mar, 21:15, Antoni Aloy wrote: > The obvious one: check your cron job .. Log your queries in postgres > to see which querie consumes more time, it should be the cron job one. I did it some time ago, and there are such entries: Mar 20 18:12:20 ns204293

Re: Django / Postrges problem

2009-03-25 Thread Antoni Aloy
2009/3/25 Szymon : > > Hello Django users, > > I have big problem. For a few days my site isn't working properly. We > have two interfaces. First connected to Apache, second is cron job > running every 10 minutes (using Django ORM etc.). The problem is when > that job is running,

Re: Django / Postrges problem

2009-03-25 Thread Rajesh D
Hi, > I have big problem. For a few days my site isn't working properly. We > have two interfaces. First connected to Apache, second is cron job > running every 10 minutes (using Django ORM etc.). The problem is when > that job is running, there is some ExclusiveLock on postgres and web >

Django / Postrges problem

2009-03-25 Thread Szymon
Hello Django users, I have big problem. For a few days my site isn't working properly. We have two interfaces. First connected to Apache, second is cron job running every 10 minutes (using Django ORM etc.). The problem is when that job is running, there is some ExclusiveLock on postgres and web