cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jesse Hodges <hodges.je...@gmail.com>
Subject duplicate values for primary key
Date Tue, 02 Aug 2016 01:16:55 GMT
Hi, I've got a bit of a conundrum. Recently I upgraded from 2.2.3 to 3.7.0
(ddc distribution). Following the upgrade (though this condition may have
existed prior to upgrade)..

I have a table with a simple partition key and multiple clustering keys,
and I have duplicates of many of the primary keys!

I've tried various repair options and lots of searching, but nothing's
really helping. I'm unsure of how to troubleshoot further or potentially
consolidate these keys. This seems like a bug, but hopefully it's something
simple I missed. I'm also willing to troubleshoot further as needed, but I
could use a few getting started pointers.

Example output: primary key is
(partition_id,alarm_id,tenant_id,account_id,source,metric)


cqlsh:alarms> select * from alarms.last_seen_state  where partition_id=10
and alarm_id='59893';

 partition_id | alarm_id | tenant_id                            |
account_id | source | metric | last_seen                       | value
--------------+----------+--------------------------------------+------------+--------+--------+---------------------------------+-------
           10 |    59893 | f50f8413-57bb-4eb5-a37c-7482a63ea9a5 |
 10303 | PORTAL |    CPU | 2016-08-01 15:27:37.000000+0000 |     1
           10 |    59893 | f50f8413-57bb-4eb5-a37c-7482a63ea9a5 |
 10303 | PORTAL |    CPU | 2016-08-01 15:07:15.000000+0000 |     1

Thanks, Jesse

Mime
View raw message