Pivotal Knowledge Base

Follow

Description on CURRENT_STATEMENT_STATUS Field of SYS.SESSIONS

Applies To

SQLFire 1.1.2.3 to GemfireXD 1.x

Purpose

This document provides a detailed description of the statuses found in the CURRENT_STATEMENT_STATUS field of the SYS.SESSIONS table.

Description

The CURRENT_STATEMENT_STATUS field of the SYS.SESSIONS table gives the current operation being performed for the SQL statement.

Batch Mode has the following statuses:

  1. EXECUTING BATCH: The current session's status is running the batch job.
  2. EXECUTING PREPAREDSTATEMENT: The current session's status is running a prepared statement.
  3. CHECKING BUCKET HOSTED: The current session's status is checking the buckets from all GemFireXD servers that hosted the resultSet when executing the prepared statement.
  4. EXECUTING STATEMENT: The current session's status is running the statement.
  5. BATCH EXCEPTION + Exception.getMessage(): Batch statement execution has an exception.

Non-Batch mode has  the following statuses:

  1. PARSING: The current session's status is parsing the prepared statement.
  2. COMPILED: The current session's status has completing the parsing prepared statement.
  3. SENDING RESULTS: The current session's status is beginning to send the results to the client.
  4. HAS MORE DATA: GemfireXD/SQLFire will sometime split large data objects into blocks; this status indicates that it still has more data blocks on the server side and is still sending the results to client.

References

  1. SESSIONS System Table description.

Comments

Powered by Zendesk