transactions:list#

#rai transactions:list [OPTIONS]

Displays information about transactions processed by RelationalAI (RAI) engines. Transactions include queries from RAI Python models and data stream batch processing. By default, only transactions for the current user are listed. Requires the eng_user application role.

Options#

OptionTypeDescription
--idTextFilter transactions by ID.
--stateTextFilter transactions by state. May be one of:
  • CREATED
  • QUEUED
  • RUNNING
  • CANCELING
  • COMPLETED
  • ABORTED
--limitIntegerLimit the number of transactions to list.
--all-usersFlagInclude transactions from all users.

Transactions States#

Transactions can have the following states:

StateDescription
CREATEDThe transaction has been accepted but is not yet in the engine queue. If it remains in this state, the engine’s resources are at capacity. Consider increasing the engine size or cancelling the transaction and running it on a different engine.
QUEUEDThe transaction is in the engine’s queue. If it remains in this state, the engine’s concurrency limit has been reached. Wait for the transaction to leave the queue or cancel it and rerun on a different engine.
RUNNINGThe transaction is being processed by the engine.
CANCELINGThe transaction is being cancelled.
COMPLETEDThe transaction has been successfully processed.
ABORTEDThe transaction was cancelled or aborted due to an error. Check the ABORT_REASON field for more details.

Example#

Use the transactions:list command to view a list of engine transactions:

#$ rai transactions:list

---------------------------------------------------

▰▰▰▰ Transactions fetched


  ID                                  Schema    State       Created               Duration
 ──────────────────────────────────────────────────────────────────────────────────────────
  01b439a7-0002-6944-0051-c0070497…   MyModel   COMPLETED   2024-05-09 18:15:31       2.4s
  01b439a7-0002-693d-0051-c0070498…   MyModel   COMPLETED   2024-05-09 18:15:06      20.5s


---------------------------------------------------

By default, the transactions:list command lists all transactions for the current user. Use the --all-users flag to include transactions from all users.

To filter transactions by ID, state, or limit, pass the corresponding option:

#$ rai transactions:list --state aborted --limit 1

---------------------------------------------------

▰▰▰▰ Transactions fetched


  ID                                  Schema    State     Created               Duration
 ──────────────────────────────────────────────────────────────────────────────────────────
  01b439a7-0002-692f-0051-c0070497…   myModel   ABORTED   2024-05-09 18:16:28       1.2s


---------------------------------------------------

See Compute Resources for more information on RAI engines and engine management.

See Also#