reindex table deadlock

From: Dan H <dw6881pr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: reindex table deadlock
Date: 2014-11-07 15:02:57
Message-ID: CAE9wFP0GXBJ83J5zZOzweHgtXBb7NWZJprB1kSxMMi7-ozMBTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I encountered a deadlock while running 'reindex table TABLE1' in
postgresql version 9.2.4
The postgresql logs shows the two offending processes.

1st process was running reindex table TABLE1
waiting for AccessExclusiveLock on primary key index of TABLE1

2nd process was running stored procedure that executes selects and
deletes to TABLE1
waiting for RowExclusiveLock on TABLE1.

Is this the same lock upgrade deadlock issue that someone has
previously mentioned with reindex?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message avpro avpro 2014-11-07 15:07:08 Fwd: function for trigger
Previous Message pbj 2014-11-07 12:03:28 Re: Performance of UPDATE SET = FROM vs UPDATE SET = (SELECT ...)