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
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