Problems after installation of 3.4.5

[LondonLass]

I've come back to zabbix after using for a couple of previous roles. After installation I am having mixed success with data being collected, and then listing or visualising.

* Zabbix Server / Agent is 3.4.5
* Infrastructure is Red Hat Enterprise Linux Server release 7.4
* Database is Mariadb 10.2.8
* Simple Master/Agent setup : no proxies
* Simple corporate setup : no internal firewall or network barriers
* Installation was rpm -> rpm2cpio + internal deployment mechanism

I then setup a number of hosts with the "Template OS Linux" to seed with some simple items.

Under latest data I can these see some of the data being collected, so for example, these items are reliably giving data across a number of hosts ... and therefore can see data, graphs etc

+ Free disk space on <fs> (percentage)

However I can't see any data/graphs for

- Free disk space on /
- Available memory
- Free swap space
- Total memory

On reflection it appears that any parameter that

+ Numeric (float) works fine,
+ Character works fine
- Numeric (unsigned) does not.

From a troubleshooting point of view I can see

* Data is collected without issue. I can use zabbix_get from the master server to evidence connectivity
* Data returned is evident in the zabbix server log file
* Data returned is evident in the mariadb query log in terms of inserts
* Data returned is evident in the mariadb database when I query the history_uint table

So I can track the data all of the way into the database but I can't get sight of it from the

* No data available for these items
* No graphs / last values possible

I have slowly increased the logging across the setup but can't see any issues. I'd appreciate any insight why only one data type doesn't work.

[LenR]

It might be this https://support.zabbix.com/browse/ZBX-13275

We had performance problems in the past 3.4.x versions even with partitioning active. Go to lastest 3.4 may be the fix.

[LondonLass]

Thanks for the response. I don't see anything there that relates to this. It's mostly about housekeeping. I am trying with the latest 3.4 however to see if that changes anything.

[dimir]

Could you post the output of the following command, e. g.:

$ for i in total free pfree; do zabbix_get -s <AGENT_IP> -k vfs.fs.size[/,$i]; done
117981093888
88247042048
78.817114

[LondonLass]

Of course ...

for i in total free pfree; do
  zabbix_get -s ${server} -k vfs.fs.size[/,$i]
done
4093313024
2436448256
63.091152

Could you post the output of the following command, e. g.:

$ for i in total free pfree; do zabbix_get -s <AGENT_IP> -k vfs.fs.size[/,$i]; done
117981093888
88247042048
78.817114

[dimir]

Looks like agent is returning the values just fine. Could you connect to the database and run SQL like this:

select distinct key_,value_type from items where key_ like 'vfs.fs.size%';

Also, in "Monitoring -> Latest data" could you check the boxes:

• Show items without data
• Show details

and make sure for the items that are missing the data there is no red cross in "Info" column, while if there is, mouse over it to get the error message.
Also, as for hosts that are missing data, do the miss the data from all the items or partially? If partially, could you give the example of such items, from single host?

[LondonLass]

I have traced all of this from testing via the zabbix_get, to seeing the values being inserted into the history_uint table just fine. I enabled the mysql log and could see the inserts taking place, and i can select those values back out again via mysql commands.

All of the hosts were setup in the same way, and all of them had the same problem. Never any data for any unsigned int values anywhere.

I wiped my install and am busy trying to install 3.4.15-1, so I can't run these commands right away, hopefully I won't need to if the latest 3.4 version just works :-) However I don't recall any red crosses anywhere.

Thanks very much for replying, I do appreciate it.

Looks like agent is returning the values just fine. Could you connect to the database and run SQL like this:

select distinct key_,value_type from items where key_ like 'vfs.fs.size%';

Also, in "Monitoring -> Latest data" could you check the boxes:

• Show items without data
• Show details

and make sure for the items that are missing the data there is no red cross in "Info" column, while if there is, mouse over it to get the error message.
Also, as for hosts that are missing data, do the miss the data from all the items or partially? If partially, could you give the example of such items, from single host?

[dimir]

Just for the record, the red crosses won't appear in "Monitoring -> Latest data" unless the above mentioned checkboxes are checked.
Good luck!

[LondonLass]

I have finished a clean re-install of 3.4.15-1 which I understand is the latest 3.4 version.

Still have the same problem. As a work around if i change the type to float it works without issue. I'm a bit stumped what would be stopping this from working.

There are no red crosses anywhere under "Monitoring -> Latest data" when the above mentioned checkboxes are checked for unsigned or float values.

Just for the record, the red crosses won't appear in "Monitoring -> Latest data" unless the above mentioned checkboxes are checked.
Good luck!

[kloczek]

* Installation was rpm -> rpm2cpio + internal deployment mechanism

People sometimes are doing crazy things ..

[LondonLass]

People sometimes are doing crazy things ..

Corporate environment. Got to play by their rules. Still not working!

[dimir]

Do you see the values in the database, the "history_uint" table? Does it contain any records at all?

[LondonLass]

Do you see the values in the database, the "history_uint" table? Does it contain any records at all?

The data collection appears to work perfectly. I can trace the data all the way into the database, and query it directly without issue. I just can't access it using the web interface in any way.

[dimir]

Can you confirm that the frontend is configured to use the same database as the server?

[LondonLass]

Can you confirm that the frontend is configured to use the same database as the server?

Yes. If I change an item to be a float it works perfectly. It's only when I use an unsigned int that everything is blank, no sign of data.