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.