Check partition size of your table’s partitions ( nodetool tablehistograms tsg_ae logs_by_user). You may need to reduce partition size of your table using guidelines given in [ http://docs.datastax.com/en/archived/cassandra/2.2/cassandra/planning/planPlanningPartitionSize.html] & [https://stackoverflow.com/questions/20512710/cassandra-has-a-limit-of-2-billion-cells-per-partition-but-whats-a-partition]
From: Thakrar, Jayesh [mailto:jthak...@conversantmedia.com] Sent: Wednesday, June 14, 2017 3:14 PM To: User <user@cassandra.apache.org> Subject: Question: Large partition warning We are on Cassandra 2.2.5 and I am constantly seeing warning messages about large partitions in system.log even though our setting for partition warning threshold is set to 4096 (MB). WARN [CompactionExecutor:43180] 2017-06-14 20:02:13,189 BigTableWriter.java:184 - Writing large partition tsg_ae/logs_by_user:114303419784957147 (17187 bytes) WARN [CompactionExecutor:43180] 2017-06-14 20:02:13,190 BigTableWriter.java:184 - Writing large partition tsg_ae/logs_by_user:820590487870502244 (2613 bytes) WARN [CompactionExecutor:43180] 2017-06-14 20:02:13,191 BigTableWriter.java:184 - Writing large partition tsg_ae/logs_by_user:421586605444858333 (54923 bytes) Here's what we have in cassandra.yaml. # Log a warning when compacting partitions larger than this value compaction_large_partition_warning_threshold_mb: 4096 So wondering if such a warning is normal or is there something wrong in our configuration or is it a bug? I have looked at https://issues.apache.org/jira/browse/CASSANDRA-9643<https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_browse_CASSANDRA-2D9643&d=DwMGaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=FsmDztdsVuIKml8IDhdHdg&m=WtJm2Pa-mx-ZvG5MPrlbSen2MJwJRm11MW5tELSFbPA&s=J-zAL67R89Gq6JWdTYeGUMou3e_51gQ2JkEEFxTxYmg&e=>. Any pointers will be greatly appreciated. Thanks, Jayesh