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