[CASSANDRA-13152] UPDATE on counter columns with empty list as argument in IN disables cluster

• Type: Bug
• Status: Resolved
• Priority: Urgent
• Resolution: Fixed
• Fix Version/s: 3.0.11, 3.11.0, 4.0-alpha1, 4.0
• Component/s: CQL/Interpreter, Local/SSTable

Environment

Linux Ubuntu 16
3 Virtual machines

• Bug Category: Availability - Process Crash
• Severity: Critical
• Assignee: Benjamin Lerer
• Reporter: jorge collinet

Authors

Benjamin Lerer

Reviewers

Alex Petrov

• Created: 25/Jan/17 13:14
• Updated: 15/May/20 08:01
• Resolved: 07/Feb/17 09:58

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.