Autovacuum deadlock - bug or not?

From: "Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Autovacuum deadlock - bug or not?
Date: 2005-11-17 14:11:13
Message-ID: 7F10D26ECFA1FB458B89C5B4B0D72C2B088215@sesrv12.wirelesscar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Don't know if this is a bug or just undocumented, but it seems as you should turn off autovacuum before you run CLUSTER, otherwise you might run into a deadlock:

NOTICE: Clustering idx_vehicle_unit_data_200407_person_information__id on vehicle_unit_data_200407
ERROR: deadlock detected
DETAIL: Process 29022 waits for AccessExclusiveLock on relation 68950 of database 16390; blocked by process 15865.
Process 15865 waits for AccessShareLock on relation 68122 of database 16390; blocked by process 29022.

/Mikael

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-11-17 14:51:10 Re: Autovacuum deadlock - bug or not?
Previous Message Prakash Suryavanshi 2005-11-17 09:33:49 BUG #2049: pg_dump BACKUP error