Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-15162

IndexNotAvailableException: The secondary index 'idx_ma_transaction_id' is not yet available

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Normal
    • Resolution: Invalid
    • Fix Version/s: None
    • Component/s: Cluster/Schema
    • Labels:
      None
    • Platform:
      All
    • Impacts:
      None

      Description

      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

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              pradip.estel Pradip Kumar
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: