Re: Meaning of ERROR: tuple concurrently updated

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Meaning of ERROR: tuple concurrently updated
Дата
Msg-id 22416.1116432003@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Meaning of ERROR: tuple concurrently updated  (KÖPFERL Robert <robert.koepferl@sonorys.at>)
Список pgsql-sql
KÖPFERL Robert <robert.koepferl@sonorys.at> writes:
> Thus I run VACUUM ANALYZE; every night by cron. However I keep getting
> ERROR:  tuple concurrently updated

Have you got other processes also doing VACUUM ANALYZE?  The only known
reason for this to happen is that two processes concurrently ANALYZE the
same table and conflict when they both try to update the same
pg_statistic rows.
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: KÖPFERL Robert
Дата:
Сообщение: Meaning of ERROR: tuple concurrently updated
Следующее
От: "Felix E. Klee"
Дата:
Сообщение: Turning column into *sorted* array?