Hi There, we are experiencing issues with influxdb 0.10 with tsm storage engine where queries of the form: "select value from forward where fund = 'ESX.IMCGlobal' and expiry = '20161216' and time > '2016-06-23' and time < '2016-06-24'" hang and never return a result. Our configuration is included below.
Couple of observations: * This only happens for yesterdays data. If I change the query to get todays data or data older than yesterday it succeeds within few seconds. * If I change the query to select count(value) or add a group by time(1s) the query succeeds. Size of the measurement and series for one day: * "select count(value) from forward where fund = 'ESX.IMCGlobal' and expiry = '20161216' and time > '2016-06-23' and time < '2016-06-24'" returns 22 711 * "select count(value) from forward where time > '2016-06-23' and time < '2016-06-24'" returns 702 112 First, I thought this might be related to https://github.com/influxdata/influxdb/issues/5553 but we are not doing any group by with limit queries. Then I considered https://github.com/influxdata/influxdb/issues/5343 but that one is harder to judge since our memory consumption is around 50GB anyway. Any help is greatly appreciated. Thank you, Jan Configuration: [monitoring] enabled = false [meta] dir = "/data/influxdb/meta" hostname = "localhost" bind-address = ":8088" retention-autocreate = true election-timeout = "1s" heartbeat-timeout = "1s" leader-lease-timeout = "500ms" commit-timeout = "50ms" [data] dir = "/data/influxdb/data" max-wal-size = 104857600 wal-flush-interval = "10m0s" wal-partition-flush-delay = "2s" wal-dir = "/data/influxdb/wal" wal-enable-logging = true retention-auto-create = true retention-check-enabled = true retention-check-period = "10m0s" retention-create-period = "45m0s" cache-snapshot-write-cold-duration = "10m" [cluster] shard-writer-timeout = "5s" [retention] enabled = true check-interval = "10m0s" [shard-precreation] enabled = true check-interval = "10m0s" advance-period = "30m0s" [snapshot] enabled = true [admin] enabled = true bind-address = ":8083" [http] enabled = true bind-address = ":8086" auth-enabled = false log-enabled = true write-tracing = false pprof-enabled = false [[graphite]] bind-address = ":2003" database = "graphite" enabled = true protocol = "udp" batch-size = 0 batch-timeout = "0" consistency-level = "one" separator = "." [continuous_queries] enabled = true recompute-previous-n = 2 recompute-no-older-than = "10m0s" compute-runs-per-interval = 10 compute-no-more-than = "2m0s" [hinted-handoff] enabled = true dir = "/data/influxdb/hh" max-size = 1073741824 max-age = "168h0m0s" retry-rate-limit = 0 retry-interval = "1s" -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" 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/e5fbed40-0f24-48e3-8490-57fab3b50f46%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
