[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: |
![]() ![]() |
||||||||
Issue Links: |
|
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? |
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
|
Comment by Alexander Vladishev [ 2015 Feb 19 ] |
It is a duplicate of |