Database measurements {device_data and config_applied}: reg

23 views
Skip to first unread message

Manukumar NM

unread,
Dec 4, 2023, 12:06:42 AM12/4/23
to open...@googlegroups.com
Hiii team,
                I have a device which is running on openwisp2 server, all the data is able to be seen in the dashboard. But when I open the time series database terminal , it will show these many measurements:> show measurements
name: measurements
name
----
config_applied
cpu
device_data
disk_memory
ping
traffic
usb0

> select * from device_data
> select * from config_data
> select * from ping limit 3
name: ping
time                content_type  loss object_id                            reachable rtt_avg rtt_max rtt_min

----                ------------  ---- ---------                            --------- ------- ------- -------
1701475411075778000 config.device 100  2b755da0-b183-4fcf-97b9-f130f49dbbfe 0                        
1701475711170015000 config.device 100  2b755da0-b183-4fcf-97b9-f130f49dbbfe 0                        
1701476011172928000 config.device 100  2b755da0-b183-4fcf-97b9-f130f49dbbfe 0   but when i tried open the data present in the device_data and config_applied measurements it is empty always. But the rest of the measurements have all the data. Why is the data not stored in those two measurements? 

Thanks in advance
image.png

Federico Capoano

unread,
Dec 6, 2023, 2:48:24 PM12/6/23
to open...@googlegroups.com
The data saved in the device_data measurement uses the short retention policy:

select * from short.device_data;

Not sure about config_applied, maybe that too, double checking the code may be needed.

I hope this helps.
Federico

--
You received this message because you are subscribed to the Google Groups "OpenWISP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openwisp+u...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/openwisp/CAG6AGHch%2B384K%2Byi_V8sbnKGeJiWAeXwJR-od_rdo9qt5GfpZg%40mail.gmail.com.
Reply all
Reply to author
Forward
0 new messages