[
https://issues.apache.org/jira/browse/CASSANDRA-12100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15352641#comment-15352641
]
Stefano Ortolani commented on CASSANDRA-12100:
----------------------------------------------
Another weird bit.
It seems that before restarting CFSTATS shows no SSTABLES associated to the CF.
{noformat}
root@node13:~# nodetool -h localhost cfstats schema.table_5
Keyspace: schema
Read Count: 9
Read Latency: 0.06611111111111112 ms.
Write Count: 293023
Write Latency: 0.03773653603983305 ms.
Pending Flushes: 0
Table: table_5
SSTable count: 0
SSTables in each level: [0, 0, 0, 0, 0, 0, 0, 0, 0]
Space used (live): 0
Space used (total): 0
Space used by snapshots (total): 28906766
Off heap memory used (total): 0
SSTable Compression Ratio: 0.0
Number of keys (estimate): 1530
Memtable cell count: 193038
Memtable data size: 459060
Memtable off heap memory used: 0
Memtable switch count: 2
Local read count: 9
Local read latency: 0.073 ms
Local write count: 293023
Local write latency: 0.042 ms
Pending flushes: 0
Bloom filter false positives: 0
Bloom filter false ratio: 0.00000
Bloom filter space used: 0
Bloom filter off heap memory used: 0
Index summary off heap memory used: 0
Compression metadata off heap memory used: 0
Compacted partition minimum bytes: 0
Compacted partition maximum bytes: 0
Compacted partition mean bytes: 0
Average live cells per slice (last five minutes):
1.1993243243243243
Maximum live cells per slice (last five minutes): 60
Average tombstones per slice (last five minutes): 1.0
Maximum tombstones per slice (last five minutes): 1
{noformat}
Afterwards the whole thing is a bit different:
{noformat}
root@node13:~# nodetool -h localhost cfstats schema.table_5
Keyspace: schema
Read Count: 0
Read Latency: NaN ms.
Write Count: 432
Write Latency: 0.02398611111111111 ms.
Pending Flushes: 0
Table: table_5
SSTable count: 1
SSTables in each level: [1, 0, 0, 0, 0, 0, 0, 0, 0]
Space used (live): 262893
Space used (total): 262893
Space used by snapshots (total): 28906766
Off heap memory used (total): 1344
SSTable Compression Ratio: 0.6389608871615797
Number of keys (estimate): 1551
Memtable cell count: 432
Memtable data size: 4518
Memtable off heap memory used: 0
Memtable switch count: 0
Local read count: 0
Local read latency: NaN ms
Local write count: 432
Local write latency: 0.027 ms
Pending flushes: 0
Bloom filter false positives: 0
Bloom filter false ratio: 0.00000
Bloom filter space used: 968
Bloom filter off heap memory used: 960
Index summary off heap memory used: 336
Compression metadata off heap memory used: 48
Compacted partition minimum bytes: 30
Compacted partition maximum bytes: 51012
Compacted partition mean bytes: 242
Average live cells per slice (last five minutes): NaN
Maximum live cells per slice (last five minutes): 0
Average tombstones per slice (last five minutes): NaN
Maximum tombstones per slice (last five minutes): 0
{noformat}
> Compactions are stuck after TRUNCATE
> ------------------------------------
>
> Key: CASSANDRA-12100
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12100
> Project: Cassandra
> Issue Type: Bug
> Reporter: Stefano Ortolani
>
> Hi,
> since the upgrade to C* 3.0.7 I see compaction tasks getting stuck when
> truncating the column family. I verified this on all nodes of the cluster.
> Pending compactions seem to disappear after restarting the node.
> {noformat}
> root@node10:~# nodetool -h localhost compactionstats
> pending tasks: 6
> id compaction type
> keyspace table completed total unit progress
> 24e1ad30-3cac-11e6-870d-5de740693258 Compaction
> schema table_1 0 57558382 bytes 0.00%
> 2be2e3b0-3cac-11e6-870d-5de740693258 Compaction
> schema table_2 0 65063705 bytes 0.00%
> 54de38f0-3cac-11e6-870d-5de740693258 Compaction
> schema table_3 0 187031 bytes 0.00%
> 31926ce0-3cac-11e6-870d-5de740693258 Compaction
> schema table_4 0 42951119 bytes 0.00%
> 3911ad00-3cac-11e6-870d-5de740693258 Compaction
> schema table_5 0 25918949 bytes 0.00%
> 3e6a8ab0-3cac-11e6-870d-5de740693258 Compaction
> schema table_6 0 65466210 bytes 0.00%
> Active compaction remaining time : 0h00m15s
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
