Skip site navigation (1) Skip section navigation (2)

Re: BUG #6482: Service terminates executing "With ... as ... UPDATE" query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dzolotarevskiy(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6482: Service terminates executing "With ... as ... UPDATE" query
Date: 2012-02-22 20:16:40
Message-ID: 24067.1329941800@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
dzolotarevskiy(at)gmail(dot)com writes:
> All queries works fine when there is only one session. When Sessions more
> then 20 it starts terminating with some probability. 
> On my production server it stops about 50 times per day.
> On my dev pc, with testing utility that uses 50 sessions at one time, it
> falls down in about 1 minute.

> Investigating problem i have found the  "fatal" query and excluding part by
> part found out that new syntax produce that exception.

I believe this is an already-known issue:
http://archives.postgresql.org/pgsql-bugs/2012-01/msg00157.php

It will be fixed in next week's update releases.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Marti RaudseppDate: 2012-02-22 21:13:03
Subject: Re: BUG #6483: Rows being evaluated, although being outside the LIMIT / OFFSET boundaries
Previous:From: Pavel StehuleDate: 2012-02-22 18:58:43
Subject: Re: BUG #6483: Rows being evaluated, although being outside the LIMIT / OFFSET boundaries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group