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

Undeletable / duplicate rows after upgrading from 2.2.4 to 3.0.7

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: 3.0.9, 3.8
    • Component/s: Local/SSTable
    • Labels:
      None
    • Severity:
      Normal

      Description

      We upgraded our cluster today and now have a some rows that refuse to delete.

      Here are some example traces.

      https://gist.github.com/vishnevskiy/36aa18c468344ea22d14f9fb9b99171d

      Even weirder.

      Updating the row and querying it back results in 2 rows even though the id is the clustering key.

      user_id            | id                 | since                    | type
      -------------------+--------------------+--------------------------+------
      116138050710536192 | 153047019424972800 |                     null |    0
      116138050710536192 | 153047019424972800 | 2016-05-30 14:53:08+0000 |    2
      

      And then deleting it again only removes the new one.

      cqlsh:discord_relationships> DELETE FROM relationships WHERE user_id = 116138050710536192 AND id = 153047019424972800;
      cqlsh:discord_relationships> SELECT * FROM relationships WHERE user_id = 116138050710536192 AND id = 153047019424972800;
      
       user_id            | id                 | since                    | type
      --------------------+--------------------+--------------------------+------
       116138050710536192 | 153047019424972800 | 2016-05-30 14:53:08+0000 |    2
      

      We tried repairing, compacting, scrubbing. No Luck.

      Not sure what to do. Is anyone aware of this?

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ifesdjeen Alex Petrov
                Reporter:
                stanislav Stanislav Vishnevskiy
                Authors:
                Alex Petrov
                Reviewers:
                Sylvain Lebresne
              • Votes:
                0 Vote for this issue
                Watchers:
                14 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: