The timestamps coming from the beaglebone are a few minutes ahead of the clock on the InfluxDB server, for whatever reason.
You can either get the clocks in tighter sync, or modify the grafana queries to include an explicit upper time bound a few minutes in the future, or you can submit the writes without explicit timestamps and let the InfluxDB server timestamp them. Note that writes without explicit timestamps can lead to duplicate points, since all points in a single write batch get the exact same timestamp. On Fri, Nov 4, 2016 at 1:03 AM, huegel.jan via InfluxData < [email protected]> wrote: > Am Donnerstag, 3. November 2016 22:27:14 UTC+1 schrieb Sean Beckett: > > The way to know is to use a query with an explicit upper bound say 5 > minutes in the future: > > > > > > SELECT * FROM foo WHERE time > now() - 5m > > > > SELECT * FROM foo WHERE time > now() - 5m AND time < now() + 5m > > > > > > If the timestamps are off, they will show up with the upper bound moved. > If that's not the explanation and both queries return the same results, > then it's some kind of performance bottleneck. > > > > > > On Thu, Nov 3, 2016 at 2:16 PM, huegel.jan via InfluxData < > [email protected]> wrote: > > Am Donnerstag, 3. November 2016 18:24:50 UTC+1 schrieb Sean Beckett: > > > > > Are you providing explicit timestamps? If so, they might be skewed > into the future. InfluxDB won't return points after now() by default. > > > > > > > > > > > > > > > https://docs.influxdata.com/influxdb/v1.0//troubleshooting/frequently- > asked-questions/#why-don-t-my-queries-return-timestamps- > that-occur-after-now > > > > > > > > > > > > > > > > > > > > On Thu, Nov 3, 2016 at 8:48 AM, huegel.jan via InfluxData < > [email protected]> wrote: > > > > > hey folks, > > > > > > > > > > > > > > > > > > > > i just started to use influxdb with grafana. > > > > > > > > > > there seems to be a delay of 2 minutes between storing data to > influxdb and display with grafana in a dashboard. > > > > > > > > > > > > > > > > > > > > i store the data with 1 second time intervall.... really slow. > > > > > > > > > > > > > > > > > > > > i query data with a refresh rate of 1 second. my goal is to view the > data like realtime. > > > > > > > > > > > > > > > > > > > > can anybody help me? > > > > > > > > > > > > > > > > > > > > influxdb v1.0.2 > > > > > > > > > > grafana v3.1.1 > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > Remember to include the version number! > > > > > > > > > > --- > > > > > > > > > > You received this message because you are subscribed to the Google > Groups "InfluxData" group. > > > > > > > > > > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected]. > > > > > > > > > > To post to this group, send email to [email protected]. > > > > > > > > > > Visit this group at https://groups.google.com/group/influxdb. > > > > > > > > > > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/728a55dd-7345-4e53-802f-064b3c09b090%40googlegroups.com. > > > > > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > > Sean Beckett > > > > > Director of Support and Professional Services > > > > > InfluxDB > > > > > > > > Hi Sean, > > > > thank you for your answer. > > > > I send data om Node-Red with a timestamp in milliseconds since 1970. > > > > If i compare the time from by beaglebone (sending data to server) and my > server time, they match within some seconds. > > > > if i stop sending data from beaglebone to influxdb, grafana is still > plotting datapoints until the 2 minute delay is over. > > > > Do you think i got a problem with my generated timestamp in my > beaglebone? > > > > > > > > -- > > > > Remember to include the version number! > > > > --- > > > > You received this message because you are subscribed to the Google > Groups "InfluxData" group. > > > > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected]. > > > > To post to this group, send email to [email protected]. > > > > Visit this group at https://groups.google.com/group/influxdb. > > > > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/7de2273a-5374-46d7-93b1-43689428f1b0%40googlegroups.com. > > > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > -- > > > > > > Sean Beckett > > Director of Support and Professional Services > > InfluxDB > > Hi Sean, > > there is a difference between those to query commands. > > with this command there is a delay and the display data is always behind > the actual time > SELECT * FROM foo WHERE time > now() - 5m > > with this command the data is displayed direct when it is stored in > influxdb > SELECT * FROM foo WHERE time > now() - 5m AND time < now() + 5m > > how can i fix this problem? do i have to modify my timestamp in my > beaglebone sensor node? > > > > -- > Remember to include the version number! > --- > You received this message because you are subscribed to the Google Groups > "InfluxData" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/f74e464d-8d76-49c5-a685-9c5b96ea49ba%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvPeC-%2Ban1d8PMiEe4TuVqrG%3DgQRiSkaN_UmCEXf9Ft6Kg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
