US 11,698,898 B2
Lock wait tracing
Piyush Kumar Jain Mahendra Kumar, Austin, TX (US); Mark F. Wilding, Issaquah, WA (US); James E. Mace, San Francisco, CA (US); and Thomas Fanghaenel, Oakland, CA (US)
Assigned to Salesforce, Inc., San Francisco, CA (US)
Filed by salesforce.com, inc., San Francisco, CA (US)
Filed on Nov. 4, 2020, as Appl. No. 17/89,355.
Prior Publication US 2022/0138175 A1, May 5, 2022
Int. Cl. G06F 16/23 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/2365 (2019.01) [G06F 16/2282 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method, comprising:
operating, by a computer system, a database that includes a lockable object;
maintaining, by the computer system, a lock wait queue that stores an indication of processes waiting to acquire a lock on the lockable object;
storing, by the computer system, trace records for those processes that, upon releasing a respective lock on the lockable object when another process is waiting in the lock wait queue, have been in contention for the respective lock for over a threshold amount of time; and
presenting, by the computer system, ones of the trace records, wherein the presented trace records identify a timeline that is usable to determine a set of processes that contributed to a delay in a victim process acquiring a lock on the lockable object.