[ 
https://issues.apache.org/jira/browse/CASSANDRA-15162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jeremy Hanna updated CASSANDRA-15162:
-------------------------------------
    Resolution: Invalid
        Status: Resolved  (was: Triage Needed)

Please use the user mailing list or the Cassandra room in Slack for operations 
questions.  From first glance, this is just a matter of the index still being 
built.

See http://cassandra.apache.org/doc/latest/contactus.html

> 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
>            Priority: Normal
>
> 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-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

Reply via email to