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

[Query Fuzz] Query doesn't return #8065

Closed
e-dard opened this issue Feb 27, 2017 · 1 comment
Closed

[Query Fuzz] Query doesn't return #8065

e-dard opened this issue Feb 27, 2017 · 1 comment
Assignees

Comments

@e-dard
Copy link
Contributor

e-dard commented Feb 27, 2017

This issue was found by fuzzing the database with a query generator tool. It may be possible to simplify the query to help identify the root cause.

Dataset
$ curl https://s3.amazonaws.com/noaa.water-database/NOAA_data.txt -o NOAA_data.txt
$ influx -import -path=NOAA_data.txt
Query
SELECT    BOTTOM("degrees", "location", 5)  AS "_",   NON_NEGATIVE_DERIVATIVE("degrees") +   STDDEV("water_level") FROM  "h2o_temperature"
Results

The query hangs. Heap remains low, no CPU activity.

Possibly related to #8061 but there is only one BOTTOM, so it's possible this is a different issue.

1488220069229540178-freeze.txt

@e-dard e-dard changed the title [Query Fuzz] Query hangs server [Query Fuzz] Query doesn't return Feb 27, 2017
@jsternberg
Copy link
Contributor

I think this query shouldn't be possible. @jwilder thoughts? I'm of the opinion that anything involving TOP() and BOTTOM() should just be by themselves.

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

2 participants