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)