[ZBX-16150] Inactive, unmounted, unaccessible VMware datastore causes errors: Unknown column 'nan' in 'field list' Created: 2019 May 21  Updated: 2024 Apr 10  Resolved: 2019 May 30

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 4.0.7, 4.2.1
Fix Version/s: 4.0.10rc1, 4.2.4rc1, 4.4.0alpha1, 4.4 (plan)

Type: Problem report Priority: Blocker
Reporter: Edgar Akhmetshin Assignee: Andrejs Kozlovs
Resolution: Fixed Votes: 1
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File VMFS-IN.png    
Issue Links:
Causes
Team: Team A
Sprint: Sprint 52 (May 2019)
Story Points: 0.125

 Description   

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:



 Comments   
Comment by Andrejs Kozlovs [ 2019 May 29 ]

Fixed in:

  • 4.0.9rc1 93f256c317e
  • 4.2.3rc1 918f976a95d
  • 4.4.0alpha1 (trunk) d91dcb9dfc5
Generated at Fri Apr 26 14:19:02 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.