[CASSANDRA-13352] Cassandra does not respond back in 12000ms

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Invalid
• Fix Version/s: 3.10
• Component/s: Legacy/Core, Legacy/CQL
• Severity: Normal
• Assignee: Unassigned
• Reporter: Chirag
• Created: 20/Mar/17 04:39
• Updated: 16/Apr/19 09:30
• Resolved: 20/Mar/17 08:22

Description

I have my system with a table design,

Create Table lamscope_dashboard.events (
ToolId text,
Date timestamp,
End_Time timestamp,
DeviceId text,
Logtype text,
EventId text,
MaterialId text,
CfgId text,
MaterialType text,
Status text,
SlotNo text,
LotId text,
RecipeId text,
StepNum int ,
Fromdevice text,
Fromslot text,
ToDevice text,
ToSlot int ,
FlowRecipeId text,
Flowinfo text,
CarrierId text,
JobId text,
Data text,
PRIMARY KEY( ToolId, Date, MaterialId, DeviceId, EventId))
WITH CLUSTERING ORDER BY (Date ASC,MaterialId ASC, DeviceId ASC)
AND COMPRESSION =

{ 'sstable_compression' : 'SnappyCompressor'}

;

Query
select * from events where eventid='xxxxx' allow filtering;
It is a single instance cluster.
System is not responding back in 12000 ms.
Query goes timeout.