Return-Path: X-Original-To: apmail-cassandra-commits-archive@www.apache.org Delivered-To: apmail-cassandra-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D721917F54 for ; Wed, 25 Mar 2015 13:51:53 +0000 (UTC) Received: (qmail 92502 invoked by uid 500); 25 Mar 2015 13:51:53 -0000 Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org Received: (qmail 92468 invoked by uid 500); 25 Mar 2015 13:51:53 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 92456 invoked by uid 99); 25 Mar 2015 13:51:53 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Mar 2015 13:51:53 +0000 Date: Wed, 25 Mar 2015 13:51:53 +0000 (UTC) From: "Charles (JIRA)" To: commits@cassandra.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CASSANDRA-9026) Garbage in the sstable of the secondary index MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CASSANDRA-9026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14379883#comment-14379883 ] Charles commented on CASSANDRA-9026: ------------------------------------ Yes, but it does not work. The unknown key and value is still in the sstable of secondary index. > Garbage in the sstable of the secondary index > --------------------------------------------- > > Key: CASSANDRA-9026 > URL: https://issues.apache.org/jira/browse/CASSANDRA-9026 > Project: Cassandra > Issue Type: Bug > Environment: CentOS 6.5 > Reporter: Charles > > We create a secondary index for a specific column. > After running a few months, by using sstable2json tool, we found there are some unknown keys which we've never assigned are stored in the sstable of the secondary index. The key value is incremental hexbyte, for example, 55012157, 55012158. > It can not be removed by nodetool repair/compact/cleanup. > When the sstable of the secondary index become larger, the read performance is dropped. -- This message was sent by Atlassian JIRA (v6.3.4#6332)