Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[0.10.0] Crashed the server with a bad derivative query #5628

Closed
binarytemple opened this issue Feb 11, 2016 · 3 comments
Closed

[0.10.0] Crashed the server with a bad derivative query #5628

binarytemple opened this issue Feb 11, 2016 · 3 comments

Comments

@binarytemple
Copy link

  • centos 6.7
  • influxdb-0.10.0-1.x86_64

Ran the following query from Grafana - crashed the influxdb server

SELECT (derivative(value, 1m) / 60.000) FROM collectd."default".interface_rx 
WHERE type = 'if_octets' AND type_instance = 'eth0' AND time > now() - 30m AND 
time < now() - 1m GROUP BY host

Log output:

[query] 2016/02/11 10:22:15 SELECT (derivative(value, 1m) / 60.000) FROM collectd."default".interface_rx WHERE type = 'if_octets' AND type_instance = 'eth0' AND time > now() - 30m AND time < now() - 1m GROUP BY host
panic: interface conversion: interface is float64, not map[string]interface {}

goroutine 233276 [running]:
github.com/influxdb/influxdb/tsdb.(*limitedRowWriter).processValues(0xc20b1afd40, 0xc20c796800, 0xad, 0x100, 0x0)
        /tmp/tmp.NZsW7kxYIE/src/github.com/influxdb/influxdb/tsdb/raw.go:524 +0x1173
github.com/influxdb/influxdb/tsdb.(*limitedRowWriter).Flush(0xc20b1afd40)
        /tmp/tmp.NZsW7kxYIE/src/github.com/influxdb/influxdb/tsdb/raw.go:446 +0xd6
github.com/influxdb/influxdb/tsdb.(*RawExecutor).execute(0xc20baba7b0, 0xc2093420c0, 0xc20805ff20)
        /tmp/tmp.NZsW7kxYIE/src/github.com/influxdb/influxdb/tsdb/raw.go:154 +0x17e5
created by github.com/influxdb/influxdb/tsdb.(*RawExecutor).Execute
        /tmp/tmp.NZsW7kxYIE/src/github.com/influxdb/influxdb/tsdb/raw.go:59 +0x64

@seiflotfy
Copy link
Contributor

@binarytemple Can you try the same query without the brackets as in:

SELECT derivative(value, 1m) / 60.000 FROM collectd."default".interface_rx 
WHERE type = 'if_octets' AND type_instance = 'eth0' AND time > now() - 30m AND 
time < now() - 1m GROUP BY host

@seiflotfy
Copy link
Contributor

I set up a PR that should fix it hopefully in master
#5633

@binarytemple
Copy link
Author

nice work. I'll leave it for now. I was just experimenting with different queries. thanks!

@rossmcdonald rossmcdonald changed the title Crashed the server with a bad derivative query [0.10.0] Crashed the server with a bad derivative query Feb 11, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants