Hi Sean, There are no errors in the logs.
I upgraded to 0.13 and the problems is gone for now but I do remember that restart used to solve that problem. I will monitor the behaviour for a while and let you know. Thanks, Jan On Friday, June 24, 2016 at 10:19:03 PM UTC+2, Sean Beckett wrote: > > 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] <javascript:>> > 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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/6c12f920-dfad-4af0-8875-8dbb9ece16d5%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
