Query Bug report

[tinycolds]

Bug report

System info:
Influxdb: 1.5.3
SySTEM: Linux 3.16.0-4-amd64 #1 SMP Debian 3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux

Steps to reproduce:
1. We have time series data like:

time                           field1
----                           ------
2018-08-06T07:38:05.276919173Z 1

Expected behavior:
1. We use query like:

SELECT sum(filed1), count(filed1) FROM "test1" where time > now() - 5m GROUP BY time(5m, 0s) fill(0) order by time desc;

2. Expected result is sum(filed1) equals count(filed1)

Actual behavior:
However, sometimes we doesn't get the right result:

time                 sum   count
----                 ---   -----
2018-08-19T09:30:00Z 37559 37643
2018-08-19T09:25:00Z 14661 14661

But after serveral seconds, query again, get the right result:

time                 sum   count
----                 ---   -----
2018-08-19T09:30:00Z 38086 38086
2018-08-19T09:25:00Z 14183 14183

[tinycolds]

any update?

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[stale]

This issue has been automatically closed because it has not had recent activity. Please reopen if this issue is still important to you. Thank you for your contributions.