-
Problem report
-
Resolution: Commercial support required
-
Critical
-
None
-
4.0.5
-
None
Good day.
Today night (in 03:00 MSK) we got problem with database postgres, see below:
25600:20190304:115631.337 cannot send list of active checks to "10.119.101.217": host [dc1-balancer-vm01] not found 25170:20190304:115631.369 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: no partition of relation "history" found for row DETAIL: Partition key of the failing row contains (clock) = (1551689750). [insert into history (itemid,clock,ns,value) values (867994,1551689750,384772864,284779.859464),(860989,1551689756,224162998,221412.266472),(867927,1551689787,383070343,366.818216),(284251,1551689791,273793699,44.460273),(569371,1551689791,276740653,3.045685),(601171,1551689791,300781547,41.274912),(593671,1551689791,358662289,46.043543),(859256,1551689794,686866352,61036.806968); ] 25158:20190304:115631.383 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: no partition of relation "history" found for row DETAIL: Partition key of the failing row contains (clock) = (1551689761). [insert into history (itemid,clock,ns,value) values (868912,1551689761,245814975,128644.649192),(586726,1551689785,875416484,0.006010),(588009,1551689785,875416484,0.006030),(584713,1551689785,875416484,0.000000),(587292,1551689785,875416484,0.009273),(588050,1551689785,875416484,0.021283),(584760,1551689785,875416484,0.000000),(584973,1551689785,875416484,100.000000),(587142,1551689785,875416484,0.007233),(588432,1551689785,875416484,0.000000),(586540,1551689785,875416484,0.005293),(585027,1551689785,875416484,0.000000),(584346,1551689786,247644428,0.000000),(587674,1551689786,247644428,0.000000),(588068,1551689786,247644428,0.004403),(588509,1551689786,247644428,0.000000),(587732,1551689786,247644428,0.002483),(586781,1551689786,247644428,0.024803),(588788,1551689786,247644428,0.007433),(588055,1551689786,247644428,0.006280),(584895,1551689786,247644428,0.000000),(585354,1551689786,247644428,100.000000),(584410,1551689786,247644428,0.000000),(654578,1551689786,247644428,0.003277),(675691,1551689791,381043938,96.745218); ] 25149:20190304:115631.488 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: no partition of relation "history" found for row DETAIL: Partition key of the failing row contains (clock) = (1551689643). [insert into history (itemid,clock,ns,value) values (882174,1551689643,606095172,5475691834.376192),(863576,1551689669,491020199,4915021742.080000),(861976,1551689781,792408487,44610.206152),(618991,1551689791,396619392,2.469136),(568951,1551689791,408292205,82.258065),(555631,1551689791,413841451,87.629544),(894631,1551689791,416162117,36.794554),(280831,1551689791,421058514,91.704534),(569251,1551689791,424207250,76.045627),(283771,1551689791,439896597,44.217157); ] 25149:20190304:115631.492 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: no partition of relation "history_uint" found for row DETAIL: Partition key of the failing row contains (clock) = (1551689719). [insert into history_uint (itemid,clock,ns,value) values (849323,1551689719,793571230,82468),(388351,1551689791,489957864,1551689470); ] [root@dc1-prod-centos-zabbix-01 zabbix]#
etc.
Please, help us. We do not have any graphs !