首页 > 其他分享 >zabbix-proxy报错:cannot send list of active checks to “x.x.x.x“:delete from hostmacro where hostid...

zabbix-proxy报错:cannot send list of active checks to “x.x.x.x“:delete from hostmacro where hostid...

时间:2023-08-15 18:05:01浏览次数:45  
标签:... list send zabbix hostmacro 报错 proxy where delete

最近新部署了zabbix,两台zabbix-proxy访问一台zabbix-server 请添加链接描述 proxy的日志里一直都有这些数据

62827:20230813:032210.216 cannot send list of active checks to "10.x.x.x": host [prod-nacos-2.sugon.local] not found
162826:20230813:032212.459 cannot send list of active checks to "10.x.x.x": host [prod-ibms-log] not found
 
delete from hostmacro where hostmacroid in (5264,5265,5266,5267,5268,5269,5270,5271,5272,5273,5274,5275,5276,5277,5278,5279,5280,5281,5282,5283,5284,5285,5286,5287,5288,5289,5290,5291,5292,5293,5294,5295,5296,5297,5298,5299,5505,5506,6085,6087,6088,6089,6090,6091,6092,6093,6094,6095,6096,6097,6098,6099,6100,6101,6102,6103,6104,6105,6106,6107,6108,6109,6110,6111,6112,6113,6114,6115,6116,6117,6118,6119,6120,6121,6122,6123,6124,6125,6126,6127,6128,6129,6130,6131,6132,6133,6134,6135,6136,6137,6138,6139,6140,6141,6142,6143,6144,6145,6146,6147,6148,6149,6150,6151);
delete from interface where interfaceid in (21,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,141,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208);
delete from hosts where hostid in (10081,10577,10580,10581,10582,10583,10584,10585,10586,10587,10588,10589,10590,10591,10592,10593,10594,10595,10596,10597,10598,10599,10600,10601,10602,10603,10604,10605,10606,10607,10608,10609,10610,10611,10612,10613,10614,10615,10616,10617,10618,10619,10620,10621,10622,10623,10624,10625,10626,10627,10628,10629,10630,10631,10632,10633,10634,10635,10636,10637,10638,10639,10698,10702,10703,10705,10707,10708,10709,10710,10711,10712,10713,10714,10715,10716,10717,10718,10719,10720,10721,10722,10723,10724,10725,10726,10727,10728,10729,10730,10731,10732,10733,10734,10735,10736,10737,10738,10739,10740,10741,10742,10743,10744,10745,10746,10747,10748,10749,10750,10751,10752,10753,10754,10755,10756,10757,10758,10759,10760,10761,10762,10763,10764,10765,10766,10767,10768,10769,10770,10771);

排查了几天,最后的原因出现在proxy使用的数据库上;

我们使用的PG库,之前出现错误,是因为我们两台proxy都连了同一个库,这个库还是server的zabbix_proxy库,后面调整为,两台proxy各连各的库,问题解决,再没有之前的日志信息,豁然开朗。

标签:...,list,send,zabbix,hostmacro,报错,proxy,where,delete
From: https://blog.51cto.com/u_16013950/7091707

相关文章

  • css 显示不完...
    参考:https://www.cnblogs.com/Nyan-Workflow-FC/p/13852337.html显示一行,显示不完...white-space:nowrap;text-overflow:ellipsis;overflow:hidden;最多显示两行,显示不完...white-space:normal;display:-webkit-box;......
  • grafana报错too many outstanding requests
    grafana报错toomanyoutstandingrequests1、问题描述当grafana使用loki作为数据源查询数据时,面板报错toomanyoutstandingrequestsloki的版本是2.8.0报错截图2、解决办法loki的配置文件中添加下面这两行query_scheduler:max_outstanding_requests_per_tenant:1000......
  • 【IDEA】出现 Element ‘project‘ cannot have character [children]...错误
    问题描述Element'project'cannothavecharacter[children],becausethetype'scontenttypeiselement-only.元素'project'不能有字符[children],因为该类型的内容类型是仅元素。 我这边是因为多了一行注释没有删除导致 解决方案检查代码,删除多余的代码......
  • dav 编译报错 v8内存溢出
    dav编译报错v8内存溢出FATALERROR:ReachedheaplimitAllocationfailed-JavaScriptheapoutofmemory  到node_modules中/.bin/roadhog.cmd把最后一句改成endLocal&goto#_undefined_#2>NUL||title%COMSPEC%&"%_prog%"--max_old_space_size=8192......
  • Oracle启动监听报错:The listener supports no services或出现 unknown状态解决
    1、查看$ORACLE_HOME/network/admin/listener.ora文件中的host是否正确,能不能ping通2、查看$ORACLE_HOME/network/admin/tnsnames.ora文件中的host是否与listener.ora中的一致3、查看/etc/hosts文件中的127.0.0.1是不是localhost,listener.ora中host跟这里的是否一样4、登录数......
  • SVN打开文件报错
    问题描述:'D:\WorkSpace\vvvvv\XXXXXXX-K3Cloud'isalreadylocked.“ 原因分析:上一次异常操作了。解决方案:找到项目目录:右键打开   ......
  • 引入feign注入报错 org.springframework.beans.factory.NoSuchBeanDefinitionExceptio
    引入feign注入报错org.springframework.beans.factory.NoSuchBeanDefinitionException解决[172.16.22.215]out:Causedby:org.springframework.beans.factory.NoSuchBeanDefinitionException:Noqualifyingbeanoftype'com.test.mydock.api.FeignRemoteTestService�......
  • json字符串转换对象或列表,多了字段不会报错
    json字符串转换对象或列表,多了字段不会报错//DEMO1转换对象应用riskIdpublicclassItem{privateStringid;privateStringrate;publicItem(Stringid,Stringrate){this.id=id;this.rate=rate;}@Overridepubl......
  • 在使用npm进行全局安装时报错
    我们在使用npm安装全局以来时,两台电脑安装有可能一台成功了,一台失败了。这是windows执行策略的问题。1.以管理员的身份运行powershell。powershell在开始里查找便可以找到。2.输入命令 set-ExecutionPolicyremoteSigned,选择A允许执行。......
  • Insert 1, Insert 2, Insert 3, ...
    Insert1,Insert2,Insert3,...时间限制(普通/Java):2000MS/4000MS内存限制:1048576KByte描述输入输出样例输入6112233样例输出8思路单调栈从左到右遍历数组,遇到1则入栈;若不为1则判断能否与最近的1匹配,如果能则继续,如果不能,则将栈顶......