upgrade_status()#

relationalai.app
#upgrade_status

A view containing status details of the RelationalAI (RAI) Native App engine upgrade process. Requires the app_admin application role.

Columns#

ColumnTypeDescription
NA_VERSIONSTRINGThe current version of the RAI Native App. This is the same version returned by the app.get_release() function.
ATTEMPTNUMBERThe number of times the current upgrade has been retried. `NULL if no upgrades have been attempted.
STATESTRINGThe current state of the upgrade. DONE when the upgrade is complete. The app.finalize_upgrade() procedure must then be called to complete the upgrade process.
ENGINE_COUNTSTRINGThe number of engines that have been upgraded.
STARTED_ATTIMESTAMPThe time when the upgrade process started.
LAST_UPDATETIMESTAMPThe time when the upgrade status was last updated.

Example#

Use the app.upgrade_status view to check the status of the RAI Native App engine upgrade process:

#SELECT * FROM relationalai.app.upgrade_status;
/*+-------------------------+---------+-------+--------------+-------------------------------+-------------------------------+
  | NA_VERSION              | ATTEMPT | STATE | ENGINE_COUNT | STARTED_AT                    | LAST_UPDATE                   |
  |-------------------------+---------+-------+--------------+-------------------------------+-------------------------------|
  | 2024.10.27-e829e39d     | 1       | DONE  | 9            | 2024-10-27 08:11:32.490 -0700 | 2024-10-27 08:17:45.108 -0700 |
  +-------------------------+---------+-------+--------------+-------------------------------+-------------------------------+ */

For more information on upgrading the RAI Native App, see Upgrades.

See Also#