Adding secondary index: java.lang.ArithmeticException: / by zero

Thu, 23 Dec 2010 00:34:55 -0800 

I was about to add a secondary index (which apparently failed) to existing 
data. When I restarted the node it crashed (!) with:

 INFO 09:21:36,510 Opening /var/lib/cassandra/data/test/tracking.6b6579-tmp-e-1
ERROR 09:21:36,512 Exception encountered during startup.
java.lang.ArithmeticException: / by zero
        at 
org.apache.cassandra.io.sstable.SSTable.estimateRowsFromIndex(SSTable.java:233)
        at 
org.apache.cassandra.io.sstable.SSTableReader.load(SSTableReader.java:284)
        at 
org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:200)
        at 
org.apache.cassandra.db.ColumnFamilyStore.<init>(ColumnFamilyStore.java:225)
        at 
org.apache.cassandra.db.ColumnFamilyStore.createColumnFamilyStore(ColumnFamilyStore.java:448)
        at 
org.apache.cassandra.db.ColumnFamilyStore.addIndex(ColumnFamilyStore.java:305)
        at 
org.apache.cassandra.db.ColumnFamilyStore.<init>(ColumnFamilyStore.java:246)
        at 
org.apache.cassandra.db.ColumnFamilyStore.createColumnFamilyStore(ColumnFamilyStore.java:448)
        at 
org.apache.cassandra.db.ColumnFamilyStore.createColumnFamilyStore(ColumnFamilyStore.java:436)
        at org.apache.cassandra.db.Table.initCf(Table.java:360)
        at org.apache.cassandra.db.Table.<init>(Table.java:290)
        at org.apache.cassandra.db.Table.open(Table.java:107)
        at 
org.apache.cassandra.service.AbstractCassandraDaemon.setup(AbstractCassandraDaemon.java:138)
        at 
org.apache.cassandra.thrift.CassandraDaemon.setup(CassandraDaemon.java:55)
        at 
org.apache.cassandra.service.AbstractCassandraDaemon.activate(AbstractCassandraDaemon.java:216)
        at 
org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java:134)
Exception encountered during startup.
java.lang.ArithmeticException: / by zero
        at 
org.apache.cassandra.io.sstable.SSTable.estimateRowsFromIndex(SSTable.java:233)
        at 
org.apache.cassandra.io.sstable.SSTableReader.load(SSTableReader.java:284)
        at 
org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:200)
        at 
org.apache.cassandra.db.ColumnFamilyStore.<init>(ColumnFamilyStore.java:225)
        at 
org.apache.cassandra.db.ColumnFamilyStore.createColumnFamilyStore(ColumnFamilyStore.java:448)
        at 
org.apache.cassandra.db.ColumnFamilyStore.addIndex(ColumnFamilyStore.java:305)
        at 
org.apache.cassandra.db.ColumnFamilyStore.<init>(ColumnFamilyStore.java:246)
        at 
org.apache.cassandra.db.ColumnFamilyStore.createColumnFamilyStore(ColumnFamilyStore.java:448)
        at 
org.apache.cassandra.db.ColumnFamilyStore.createColumnFamilyStore(ColumnFamilyStore.java:436)
        at org.apache.cassandra.db.Table.initCf(Table.java:360)
        at org.apache.cassandra.db.Table.<init>(Table.java:290)
        at org.apache.cassandra.db.Table.open(Table.java:107)
        at 
org.apache.cassandra.service.AbstractCassandraDaemon.setup(AbstractCassandraDaemon.java:138)
        at 
org.apache.cassandra.thrift.CassandraDaemon.setup(CassandraDaemon.java:55)
        at 
org.apache.cassandra.service.AbstractCassandraDaemon.activate(AbstractCassandraDaemon.java:216)
        at 
org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java:134)

So, I deleted the file which let's cassandra to startup again (and starting all 
over to build the secondary index).

Since 0.7rc2 was too unstable I'm on SNAPSHOT from Dec 17.

Reply via email to