Thread: Help with Error

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.

John P Weatherman <jweatherman91@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

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