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

Inactive, unmounted, unaccessible VMware datastore causes errors: Unknown column 'nan' in 'field list'

XMLWordPrintable

    • Sprint 52 (May 2019)
    • 0.125

      Steps to reproduce:

      1. Zabbix Server 4.0.7
      2. VMware vSphere 6.X
        Hypervisor - VMware ESXi, 6.0.0, 3620759
        vSphere - Version 6.0.0 Build 6855238
        
      3. default VMware template

      All such datastores are discovered and added to the monitoring...

      Result:
      Zabbix Server crash with log full of database error messages:

       18270:20190520:144754.580 [Z3005] query failed: [1054] Unknown column 'nan' in 'field list' [insert into history (itemid,clock,ns,value) values (77574,1558378074,41755407,36.384224),(78474,1558378074,45160051,6.764451),(80274,1558378074,45354634,23.046398),(82374,1558378074,45655823,56.875324),(78174,1558378074,46113976,16.351151),(60174,1558378074,46399604,17.417173),(80574,1558378074,47757805,19.618302),(68574,1558378074,48078880,14.979284),(102774,1558378074,48376821,54.874377),(80874,1558378074,48508689,34.084469),(101574,1558378074,48772348,14.368895),(67374,1558378074,49108840,31.500772),(78774,1558378074,49387480,12.670710),(67674,1558378074,49712409,36.531139),(81474,1558378074,50699982,27.440721),(85974,1558378074,52189729,99.974917),(61374,1558378074,52255032,20.746909),(109074,1558378074,53006333,-nan),(82674,1558378074,53410889,25.347111),(61674,1558378074,53794587,12.334327),(71274,1558378074,53925894,2.717302),(106074,1558378074,54331215,21.409006),(84774,1558378074,57335396,99.974917),(73074,1558378074,57659309,12.537814),(85374,1558378074,58385534,99.974917),(73374,1558378074,58907869,70.541076),(88374,1558378074,59182560,19.955756),(89274,1558378074,59317092,98.097187),(37974,1558378074,59387960,3.762336),(182874,1558378074,59579068,4.533670),(187374,1558378074,59860606,95.101436),(182574,1558378074,60323818,5.980540),(181974,1558378074,60806040,15.444616),(183474,1558378074,61471119,66.232502),(184974,1558378074,61942844,21.549336),(74574,1558378074,62164789,41.187996),(186474,1558378074,63262201,3.826418),(75474,1558378074,63457205,0.917594),(88974,1558378074,63839916,22.085608),(59874,1558378074,64182771,24.888693),(47874,1558378074,64470472,1.885417),(23274,1558378074,64725709,99.996456),(63774,1558378074,66122046,3.762244),(77874,1558378074,67383942,9.552083),(77274,1558378074,67832516,40.585229),(76974,1558378074,67905481,71.290244),(28434,1558378074,70114784,87.565423);
      
      (109074,1558378074,53006333,-nan)
      

      Expected:

            ak Andrejs Kozlovs
            edgar.akhmetshin Edgar Akhmetshin
            Team A
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: