Global avoidance of hang states via priority inheritance in multi-node computing system

A clustered computing system, comprising:

• a plurality of computing nodes for executing processes, each of the computing nodes including a processor, an operating system, and a database instance that is configured as part of a clustered database system;
• a shared global memory that is shared on a remote node of the computing nodes and accessed by the plurality of computing nodes in the clustered database system;
• a blocking avoidance logic embodied in one or more of the plurality of nodes and when executed is configured to:
• determine when a process in a first node of the computing nodes is in a wait state that is waiting for a resource, the process being a waiting process;
• determine an identity and a processing state of a blocking process from the shared global memory on the remote node, where the blocking process is part of a second node of the computing nodes, to which the resource is allocated;
• and
• selectively causing an operating system local to the blocking process to increase an execution priority of the blocking process based, at least in part, on an execution priority of the waiting process and the process state information of the blocking process.

A non-transitory computer-readable medium storing computer-executable instructions that when executed by a computer cause the computer to perform a method, the method comprising:

• searching process state information of a distributed computing system having a plurality of computing nodes to identify a waiting process from a first computing node, where the waiting process is in a blocked state and waiting for a resource;
• searching resource state information of the distributed computing system to identify a blocking process from a different computing node in the distributing computing system using an identifier of the resource, where the blocking process is holding the resource, where the process state information and the resource state information are stored in a global memory shared by the plurality of computing nodes, and where the global memory is on a remote node in the plurality of computing nodes and is accessed by the plurality of computing nodes;
• generating a message that includes instructions and data with at least a priority of the waiting process, an identifier of the blocking process, and the identifier of the resource;
• and
• transmitting the message to the second node to cause an execution priority of the blocking process to be increased if the execution priority is lower than the waiting process.