[CASSANDRA-11011] DateTieredCompactionStrategy not compacting sstables in 2.1.12

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Component/s: Local/Compaction
• Labels: dtcs

Environment

Ubuntu 14.04.3 LTS
2.1.12

• Severity: Normal
• Assignee: Marcus Eriksson
• Reporter: Alexander Piavlo

Authors

Marcus Eriksson

Reviewers

Carl Yeksigian

• Created: 14/Jan/16 06:58
• Updated: 16/Apr/19 09:30
• Resolved: 03/May/16 18:11

Description

The following CF is never compacting from day one

CREATE TABLE globaldb."DynamicParameter" (
dp_id bigint PRIMARY KEY,
dp_advertiser_id int,
dp_application_id int,
dp_application_user_id bigint,
dp_banner_id int,
dp_campaign_id int,
dp_click_timestamp timestamp,
dp_country text,
dp_custom_parameters text,
dp_flags bigint,
dp_ip int,
dp_machine_id text,
dp_string text
) WITH bloom_filter_fp_chance = 0.01
AND caching = '

{"keys":"ALL", "rows_per_partition":"NONE"}

'
AND comment = ''
AND compaction =

{'max_sstable_age_days': '30', 'base_time_seconds': '3600', 'timestamp_resolution': 'MILLISECONDS', 'enabled': 'true', 'min_threshold': '2', 'class': 'org.apache.cassandra.db.compaction.DateTieredCompactionStrategy'}

AND compression =

{'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}

AND dclocal_read_repair_chance = 0.2
AND default_time_to_live = 10713600
AND gc_grace_seconds = 1209600
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99.0PERCENTILE';