To reset the whole DB delete everything in the data and commit log directories, they are specified in cassandra.yaml .
What does your yaml file look like ? This looks like an error trying to add an index at startup, it would be good to know why.
You may need to roll back to the initial yaml file.
Hope that helps
Aaron
On 17 Nov, 2010,at 08:52 AM, André Fiedler <fiedler.an...@googlemail.com> wrote:
I got the following log, how do i fix this? How can i reset the whole database? (i´m only testing b now)------------------- LOG ------------------------------INFO 20:45:44,852 Heap size: 1069416448/1069416448INFO 20:45:44,913 JNA not found. Native methods will be disabled.INFO 20:45:44,963 Loading settings from file:/Applications/apache-cassandra-0.7.0-beta3/conf/cassandra.yamlINFO 20:45:45,310 DiskAccessMode 'auto' determined to be mmap, indexAccessMode is mmapINFO 20:45:45,573 Creating new commitlog segment /var/lib/cassandra/commitlog/CommitLog-1289936745573.logINFO 20:45:45,848 Deleted /var/lib/cassandra/data/system/Schema-e-37-<>INFO 20:45:45,859 Deleted /var/lib/cassandra/data/system/Schema-e-39-<>INFO 20:45:45,887 Deleted /var/lib/cassandra/data/system/Schema-e-38-<>INFO 20:45:45,888 Deleted /var/lib/cassandra/data/system/Schema-e-40-<>INFO 20:45:46,029 read 1 from saved key cacheINFO 20:45:46,037 Sampling index for /var/lib/cassandra/data/system/IndexInfo-e-37-<>INFO 20:45:46,210 read 1 from saved key cacheINFO 20:45:46,213 Sampling index for /var/lib/cassandra/data/system/Schema-e-43-<>INFO 20:45:46,232 Sampling index for /var/lib/cassandra/data/system/Schema-e-41-<>INFO 20:45:46,265 Sampling index for /var/lib/cassandra/data/system/Schema-e-42-<>INFO 20:45:46,276 read 0 from saved key cacheINFO 20:45:46,282 Sampling index for /var/lib/cassandra/data/system/Migrations-e-42-<>INFO 20:45:46,302 Sampling index for /var/lib/cassandra/data/system/Migrations-e-43-<>INFO 20:45:46,308 Sampling index for /var/lib/cassandra/data/system/Migrations-e-41-<>INFO 20:45:46,329 read 1 from saved key cacheINFO 20:45:46,331 Sampling index for /var/lib/cassandra/data/system/LocationInfo-e-23-<>INFO 20:45:46,347 Sampling index for /var/lib/cassandra/data/system/LocationInfo-e-22-<>INFO 20:45:46,353 Sampling index for /var/lib/cassandra/data/system/LocationInfo-e-21-<>INFO 20:45:46,367 read 0 from saved key cacheINFO 20:45:46,378 loading row cache for LocationInfo of systemINFO 20:45:46,379 completed loading (1 ms; 0 keys) row cache for LocationInfo of systemINFO 20:45:46,379 loading row cache for HintsColumnFamily of systemINFO 20:45:46,380 completed loading (1 ms; 0 keys) row cache for HintsColumnFamily of systemINFO 20:45:46,380 loading row cache for Migrations of systemINFO 20:45:46,380 completed loading (0 ms; 0 keys) row cache for Migrations of systemINFO 20:45:46,381 loading row cache for Schema of systemINFO 20:45:46,381 completed loading (0 ms; 0 keys) row cache for Schema of systemINFO 20:45:46,382 loading row cache for IndexInfo of systemINFO 20:45:46,382 completed loading (1 ms; 0 keys) row cache for IndexInfo of systemINFO 20:45:46,492 Loading schema version 5712cb3b-f1b8-11df-b584-e700f669bcfcWARN 20:45:47,792 Schema definitions were defined both locally and in cassandra.yaml. Definitions in cassandra.yaml were ignored.INFO 20:45:47,860 read 2 from saved key cacheINFO 20:45:47,879 read 0 from saved key cacheINFO 20:45:47,885 read 0 from saved key cacheINFO 20:45:47,888 read 0 from saved key cacheINFO 20:45:47,890 read 0 from saved key cacheINFO 20:45:47,893 read 0 from saved key cacheERROR 20:45:47,894 Exception encountered during startup.java.lang.IndexOutOfBoundsExceptionat java.nio.Buffer.checkIndex(Buffer.java:520)at java.nio.HeapByteBuffer.getLong(HeapByteBuffer.java:391)at org.apache.cassandra.db.marshal.LexicalUUIDType.getUUID(LexicalUUIDType.java:37)at org.apache.cassandra.db.marshal.LexicalUUIDType.compare(LexicalUUIDType.java:51)at org.apache.cassandra.db.marshal.LexicalUUIDType.compare(LexicalUUIDType.java:29)at java.util.concurrent.ConcurrentSkipListMap$ComparableUsingComparator.compareTo(ConcurrentSkipListMap.java:606)at java.util.concurrent.ConcurrentSkipListMap.findPredecessor(ConcurrentSkipListMap.java:685)at java.util.concurrent.ConcurrentSkipListMap.doPut(ConcurrentSkipListMap.java:864)at java.util.concurrent.ConcurrentSkipListMap.put(ConcurrentSkipListMap.java:1659)at org.apache.cassandra.db.ColumnFamilyStore.addIndex(ColumnFamilyStore.java:320)at org.apache.cassandra.db.ColumnFamilyStore.<init>(ColumnFamilyStore.java:256)at org.apache.cassandra.db.ColumnFamilyStore.createColumnFamilyStore(ColumnFamilyStore.java:443)at org.apache.cassandra.db.ColumnFamilyStore.createColumnFamilyStore(ColumnFamilyStore.java:431)at org.apache.cassandra.db.Table.initCf(Table.java:335)at org.apache.cassandra.db.Table.<init>(Table.java:277)at org.apache.cassandra.db.Table.open(Table.java:113)at org.apache.cassandra.service.AbstractCassandraDaemon.setup(AbstractCassandraDaemon.java:137)at org.apache.cassandra.thrift.CassandraDaemon.setup(CassandraDaemon.java:55)at org.apache.cassandra.service.AbstractCassandraDaemon.activate(AbstractCassandraDaemon.java:215)at orgapache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java:134)Exception encountered during startup.java.lang.IndexOutOfBoundsExceptionat java.nio.Buffer.checkIndex(Buffer.java:520)at java.nio.HeapByteBuffer.getLong(HeapByteBuffer.java:391)at org.apache.cassandra.db.marshal.LexicalUUIDType.getUUID(LexicalUUIDType.java:37)at org.apache.cassandra.db.marshal.LexicalUUIDType.compare(LexicalUUIDType.java:51)at org.apache.cassandra.db.marshal.LexicalUUIDType.compare(LexicalUUIDType.java:29)at java.util.concurrent.ConcurrentSkipListMap$ComparableUsingComparator.compareTo(ConcurrentSkipListMap.java:606)at java.util.concurrent.ConcurrentSkipListMap.findPredecessor(ConcurrentSkipListMap.java:685)at java.util.concurrent.ConcurrentSkipListMap.doPut(ConcurrentSkipListMap.java:864)at java.util.concurrent.ConcurrentSkipListMap.put(ConcurrentSkipListMap.java:1659)at org.apache.cassandra.db.ColumnFamilyStore.addIndex(ColumnFamilyStore.java:320)at org.apache.cassandra.db.ColumnFamilyStore.<init>(ColumnFamilyStore.java:256)at org.apache.cassandra.db.ColumnFamilyStore.createColumnFamilyStore(ColumnFamilyStore.java:443)at org.apache.cassandra.db.ColumnFamilyStore.createColumnFamilyStore(ColumnFamilyStore.java:431)at org.apache.cassandra.db.Table.initCf(Table.java:335)at org.apache.cassandra.db.Table.<init>(Table.java:277)at org.apache.cassandra.db.Table.open(Table.java:113)at org.apache.cassandra.service.AbstractCassandraDaemon.setup(AbstractCassandraDaemon.java:137)at org.apache.cassandra.thrift.CassandraDaemon.setup(CassandraDaemon.java:55)at org.apache.cassandra.service.AbstractCassandraDaemon.activate(AbstractCassandraDaemon.java:215)at org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java:134)
