Column name
|
Description
|
---|---|
STATE
|
Current state of the message. The following values are possible:
▪ 0 = DELETED N/A (internal non-persistent state)
▪ 1 = ERROR - Error has occurred during message processing; the reason for the error was recorded in the error-columns of the row.
▪ 10 = RECEIVED - master has received a message from the replica
▪ 11 = SAVED - message has been saved in the master database and is being processed
▪ 12 = READY - master has processed the message
▪ 13 = SENT - N/A (internal non-persistent state)
|
REPLICA_ID
|
ID of the replica database from which the message was sent.
|
MASTER_ID
|
ID of the database to which the master is sent.
|
MSG_ID
|
Internal ID of the message.
|
MSG_NAME
|
Name of the message given by the user.
|
MSG_TIME
|
Create time of the message.
|
MSG_BYTE_COUNT
|
Size of the message in bytes.
|
CREATE_UID
|
ID of the user who created the message.
|
FORWARD_UID
|
ID of the user who forwarded the message.
|
ERROR_CODE
|
Code of the error that caused the termination of the message execution. You can determine the transaction and statement that caused the error from the TRX_ID and STMT_ID information.
|
ERROR_TEXT
|
Description of the error that caused the termination of the message execution.
|
TRX_ID
|
Sequence number of the transaction that caused the error.
|
STMT_ID
|
Sequence number of the statement of a transaction that caused an error.
|
ORD_ID_COUNT
|
N/A (internal use only).
|
ORD_ID
|
N/A (internal use only).
|
FLAGS
|
NULL or 0 = Normal message.
1 = Message is deleted when reply is sent to replica.
|
FAILED_MSG_ID
|
This is an INTEGER column which is part of the primary key. The value is zero for normal messages. The value is msg_id if LOG_ERRORS option is ON and any errors exists.
|