Postgres Pro
Downloads
Home   >   mailing lists

Autovacuum deadlock - bug or not? - Mailing list pgsql-bugs

From Mikael Carneholm
Subject Autovacuum deadlock - bug or not?
Date
Msg-id 7F10D26ECFA1FB458B89C5B4B0D72C2B088215@sesrv12.wirelesscar.com
Whole thread Raw
Responses Re: Autovacuum deadlock - bug or not?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
Don't know if this is a bug or just undocumented, but it seems as you shoul=
d 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 d=
atabase 16390; blocked by process 15865.
Process 15865 waits for AccessShareLock on relation 68122 of database 16390=
; blocked by process 29022.

/Mikael

pgsql-bugs by date:

Previous
From: Matt
Date:
Subject: Huge query stalls at PARSE/BIND stage (2)
Next
From: Tom Lane
Date:
Subject: Re: Autovacuum deadlock - bug or not?