在搭建完Gbase集群监控系统后,需要在平台管理中新建集群和新建采集中心。采集中心新建安装完成后,通过系统提供的服务器管理页面的模板导入采集节点后,启动采集代理失败,采集中心报错:
2021-10-13 13:48:51,095 ERROR [XML-RPC-0] task.AcquireClusterInfo getClusterVersion (AcquireClusterInfo.java:109) - Not any one node is started or all node's proxy services are unavailable.
2021-10-13 13:48:59,312 ERROR [XML-RPC-0] impl.NodeOPT startNode (NodeOPT.java:327) - The Center hasn't inited or failed to connect resource db!
进一步排查,执行查看节点监控指标信息,执行查询语句:
select monitor_index.index_name,kind,threshold,unit_code,is_summary_alarm,is_cancel_single_alarm,summary_type,summary_judgment_condition,summary_threshold,`condition`,monitor_level.`level`,is_recovery,is_series,code,event_name,warning_conf.`desc`,alarm_object,strategy_class,event_name_ch,continuous_break_num,summary_strategy_class from monitor_index inner join warning_conf on monitor_index.id = warning_conf.id inner join `cluster` on `cluster`.strategy_id=monitor_index.strategy_id inner join `monitor_level` on `monitor_index`.level_id = monitor_level.id left join `monitor_index_summary_type` on `monitor_index`.summary_type=`monitor_index_summary_type`.id where `cluster`.is_delete = 0 and monitor_index.is_exception=1 and monitor_index.index_name='sql_execute_time'
发现continuous_break_num字段在默认值为1,但是执行后默认值为null
发现这个字段不同的Gbase 集群版本对default 默认值的支持不一致,修改对应的资源库的版本即可。



