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

Using Line protocol to write points and then using derivative functions crashes the database #3139

Closed
anandmani-lab49 opened this issue Jun 25, 2015 · 2 comments

Comments

@anandmani-lab49
Copy link

This does not happen when using json to write data. Here are the steps to reproduce:
-- Create Database
curl -G 'http://localhost:8086/query' --data-urlencode "q=CREATE DATABASE testDerivative"
-- Insert some data
curl -XPOST 'http://localhost:8086/write?db=testDerivative&precision=ms' -d 'cpu,host=server01,region=uswest value=123 1435256752991'
curl -XPOST 'http://localhost:8086/write?db=testDerivative&precision=ms' -d 'cpu,host=server01,region=uswest value=234 1435256760819'
-- Query using derivative
curl -G http://localhost:8086/query?pretty=true --data-urlencode "db=testDerivative" --data-urlencode "q=SELECT derivative(value) FROM cpu WHERE host='server01'"

Boom database is down. Please advise.

@jwilder
Copy link
Contributor

jwilder commented Jun 25, 2015

You are writing points as integers which was not possible before with the JSON API. There is bug in 0.9.0 with a pending fix #2986 that has not been merged yet.

As a workaround, you can write your points as floats by adding a .0 to each one.

@gunnaraasen
Copy link
Member

Closing in favor of #2956. Thanks for the report!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants