[CASSANDRA-3488] Secondary indexes still around 3 months after deleting them

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Cannot Reproduce
• Component/s: Feature/2i Index
• Labels: secondary_index
• Severity: Normal
• Assignee: Unassigned
• Reporter: Jeremy Hanna
• Created: 13/Nov/11 01:05
• Updated: 16/Apr/19 09:32
• Resolved: 15/Nov/11 22:16

Description

We had an issue where we lost the data directories of two nodes. So we re-bootstrapped those two nodes into the cluster and did the repair. During the repair, secondary indexes were built as evidenced both in compactionstats and in the filesystem. The problem is, we haven't had secondary indexes on any of our column families for about 3 months now. The history there is that we were on 0.7.6, deleted the secondary indexes on that version, and upgraded to 0.8.4 a bit later. It bootstrapped and repaired last night and this morning, but it's been a good 10 hours today of almost exclusively rebuilding secondary indexes that shouldn't be there.