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

UPDATE on counter columns with empty list as argument in IN disables cluster

    XMLWordPrintableJSON

    Details

    • Bug Category:
      Availability - Process Crash
    • Severity:
      Critical

      Description

      On a 3 node cluster
      with this table (replication factor of 2):

      CREATE TABLE tracking.item_items_rec_history (
      	reference_id bigint,
      	country text,
      	portal text,
      	app_name text,
      	recommended_id bigint,
      	counter counter,
      	PRIMARY KEY (reference_id, country, portal, app_name, recommended_id)
      );
      

      If I execute

      UPDATE user_items_rec_history 
      SET counter = counter + 1 
      WHERE reference_id = 1 AND country = '' AND portal = '' AND app_name = '' AND recommended_id IN ();
      

      Take note that the IN is empty

      The cluster starts to malfunction and responds a lot of timeouts to any query.

      After resetting some of the nodes, the cluster starts to function normally again.

        Attachments

          Activity

            People

            • Assignee:
              blerer Benjamin Lerer
              Reporter:
              george C jorge collinet
              Authors:
              Benjamin Lerer
              Reviewers:
              Alex Petrov
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: