You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Pradip Kumar (JIRA)" <ji...@apache.org> on 2019/06/14 18:04:00 UTC
[jira] [Created] (CASSANDRA-15162) IndexNotAvailableException: The
secondary index 'idx_ma_transaction_id' is not yet available
Pradip Kumar created CASSANDRA-15162:
----------------------------------------
Summary: IndexNotAvailableException: The secondary index 'idx_ma_transaction_id' is not yet available
Key: CASSANDRA-15162
URL: https://issues.apache.org/jira/browse/CASSANDRA-15162
Project: Cassandra
Issue Type: Improvement
Components: Cluster/Schema
Reporter: Pradip Kumar
Hi,
I created an index on the table "moneyid_allocation" as below..
*CREATE INDEX idx_ma_transaction_id ON moneymarking.moneyid_allocation (transaction_id);*
But when I am selecting the data by using the indexed column the got error in the system.log, Please suggest to resolve the issue
There are around 10 million records in the table.
*select query:-*
select * from moneyid_allocation where transaction_id='1111111111' limit 1 ALLOW FILTERING;
*Error in system.log:-*
WARN [ReadStage-4] 2019-06-14 23:28:56,666 AbstractLocalAwareExecutorService.java:167 - Uncaught exception on thread Thread[ReadStage-4,5,main]: {}
java.lang.RuntimeException: org.apache.cassandra.index.IndexNotAvailableException: The secondary index 'idx_ma_transaction_id' is not yet available
at org.apache.cassandra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:2601) ~[apache-cassandra-3.11.3.jar:3.11.3]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_161]
at org.apache.cassandra.concurrent.AbstractLocalAwareExecutorService$FutureTask.run(AbstractLocalAwareExecutorService.java:162) ~[apache-cassandra-3.11.3.jar:3.11.3]
at org.apache.cassandra.concurrent.AbstractLocalAwareExecutorService$LocalSessionFutureTask.run(AbstractLocalAwareExecutorService.java:134) [apache-cassandra-3.11.3.jar:3.11.3]
at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:109) [apache-cassandra-3.11.3.jar:3.11.3]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_161]
Caused by: org.apache.cassandra.index.IndexNotAvailableException: The secondary index 'idx_ma_transaction_id' is not yet available
at org.apache.cassandra.db.ReadCommand.executeLocally(ReadCommand.java:416) ~[apache-cassandra-3.11.3.jar:3.11.3]
at org.apache.cassandra.service.StorageProxy$LocalReadRunnable.runMayThrow(StorageProxy.java:1887) ~[apache-cassandra-3.11.3.jar:3.11.3]
at org.apache.cassandra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:2597) ~[apache-cassandra-3.11.3.jar:3.11.3]
... 5 common frames omitted
Regards,
Pradip
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org