Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Tue, 24 May 2016 17:12:12 +0000 (UTC)
From: "Julien Anguenot (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12972450.1464109906000.278542.1464109932910@Atlassian.JIRA>
In-Reply-To: <JIRA.12972450.1464109906000@Atlassian.JIRA>
References: <JIRA.12972450.1464109906000@Atlassian.JIRA> <JIRA.12972450.1464109906691@arcas>
Subject: [jira] [Created] (CASSANDRA-11887) Duplicate rows after a 2.2.5 to
 3.0.4 migration
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Tue, 24 May 2016 17:12:15 -0000

Julien Anguenot created CASSANDRA-11887:
-------------------------------------------

             Summary: Duplicate rows after a 2.2.5 to 3.0.4 migration
                 Key: CASSANDRA-11887
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11887
             Project: Cassandra
          Issue Type: Bug
            Reporter: Julien Anguenot
            Priority: Blocker


After migrating from 2.2.5 to 3.0.4, some tables seem to carry duplicate primary keys.

Below an example. Note, repair / scrub of such table do not seem to fix nor indicate any issues.

*Table definition*:

{code}
CREATE TABLE core.edge_ipsec_vpn_service (
    edge_uuid text PRIMARY KEY,
    enabled boolean,
    endpoints set<frozen<edge_ipsec_vpn_endpoint>>,
    tunnels set<frozen<edge_ipsec_vpn_tunnel>>
) WITH bloom_filter_fp_chance = 0.01
    AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
    AND comment = ''
    AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
    AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
    AND crc_check_chance = 1.0
    AND dclocal_read_repair_chance = 0.1
    AND default_time_to_live = 0
    AND gc_grace_seconds = 864000
    AND max_index_interval = 2048
    AND memtable_flush_period_in_ms = 0
    AND min_index_interval = 128
    AND read_repair_chance = 0.0
    AND speculative_retry = '99PERCENTILE';

{code}

*UDTs:*

{code}

CREATE TYPE core.edge_ipsec_vpn_endpoint (
    network text,
    public_ip text
);

CREATE TYPE core.edge_ipsec_vpn_tunnel (
    name text,
    description text,
    peer_ip_address text,
    peer_id text,
    local_ip_address text,
    local_id text,
    local_subnets frozen<set<frozen<edge_ipsec_vpn_subnet>>>,
    peer_subnets frozen<set<frozen<edge_ipsec_vpn_subnet>>>,
    shared_secret text,
    shared_secret_encrypted boolean,
    encryption_protocol text,
    mtu int,
    enabled boolean,
    operational boolean,
    error_details text,
    vpn_peer frozen<edge_ipsec_vpn_peer>
);

CREATE TYPE core.edge_ipsec_vpn_subnet (
    name text,
    gateway text,
    netmask text
);

CREATE TYPE core.edge_ipsec_vpn_peer (
    type text,
    id text,
    name text,
    vcd_url text,
    vcd_org text,
    vcd_username text
);

{code}

sstabledump extract (IP addressees hidden as well as  secrets)

{code}
[...]
 { 
    "partition" : {
      "key" : [ "50eb12a8-b848-4cda-bebd-2a9c2a4490ee" ],
      "position" : 429842
    },
    "rows" : [
      { 
        "type" : "row",
        "position" : 429932,
        "liveness_info" : { "tstamp" : "2016-05-06T17:10:40.483012Z" },
        "cells" : [
          { "name" : "enabled", "value" : "true" },
          { "name" : "tunnels", "path" : [ "TSL::1.2.3.4:1.2.3.4:1.2.3.4:1.2.3.4:XXX:XXX:false:3DES:1500:true:false::third party\\:1.2.3.4\\:\\:\\:\\:" ], "value" : "" }
        ]
      },
      { 
        "type" : "row",
        "position" : 430313,
        "cells" : [
          { "name" : "tunnels", "path" : [ "TSL::1.2.3.4:1.2.3.4:1.2.3.4:1.2.3.4:XXX:XXX:XXX:false:3DES:1500:true:false::third party\\:1.2.3.4\\:\\:\\:\\:" ], "value" : "", "tstamp" : "2016-03-29T08:08:53.504005Z" }
        ]
      },
      { 
        "type" : "row",
        "position" : 430693,
        "cells" : [
          { "name" : "tunnels", "path" : [ "TSL::1.2.3.4:1.2.3.4:1.2.3.4:1.2.3.4:XXX:XXX:false:3DES:1500:true:false::third party\\:1.2.3.4\\:\\:\\:\\:" ], "value" : "", "tstamp" : "2016-03-29T07:08:59.561Z" }  
        ]
      }
    ]
  }

[...]
{code}


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