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
    XMLWordPrintableJSON

    Details

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

      CentOS 5.5 (64bit), JDK 1.6.0_23

    • Severity:
      Normal

      Description

      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".

        Attachments

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

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment