wifinigel / wiperf_poller

Polling engine for the wiperf utility
Other
3 stars 5 forks source link

Some InfluxDB field are wrong data type - makes calcs impossible (Teddy) #3

Closed wifinigel closed 3 years ago

wifinigel commented 4 years ago

Looking at the data fields created in InfluxDB, there are a number that are the wrong data type, making data maniuplation difficult when wanting to perform calcs on the dta.

Theses need to be fixed up to use the correct data types by fixing the data type sent to InfluxDB in the wiperf code.

Here is an example of bad data fields:

> show field keys
name: wiperf-ping
fieldKey     fieldType
--------     ---------
percent_loss string
ping_host    string
ping_index   integer
pkts_rx      string
pkts_tx      string
rtt_avg_ms   float
rtt_max_ms   float
rtt_mdev_ms  float
rtt_min_ms   float
test_time_ms string

The issue is that when these are fixed, it will stop existing database tables from working correctly. This will require users to re-init their DB to ensure they obtain the correct structure. Will look in to options for scripting a fix-up in InfluxDB, but suspect this could be a lot of work.

wifinigel commented 3 years ago

Fixed - see notes in issue #18