InfluxDB is recording the timestamps it is given. I can't say why they would be a couple minutes in the future. Perhaps there's some alteration happening on the beaglebone.
On Mon, Nov 7, 2016 at 2:13 AM, huegel.jan via InfluxData < influxdb@googlegroups.com> wrote: > Am Freitag, 4. November 2016 16:54:53 UTC+1 schrieb Sean Beckett: > > 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 < > infl...@googlegroups.com> 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 < > infl...@googlegroups.com> 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 < > infl...@googlegroups.com> 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 influxdb+u...@googlegroups.com. > > > > > > > > > > > > > > > > > > > > > > To post to this group, send email to infl...@googlegroups.com. > > > > > > > > > > > > > > > > > > > > > > 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 influxdb+u...@googlegroups.com. > > > > > > > > > > To post to this group, send email to infl...@googlegroups.com. > > > > > > > > > > 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 influxdb+u...@googlegroups.com. > > > > To post to this group, send email to infl...@googlegroups.com. > > > > 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 > > Hi Sean, > > thx for your answer. > I cant get it work. > > SELECT "Temperature" FROM "Values" WHERE "Serial_NR" = '12345' AND time > > now() - 60m AND time < now() + 5m > If i modify my timestamp in beaglebone (+ 2.5 minutes) my timeshift query > will display the data if i stop it. data will be plot the next 2.5 minutes. > this query works. but i cant use the "quick ranges change" in grafana, > because data will only be plot within the now()-60min expression > > SELECT "Temperature" FROM "Values" WHERE "Serial_NR" = '12345' > if i take a look at my data display with no timeshift it doesnt matter. > the plot is always 2.5 behind. i really dont know why... > > beaglebone and server are 1 second out of timesync. i think this isnt the > problem... > > -- > 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 influxdb+unsubscr...@googlegroups.com. > To post to this group, send email to influxdb@googlegroups.com. > 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/616e5a1e-15fa-4804-a21e-479c77830247%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 influxdb+unsubscr...@googlegroups.com. To post to this group, send email to influxdb@googlegroups.com. 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/CALGqCvPViRP7emGCp7knj3cii4XP9QDzm%3D0jVy%3DakKShWETsZg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
