Обсуждение: Help with Error

Поиск
Список
Период
Сортировка

Help with Error

От
John P Weatherman
Дата:
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.


Re: Help with Error

От
Tom Lane
Дата:
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

Re: Help with Error

От
abhishekgautam009@gmail.com
Дата:
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