ERROR: Too many updates/deletes within transaction (cmin - Mailing list pgsql-novice

From Petri Röytiö
Subject ERROR: Too many updates/deletes within transaction (cmin
Date
Msg-id 1250068953179.petri.roytio1.28048.t-ztPLIr-Bt8n0MOn0xU6w@luukku.com
Whole thread Raw
Responses Re: ERROR: Too many updates/deletes within transaction (cmin
List pgsql-novice
Hi.

Every now and then I get following error message. It seems that it happens more or less randomly...I guess the reason
isthat some transaction log is filled. 

How can I prevent this?

[Err] ERROR:  Too many updates/deletes within transaction (cmin). Reader gang not able to provide correct visibility
1/1(combocid.c:275)  (seg6 slice1 xback2-3:50003 pid=28899) 
CONTEXT:  SQL statement "CREATE TABLE profilointi.group_names AS SELECT group_id FROM
profilointi.vtj_profilointi_results_filledWHERE group_id IS NOT NULL GROUP BY group_id" 
PL/pgSQL function "petri_profilointia_create_table" line 14 at SQL statement


BR,
Petri

....................................................................
Luukku Plus -paketilla pääset eroon tila- ja turvallisuusongelmista.
Hanki Luukku Plus ja helpotat elämääsi. http://www.mtv3.fi/luukku

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Moving filesystems
Next
From: Tom Lane
Date:
Subject: Re: ERROR: Too many updates/deletes within transaction (cmin