cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefano Ortolani (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-12100) Compactions are stuck after TRUNCATE
Date Tue, 28 Jun 2016 09:08:57 GMT

    [ 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)

Mime
View raw message