Postgres Pro
Downloads
Home   >   mailing lists

How to track down locks held by recovery process on a slave? - Mailing list pgsql-admin

From Amador Alvarez
Subject How to track down locks held by recovery process on a slave?
Date
Msg-id CA+vGRtg+8wNugVByhLrhZX=SBnb7k9b9zZfOMPNo7nAEoRAu6w@mail.gmail.com
Whole thread Raw
Responses Re: How to track down locks held by recovery process on a slave?  (reiner peterke <zedaardv@drizzle.com>)
List pgsql-admin
Tree view
Hi there,

I am using a postgres 9.2 slave for some reports and I noticed that sometimes they are held up because certain activity on the master like vacuums can affect long queries on a slave .

Looking at pg_locks view , I can see that the recovering process on the slave is holding some AccessExclusiveLock locks on relations which numbers that do not mach any pg_class.oid.

Any idea How could I find out which relations are locked by the recovering process?


Thanks in advance,
A.A.

pgsql-admin by date:

Previous
From: Mike Broers
Date:
Subject: Re: ERROR: could not open file "base/125542/12631" Corruption?
Next
From: reiner peterke
Date:
Subject: Re: How to track down locks held by recovery process on a slave?