Hi, On Mon, Oct 2, 2017 at 8:41 AM Varun Barala <varunbaral...@gmail.com> wrote:
> Might be possible C* is not compacting the sstables [ > https://stackoverflow.com/questions/28437301/cassandra-not-compacting-sstables > ] > Oh, the other CF-s in the same keyspace are compacted, but the `number_item` not. [cassandra@dc02-rack01-cass01 number_item-524bf49001d911e798503511c5f98764]$ ls -l total 172704 drwxr-xr-x 4 cassandra cassandra 4096 Oct 1 10:43 backups -rw-r--r-- 1 cassandra cassandra 15227 Oct 2 01:15 mc-48278-big-CompressionInfo.db -rw-r--r-- 1 cassandra cassandra 46562318 Oct 2 01:15 mc-48278-big-Data.db -rw-r--r-- 1 cassandra cassandra 10 Oct 2 01:15 mc-48278-big-Digest.crc32 -rw-r--r-- 1 cassandra cassandra 176 Oct 2 01:15 mc-48278-big-Filter.db -rw-r--r-- 1 cassandra cassandra 119665 Oct 2 01:15 mc-48278-big-Index.db -rw-r--r-- 1 cassandra cassandra 6368 Oct 2 01:15 mc-48278-big-Statistics.db -rw-r--r-- 1 cassandra cassandra 92 Oct 2 01:15 mc-48278-big-Summary.db -rw-r--r-- 1 cassandra cassandra 92 Oct 2 01:15 mc-48278-big-TOC.txt -rw-r--r-- 1 cassandra cassandra 20643 Oct 2 01:16 mc-48279-big-CompressionInfo.db -rw-r--r-- 1 cassandra cassandra 62681705 Oct 2 01:16 mc-48279-big-Data.db -rw-r--r-- 1 cassandra cassandra 10 Oct 2 01:16 mc-48279-big-Digest.crc32 -rw-r--r-- 1 cassandra cassandra 176 Oct 2 01:16 mc-48279-big-Filter.db -rw-r--r-- 1 cassandra cassandra 162571 Oct 2 01:16 mc-48279-big-Index.db -rw-r--r-- 1 cassandra cassandra 6375 Oct 2 01:16 mc-48279-big-Statistics.db -rw-r--r-- 1 cassandra cassandra 92 Oct 2 01:16 mc-48279-big-Summary.db -rw-r--r-- 1 cassandra cassandra 92 Oct 2 01:16 mc-48279-big-TOC.txt -rw-r--r-- 1 cassandra cassandra 20099 Oct 2 01:16 mc-48280-big-CompressionInfo.db -rw-r--r-- 1 cassandra cassandra 62587865 Oct 2 01:16 mc-48280-big-Data.db -rw-r--r-- 1 cassandra cassandra 10 Oct 2 01:16 mc-48280-big-Digest.crc32 -rw-r--r-- 1 cassandra cassandra 176 Oct 2 01:16 mc-48280-big-Filter.db -rw-r--r-- 1 cassandra cassandra 158379 Oct 2 01:16 mc-48280-big-Index.db -rw-r--r-- 1 cassandra cassandra 6375 Oct 2 01:16 mc-48280-big-Statistics.db -rw-r--r-- 1 cassandra cassandra 92 Oct 2 01:16 mc-48280-big-Summary.db -rw-r--r-- 1 cassandra cassandra 92 Oct 2 01:16 mc-48280-big-TOC.txt -rw-r--r-- 1 cassandra cassandra 51 Oct 2 01:16 mc-48281-big-CompressionInfo.db -rw-r--r-- 1 cassandra cassandra 50 Oct 2 01:16 mc-48281-big-Data.db -rw-r--r-- 1 cassandra cassandra 10 Oct 2 01:16 mc-48281-big-Digest.crc32 -rw-r--r-- 1 cassandra cassandra 176 Oct 2 01:16 mc-48281-big-Filter.db -rw-r--r-- 1 cassandra cassandra 20 Oct 2 01:16 mc-48281-big-Index.db -rw-r--r-- 1 cassandra cassandra 4640 Oct 2 01:16 mc-48281-big-Statistics.db -rw-r--r-- 1 cassandra cassandra 92 Oct 2 01:16 mc-48281-big-Summary.db -rw-r--r-- 1 cassandra cassandra 92 Oct 2 01:16 mc-48281-big-TOC.txt Now check both the list results. If they have some common sstables then we > can say that C* is not compacting sstables. > Yes, exactly. How can I fix it? Bye, Gábor Auth