Note
This view is available starting with V4.0.0.
Purpose
This view displays the event history of an OBServer node.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TIMESTAMP | timestamp(6) | NO | The time when the event occurred. |
| SVR_IP | varchar(46) | NO | The IP address of the node where the event occurred. |
| SVR_PORT | bigint(20) | NO | The port of the node where the event occurred. |
| MODULE | varchar(64) | NO | The name of the module to which the event belongs. |
| EVENT | varchar(64) | NO | The name of the event. |
| NAME1 | varchar(256) | YES | The name of the first event attribute. |
| VALUE1 | varchar(256) | YES | The value of the first event attribute. |
| NAME2 | varchar(256) | YES | The name of the second event attribute. |
| VALUE2 | longtext | YES | The value of the second event attribute. |
| NAME3 | varchar(256) | YES | The name of the third event attribute. |
| VALUE3 | varchar(256) | YES | The value of the third event attribute. |
| NAME4 | varchar(256) | YES | The name of the fourth event attribute. |
| VALUE4 | varchar(256) | YES | The value of the fourth event attribute. |
| NAME5 | varchar(256) | YES | The name of the fifth event attribute. |
| VALUE5 | varchar(256) | YES | The value of the fifth event attribute. |
| NAME6 | varchar(256) | YES | The name of the sixth event attribute. |
| VALUE6 | varchar(256) | YES | The value of the sixth event attribute. |
| EXTRA_INFO | varchar(512) | YES | Additional information. |
Sample query
Query the first record of the DDL events on an OBServer node in the sys tenant.
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_SERVER_EVENT_HISTORY WHERE MODULE = 'ddl' ORDER BY TIMESTAMP DESC LIMIT 1;
The query result is as follows:
*************************** 1. row ***************************
TIMESTAMP: 2026-01-29 16:42:32.673049
SVR_IP: 172.xx.xxx.xxx
SVR_PORT: 2882
MODULE: ddl
EVENT: create table execute finish
NAME1: tenant_id
VALUE1: 1002
NAME2: ret
VALUE2: 0
NAME3: trace_id
VALUE3: YB4**********************************
NAME4: rpc_dst
VALUE4: "172.xx.xxx.xxx:2882"
NAME5: table_info
VALUE5: 500217
NAME6: schema_version
VALUE6: 1769676152629320
EXTRA_INFO:
1 row in set