Influxdb blocking on queries

influxdb
#1

Hi!

I’m a new user, trying to evaluate InfluxDB Enterprise. Forgive me if this is the wrong forum or category.

I started sending stats to a 3-node cluster a few days ago. InfluxDB has started blocking on data queries:

[avishai@aus-influxdb1 ~]$ influx -port 19030 -database telegraf
Connected to http://localhost:19030 version 1.3.1-c1.3.1
InfluxDB shell version: 1.3.1-c1.3.1
> select * from system limit 10; -- hangs for ever

I know the system series is supposed to have data, because I queried it successfully a few days ago.

I’m not sure where to start looking for a cause. I’ve looked at the results of show stats and show diagnostics but those a little overwhelming. As you can understand, non-data queries (queries over _internal) return immediately.

I can paste/attach stats and diagnostics if it would help.

#2

Have you tried to limit the query to be only within the last hour, or something like that to reduce the result set. Is it possible that it’s still selecting the data. for large selects like select *, that can always be a concern, especially if it’s a lot of data.
However, having just set it up a few days ago, it shouldn’t be that much data.
You can limit to time with a “where time > now()-1d” to mean anything newer than 1 day old.

#3

Thank you for your answer. I was able to resolve the issue with the help of influxdb support. It was a combination of running out of disk (bad config) and a bad proxy configuration.