Hi!
I’ve installed Grafana on my Ubuntu machine to display a set of measurements collected by an app running on the same machine.
The measurements are stored in an influx db. This db is the datasource for my dashboard.
One of these measurements is a 64 bit integer. In my dashboard this value instead of being displayed correctly is rounded.
I’ve queried the database using a curl command and I’m sure that the value is correctly stored inside influx db. However, when the query is done in Grafana, the value is rounded (See the 2 queries below).
Is this a known issue? Is there any fix/workaround?
Thanks,
Piero
Command line CURL Query
$curl -G ‘http://localhost:8086/query?pretty=true’ --data-urlencode “db=my_db” --data-urlencode “q=SELECT last(“Global Time”) FROM “my_kpi” WHERE (“deviceId” = ‘device_1’) AND time >= 1525132506761ms and time <= 1525132506763ms” --data-urlencode “epoch=ms”
{
“results”: [
{
“statement_id”: 0,
“series”: [
{
“name”: “my_kpi”,
“columns”: [
“time”,
“last”
],
“values”: [
[
1525132506762,
1525132498218491967 <–correct value
]
]
}
]
}
]
}
Grafana Query
xhrStatus:“complete”
request:Object
method:“GET”
url:“http://localhost:8086/query”
params:Object
u:"***"
p:"***"
db:“my_db”
q:“SELECT last(“Global Time”) FROM “my_kpi” WHERE (“deviceId” = ‘device_1’) AND time >= 1525132506761ms and time <= 1525132506763ms”
epoch:“ms”
data:null
precision:“ms”
response:Object
results:Array[1]
0:Object
statement_id:0
series:Array[1]
0:Object
name:“my_kpi”
columns:Array[2]
0:“time”
1:“last”
values:Array[1]
0:Array[1525132506762,1525132498218492000] <–rounded value