[ https://issues.apache.org/jira/browse/CASSANDRA-8865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14337126#comment-14337126 ]
Constance Eustace commented on CASSANDRA-8865: ---------------------------------------------- Our doublequoted DROP statement seems to have successfully removed the traces of the old index from the schema... but we think the filesystem artifacts of the index are still around: so in the definition_bundle keyspace after SSTable upgrade, and then we dropped the definition_bundle__BundleDefSkuIDX index with a double-quoted drop and then recreated the index... lm@ip-172-16-10-50:/raid0/var/lib/cassandra/data/definition_bundle$ ls -la total 12 drwxr-xr-x 7 cassandra cassandra 133 Feb 25 16:32 . drwxr-xr-x 31 cassandra cassandra 4096 Feb 20 20:44 .. drwxr-xr-x 3 cassandra cassandra 22 Feb 25 18:33 blob drwxr-xr-x 3 cassandra cassandra 4096 Feb 25 19:54 entity_bundledef drwxr-xr-x 2 cassandra cassandra 4096 Feb 25 20:23 entity_bundledef-e6be57cfd0023d7dba582d4c577d6d61 drwxr-xr-x 3 cassandra cassandra 22 Feb 25 18:33 relation drwxr-xr-x 3 cassandra cassandra 22 Feb 25 18:33 relationbackref In this directory we still see the case-sensitive artifacts of the index: arlm@ip-172-16-10-50:/raid0/var/lib/cassandra/data/definition_bundle/entity_bundledef$ ls -la total 108 drwxr-xr-x 3 cassandra cassandra 4096 Feb 25 19:54 . drwxr-xr-x 7 cassandra cassandra 133 Feb 25 16:32 .. -rw-r--r-- 1 cassandra cassandra 43 Feb 24 08:54 definition_bundle-entity_bundledef.definition_bundle__BundleDefSkuIDX-jb-1-CompressionInfo.db -rw-r--r-- 1 cassandra cassandra 123 Feb 24 08:54 definition_bundle-entity_bundledef.definition_bundle__BundleDefSkuIDX-jb-1-Data.db -rw-r--r-- 1 cassandra cassandra 16 Feb 24 08:54 definition_bundle-entity_bundledef.definition_bundle__BundleDefSkuIDX-jb-1-Filter.db -rw-r--r-- 1 cassandra cassandra 30 Feb 24 08:54 definition_bundle-entity_bundledef.definition_bundle__BundleDefSkuIDX-jb-1-Index.db -rw-r--r-- 1 cassandra cassandra 4513 Feb 24 08:54 definition_bundle-entity_bundledef.definition_bundle__BundleDefSkuIDX-jb-1-Statistics.db -rw-r--r-- 1 cassandra cassandra 116 Feb 24 08:54 definition_bundle-entity_bundledef.definition_bundle__BundleDefSkuIDX-jb-1-Summary.db -rw-r--r-- 1 cassandra cassandra 79 Feb 24 08:54 definition_bundle-entity_bundledef.definition_bundle__BundleDefSkuIDX-jb-1-TOC.txt -rw-r--r-- 1 cassandra cassandra 43 Feb 25 18:33 definition_bundle-entity_bundledef-ka-3-CompressionInfo.db -rw-r--r-- 1 cassandra cassandra 1173 Feb 25 18:33 definition_bundle-entity_bundledef-ka-3-Data.db -rw-r--r-- 1 cassandra cassandra 9 Feb 25 18:33 definition_bundle-entity_bundledef-ka-3-Digest.sha1 -rw-r--r-- 1 cassandra cassandra 208 Feb 25 18:33 definition_bundle-entity_bundledef-ka-3-Filter.db -rw-r--r-- 1 cassandra cassandra 55 Feb 25 18:33 definition_bundle-entity_bundledef-ka-3-Index.db -rw-r--r-- 1 cassandra cassandra 4499 Feb 25 18:33 definition_bundle-entity_bundledef-ka-3-Statistics.db -rw-r--r-- 1 cassandra cassandra 191 Feb 25 18:33 definition_bundle-entity_bundledef-ka-3-Summary.db -rw-r--r-- 1 cassandra cassandra 91 Feb 25 18:33 definition_bundle-entity_bundledef-ka-3-TOC.txt -rw-r--r-- 1 cassandra cassandra 43 Feb 25 19:54 definition_bundle-entity_bundledef-ka-4-CompressionInfo.db -rw-r--r-- 1 cassandra cassandra 1163 Feb 25 19:54 definition_bundle-entity_bundledef-ka-4-Data.db -rw-r--r-- 1 cassandra cassandra 9 Feb 25 19:54 definition_bundle-entity_bundledef-ka-4-Digest.sha1 -rw-r--r-- 1 cassandra cassandra 16 Feb 25 19:54 definition_bundle-entity_bundledef-ka-4-Filter.db -rw-r--r-- 1 cassandra cassandra 55 Feb 25 19:54 definition_bundle-entity_bundledef-ka-4-Index.db -rw-r--r-- 1 cassandra cassandra 4494 Feb 25 19:54 definition_bundle-entity_bundledef-ka-4-Statistics.db -rw-r--r-- 1 cassandra cassandra 191 Feb 25 19:54 definition_bundle-entity_bundledef-ka-4-Summary.db -rw-r--r-- 1 cassandra cassandra 91 Feb 25 19:54 definition_bundle-entity_bundledef-ka-4-TOC.txt drwxr-xr-x 3 cassandra cassandra 36 Feb 25 18:33 snapshots in this directory we see the lowercased artifacts of the index... carlm@ip-172-16-10-50:/raid0/var/lib/cassandra/data/definition_bundle/entity_bundledef-e6be57cfd0023d7dba582d4c577d6d61$ ls -la total 76 drwxr-xr-x 2 cassandra cassandra 4096 Feb 25 20:23 . drwxr-xr-x 7 cassandra cassandra 133 Feb 25 16:32 .. -rw-r--r-- 1 cassandra cassandra 43 Feb 25 20:09 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidx-ka-1-CompressionInfo.db -rw-r--r-- 1 cassandra cassandra 164 Feb 25 20:09 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidx-ka-1-Data.db -rw-r--r-- 1 cassandra cassandra 10 Feb 25 20:09 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidx-ka-1-Digest.sha1 -rw-r--r-- 1 cassandra cassandra 16 Feb 25 20:09 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidx-ka-1-Filter.db -rw-r--r-- 1 cassandra cassandra 60 Feb 25 20:09 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidx-ka-1-Index.db -rw-r--r-- 1 cassandra cassandra 4570 Feb 25 20:09 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidx-ka-1-Statistics.db -rw-r--r-- 1 cassandra cassandra 116 Feb 25 20:09 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidx-ka-1-Summary.db -rw-r--r-- 1 cassandra cassandra 91 Feb 25 20:09 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidx-ka-1-TOC.txt -rw-r--r-- 1 cassandra cassandra 43 Feb 25 20:23 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidxtest-ka-1-CompressionInfo.db -rw-r--r-- 1 cassandra cassandra 135 Feb 25 20:23 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidxtest-ka-1-Data.db -rw-r--r-- 1 cassandra cassandra 9 Feb 25 20:23 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidxtest-ka-1-Digest.sha1 -rw-r--r-- 1 cassandra cassandra 16 Feb 25 20:23 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidxtest-ka-1-Filter.db -rw-r--r-- 1 cassandra cassandra 16 Feb 25 20:23 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidxtest-ka-1-Index.db -rw-r--r-- 1 cassandra cassandra 4548 Feb 25 20:23 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidxtest-ka-1-Statistics.db -rw-r--r-- 1 cassandra cassandra 74 Feb 25 20:23 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidxtest-ka-1-Summary.db -rw-r--r-- 1 cassandra cassandra 91 Feb 25 20:23 definition_bundle-entity_bundledef.definition_bundle__bundledefskuidxtest-ka-1-TOC.txt Our suspicion is that these are dangling remains, since the newly recreated index files are lowercase. Can we manually delete the case-sensitive artifacts safely? > DROP INDEX name case sensitivity causing errors in cass upgrade 2.0.10 to > 2.1.3 > ------------------------------------------------------------------------------- > > Key: CASSANDRA-8865 > URL: https://issues.apache.org/jira/browse/CASSANDRA-8865 > Project: Cassandra > Issue Type: Bug > Components: Core > Environment: Amazon, single node, ubuntu 14.04, jdk 7 > Reporter: Constance Eustace > > We are upgrading our dev cluster. > The indexes are behaving very strangely. > create index definition_bundle__BundleDefSkuIDXTest on > definition_bundle.entity_bundledef(e_entlinks) ; > definition_bundle> select column_name, index_name, index_options, index_type, > component_index from system.schema_columns where keyspace_name = > 'definition_bundle' and columnfamily_name = 'entity_bundledef'; > column_name | index_name | index_options | > index_type | component_index > -------------+----------------------------------------+---------------+------------+----------------- > bundle_sku | definition_bundle__BundleDefSkuIDX | {} | > COMPOSITES | 1 > e_entid | null | null | > null | null > e_entlinks | definition_bundle__bundledefskuidxtest | {} | > COMPOSITES | 1 > NOTICE THE AUTO-DOWNCASE of our newly created index. The index that already > existed is NOT AUTO-DOWNCASED. I don't know if this is recent or not. > We cannot drop the mixed case index. Nodetool index reconstruction did not > work. Indexes are doing very weird things. > Hm. UPDATE: > This did successfully delete the index: > drop index "definition_bundle__BundleDefSkuIDX"; > Anyway, it looks like there is some upcase/downcase assumptions not being > properly done.... somewhere, either in upgrades or similar stuff. > We will probably drop our indexes and recreate them. -- This message was sent by Atlassian JIRA (v6.3.4#6332)