Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-15752

Zabbix - PGRES_FATAL_ERROR.

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Commercial support required
    • Icon: Critical 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 !

        1. screenshot-1.png
          162 kB
          Клыков Александр
        2. screenshot-2.png
          135 kB
          Клыков Александр

            dotneft Alexey Pustovalov
            Alexadre Клыков Александр
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: