ERROR: Too many updates/deletes within transaction (cmin

Поиск
Список
Период
Сортировка
От Petri Röytiö
Тема ERROR: Too many updates/deletes within transaction (cmin
Дата
Msg-id 1250068953179.petri.roytio1.28048.t-ztPLIr-Bt8n0MOn0xU6w@luukku.com
обсуждение исходный текст
Ответы Re: ERROR: Too many updates/deletes within transaction (cmin  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Moving filesystems
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: Too many updates/deletes within transaction (cmin