Re: Meaning of ERROR: tuple concurrently updated

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
Cc: Sql-Postgre <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Meaning of ERROR: tuple concurrently updated
Date: 2005-05-18 16:00:03
Message-ID: 22416.1116432003@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

=?ISO-8859-1?Q?K=D6PFERL_Robert?= <robert(dot)koepferl(at)sonorys(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Felix E. Klee 2005-05-18 16:12:37 Turning column into *sorted* array?
Previous Message KÖPFERL Robert 2005-05-18 15:50:18 Meaning of ERROR: tuple concurrently updated