Jira (PDB-5555) Correct lock acquisition order of Report Partition GC

13 views
Skip to first unread message

Austin Blatt (Jira)

unread,
Oct 20, 2022, 5:21:03 PM10/20/22
to puppe...@googlegroups.com
Austin Blatt created an issue
 
PuppetDB / Improvement PDB-5555
Correct lock acquisition order of Report Partition GC
Issue Type: Improvement Improvement
Assignee: Unassigned
Created: 2022/10/20 2:20 PM
Priority: Normal Normal
Reporter: Austin Blatt

In Postgres, all transactions should acquire their locks in the same order, but report storage and report partition deletion acquire them in opposite orders (the order of operations in the transactions).

Report storage acquires locks on certnames, then reports, then resource_events, partition gc drops resource_events, the reports, then updates certnames (acquiring the locks in that order).
Add Comment Add Comment
 
This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8)
Atlassian logo

Nick Lewis (Jira)

unread,
Oct 26, 2022, 1:21:02 PM10/26/22
to puppe...@googlegroups.com
Nick Lewis updated an issue
Change By: Nick Lewis
Team: Skeletor

Cas Donoghue (Jira)

unread,
Nov 9, 2022, 1:17:01 PM11/9/22
to puppe...@googlegroups.com
Cas Donoghue updated an issue
Change By: Cas Donoghue
Sprint: Skeletor 11/23/2022

Cas Donoghue (Jira)

unread,
Nov 10, 2022, 12:10:02 PM11/10/22
to puppe...@googlegroups.com
Cas Donoghue updated an issue
Change By: Cas Donoghue
Story Points: 1

Nick Lewis (Jira)

unread,
Nov 14, 2022, 5:45:03 PM11/14/22
to puppe...@googlegroups.com
Nick Lewis assigned an issue to Nick Lewis
Change By: Nick Lewis
Assignee: Nick Lewis

Cas Donoghue (Jira)

unread,
Nov 23, 2022, 1:48:03 PM11/23/22
to puppe...@googlegroups.com
Cas Donoghue updated an issue
Change By: Cas Donoghue
Sprint: Skeletor 11/23/2022 , Skeletor 12/07/2022

Nick Lewis (Jira)

unread,
Nov 30, 2022, 2:27:02 PM11/30/22
to puppe...@googlegroups.com
Nick Lewis updated an issue
Change By: Nick Lewis
Release Notes: Not Needed

Nick Lewis (Jira)

unread,
Nov 30, 2022, 2:28:03 PM11/30/22
to puppe...@googlegroups.com
Nick Lewis updated an issue
Change By: Nick Lewis
Fix Version/s: PDB 7.y

Austin Blatt (Jira)

unread,
Dec 2, 2022, 12:15:02 PM12/2/22
to puppe...@googlegroups.com
Austin Blatt updated an issue
Change By: Austin Blatt
Fix Version/s: PDB 7.y
Fix Version/s: PDB 7.12.0
Reply all
Reply to author
Forward
0 new messages