-
Notifications
You must be signed in to change notification settings - Fork 3.6k
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.9.3-rc1] some data not returned in query response #3759
Comments
What version of InfluxDB is this? |
I'm seeing the same issue and am running from the following commit:
|
To be clear, filling in intervals with no data with null is the default operation. If you want to change this, you can do so. Check out the docs below: https://influxdb.com/docs/v0.9/query_language/data_exploration.html#group-by |
I believe the system is behaving as designed and documented. Please let us know if you disagree. |
I'm using this version:
The problem is that I have data in db (one metric every 5 seconds from last 12h). |
@testuser7 it was not clear from your initial report that you expected returned values rather than nulls. It looks from the output like your only measurement in the query is
If the exact value of the
How do you know there are values in the database for those time periods? What are the results of:
|
@beckettsean I found that there is problem with time ranges.
|
@testuser7 This could be related to #3781, a data consistency issue found in 0.9.3-rc1 and fixed in 0.9.3-rc2. Can you try to reproduce with 0.9.3-rc2? Do your results above change if you use epoch timestamps instead of datetime strings? What results do you get if you |
@beckettsean The same problem is observed on 0.9.3-rc2 (db created in version rc1 was used). Queries with epoch timestamps give me the same results:
|
+1, I am observing this problem with 0.9.3-rc2. The data just disappears. |
In my case all data is in db. There is only problem with getting data from db... |
@testuser7 So you're saying the Can you put up a gist of the results of |
Query result:
|
@testuser7 thanks for the data. Now I'm completely stumped as to what is happening. Do any other queries show this behavior? Is there a measurement called |
It seems that the problem is fixed with version rc3! |
Probably fixed by #3829 |
Hi,
I have problem with query generated by Grafana (metric SystemCpuLoad is saved every 5 seconds in db):
There is many null values in response (only about last 100 minutes have correct values):
The text was updated successfully, but these errors were encountered: