{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/3709","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/3709/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/3709/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/3709/events","html_url":"https://github.com/influxdb/influxdb/issues/3709","id":101588898,"number":3709,"title":"Server Error 500","user":{"login":"mnietz","id":8960791,"avatar_url":"https://avatars.githubusercontent.com/u/8960791?v=3","gravatar_id":"","url":"https://api.github.com/users/mnietz","html_url":"https://github.com/mnietz","followers_url":"https://api.github.com/users/mnietz/followers","following_url":"https://api.github.com/users/mnietz/following{/other_user}","gists_url":"https://api.github.com/users/mnietz/gists{/gist_id}","starred_url":"https://api.github.com/users/mnietz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mnietz/subscriptions","organizations_url":"https://api.github.com/users/mnietz/orgs","repos_url":"https://api.github.com/users/mnietz/repos","events_url":"https://api.github.com/users/mnietz/events{/privacy}","received_events_url":"https://api.github.com/users/mnietz/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-18T07:22:05Z","updated_at":"2015-08-18T16:24:12Z","closed_at":null,"body":"InfluxDB-0.9.2\r\nDebian-8.1\r\n\r\nI've had a strange issue with the above configuration. In the influx-logs i recognized, that at some point of time a continuous query died with a timeout (btw: what's the maximum time for a cq ?):\r\n\r\n[continuous_querier] 2015/08/15 03:00:17 timeout\r\n[continuous_querier] 2015/08/15 03:00:17 error: timeout. running: SELECT count(distinct(sid)) AS \"value\" INTO \"db\".\"policy01\".view_distinct_per_sid_1h FROM \"db\".\"default\".view WHERE time >= '2015-08-15T01:00:00Z' AND time < '2015-08-15T02:00:00Z' GROUP BY time(1h), *\r\n[continuous_querier] 2015/08/15 03:00:17 error executing query: CREATE CONTINUOUS QUERY view_distinct_per_sid_1h ON db BEGIN SELECT count(distinct(sid)) AS \"value\" INTO \"db\".\"policy01\".view_distinct_per_sid_1h FROM \"db\".\"default\".view GROUP BY time(1h), * END: err = timeout\r\n\r\nThis timeout was possibly causes by a system backup running at that time, but a few minutes after that, inserting into the database were no longer possible and result in a 500 error\r\n\r\n[http] 2015/08/15 03:05:02 [15/Aug/2015:03:05:02 +0200] POST /write?db=db&p=%5BREDACTED%5D&precision=s&u=user HTTP/1.1 204 0 - -a86dcd11-42e9-11e5-a5a8-000000000000 1.512026ms\r\n[http] 2015/08/15 03:05:02 [15/Aug/2015:03:05:02 +0200] POST /write?db=db&p=%5BREDACTED%5D&precision=s&u=user HTTP/1.1 204 0 - - a875d87b-42e9-11e5-a5a9-000000000000 1.661902ms\r\n\r\n[http] 2015/08/15 03:05:07 [15/Aug/2015:03:05:02 +0200] POST /write?db=db&p=%5BREDACTED%5D&precision=s&u=user HTTP/1.1 500 8 - - a87f2cd2-42e9-11e5-a5aa-000000000000 5.000482862s\r\n[http] 2015/08/15 03:05:12 [15/Aug/2015:03:05:07 +0200] POST /write?db=db&p=%5BREDACTED%5D&precision=s&u=user HTTP/1.1 500 8 - - \r\nab814124-42e9-11e5-a5ab-000000000000 5.000432216s\r\n\r\nThere are no long-entries missing between these events. Normaly our writes last about 1-2 ms, than suddenly it is constant over 5s and returning 500 error.\r\n\r\nWe 'solved' this by restarting influx.\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/132265857","html_url":"https://github.com/influxdb/influxdb/issues/3709#issuecomment-132265857","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/3709","id":132265857,"user":{"login":"jfromaniello","id":178512,"avatar_url":"https://avatars.githubusercontent.com/u/178512?v=3","gravatar_id":"","url":"https://api.github.com/users/jfromaniello","html_url":"https://github.com/jfromaniello","followers_url":"https://api.github.com/users/jfromaniello/followers","following_url":"https://api.github.com/users/jfromaniello/following{/other_user}","gists_url":"https://api.github.com/users/jfromaniello/gists{/gist_id}","starred_url":"https://api.github.com/users/jfromaniello/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jfromaniello/subscriptions","organizations_url":"https://api.github.com/users/jfromaniello/orgs","repos_url":"https://api.github.com/users/jfromaniello/repos","events_url":"https://api.github.com/users/jfromaniello/events{/privacy}","received_events_url":"https://api.github.com/users/jfromaniello/received_events","type":"User","site_admin":false},"created_at":"2015-08-18T16:24:12Z","updated_at":"2015-08-18T16:24:12Z","body":"I am having the same issue when writing from node.js many records.\r\n\r\nI eventually start getting 500s in the logs, the node.js sdk gets a \"timeout\" error."}}