You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by "w-s-q (via GitHub)" <gi...@apache.org> on 2025/09/26 07:46:32 UTC
[I] [Bug] 2.0.4版本在服务器内存资源不足时，使用C#的库，按照time>2025-09-25 17:33:10.555条件，查询返回的数据错误，返回的有小于查询条件时间的数据 [iotdb]
w-s-q opened a new issue, #16489:
URL: https://github.com/apache/iotdb/issues/16489
### Search before asking
- [x] I searched in the [issues](https://github.com/apache/iotdb/issues) and found nothing similar.
### Version
os:rocky linux 10.0
iotdb:apach-iotdb v2.0.4
C#程序集:Apach.IoTDB 2.0.2
### Describe the bug and provide the minimal reproduce step
string sql=select * from root.edge.device where time>2025-09-25 17:33:10.555 order by time asc limit 128;
using var dataSet=await sessionPool.ExecuteQueryStatementAsync(sql,5000);
返回的数据中，存在时间戳小于2025-09-25 17:33:10.555的数据。
dataSet.next()读取行，多行中的数据没有按照时间排序，存在时间乱序现象
### What did you expect to see?
按照条件返回正确数据
### What did you see instead?
返回数据错误，顺序也不对
### Anything else?
_No response_
### Are you willing to submit a PR?
- [ ] I'm willing to submit a PR!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] 2.0.4版本在服务器内存资源不足时，使用C#的库，按照time>2025-09-25 17:33:10.555条件，查询返回的数据错误，返回的有小于查询条件时间的数据 [iotdb]
Posted by "w-s-q (via GitHub)" <gi...@apache.org>.
w-s-q commented on issue #16489:
URL: https://github.com/apache/iotdb/issues/16489#issuecomment-3350047519
> 时间条件可以转成 时间戳格式，来避免时区不同造成问题。 另外可以直接使用 cli 查询看下具体的结果再对比 程序中的
第一个问题可能是时区问题，具体现象：查询不是每次都出现，而是运行一段时间后，偶发出现。查看当时iotdb服务器的资源状况，发现运行内存不足，服务器是4核8g，此时内存占用几乎是100%。
第二个问题是，返回的数据时间比sql条件时间早1毫秒，可能时间精度存在问题。比如查询条件是time>2025-09-25 17:33:10.555，实际上查询出的数据time是2025-09-25 17:33:10.554，同样也是偶发。
cli查询没发现以上问题，推测可能是C#的iotdb库有问题？测试环境是.net8+windows11，vs2022
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] 2.0.4版本在服务器内存资源不足时，使用C#的库，按照time>2025-09-25 17:33:10.555条件，查询返回的数据错误，返回的有小于查询条件时间的数据 [iotdb]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #16489:
URL: https://github.com/apache/iotdb/issues/16489#issuecomment-3337195959
Hi, this is your first issue in IoTDB project. Thanks for your report. Welcome to join the community!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] 2.0.4版本在服务器内存资源不足时，使用C#的库，按照time>2025-09-25 17:33:10.555条件，查询返回的数据错误，返回的有小于查询条件时间的数据 [iotdb]
Posted by "CritasWang (via GitHub)" <gi...@apache.org>.
CritasWang commented on issue #16489:
URL: https://github.com/apache/iotdb/issues/16489#issuecomment-3346386532
时间条件可以转成 时间戳格式，来避免时区不同造成问题。
另外可以直接使用 cli 查询看下具体的结果再对比 程序中的
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] 2.0.4版本在服务器内存资源不足时，使用C#的库，按照time>2025-09-25 17:33:10.555条件，查询返回的数据错误，返回的有小于查询条件时间的数据 [iotdb]
Posted by "CritasWang (via GitHub)" <gi...@apache.org>.
CritasWang commented on issue #16489:
URL: https://github.com/apache/iotdb/issues/16489#issuecomment-3384020971
> 第一个问题可能是时区问题，具体现象：查询不是每次都出现，而是运行一段时间后，偶发出现。查看当时iotdb服务器的资源状况，发现运行内存不足，服务器是4核8g，此时内存占用几乎是100%。 第二个问题是，返回的数据时间比sql条件时间早1毫秒，可能时间精度存在问题。比如查询条件是time>2025-09-25 17:33:10.555，实际上查询出的数据time是2025-09-25 17:33:10.554，同样也是偶发。 cli查询没发现以上问题，推测可能是C#的iotdb库有问题？测试环境是.net8+windows11，vs2022
可以贴出来有问题的结果和语句来看下，把原始的时间戳和 格式化后的都加到日志中，输出出来。这样也能方便确认具体问题
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org