You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by "haoyuebju2 (via GitHub)" <gi...@apache.org> on 2025/06/30 09:36:20 UTC
[I] [Bug] 使用删除语句删除某个timeseries或者某个范围的timeseries的数据时，语句执行成功但数据未删除 [iotdb]
haoyuebju2 opened a new issue, #15846:
URL: https://github.com/apache/iotdb/issues/15846
### Search before asking
- [x] I searched in the [issues](https://github.com/apache/iotdb/issues) and found nothing similar.
### Version
IoTDB 0.13.4 and IoTDB 2.0.3
均为单机版
### Describe the bug and provide the minimal reproduce step
服务端日志
`2025-06-30 17:24:42,521 [pool-16-IoTDB-RPC-Client-4] INFO o.a.i.d.q.e.PlanExecutor:1380 - delete data from [root.CME.ES.ES2509.tick] in [1751126400000,9223372036854775807]
2025-06-30 17:24:43,746 [pool-16-IoTDB-RPC-Client-4] INFO o.a.i.d.q.e.PlanExecutor:1380 - delete data from [root.CME.ES.ES2509.tick] in [1751126400000,9223372036854775807]`
客户端信息
`IoTDB> delete from root.CME.ES.ES2509.tick where time >= 2025-06-29T15:31:00;
Msg: The statement is executed successfully.`
### What did you expect to see?
希望看到2025-06-29T15:31:00之后的数据被删除
### What did you see instead?
但实际查询的时候，2025-06-29T15:31:00之后的数据仍在
### 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] 使用删除语句删除某个timeseries或者某个范围的timeseries的数据时，语句执行成功但数据未删除 [iotdb]
Posted by "haoyuebju2 (via GitHub)" <gi...@apache.org>.
haoyuebju2 commented on issue #15846:
URL: https://github.com/apache/iotdb/issues/15846#issuecomment-3018494695
`IoTDB> SELECT * from root.CME.ES.ES2509.tick where time > 2025-06-30 15:30:00 limit 10
17:43:51.783 [main] DEBUG org.apache.iotdb.rpc.AutoResizingBuffer - org.apache.iotdb.rpc.AutoResizingBuffer@3de8f619 expand from 1024 to 2716, request: 2716
+-----------------------------+----------------------------+------------------------------+----------------------------------+--------------------------------------+------------------------------------+-------------------------------------+------------------------------+------------------------------+----------------------------+------------------------------------+------------------------------------+---------------------------+------------------------------+--------------------------------+-----------------------------------+-----------------------------+----------------------------------+--------------------------------+
| Time|root.CME.ES.ES2509.tick.High|root.CME.ES.ES2509.tick.BidVol|root.CME.ES.ES2509.tick.BestBidQty|root.CME.ES.ES2509.tick.PreSettlePrice|root.CME.ES.ES2509.tick.BestAskPrice|root.CME.ES.ES2509.tick.TotalTurnover|root.CME.ES.ES2509.tick.Change|root.CME.ES.ES2509.tick.AskVol|root.CME.ES.ES2509.tick.Open|root.CME.ES.ES2509.tick.OpenInterest|root.CME.ES.ES2509.tick.BestBidPrice|root.CME.ES.ES2509.tick.Low|root.CME.ES.ES2509.tick.Volume|root.CME.ES.ES2509.tick.PreClose|root.CME.ES.ES2509.tick.TotalVolume|root.CME.ES.ES2509.tick.Close|root.CME.ES.ES2509.tick.BestAskQty|root.CME.ES.ES2509.tick.Contract|
+-----------------------------+----------------------------+------------------------------+----------------------------------+--------------------------------------+------------------------------------+-------------------------------------+------------------------------+------------------------------+----------------------------+------------------------------------+------------------------------------+---------------------------+------------------------------+--------------------------------+-----------------------------------+-----------------------------+----------------------------------+--------------------------------+
|2025-06-30T15:31:38.048+08:00| 6255.0| 0.0| 20.0| 6223.75| 6245.75| 0.0| 21.75| 0.0| 6223.25| 1868068.0| 6245.25| 6223.25| 1.0| 6223.75| 77047.0| 6245.5| 16.0| ES2509|
|2025-06-30T15:31:40.135+08:00| 6255.0| 1.0| 5.0| 6223.75| 6245.75| 0.0| 21.75| 0.0| 6223.25| 1868068.0| 6245.5| 6223.25| 1.0| 6223.75| 77047.0| 6245.5| 15.0| ES2509|
|2025-06-30T15:31:41.100+08:00| 6255.0| 1.0| 9.0| 6223.75| 6245.75| 0.0| 21.75| 0.0| 6223.25| 1868068.0| 6245.5| 6223.25| 1.0| 6223.75| 77047.0| 6245.5| 13.0| ES2509|
|2025-06-30T15:31:41.850+08:00| 6255.0| 1.0| 1.0| 6223.75| 6245.75| 0.0| 21.75| 0.0| 6223.25| 1868068.0| 6245.5| 6223.25| 1.0| 6223.75| 77047.0| 6245.5| 18.0| ES2509|
|2025-06-30T15:31:43.019+08:00| 6255.0| 1.0| 2.0| 6223.75| 6245.75| 0.0| 21.75| 0.0| 6223.25| 1868068.0| 6245.5| 6223.25| 1.0| 6223.75| 77047.0| 6245.5| 18.0| ES2509|
|2025-06-30T15:31:45.196+08:00| 6255.0| 1.0| 10.0| 6223.75| 6245.75| 0.0| 21.75| 0.0| 6223.25| 1868068.0| 6245.5| 6223.25| 1.0| 6223.75| 77047.0| 6245.5| 14.0| ES2509|
|2025-06-30T15:31:46.009+08:00| 6255.0| 8.0| 12.0| 6223.75| 6246.0| 0.0| 22.0| 0.0| 6223.25| 1868068.0| 6245.75| 6223.25| 8.0| 6223.75| 77055.0| 6245.75| 27.0| ES2509|
|2025-06-30T15:31:47.185+08:00| 6255.0| 8.0| 12.0| 6223.75| 6246.0| 0.0| 22.0| 0.0| 6223.25| 1868068.0| 6245.75| 6223.25| 8.0| 6223.75| 77055.0| 6245.75| 25.0| ES2509|
|2025-06-30T15:31:48.469+08:00| 6255.0| 8.0| 15.0| 6223.75| 6246.0| 0.0| 22.0| 0.0| 6223.25| 1868068.0| 6245.75| 6223.25| 8.0| 6223.75| 77055.0| 6245.75| 25.0| ES2509|
|2025-06-30T15:31:56.245+08:00| 6255.0| 0.0| 18.0| 6223.75| 6246.0| 0.0| 22.0| 0.0| 6223.25| 1868068.0| 6245.5| 6223.25| 1.0| 6223.75| 77066.0| 6245.75| 26.0| ES2509|
+-----------------------------+----------------------------+------------------------------+----------------------------------+--------------------------------------+------------------------------------+-------------------------------------+------------------------------+------------------------------+----------------------------+------------------------------------+------------------------------------+---------------------------+------------------------------+--------------------------------+-----------------------------------+-----------------------------+----------------------------------+--------------------------------+
Total line number = 10
It costs 0.203s
IoTDB> delete from root.CME.ES.ES2509.tick where time >= 2025-06-29T15:31:00;
Msg: The statement is executed successfully.
IoTDB> SELECT * from root.CME.ES.ES2509.tick where time > 2025-06-30 15:30:00 limit 10
+-----------------------------+----------------------------+------------------------------+----------------------------------+--------------------------------------+------------------------------------+-------------------------------------+------------------------------+------------------------------+----------------------------+------------------------------------+------------------------------------+---------------------------+------------------------------+--------------------------------+-----------------------------------+-----------------------------+----------------------------------+--------------------------------+
| Time|root.CME.ES.ES2509.tick.High|root.CME.ES.ES2509.tick.BidVol|root.CME.ES.ES2509.tick.BestBidQty|root.CME.ES.ES2509.tick.PreSettlePrice|root.CME.ES.ES2509.tick.BestAskPrice|root.CME.ES.ES2509.tick.TotalTurnover|root.CME.ES.ES2509.tick.Change|root.CME.ES.ES2509.tick.AskVol|root.CME.ES.ES2509.tick.Open|root.CME.ES.ES2509.tick.OpenInterest|root.CME.ES.ES2509.tick.BestBidPrice|root.CME.ES.ES2509.tick.Low|root.CME.ES.ES2509.tick.Volume|root.CME.ES.ES2509.tick.PreClose|root.CME.ES.ES2509.tick.TotalVolume|root.CME.ES.ES2509.tick.Close|root.CME.ES.ES2509.tick.BestAskQty|root.CME.ES.ES2509.tick.Contract|
+-----------------------------+----------------------------+------------------------------+----------------------------------+--------------------------------------+------------------------------------+-------------------------------------+------------------------------+------------------------------+----------------------------+------------------------------------+------------------------------------+---------------------------+------------------------------+--------------------------------+-----------------------------------+-----------------------------+----------------------------------+--------------------------------+
|2025-06-30T15:31:38.048+08:00| 6255.0| 0.0| 20.0| 6223.75| 6245.75| 0.0| 21.75| 0.0| 6223.25| 1868068.0| 6245.25| 6223.25| 1.0| 6223.75| 77047.0| 6245.5| 16.0| ES2509|
|2025-06-30T15:31:40.135+08:00| 6255.0| 1.0| 5.0| 6223.75| 6245.75| 0.0| 21.75| 0.0| 6223.25| 1868068.0| 6245.5| 6223.25| 1.0| 6223.75| 77047.0| 6245.5| 15.0| ES2509|
|2025-06-30T15:31:41.100+08:00| 6255.0| 1.0| 9.0| 6223.75| 6245.75| 0.0| 21.75| 0.0| 6223.25| 1868068.0| 6245.5| 6223.25| 1.0| 6223.75| 77047.0| 6245.5| 13.0| ES2509|
|2025-06-30T15:31:41.850+08:00| 6255.0| 1.0| 1.0| 6223.75| 6245.75| 0.0| 21.75| 0.0| 6223.25| 1868068.0| 6245.5| 6223.25| 1.0| 6223.75| 77047.0| 6245.5| 18.0| ES2509|
|2025-06-30T15:31:43.019+08:00| 6255.0| 1.0| 2.0| 6223.75| 6245.75| 0.0| 21.75| 0.0| 6223.25| 1868068.0| 6245.5| 6223.25| 1.0| 6223.75| 77047.0| 6245.5| 18.0| ES2509|
|2025-06-30T15:31:45.196+08:00| 6255.0| 1.0| 10.0| 6223.75| 6245.75| 0.0| 21.75| 0.0| 6223.25| 1868068.0| 6245.5| 6223.25| 1.0| 6223.75| 77047.0| 6245.5| 14.0| ES2509|
|2025-06-30T15:31:46.009+08:00| 6255.0| 8.0| 12.0| 6223.75| 6246.0| 0.0| 22.0| 0.0| 6223.25| 1868068.0| 6245.75| 6223.25| 8.0| 6223.75| 77055.0| 6245.75| 27.0| ES2509|
|2025-06-30T15:31:47.185+08:00| 6255.0| 8.0| 12.0| 6223.75| 6246.0| 0.0| 22.0| 0.0| 6223.25| 1868068.0| 6245.75| 6223.25| 8.0| 6223.75| 77055.0| 6245.75| 25.0| ES2509|
|2025-06-30T15:31:48.469+08:00| 6255.0| 8.0| 15.0| 6223.75| 6246.0| 0.0| 22.0| 0.0| 6223.25| 1868068.0| 6245.75| 6223.25| 8.0| 6223.75| 77055.0| 6245.75| 25.0| ES2509|
|2025-06-30T15:31:56.245+08:00| 6255.0| 0.0| 18.0| 6223.75| 6246.0| 0.0| 22.0| 0.0| 6223.25| 1868068.0| 6245.5| 6223.25| 1.0| 6223.75| 77066.0| 6245.75| 26.0| ES2509|
+-----------------------------+----------------------------+------------------------------+----------------------------------+--------------------------------------+------------------------------------+-------------------------------------+------------------------------+------------------------------+----------------------------+------------------------------------+------------------------------------+---------------------------+------------------------------+--------------------------------+-----------------------------------+-----------------------------+----------------------------------+--------------------------------+
Total line number = 10
It costs 0.146s`
--
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] 使用删除语句删除某个timeseries或者某个范围的timeseries的数据时，语句执行成功但数据未删除 [iotdb]
Posted by "CritasWang (via GitHub)" <gi...@apache.org>.
CritasWang closed issue #15846: [Bug] 使用删除语句删除某个timeseries或者某个范围的timeseries的数据时，语句执行成功但数据未删除
URL: https://github.com/apache/iotdb/issues/15846
--
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] 使用删除语句删除某个timeseries或者某个范围的timeseries的数据时，语句执行成功但数据未删除 [iotdb]
Posted by "CritasWang (via GitHub)" <gi...@apache.org>.
CritasWang commented on issue #15846:
URL: https://github.com/apache/iotdb/issues/15846#issuecomment-3018488363
看下执行完成后的查询结果
--
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] 使用删除语句删除某个timeseries或者某个范围的timeseries的数据时，语句执行成功但数据未删除 [iotdb]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #15846:
URL: https://github.com/apache/iotdb/issues/15846#issuecomment-3018468966
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] 使用删除语句删除某个timeseries或者某个范围的timeseries的数据时，语句执行成功但数据未删除 [iotdb]
Posted by "CritasWang (via GitHub)" <gi...@apache.org>.
CritasWang commented on issue #15846:
URL: https://github.com/apache/iotdb/issues/15846#issuecomment-3018499456
用 delete from root.CME.ES.ES2509.tick.* where time >= 2025-06-29T15:31:00;
--
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