[ZBX-9217] Inventory->Hosts not show some hosts Created: 2015 Jan 15  Updated: 2017 May 30  Resolved: 2015 Feb 19

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 2.4.3
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: Chagin Grigory Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: inventory
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Debian 7


Attachments: PNG File zab1.png     PNG File zab2.png    
Issue Links:
Duplicate
duplicates ZBX-4633 On Inventory->Hosts page not all host... Closed

 Description   

Open Inventory->Overview and grouping by Type, Click to one of types and don't see any hosts in list



 Comments   
Comment by Alexander Vladishev [ 2015 Jan 19 ]

What database are you using?
Do you use automatic population of host inventory?

Comment by Alexander Vladishev [ 2015 Jan 19 ]

Please attach an output of this sql statement:

select type, length(type) from host_inventory where type like '%GS-4012S%';

Seems problem with trailing or leading spaces. These can be received by automatic population of host inventory.

Comment by Chagin Grigory [ 2015 Jan 19 ]

DB type: mysql; Use autodiscovery;

mysql> select type, length(type) from host_inventory where type like '%GS-4012F%';
+----------+--------------+
| type     | length(type) |
+----------+--------------+
| GS-4012F |            8 |
+----------+--------------+
1 row in set (0.00 sec)
Comment by Alexander Vladishev [ 2015 Jan 27 ]

Sorry for a delay.

The issue still reproducible with such data (without spaces)? I can reproduce it on my environment only with inventory data with trailing spaces.

Comment by Chagin Grigory [ 2015 Jan 28 ]

Yes. Still reproduce. I have hosts > 1000, may be inventory work only with first 1000 hosts?

I'm analyze SQL queries and saw

SELECT h.hostid,h.name,h.status FROM hosts h WHERE h.flags IN (0,4) AND h.status IN (0,1) AND h.hostid IN ( SELECT hin.hostid FROM host_inventory hin) LIMIT 1001 OFFSET 0

Comment by Alexander Vladishev [ 2015 Feb 19 ]

It is a duplicate of ZBX-4633.

Generated at Fri Mar 14 17:06:31 EET 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.