MV_EVENTS

This view contains information about events and is useful for monitoring events across clusters over time.

Information on the most recent 1028 events is stored in the view. The view is flushed upon database restart, but otherwise there is no set retention period.

Events from all nodes are stored in the view and when a node is restarted, events specific to that node are removed from the view. For example, if the Master Aggregator is restarted, events related to it are removed from the view, while events from other nodes will remain.

Learn more about interpreting this view in the Components to Monitor guide.

Column Name

Description

ORIGIN_NODE_ID

The ID of the node from where a given event occurred.

EVENT_TIME

The timestamp of a given event.

SEVERITY

The severity of a given event: NOTICE, WARNING, or ERROR

EVENT_TYPE

The type of event that occurred.

DETAILS

Additional information about a given event in JSON format.

MV_EVENTS.EVENT_TYPE

Provides descriptions for each potential result of SELECT DISTINCT EVENT_TYPE FROM information_schema.MV_EVENTS. Each result is one type of event occurring on the related node.

Event Type

Description

NODE_STARTING

The related node is starting up.

NODE_ONLINE

The related node is online.

NODE_OFFLINE

The related node is offline.

NODE_ATTACHING

The related node is attaching.

NODE_DETACHED

The related node is detaching.

LEAF_ADD

A leaf node is being added to the cluster.

LEAF_REMOVE

A leaf node is being removed from the cluster.

AGGREGATOR_ADD

An aggregator is being added to the cluster.

AGGREGATOR_REMOVE

An aggregator is being removed from the cluster.

DATABASE_REPLICATION_START

Replication of the database is started.

DATABASE_REPLICATION_STOP

Replication of the database is stopped.

REBALANCE_STARTED

REBALANCE_FINISHED

A partition rebalance has finished.

NOTIFY_AGGREGATOR_PROMOTED

The related node has been notified of an aggregator being promoted from child to master.

NODE_REACHABLE

The related node has become reachable.

NODE_UNREACHABLE

The related node has become unreachable.

SYSTEM_VAR_CHANGED

An engine variable was reconfigured.

HEARTBEAT_QUERY_FAILURE

A heartbeat query failed.

BACKUP_DB

The related database, and therefore the given node, has been backed up.

RESTORE_DB

A backup of the related database, and therefore the given node, has been restored.

MAX_MEMORY

Maximum server memory has been hit.

MAX_TABLE_MEMORY

Maximum table memory has been hit.

MAX_MEMORY_ON_REPLAY

This means that replicate operations ran out of memory, stopping replay.

PARTITION_UNRECOVERABLE

A partition is lost due to failure and no longer can be recovered.

WORKLOAD_THROTTLE

PIPELINE_STOPPED

A pipeline stopped.

INGEST_ERRORS_OUT_OF_DISK

Ingest is failing due to low disk space available.

DATABASE_REPROVISION

The related database is being reprovisioned.

MAX_BLOB_CACHE_SIZE_ON_REPLAY

This means that SingleStore ran out of cache space while attempting to create a blob, stopping replay.

CONSENSUS_ROLE_TRANSITION

Indicates a role transition has happened on this node (for example, voting member --> demoted voting member), and has the following keys:

  • Previous_role - the previous role the node had

  • New_role - the new role the node has

  • Reason - description of why there was a transition

CONSENSUS_ELECTION

Indicates a consensus election has been started by this node. It has no keys.

CONSENSUS_VOTING_REQUEST_RECEIVED

Indicates a voting request has been received by this node. It has the following keys:

  • Node_id - id of the node that sent the vote request

  • Last_log_index/ last_log_term / term - details of the vote request

CONSENSUS_VOTING_RESPONSE_SENT

Indicates this node has responded to a voting request that it received. It has the following keys:

  • Node_id - id of the node that send the request this response is referring to

  • Term - term of the vote request

  • Vote - whether the voter voted yes or no

CONSENSUS_VOTING_REQUEST_SENT

Indicates this node has sent a vote request. It has the following keys:

  • Node_id - id of the node that it sent the vote request to

  • Last_log_index/ last_log_term / term - details of the vote request

CONSENSUS_VOTING_RESPONSE_RECEIVED

Indicates this node has received a vote response to a request it sent. It has the following keys:

  • Node_id - id of the node that sent the vote response.

  • Term - term of the vote request

  • Vote - whether the voter voted yes or no

NEW_MASTER_AGGREGATOR

indicates a new master aggregator has been elected (will also be issued when AGGREGATOR SET AS MASTER is used to forcibly change the MA); each node in the cluster will issue this event when it learns of the election.

It has the following keys:

  • Node_id - id of the new MA

  • Term - term for the new MA

Last modified: September 25, 2024

Was this article helpful?