[jira] [Commented] (CASSANDRA-5791) A nodetool command to validate all sstables in a node

["Jonathan Ellis (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-5791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14619190#comment-14619190 ] 

Jonathan Ellis commented on CASSANDRA-5791:
-------------------------------------------

... so we mark sstables that fail verification as unrepaired?  Because that's not going to help much: it means the local node will use that sstable in the next repair, but other nodes will not.  So all we'll end up doing is streaming whatever data we can read from it, to the other replicas.

IMO what we should do is:

# scrub, because it's quite likely we'll fail reading from the sstable otherwise and
# full repair across the data range covered by the sstable



> A nodetool command to validate all sstables in a node
> -----------------------------------------------------
>
>                 Key: CASSANDRA-5791
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5791
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: Core
>            Reporter: sankalp kohli
>            Assignee: Jeff Jirsa
>            Priority: Minor
>             Fix For: 2.2.0 beta 1
>
>         Attachments: cassandra-5791-20150319.diff, cassandra-5791-patch-3.diff, cassandra-5791.patch-2
>
>
> CUrrently there is no nodetool command to validate all sstables on disk. The only way to do this is to run a repair and see if it succeeds. But we cannot repair the system keyspace. 
> Also we can run upgrade sstables but that re writes all the sstables. 
> This command should check the hash of all sstables and return whether all data is readable all not. This should NOT care about consistency. 
> The compressed sstables do not have hash so not sure how it will work there.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)