cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julien Anguenot (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-11887) Duplicate rows after a 2.2.5 to 3.0.4 migration
Date Tue, 24 May 2016 17:15:13 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-11887?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Julien Anguenot updated CASSANDRA-11887:
----------------------------------------
    Reproduced In: 3.0.6, 3.0.5, 3.0.4  (was: 3.0.4)

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

Mime
View raw message