Cassandra
  1. Cassandra
  2. CASSANDRA-4877

Range queries return fewer result after a lot of delete

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Fix Version/s: 1.2.0 beta 3
    • Component/s: None
    • Labels:
      None

      Description

      Hi, I'm testing on the trunk version
      I'm using : [cqlsh 2.3.0 | Cassandra 1.2.0-beta1-SNAPSHOT | CQL spec 3.0.0 | Thrift protocol 19.35.0]

      My use case is :
      I create a table
      CREATE TABLE premier (
      id int PRIMARY KEY,
      value int
      ) WITH
      comment='' AND
      caching='KEYS_ONLY' AND
      read_repair_chance=0.100000 AND
      dclocal_read_repair_chance=0.000000 AND
      gc_grace_seconds=864000 AND
      replicate_on_write='true' AND
      compression=

      {'sstable_compression': 'SnappyCompressor'}

      ;

      1) I insert 10 000 000 rows (they are like id = 1 and value =1)
      2) I delete 2 000 000 rows (i use random method to choose the key value)
      3) I do select * from premier ; and my result is 7944 instead of 10 000.
      4) if if do select * from premier limit 20000 ; my result is 15839 .

      So after a lot of delete, the range operator is not working.

      1. 0001-4877.patch
        24 kB
        Sylvain Lebresne
      2. 0002-Rename-maxIsColumns-to-countCQL3Rows.patch
        25 kB
        Sylvain Lebresne

        Activity

        julien campan created issue -
        Sylvain Lebresne made changes -
        Field Original Value New Value
        Assignee Sylvain Lebresne [ slebresne ]
        Sylvain Lebresne made changes -
        Fix Version/s 1.2.0 rc1 [ 12323481 ]
        Sylvain Lebresne made changes -
        Attachment 0001-4877.patch [ 12554370 ]
        Attachment 0002-Rename-maxIsColumns-to-countCQL3Rows.patch [ 12554371 ]
        Sylvain Lebresne made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Sylvain Lebresne made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Reviewer jbellis
        Resolution Fixed [ 1 ]
        Sylvain Lebresne made changes -
        Fix Version/s 1.2.0 beta 3 [ 12323603 ]
        Fix Version/s 1.2.0 rc1 [ 12323481 ]
        Gavin made changes -
        Workflow no-reopen-closed, patch-avail [ 12731924 ] patch-available, re-open possible [ 12753516 ]
        Gavin made changes -
        Workflow patch-available, re-open possible [ 12753516 ] reopen-resolved, no closed status, patch-avail, testing [ 12756694 ]

          People

          • Assignee:
            Sylvain Lebresne
            Reporter:
            julien campan
            Reviewer:
            Jonathan Ellis
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development