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

Re: ERROR: Too many updates/deletes within transaction (cmin

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Petri Röytiö <petri(dot)roytio1(at)luukku(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: ERROR: Too many updates/deletes within transaction (cmin
Date: 2009-08-13 19:11:12
Message-ID: 407d949e0908131211t1e815e76h20a4b1c1e272a7c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Thu, Aug 13, 2009 at 3:56 PM, Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> =?ISO-8859-1?Q?Petri_R=F6yti=F6?= <petri(dot)roytio1(at)luukku(dot)com> writes:
>> Every now and then I get following error message. It seems that it happens more or less randomly...I guess the reason is that some transaction log is filled.
>
>> [Err] ERROR:  Too many updates/deletes within transaction (cmin). Reader gang not able to provide correct visibility 1/1 (combocid.c:275)  (seg6 slice1 xback2-3:50003 pid=28899)
>
> [ blink... ]  There is no such error message anywhere in the Postgres
> sources.  I suppose you are running somebody's heavily-modified version.
> You had better take this up with that somebody.

Google tells me this was in Greenplum's 3.2 release notes:

Resolved Issues in 3.2 -

3164 Too many updates/deletes within transaction error in serializable
transactions

In 3.1.1.4 and later, certain serializable transactions containing
function calls or TRUNCATE commands would fail with the error: ERROR:
Too many updates/deletes within transaction..

-- 
greg
http://mit.edu/~gsstark/resume.pdf

In response to

pgsql-novice by date

Next:From: P. StaringDate: 2009-08-14 12:09:08
Subject: Having trouble installing on Vista
Previous:From: Tom LaneDate: 2009-08-13 16:43:49
Subject: Re: Calling stored function that returns a cursor from a libpq program

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