ERROR: Too many updates/deletes within transaction (cmin

From: Petri Röytiö <petri(dot)roytio1(at)luukku(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: ERROR: Too many updates/deletes within transaction (cmin
Date: 2009-08-12 09:22:33
Message-ID: 1250068953179.petri.roytio1.28048.t-ztPLIr-Bt8n0MOn0xU6w@luukku.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 is that 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_filled WHERE 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-08-13 14:56:02 Re: ERROR: Too many updates/deletes within transaction (cmin
Previous Message Tom Lane 2009-08-11 16:33:20 Re: Moving filesystems