【现场需求】中兴VMAX项目_故障EVENT信息显示来源、时间、原因等详细信息以便排查
使用版本:9.5.3.28.4及以上的953版本
实现方式:增加detail参数,用于显示
1.fevent log的产生时间
2.产生来源(哪个节点记录的)
3.记录执行sql记录feventlog的sessionid
4.执行sql类型
操作示例:
[gbase@zhangcuiping-node-1 statemachine]$ gcadmin showddlevent detail =========》增加detail参数,其他参数不变
Vc event count:1
Event ID: 6
ObjectName: test
Fail Node Copy:
Fail Data Copy:
NodeIP: 10.10.14.35 FAILURE
Time:2023-02-01 15:03:10.944 Source:10.10.59.49 SessionId:102 Cmd:CREATE_DB =======》增加显示内容
[gbase@zhangcuiping-node-1 statemachine]$ gcadmin showddlevent =======》原有fevent log的显示
Vc event count:1
Event ID: 6
ObjectName: test
Fail Node Copy:
Fail Data Copy:
NodeIP: 10.10.14.35 FAILURE
----目前cmd为unknown类型的sql如下:
1.initnodedatamap
2.镜像表
显示create_table
create table vc1.DB.t(a int, aa varchar(10));
CREATE TABLE VC1.DB.T2 MIRROR TO vc AS SELECT * FROM VC1.DB.T;
显示unknown
ALTER TABLE VC1.DB.T3 CREATE MIRROR TO vc FORCE;
ALTER DATABASE vc1.db1 CREATE MIRROR TO vc;
ALTER DATABASE VC1.db2 SET DEFAULT MIRROR = null;
ALTER TABLE VC1.DB.T1 DELETE MIRROR;
ALTER DATABASE VC1.DB DELETE MIRROR;
3.create encryption/alter encryption
----cmd=SET_OPTION,sql类型如下:
1.同步工具:==>产生dmlevent且cmd=SET_OPTION
[gbase@zhangcuiping-node-2 gcluster_rsynctool]$ ./gcluster_rsynctool.py --master_mpp_ip=10.10.14.64 --master_mpp_gc_pw=gbase20110531 --slave_mpp_ip=10.10.14.36 --slave_mpp_gc_pw=gbase20110531 --table_list_file=t.list1 --log_level=5 --rsync_mode=0 --sync_vc_name=vc1
2.SET PASSWORD = PASSWORD(‘test1’);==>产生ddlevent且cmd=SET_OPTION
3.set self gcluster_node_status_list=‘vcid:db.tb:segment:nodeid:datastate:scn’ 产生dmlevent且cmd=SET_OPTION