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

Updating a row that has a TTL produce unexpected results

Log workAgile BoardRank to TopRank to BottomAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Normal

    Description

      Reported on stackoverflow: http://stackoverflow.com/questions/27280407/cassandra-ttl-gets-set-to-0-on-primary-key-if-no-ttl-is-specified-on-an-update?newreg=19e8c6757c62474985fef7c3037e8c08

      I can reproduce the issue with 2.0, 2.1 and trunk. I've attached a small script to reproduce the issue with CCM, and here is it's output:

      aboudreault@kovarro:~/dev/cstar/so27280407$ ./test.sh 
      Current cluster is now: local
      Insert data with a 5 sec TTL
      INSERT INTO ks.tbl (pk, foo, bar) values (1, 1, 'test') using TTL 5;
      
       pk | bar  | foo
      ----+------+-----
        1 | test |   1
      
      (1 rows)
      
      Update data with no TTL
      UPDATE ks.tbl set bar='change' where pk=1;
      sleep 6 sec
      BUG: Row should be deleted now, but isn't. and foo column has been deleted???
      
       pk | bar    | foo
      ----+--------+------
        1 | change | null
      
      (1 rows)
      
      Insert data with a 5 sec TTL
      INSERT INTO ks.tbl (pk, foo, bar) values (1, 1, 'test') using TTL 5;
      
       pk | bar  | foo
      ----+------+-----
        1 | test |   1
      
      (1 rows)
      
      Update data with a higher (10) TTL
      UPDATE ks.tbl USING TTL 10 set bar='change' where pk=1;
      sleep 6 sec
      BUG: foo column has been deleted?
      
       pk | bar    | foo
      ----+--------+------
        1 | change | null
      
      (1 rows)
      
      sleep 5 sec
      Data is deleted now after the second TTL set during the update. Is this a bug or the expected behavior?
      
      (0 rows)
      

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned Assign to me
            aboudreault Alan Boudreault
            Alan Boudreault Alan Boudreault
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment