As stated in topic, I'm unable to drop secondary index either by using
cli or cqlsh. In both cases it looks like to command is processed
properly (some uuid shows up in cli, no output in cqlsh), I can see in
logs that schema is going to be updated (index name and type are set to
null) and then... nothing. No exception, no information. Just a few
lines of output telling me that some system-related Memtables/CFs got
flushed/compacted. Attaching logs at the end of this email (I was
dropping Users_username_idx_1).
I'm using C* 1.2.1, upgraded some time ago from 1.1.0. The same works
perfectly on a test cluster which uses the same C* configuration and a
sample of production data (and was upgraded at the same time as production).
However, when I setup out environment on a brand new C* 1.2.1 cluster
(not upgraded), I can see some differences in schemas comparing to the
1.1.0 -> 1.2.1 one; for example missing 'type' column for
system.schema_columns for example. I wonder if it's not a problem, but
as far as I can see in source code it seems to be handled.
Rebuilding indexes fails (no new files were created) with no errors too.
Any ideas?
INFO [Thrift:24864] 2013-04-18 10:23:17,536 MigrationManager.java (line
246) Update ColumnFamily 'production/Users' From
org.apache.cassandra.config.CFMetaData@4febff32[cfId=5230d831-0ac9-3c5f-835f-481296696252,ksName=production,cfName=Users,cfType=Standard,comparator=org.apache.cassandra.db.marshal.AsciiType,subcolumncomparator=<null>,comment=,readRepairChance=1.0,dclocalReadRepairChance=0.0,replicateOnWrite=true,gcGraceSeconds=864000,defaultValidator=org.apache.cassandra.db.marshal.UTF8Type,keyValidator=org.apache.cassandra.db.marshal.LexicalUUIDType,minCompactionThreshold=4,maxCompactionThreshold=32,keyAliases=[],columnAliases=[],valueAlias=<null>,column_metadata={java.nio.HeapByteBuffer[pos=0
lim=12 cap=12]=ColumnDefinition{name=646174655f63726561746564,
validator=org.apache.cassandra.db.marshal.LongType, index_type=null,
index_name='null'}, java.nio.HeapByteBuffer[pos=0 lim=6
cap=6]=ColumnDefinition{name=616374697665,
validator=org.apache.cassandra.db.marshal.IntegerType, index_type=KEYS,
index_name='Users_active_idx'}, java.nio.HeapByteBuffer[pos=0 lim=5
cap=5]=ColumnDefinition{name=656d61696c,
validator=org.apache.cassandra.db.marshal.UTF8Type, index_type=KEYS,
index_name='Users_email_idx'}, java.nio.HeapByteBuffer[pos=0 lim=8
cap=8]=ColumnDefinition{name=757365726e616d65,
validator=org.apache.cassandra.db.marshal.UTF8Type, index_type=KEYS,
index_name='Users_username_idx'}, java.nio.HeapByteBuffer[pos=0 lim=18
cap=18]=ColumnDefinition{name=64656661756c745f6163636f756e745f6964,
validator=org.apache.cassandra.db.marshal.LexicalUUIDType,
index_type=null, index_name='null'}},compactionStrategyClass=class
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy,compactionStrategyOptions={},compressionOptions={sstable_compression=org.apache.cassandra.io.compress.SnappyCompressor},bloomFilterFpChance=<null>,caching=KEYS_ONLY]
To
org.apache.cassandra.config.CFMetaData@2eb25d0[cfId=5230d831-0ac9-3c5f-835f-481296696252,ksName=production,cfName=Users,cfType=Standard,comparator=org.apache.cassandra.db.marshal.AsciiType,subcolumncomparator=<null>,comment=,readRepairChance=1.0,dclocalReadRepairChance=0.0,replicateOnWrite=true,gcGraceSeconds=864000,defaultValidator=org.apache.cassandra.db.marshal.UTF8Type,keyValidator=org.apache.cassandra.db.marshal.LexicalUUIDType,minCompactionThreshold=4,maxCompactionThreshold=32,keyAliases=[],columnAliases=[],valueAlias=<null>,column_metadata={java.nio.HeapByteBuffer[pos=0
lim=12 cap=12]=ColumnDefinition{name=646174655f63726561746564,
validator=org.apache.cassandra.db.marshal.LongType, index_type=null,
index_name='null'}, java.nio.HeapByteBuffer[pos=0 lim=6
cap=6]=ColumnDefinition{name=616374697665,
validator=org.apache.cassandra.db.marshal.IntegerType, index_type=KEYS,
index_name='Users_active_idx'}, java.nio.HeapByteBuffer[pos=0 lim=5
cap=5]=ColumnDefinition{name=656d61696c,
validator=org.apache.cassandra.db.marshal.UTF8Type, index_type=null,
index_name='null'}, java.nio.HeapByteBuffer[pos=0 lim=8
cap=8]=ColumnDefinition{name=757365726e616d65,
validator=org.apache.cassandra.db.marshal.UTF8Type, index_type=KEYS,
index_name='Users_username_idx'}, java.nio.HeapByteBuffer[pos=0 lim=18
cap=18]=ColumnDefinition{name=64656661756c745f6163636f756e745f6964,
validator=org.apache.cassandra.db.marshal.LexicalUUIDType,
index_type=null, index_name='null'}},compactionStrategyClass=class
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy,compactionStrategyOptions={},compressionOptions={sstable_compression=org.apache.cassandra.io.compress.SnappyCompressor},bloomFilterFpChance=<null>,caching=KEYS_ONLY]
INFO [MigrationStage:1] 2013-04-18 10:23:17,567 ColumnFamilyStore.java
(line 640) Enqueuing flush of
Memtable-schema_columnfamilies@469728303(1023/2281 serialized/live
bytes, 20 ops)
INFO [FlushWriter:22] 2013-04-18 10:23:17,568 Memtable.java (line 447)
Writing Memtable-schema_columnfamilies@469728303(1023/2281
serialized/live bytes, 20 ops)
INFO [FlushWriter:22] 2013-04-18 10:23:17,573 Memtable.java (line 481)
Completed flushing
/cassandra/system/schema_columnfamilies/system-schema_columnfamilies-ib-631-Data.db
(648 bytes) for commitlog position
ReplayPosition(segmentId=1365620853206, position=2889368)
INFO [CompactionExecutor:7616] 2013-04-18 10:23:17,574
CompactionTask.java (line 118) Compacting
[SSTableReader(path='/cassandra/system/schema_columnfamilies/system-schema_columnfamilies-ib-631-Data.db'),
SSTableReader(path='/cassandra/system/schema_columnfamilies/system-schema_columnfamilies-ib-629-Data.db'),
SSTableReader(path='/cassandra/system/schema_columnfamilies/system-schema_columnfamilies-ib-630-Data.db'),
SSTableReader(path='/cassandra/system/schema_columnfamilies/system-schema_columnfamilies-ib-628-Data.db')]
INFO [MigrationStage:1] 2013-04-18 10:23:17,576 ColumnFamilyStore.java
(line 640) Enqueuing flush of Memtable-schema_columns@1106646812(248/700
serialized/live bytes, 5 ops)
INFO [FlushWriter:22] 2013-04-18 10:23:17,577 Memtable.java (line 447)
Writing Memtable-schema_columns@1106646812(248/700 serialized/live
bytes, 5 ops)
INFO [FlushWriter:22] 2013-04-18 10:23:17,595 Memtable.java (line 481)
Completed flushing
/cassandra/system/schema_columns/system-schema_columns-ib-483-Data.db
(199 bytes) for commitlog position
ReplayPosition(segmentId=1365620853206, position=2889368)
INFO [CompactionExecutor:7617] 2013-04-18 10:23:17,595
CompactionTask.java (line 118) Compacting
[SSTableReader(path='/cassandra/system/schema_columns/system-schema_columns-ib-480-Data.db'),
SSTableReader(path='/cassandra/system/schema_columns/system-schema_columns-ib-482-Data.db'),
SSTableReader(path='/cassandra/system/schema_columns/system-schema_columns-ib-481-Data.db'),
SSTableReader(path='/cassandra/system/schema_columns/system-schema_columns-ib-483-Data.db')]
INFO [CompactionExecutor:7616] 2013-04-18 10:23:17,611
CompactionTask.java (line 273) Compacted 4 sstables to
[/cassandra/system/schema_columnfamilies/system-schema_columnfamilies-ib-632,].
17,018 bytes to 15,070 (~88% of original) in 36ms = 0.399219MB/s. 8
total rows, 5 unique. Row merge counts were {1:4, 2:0, 3:0, 4:1, }
INFO [CompactionExecutor:7617] 2013-04-18 10:23:17,616
CompactionTask.java (line 273) Compacted 4 sstables to
[/cassandra/system/schema_columns/system-schema_columns-ib-484,]. 3,804
bytes to 3,148 (~82% of original) in 20ms = 0.150108MB/s. 7 total rows,
4 unique. Row merge counts were {1:3, 2:0, 3:0, 4:1, }
M.