#influxdb

Hi. We're using a influxdb/grafana setup that is working really well. I'd like to start using some annotations but I'm not really sure how to go about doing this. Any pointers or links to documentation on how I should work with annotations in a setup like mine?

I can only seem to find grafanas, fairly limited, documentation on how to get it drawn in grafana which assumes I would know how to create them in the first place

isn't it just a matter of inserting them in an influxdb table?

Got called into a bunch of meetings

Dieterbe: Yep, I guess so. I've done a few by hand now that are displayed nicely, but I still don't know what would be a good way to create them - doing it directly through an influxdb client is very cumbersome. How does other people do it?

fantyz: honestly i haven't really seen people use influx for that. many use ES

it also depends on where the events you want to store are coming from

Dieterbe: these annotations would be manually created and usually to indicate some event (eg. deployed some update, external service xxx down, database issues)

I'm thinking I'll make a jenkins task that can push a message to influx

for manual events you can also use https://github.com/Dieterbe/anthracite/ which uses ES

select mean(value) from series where time < now() - '7d' currently works, but gives unexpected results... Can it be made to throw an error?

eh. time > now() - '7d'

The string version of '7d' is the thing i'm referring to: it should not be quoted to be valid.

kaisan: I agree. Also "select value from non_existent" returns nothing, whereas "select * from non_existent" returns an error. Maybe that's just the way InfluxDB works, though?

select last(value) from cpu_iowait returns time "1970-01-01T00:00:00Z". Same with first(value). Not sure if I'm missing something or if it's a bug.

my influxdb instance is currently stuck at init stage, It is only repeating the following syscall futex(0xc2080207d8, FUTEX_WAKE, 1)

version 0.9.2

gcmalloc: Does it do anything before getting stuck calling futex()?

Is there anything in the log?

*gcmacmalloc even

currently this

it is also listening on port 8088, but I never started or setup a cluster

only a single node

ok removed everydata and started from scratch

failed to write point batch to database "metrics": retention policy not found with the retention-autocreate set to true