DROP INDEX hangs

From: "Arnaud L(dot)" <arnaud(dot)listes(at)codata(dot)eu>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: DROP INDEX hangs
Date: 2017-11-08 09:19:27
Message-ID: 178bc1ca-4819-9d8f-b9c0-f82623332618@codata.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

Using PostgreSQL 9.3.4, compiled by Visual C++ build 1600, 32-bit (on
Windows, obviously).
I noticed that my vacuumdb was hanging on a specific index, so I decided
that the easiest path was to create a duplicate of it (CREATE INDEX
CONCURRENTLY myindex_v2 ...), and drop the original one (DROP INDEX
myindex).
Bad idea : the DROP INDEX command is hanging, doing no IO but using a
full CPU core.
It does not look like it is waiting for a lock (pg_locks show very few
locks right now, and absolutely none related to this pid).

The index is not listed anymore in the table description though
(something was definitively wrong with this index).

I tried to nicely cancel the query via pgadmin, but this does not help.
What can I do ? Should I terminate this backend ? What is the risk of
terminating a drop index operation ?

Thanks for your advices !

--
Arnaud

Browse pgsql-general by date

  From Date Subject
Next Message Arup Rakshit 2017-11-08 10:32:55 filter records by substring match of an postgresql array column
Previous Message Michael Paquier 2017-11-08 00:43:18 Re: Naming conventions for column names