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