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

Secondary index and index expression problems

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments


    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: 0.7.5
    • Component/s: Feature/2i Index
    • Labels:
    • Environment:

      CentOS 5.5 (64bit), JDK 1.6.0_23

    • Severity:


      When I iteratively get data with secondary index and index clause, result of data acquired by consistency level "one" is different from the one by consistency level "quorum". The one by consistecy level "one" is correct result. But the one by consistecy level "quorum" is incorrect and is dropped by Cassandra.

      You can reproduce the bug by executing attached programs.

      • 1. Start Cassandra cluster. It consists of 3 cassandra nodes and distributes data by ByteOrderedPartitioner. Initial tokens of those nodes are ["31", "32", "33"].
      • 2. Create keyspace and column family, according to "create_table.cli",
      • 3. Execute "secondary_index_insertv2.py", inserting a few hundred columns to cluster
      • 4. Execute "secondary_index_checkv2.py" and get data with secondary index and index clause iteratively. "secondary_index_insertv2.py" and "secondary_index_checkv2.py" require pycassa.

      You will be able to execute 4th "secondary_index_checkv2.py" script with following option so that
      you get data with consistency level "one".

      % python "secondary_index_checkv2.py" -one

      On the other hand, to acquire data with consistency level "quorum", you will need to use following option.

      % python "secondary_index_checkv2.py" -quorum

      You can check that result of data acquired by consistency level "one" is different from one by consistency level "quorum".


        1. secondary_index_insertv2.py
          2 kB
          Muga Nishizawa
        2. secondary_index_checkv2.py
          3 kB
          Muga Nishizawa
        3. node-1.system.log
          37 kB
          Shotaro Kamio
        4. create_table.cli
          0.2 kB
          Muga Nishizawa
        5. CASSANDRA-2406-debug.patch
          1 kB
          Shotaro Kamio
        6. CASSANDRA-2406.patch
          2 kB
          Pavel Yaskevich



            • Assignee:
              xedin Pavel Yaskevich Assign to me
              muga_nishizawa Muga Nishizawa
              Pavel Yaskevich
              Jonathan Ellis


              • Created:

                Issue deployment