All,

I am intermittently seeing a job fail with:

ERROR: Too many updates/deletes within transaction. Reader gang not able
to provide correct visibility (combocid.c:270) (seg1 slice1 sdw1:50002
pid=15588)
SQL state: XX000

Does anyone have any ideas what this really means? So far, waiting
until system usage is low and rerunning seems to let it go through,
which would suggest to me this is a miss leading error at best. The
"transaction" doesn't really seem to be the problem. This is happening
on as CREATE AS SELECT.

Thanks,

John P Weatherman
Sr DBA
Asurion, Inc.


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

John P Weatherman <jweatherman91 [at] alumni.wfu.edu> writes:
> I am intermittently seeing a job fail with:

> ERROR: Too many updates/deletes within transaction. Reader gang not able
> to provide correct visibility (combocid.c:270) (seg1 slice1 sdw1:50002
> pid=15588)
> SQL state: XX000

A bit of searching of the archives would've led you to
http://archives.postgresql.org/pgsql-novice/2009-08/msg00082 .php

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--000e0cd150824b710404740d8053
Content-Type: text/plain; charset=ISO-8859-1

Hi ,

I guess this is not Postgres.Is it Greenplum ?

Check for max connections on master and corresponding all nodes.

Max connections at nodes has to 4-5 times the max on master.

BTW are you using simple "create as select * from table " or anything else

Abhi

--000e0cd150824b710404740d8053
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi ,<br><br>I guess this is not Postgres.Is it Greenplum ?<br><br>Check for=
max connections on master and corresponding=A0 all nodes.<br><br>Max conne=
ctions at nodes has to 4-5 times the max on master.<br><br>BTW are you usin=
g simple "create as select * from table " or anything else<br>

<br>Abhi

--000e0cd150824b710404740d8053--