subject:"\[GENERAL\] reindex table deadlock"

Re: [GENERAL] reindex table deadlock

2014-11-11 Thread jaime soler

El vie, 07-11-2014 a las 10:02 -0500, Dan H escribió: > 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 o

[GENERAL] reindex table deadlock

2014-11-07 Thread Dan H

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 procedur