conflicting lock request message

From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: conflicting lock request message
Date: 2020-03-06 12:58:50
Message-ID: CADyzmyzymNtR27d_ZZJfR-v0M7_Yd8hoomvBc4vCNxQoSdD17A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Good morning,

I am running a vacuum on a large table that has had over 1 billion rows
deleted and am getting this message:

postgres(at)10(dot)53(dot)4(dot)110:prime_production INFO: "customer_attributes":
suspending truncate due to conflicting lock request
Mar 6 07:52:29 primeprodpsql01 postgres[8252]: [1156-1]
postgres(at)10(dot)53(dot)4(dot)110:prime_production INFO: "customer_attributes":
truncated 32541952 to 32173088 pages

I am running postgres 9.4. This message has been repeatedly sent now for
about 30 minutes after index scans have completed.

We have never had this problem before. I'm sure it has something to do
with the massive delete.

Any suggestions? Thank you.

--
*Mark Steben*
Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Janes 2020-03-06 13:47:41 Re: conflicting lock request message
Previous Message Imre Samu 2020-03-05 16:10:56 Re: shm