You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by "XiangweiWei (Jira)" <ji...@apache.org> on 2020/01/06 07:50:00 UTC
[jira] [Commented] (IOTDB-404) Server will be stuck when executing
SELECT statement
[ https://issues.apache.org/jira/browse/IOTDB-404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17008599#comment-17008599 ]
XiangweiWei commented on IOTDB-404:
-----------------------------------
I think the problem occurs in org.apache.iotdb.db.query.dataset.NewEngineDataSetWithoutValueFilter
void fillCache(int seriesIndex)
BatchData batchData = blockingQueueArray[seriesIndex].take();
And the server log shows:
15:41:04.075 [pool-9-IoTDB-Query-ServerServiceImpl-thread-6] DEBUG org.apache.iotdb.db.engine.cache.DeviceMetaDataCache - [ChunkMetaData cache didn't hit] The number of requests for cache is 3, hit rate is 0.0.
15:41:04.075 [pool-9-IoTDB-Query-ServerServiceImpl-thread-3] DEBUG org.apache.iotdb.db.engine.cache.DeviceMetaDataCache - [ChunkMetaData cache didn't hit] The number of requests for cache is 3, hit rate is 0.0.
15:41:04.079 [pool-9-IoTDB-Query-ServerServiceImpl-thread-3] DEBUG org.apache.iotdb.db.engine.cache.TsFileMetaDataCache - [TsFileMetaData cache didn't hit] The number of requests for cache is 2, hit rate is 0.0.
15:41:04.082 [pool-9-IoTDB-Query-ServerServiceImpl-thread-6] DEBUG org.apache.iotdb.db.engine.cache.TsFileMetaDataCache - [TsFileMetaData cache didn't hit] The number of requests for cache is 2, hit rate is 0.0.
15:41:04.082 [pool-9-IoTDB-Query-ServerServiceImpl-thread-2] DEBUG org.apache.iotdb.db.engine.cache.DeviceMetaDataCache - [ChunkMetaData cache didn't hit] The number of requests for cache is 6, hit rate is 0.0.
15:41:04.082 [pool-9-IoTDB-Query-ServerServiceImpl-thread-2] DEBUG org.apache.iotdb.db.engine.cache.TsFileMetaDataCache - [TsFileMetaData cache didn't hit] The number of requests for cache is 3, hit rate is 0.0.
15:41:04.082 [pool-9-IoTDB-Query-ServerServiceImpl-thread-5] DEBUG org.apache.iotdb.db.engine.cache.DeviceMetaDataCache - [ChunkMetaData cache didn't hit] The number of requests for cache is 6, hit rate is 0.0.
15:41:04.082 [pool-9-IoTDB-Query-ServerServiceImpl-thread-5] DEBUG org.apache.iotdb.db.engine.cache.TsFileMetaDataCache - [TsFileMetaData cache didn't hit] The number of requests for cache is 4, hit rate is 0.0.
15:41:04.083 [pool-9-IoTDB-Query-ServerServiceImpl-thread-1] DEBUG org.apache.iotdb.db.engine.cache.DeviceMetaDataCache - [ChunkMetaData cache didn't hit] The number of requests for cache is 6, hit rate is 0.0.
15:41:04.083 [pool-9-IoTDB-Query-ServerServiceImpl-thread-1] DEBUG org.apache.iotdb.db.engine.cache.TsFileMetaDataCache - [TsFileMetaData cache didn't hit] The number of requests for cache is 5, hit rate is 0.0.
15:41:04.083 [pool-9-IoTDB-Query-ServerServiceImpl-thread-4] DEBUG org.apache.iotdb.db.engine.cache.DeviceMetaDataCache - [ChunkMetaData cache didn't hit] The number of requests for cache is 6, hit rate is 0.0.
15:41:04.083 [pool-9-IoTDB-Query-ServerServiceImpl-thread-4] DEBUG org.apache.iotdb.db.engine.cache.TsFileMetaDataCache - [TsFileMetaData cache didn't hit] The number of requests for cache is 6, hit rate is 0.0.
> Server will be stuck when executing SELECT statement
> ----------------------------------------------------
>
> Key: IOTDB-404
> URL: https://issues.apache.org/jira/browse/IOTDB-404
> Project: Apache IoTDB
> Issue Type: Bug
> Reporter: XiangweiWei
> Priority: Major
> Fix For: 0.10.0-SNAPSHOT
>
>
> First, I open a new server and client, and add some data, like
> ```sql
> SET STORAGE GROUP TO root.vehicle
> CREATE TIMESERIES root.vehicle.d0.s0 WITH DATATYPE=INT32, ENCODING=RLE
> insert into root.vehicle.d0(timestamp,s0) values(1,101)
> insert into root.vehicle.d0(timestamp,s0) values(2,198)
> insert into root.vehicle.d0(timestamp,s0) values(100,99)
> insert into root.vehicle.d0(timestamp,s0) values(101,99)
> insert into root.vehicle.d0(timestamp,s0) values(102,80)
> ```
> Then the select and other statament is usual, returning the correct result.
> However, once I restart the server, then execute the select statement again, like
> `SELECT * FROM root.vehicle`
> the server will be stuck and don't return any data.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)