Are there any errors in the logs? Can you upgrade to 0.13 or 1.0beta2?
On Fri, Jun 24, 2016 at 2:00 AM, Jan Kis <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/influxdb/e5fbed40-0f24-48e3-8490-57fab3b50f46%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- 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/CALGqCvOeRh%2BXrbiPc%2BXHpV3oW1U0k8S7oo_GmXDQoUv_OQvSOQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
