PersistentQueryStateLog

When a query worker is started or stopped, it goes through a series of state changes, representing the worker's status. Each state represents a specific condition, and every state change for every PQ is stored in the PersistentQueryStateLog. Current states are also visible in the status column in the Query Configuration Deephaven console panel. States include:

StateDescription
UninitializedThe query has no status as it has not been run.
ConnectingThe controller is connecting.
AuthenticatingThe query is authenticating with the authentication server.
AcquiringWorkerThe dispatcher is creating a worker process for the query.
InitializingThe worker process for the query is initializing.
RunningThe query worker is running (script query types only).
FailedThe query worker failed to start correctly; an exception should be visible.
ErrorThe query generated an error.
DisconnectedThe query worker disconnected unexpectedly. This may occur, for example, if the JVM experiences an OutOfMemoryError, a Hotspot error (possibly caused by a buggy native module), or if the garbage collector pauses the JVM for longer than the heartbeat interval between the worker and dispatcher.
StoppedThe query stopped normally (Live Query (Script) query types only).
CompletedThe query completed successfully (Batch Query (RunAndDone) query types only).
ExecutingThe query is executing (Batch Query (RunAndDone) query types only).

The PersistentQueryStateLog table contains every state change that has occurred for all persistent queries.

Columns

Column NameColumn TypeDescription
DateStringThe date on which the state change occurred. This is the partitioning column.
OwnerStringThe owner of the Persistent Query.
NameStringThe name of the Persistent Query.
TimestampDateTimeThe timestamp for the state change.
StatusStringThe new query state, e.g., Running, Disconnected, etc.
ServerHostStringThe host on which the query ran.
WorkerNameStringThe worker's name.
WorkerPortintThe worker's port for connections.
LastModifiedByAuthenticatedStringThe authenticated user who last modified this query.
LastModifiedByEffectiveStringThe effective user who last modified this query.
SerialNumberlongThe query's serial number (a system-generated identifier unique to each Persistent Query).
VersionNumberlongThe query's version number (a number that starts at 1 for each query and is incremented each time the query is updated).
TypeSpecificStateStringA type-specific state value; this will not apply to most queries.
ExceptionMessageStringIf applicable, the exception message for a failed query.
ExceptionStackTraceStringIf applicable, the full stack trace for a failed query.
ScriptLoaderStateMapState of script loader infrastructure when logged. Currently, only "git" repository states are relevant, with the revision fingerprint of each, keyed by repo name, logged.