ProcessEventLog

The ProcessEventLog table contains all log messages for Deephaven workers and query or merge servers, including the output from workers, which is useful to investigate behavior and diagnose failures or crashes. You should filter by the Process or ProcessInfoId columns to retrieve rows of interest. You must also sort by the Timestamp column to view data in order, as data logged by the worker is separate from stdout and stderr data captured by the query or merge servers.

Configuration

Any process that can write to the ProcessEventLog can override the following configuration, which should be based on the process name: <process name>.writeDatabaseProcessLogs - if true, then the AuditEventLog will be created; if false, then the AuditEventLog will not be created.

The same set of processes that can write to the AuditEventLog can write to the ProcessEventLog.

Columns

Column NameColumn TypeDescription
DateStringThe date on which the log event was generated. This is the partitioning column.
TimestampDateTimeThe timestamp for the logged event.
HostStringThe host name for the logged event.
LevelStringThe level for the event. This is usually one of the standard log levels (INFO, WARN, etc), but in the case of a worker output logged by the query server, it will instead indicate the level of captured output (stdout or stderr).
ProcessStringThe name of the process that generated the event (e.g., RemoteQueryDispatcher, worker_1).
ProcessInfoIdStringWorker ProcessInfoId of the running query.
AuthenticatedUserStringThe authenticated user who last ran this query.
EffectiveUserStringThe effective user who last ran this query.
LogEntryStringThe logged event.