These are chat archives for influxdata/influxdb

21st
Oct 2016
Will Fuqua
@wafuqua_twitter
Oct 21 2016 02:16
I'm running an older version of influxdb (0.8.8), and a user ran an unbounded select that caused influxdb to crash. Now, every time influxdb tries to start it resumes the query, crashing again. Is there some way to clear out the past query, so influxdb doesn't try to run it on startup?
of course, the long term solution is to upgrade influxdb...
James Wong
@jameswnl
Oct 21 2016 18:18
Hi, does the query support epoch time in the where clause?
Connor Peet
@connor4312
Oct 21 2016 18:18
There's no mention of epoch, timestamps, or unix in their query language spec
James Wong
@jameswnl
Oct 21 2016 18:19
ok, that’s quite inconvenient
Connor Peet
@connor4312
Oct 21 2016 18:19
What language are you using to connect?
James Wong
@jameswnl
Oct 21 2016 18:19
ok, I am using ruby client and i now have to convert the format
Connor Peet
@connor4312
Oct 21 2016 18:19
Ah
James Wong
@jameswnl
Oct 21 2016 18:20
epoch is most universal
Connor Peet
@connor4312
Oct 21 2016 18:20
Yea, that's kind of an annoying point. Even ISO times would work :P
This is an implementation in Node, but I imagine in Ruby you have better formatting capabilities: https://github.com/node-influx/node-influx/blob/master/src/grammar/times.ts#L156
James Wong
@jameswnl
Oct 21 2016 18:21
yeah, i am pretty sure i can do the conversion
but just some tedious work
:cry:
hey, i think it may have worked
Connor Peet
@connor4312
Oct 21 2016 18:23
That was fast :)
James Wong
@jameswnl
Oct 21 2016 18:23
epoch does works
Connor Peet
@connor4312
Oct 21 2016 18:23
Oh nice :)
That is something I've seen: the InfluxQL doc specifies what works, but it is not a comprehensive set of everything that works and every nuance
James Wong
@jameswnl
Oct 21 2016 18:24
i was using the option epoch: ’s’ to match the timestamp in sec that I am giving it
Connor Peet
@connor4312
Oct 21 2016 18:24
:+1:
James Wong
@jameswnl
Oct 21 2016 18:25
so I need to pass it a timestamp with extra 6 0 and that works
James Wong
@jameswnl
Oct 21 2016 19:46
how do i interpret the results of group by tag values and time?
in the e.g. SELECT MEAN("water_level") FROM "h2o_feet" WHERE time > now() - 2w GROUP BY "location",time(6h)
on this page
how do i know which location a reult point is about?