Purpose
The oceanbase.CDB_OB_TENANT_EVENT_HISTORY view displays the historical operation records of all tenants in the current cluster. You can query this view only from the sys tenant.
Note
This view is introduced since OceanBase Database V4.2.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| TIMESTAMP | timestamp(6) | NO | The time when the operation was executed, in microseconds. |
| MODULE | varchar(256) | NO | The name of the module. |
| EVENT | varchar(256) | NO | The name of the event. |
| NAME1 | varchar(256) | YES | The name of the first attribute. |
| VALUE1 | longtext | YES | The value of the first attribute. |
| NAME2 | varchar(256) | YES | The name of the second attribute. |
| VALUE2 | longtext | YES | The value of the second attribute. |
| NAME3 | varchar(256) | YES | The name of the third attribute. |
| VALUE3 | longtext | YES | The value of the third attribute. |
| NAME4 | varchar(256) | YES | The name of the fourth attribute. |
| VALUE4 | longtext | YES | The value of the fourth attribute. |
| NAME5 | varchar(256) | YES | The name of the fifth attribute. |
| VALUE5 | longtext | YES | The value of the fifth attribute. |
| NAME6 | varchar(256) | YES | The name of the sixth attribute. |
| VALUE6 | longtext | YES | The value of the sixth attribute. |
| EXTRA_INFO | longtext | YES | The additional information about the event. |
| SVR_IP | varchar(46) | YES | The IP address of the OBServer node on which the operation was executed. |
| SVR_PORT | bigint(20) | YES | The port number of the OBServer node on which the operation was executed. |
| TRACE_ID | varchar(64) | YES | The trace ID of the operation. |
| COST_TIME | bigint(20) | YES | The time taken to execute the operation. |
| RET_CODE | bigint(20) | YES | The error code for the operation. The value 0 indicates that the operation was successfully executed. |
| ERROR_MSG | varchar(512) | YES | The error message. |