Unable to execute pull query : Exhausted standby hosts to try.

309 views

Skip to first unread message

Anup Tiwari

unread,

Sep 1, 2021, 3:41:06 AM9/1/21

to ksqldb-users

Hi Team,

While executing a pull query on my table, i am getting below error :-

Unable to execute pull query: select * from A2_LAST_10_VAL where uid = '31';. Exhausted standby hosts to try.

I tried to see what is happening via explain query command and found below error :-

Error Details : org.apache.kafka.streams.errors.ProcessorStateException: Error opening store Aggregate-Aggregate-Materialize at location /data/hadoop/_confluent-ksql-poc_query_CTAS_A2_LAST_10_VAL_4839/1_7/rocksdb/Aggregate-Aggregate-Materialize
Caused by: org.rocksdb.RocksDBException: While opening a file for sequentially reading: /data/hadoop/_confluent-ksql-poc_query_CTAS_A2_LAST_10_VAL_4839/1_7/rocksdb/Aggregate-Aggregate-Materialize/MANIFEST-002590: No such file or directory
at org.rocksdb.RocksDB.open(Native Method)

We haven't touched the directory which is being pointed in error and are able to see other files such as LOG.old.** / **.sst etc. Also just wanted to let you know that we are successfully able to execute push query on the same table.