US 12,182,588 B2Granted

Performing shutdown of a node in a database system

AssigneeOcient Holdings LLC

InventorsGeorge Kondiles, Alyssa Catherine Wagenmaker, Ellis Mihalko Saupe, Jason Arnold, Natalia Marie Jenuwine, Finley Jordan Lau, David Charles Boutcher, Anna Veselova, Susmita Saha

Life of this patent

Estimating the term…

patentgrep

Loading patent…

Abstract

A node of a database system is operable to determine, at a first time, to prepare for a shutdown. The shutdown of the node is performed at a second time that is a period of time after the first time based on the node delaying the shutdown until a plurality of currently running processes being run by the node that initiated prior to the first time are determined to be complete. During the period of time after the first time and prior to performing the shutdown, a set of new processing requests are rejected by the node.

Claims20

Dependent claims

A method for execution by a node of a database system, comprising:

determining, at a first time, to prepare for a shutdown;
performing the shutdown at a second time that is a period of time after the first time based on delaying the shutdown until all of:
a set of currently running tasks being executed by the node that initiated prior to the first time are determined to be complete;
a set of currently running administrative processes being executed by the node that initiated prior to the first time are determined to be complete;
a set of operator executions of currently running queries assigned for execution by the node that initiated prior to the first time are determined to be complete;
a set of active connections on a local server of the node are closed;
a set of segments servicing for a set of segments assigned to the node that initiated prior to the first time are determined to be complete;
a set of pages currently being generated by the node that initiated generation prior to the first time are determined to be complete;
and
a set of segments currently being generated by the node that initiated generation prior to the first time are determined to be complete;
during the period of time after the first time and prior to performing the shutdown, rejecting a set of new task execution requests;
during the period of time after the first time and prior to performing the shutdown, rejecting at set of new administrative update messages;
during the period of time after the first time and prior to performing the shutdown, redirecting each of a set of incoming server-based commands to a non-local server for execution;
and
during the period of time after the first time and prior to performing the shutdown, rejecting a set of new data loading requests.

12 more elements

A database system includes:

a plurality of nodes that each include at least one processor;
and
at least one memory that stores operational instructions that, when executed by the at least one processor, cause the database system to:
determine, via each node of a plurality of nodes at a corresponding first time, to prepare for a shutdown;
perform, via the each node, the shutdown at a corresponding second time that is a corresponding period of time after the corresponding first time based on delaying the shutdown until all of:
a corresponding set of currently running tasks being executed by the each node that initiated prior to the corresponding first time are determined to be complete;
a corresponding set of currently running administrative processes being executed by the each node that initiated prior to the corresponding first time are determined to be complete;
a corresponding set of operator executions of currently running queries assigned for execution by the each node that initiated prior to the corresponding first time are determined to be complete;
a corresponding set of active connections on a corresponding local server of the each node are closed;
a corresponding set of segments servicing for a set of segments assigned to the each node that initiated prior to the corresponding first time are determined to be complete;
a corresponding set of pages currently being generated by the each node that initiated generation prior to the corresponding first time are determined to be complete;
and
a corresponding set of segments currently being generated by the each node that initiated generation prior to the corresponding first time are determined to be complete;
during the corresponding period of time after the corresponding first time and prior to performing the shutdown, reject, via the each node, a corresponding set of new task execution requests;
during the period of time after the first time and prior to performing the shutdown, reject, via the each node, a corresponding set of new administrative update messages;
during the period of time after the first time and prior to performing the shutdown, redirect, via the each node, each of a corresponding set of incoming server-based commands to a non-local server;
and
during the period of time after the first time and prior to performing the shutdown, reject, via the each node, a corresponding set of new data loading requests.

15 more elements

Dependencies are inferred from the claim text.