That was bug in 1.1.1 and fixed in https://issues.apache.org/jira/browse/CASSANDRA-4331. Workaround is deleting the key cache files for your index CFs should fix this.
Yuki On Friday, June 29, 2012 at 10:02 AM, Thierry Templier wrote: > Hello, > > My problem seems to occur after a server restart. As a matter of fact, > if I clean the data, create a new keyspace and and its structure with > cqlsh, I can use the database correctly (both with cqlsh and a Java > application with Astyanax). If I stop the server and restart it, I have > my problem and then my requests don't work anymore (for example, > requests with where clause). > > Thanks for your help! > Thierry > > > Hello, > > > > When I start the Cassandra server, some exceptions occur: > > > > INFO 10:22:16,014 reading saved cache > > /var/lib/cassandra/saved_caches/apispark-CellMessage-KeyCache > > INFO 10:22:16,016 Opening > > /var/lib/cassandra/data/apispark/CellMessage/apispark-CellMessage-hd-2 > > (498 bytes) > > INFO 10:22:16,016 Opening > > /var/lib/cassandra/data/apispark/CellMessage/apispark-CellMessage-hd-1 > > (635 bytes) > > INFO 10:22:16,041 Creating new index : > > ColumnDefinition{name=76657273696f6e, > > validator=org.apache.cassandra.db.marshal.UTF8Type, index_type=KEYS, > > index_name='cellmessage_version'} > > INFO 10:22:16,045 reading saved cache > > /var/lib/cassandra/saved_caches/apispark-CellMessage.cellmessage_version-KeyCache > > INFO 10:22:16,066 Opening > > /var/lib/cassandra/data/apispark/CellMessage/apispark-CellMessage.cellmessage_version-hd-2 > > > > (349 bytes) > > INFO 10:22:16,066 Opening > > /var/lib/cassandra/data/apispark/CellMessage/apispark-CellMessage.cellmessage_version-hd-1 > > > > (401 bytes) > > ERROR 10:22:16,068 Exception in thread Thread[SSTableBatchOpen:1,5,main] > > java.lang.ClassCastException: java.math.BigInteger cannot be cast to > > java.nio.ByteBuffer > > at org.apache.cassandra.db.marshal.UTF8Type.compare(UTF8Type.java:27) > > at org.apache.cassandra.dht.LocalToken.compareTo(LocalToken.java:45) > > at > > org.apache.cassandra.db.DecoratedKey.compareTo(DecoratedKey.java:89) > > at > > org.apache.cassandra.db.DecoratedKey.compareTo(DecoratedKey.java:38) > > at java.util.TreeMap.getEntry(TreeMap.java:345) > > at java.util.TreeMap.containsKey(TreeMap.java:226) > > at java.util.TreeSet.contains(TreeSet.java:234) > > at > > org.apache.cassandra.io.sstable.SSTableReader.load(SSTableReader.java:396) > > at > > org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:187) > > at > > org.apache.cassandra.io.sstable.SSTableReader$1.run(SSTableReader.java:225) > > at > > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) > > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) > > at java.lang.Thread.run(Thread.java:636) > > ERROR 10:22:16,071 Exception in thread Thread[SSTableBatchOpen:2,5,main] > > java.lang.ClassCastException: java.math.BigInteger cannot be cast to > > java.nio.ByteBuffer > > at org.apache.cassandra.db.marshal.UTF8Type.compare(UTF8Type.java:27) > > at org.apache.cassandra.dht.LocalToken.compareTo(LocalToken.java:45) > > at > > org.apache.cassandra.db.DecoratedKey.compareTo(DecoratedKey.java:89) > > at > > org.apache.cassandra.db.DecoratedKey.compareTo(DecoratedKey.java:38) > > at java.util.TreeMap.getEntry(TreeMap.java:345) > > at java.util.TreeMap.containsKey(TreeMap.java:226) > > at java.util.TreeSet.contains(TreeSet.java:234) > > at > > org.apache.cassandra.io.sstable.SSTableReader.load(SSTableReader.java:396) > > at > > org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:187) > > at > > org.apache.cassandra.io.sstable.SSTableReader$1.run(SSTableReader.java:225) > > at > > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) > > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) > > at java.lang.Thread.run(Thread.java:636) > > > > Here is the definition of the related table CellMessage: > > > > CREATE TABLE CellMessage ( > > id text PRIMARY KEY, > > "type" text, > > version text, > > content text, > > title text, > > generated text, > > date text > > ) WITH > > comment='' AND > > comparator=text AND > > read_repair_chance=0.100000 AND > > gc_grace_seconds=864000 AND > > default_validation=text AND > > min_compaction_threshold=4 AND > > max_compaction_threshold=32 AND > > replicate_on_write='true' AND > > compaction_strategy_class='SizeTieredCompactionStrategy' AND > > compression_parameters:sstable_compression='SnappyCompressor'; > > > > CREATE INDEX cellmessage_version ON CellMessage (version); > > > > Such errors occur for most tables I defined... > > > > Thanks very much for your help! > > Thierry > > > > >