{"action":"opened","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/5105","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/5105/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/5105/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/5105/events","html_url":"https://github.com/influxdb/influxdb/issues/5105","id":121963446,"number":5105,"title":"[0.9.5] InfluxDB becomes unresponsive","user":{"login":"seyoonhan","id":16109967,"avatar_url":"https://avatars.githubusercontent.com/u/16109967?v=3","gravatar_id":"","url":"https://api.github.com/users/seyoonhan","html_url":"https://github.com/seyoonhan","followers_url":"https://api.github.com/users/seyoonhan/followers","following_url":"https://api.github.com/users/seyoonhan/following{/other_user}","gists_url":"https://api.github.com/users/seyoonhan/gists{/gist_id}","starred_url":"https://api.github.com/users/seyoonhan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/seyoonhan/subscriptions","organizations_url":"https://api.github.com/users/seyoonhan/orgs","repos_url":"https://api.github.com/users/seyoonhan/repos","events_url":"https://api.github.com/users/seyoonhan/events{/privacy}","received_events_url":"https://api.github.com/users/seyoonhan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-12-14T02:34:20Z","updated_at":"2015-12-14T02:34:20Z","closed_at":null,"body":"I'm using InfluxDB for production stage.\r\nBut once a day, I should restart the db manually.\r\nBecause InfluxDB becomes unresponsive once a day, rejecting all request with http 500.\r\nAnd It tooks exactly 5s to give 500 response to client.(seems timeout)\r\n\r\nPlease see middle of the log.(Click image)\r\nAfter running CQ, the db becomes unresponsive. \r\n(At that time, there were very small inputs, no issue on system, and there were no expensive queries running.)\r\n<img width=\"1747\" alt=\"2015-12-14 10 25 08\" src=\"https://cloud.githubusercontent.com/assets/16109967/11771521/eabe41a0-a254-11e5-9d9f-2894831ab32a.png\">\r\n\r\n\r\n\r\nRunning CQ list.\r\n<img width=\"1972\" alt=\"2015-12-14 10 26 06\" src=\"https://cloud.githubusercontent.com/assets/16109967/11771523/f33ee1ea-a254-11e5-9b9b-0b98b54ddbb7.png\">\r\n\r\n\r\nConfiguration(It'salmost default)\r\n```\r\n[meta]\r\n  dir = \"/mysql/meta\"\r\n  hostname = \"localhost\"\r\n  bind-address = \":8088\"\r\n  retention-autocreate = true\r\n  election-timeout = \"1s\"\r\n  heartbeat-timeout = \"1s\"\r\n  leader-lease-timeout = \"500ms\"\r\n  commit-timeout = \"50ms\"\r\n  cluster-tracing = false\r\n  raft-promotion-enabled = true\r\n\r\n[data]\r\n  dir = \"/mysql/data\"\r\n  engine = \"bz1\"\r\n  max-wal-size = 104857600\r\n  wal-flush-interval = \"10m0s\"\r\n  wal-partition-flush-delay = \"2s\"\r\n  wal-dir = \"/mysql/wal\"\r\n  wal-logging-enabled = false\r\n  wal-ready-series-size = 30720\r\n  wal-compaction-threshold = 0.5\r\n  wal-max-series-size = 1048576\r\n  wal-flush-cold-interval = \"5s\"\r\n  wal-partition-size-threshold = 52428800\r\n  wal-flush-memory-size-threshold = 5242880\r\n  wal-max-memory-size-threshold = 104857600\r\n  index-compaction-age = 60000000000\r\n  index-min-compaction-interval = 60000000000\r\n  index-compaction-min-file-count = 5\r\n  index-compaction-full-age = 300000000000\r\n  query-log-enabled = true\r\n\r\n[cluster]\r\n  force-remote-mapping = false\r\n  write-timeout = \"5s\"\r\n  shard-writer-timeout = \"5s\"\r\n  shard-mapper-timeout = \"5s\"\r\n\r\n[retention]\r\n  enabled = true\r\n  check-interval = \"1440m0s\"\r\n\r\n[registration]\r\n  enabled = true\r\n  url = \"https://enterprise.influxdata.com\"\r\n  token = \"\"\r\n  stats-interval = \"1m0s\"\r\n\r\n[shard-precreation]\r\n  enabled = true\r\n  check-interval = \"10m0s\"\r\n  advance-period = \"30m0s\"\r\n\r\n[admin]\r\n  enabled = true\r\n  bind-address = \":8083\"\r\n  https-enabled = false\r\n  https-certificate = \"/etc/ssl/influxdb.pem\"\r\n\r\n[monitor]\r\n  store-enabled = false\r\n  store-database = \"_internal\"\r\n  store-interval = \"10s\"\r\n\r\n[subscriber]\r\n  enabled = true\r\n\r\n[http]\r\n  enabled = true\r\n  bind-address = \":8086\"\r\n  auth-enabled = false\r\n  log-enabled = true\r\n  write-tracing = false\r\n  pprof-enabled = false\r\n  https-enabled = false\r\n  https-certificate = \"/etc/ssl/influxdb.pem\"\r\n\r\n[collectd]\r\n  enabled = false\r\n  bind-address = \":25826\"\r\n  database = \"collectd\"\r\n  retention-policy = \"\"\r\n  batch-size = 10000\r\n  batch-pending = 10\r\n  batch-timeout = \"10s\"\r\n  read-buffer = 0\r\n  typesdb = \"/usr/share/collectd/types.db\"\r\n\r\n[opentsdb]\r\n  enabled = false\r\n  bind-address = \":4242\"\r\n  database = \"opentsdb\"\r\n  retention-policy = \"\"\r\n  consistency-level = \"one\"\r\n  tls-enabled = false\r\n  certificate = \"/etc/ssl/influxdb.pem\"\r\n  batch-size = 1000\r\n  batch-pending = 5\r\n  batch-timeout = \"1s\"\r\n\r\n[continuous_queries]\r\n  log-enabled = true\r\n  enabled = true\r\n  recompute-previous-n = 2\r\n  recompute-no-older-than = \"10m0s\"\r\n  compute-runs-per-interval = 10\r\n  compute-no-more-than = \"2m0s\"\r\n\r\n[hinted-handoff]\r\n  enabled = true\r\n  dir = \"/mysql/hh\"\r\n  max-size = 1073741824\r\n  max-age = \"168h0m0s\"\r\n  retry-rate-limit = 0\r\n  retry-interval = \"1s\"\r\n  retry-max-interval = \"1m0s\"\r\n  purge-interval = \"1h0m0s\"\r\n\r\n```\r\n\r\n\r\n\r\n\r\n"}}