rs_exceptslast

Stores the origin ID, secondary queue ID, and associated information about the last logged transaction written into the exceptions log.

Column

Datatype

Description

error_db

int

Database where the error occurred

origin

int

Origin database of the transactions

origin_qid

binary(36)

qid of the last transaction from this origin

secondary_qid

binary(36)

Secondary qid of the last logged transaction from this origin

status

tinyint

Status of the transaction:

  • 0 – Valid: no transactions were lost for this origin

  • 1 – Detecting losses: you should determine if any transactions have been lost in this origin

  • 2 – Rejecting messages after loss detected: transactions were probably lost for this origin

origin_time

datetime

Time at origin for the transaction

log_time

datetime

Time the transaction was logged

lorigin

int

Logical database where the message originated

Indexes

  • Unique index on (error_db, origin)

  • Unique index on (error_db, origin, status)