Andrés de la Peña created CASSANDRA-13400:
---------------------------------------------

             Summary: java.lang.ArithmeticException: / by zero when index is 
created on table with clustering columns only
                 Key: CASSANDRA-13400
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-13400
             Project: Cassandra
          Issue Type: Bug
            Reporter: Andrés de la Peña
            Assignee: Andrés de la Peña


If we create an index over the clustering key of a table without regular 
columns:
{code}
CREATE KEYSPACE k WITH replication = {'class': 'SimpleStrategy', 
'replication_factor': 1};
CREATE TABLE k.t (pk text, ck text, PRIMARY KEY (pk, ck));
INSERT INTO k.t (pk, ck) VALUES ( 'pk','ck');
CREATE INDEX idx ON k.t(ck);
{code}
Then the following error index creation erros is logged:
{code}
INFO  10:19:34 Submitting index build of idx for data in 
BigTableReader(path='/Users/adelapena/datastax/cassandra/data/data/k/t-ed3d6f90185611e7949f55d18a2e5858/mc-1-big-Data.db')
ERROR 10:19:34 Exception in thread Thread[SecondaryIndexManagement:2,5,main]
java.lang.RuntimeException: java.util.concurrent.ExecutionException: 
java.lang.ArithmeticException: / by zero
        at 
org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:402) 
~[main/:na]
        at 
org.apache.cassandra.index.internal.CassandraIndex.buildBlocking(CassandraIndex.java:723)
 ~[main/:na]
        at 
org.apache.cassandra.index.internal.CassandraIndex.lambda$getBuildIndexTask$5(CassandraIndex.java:693)
 ~[main/:na]
        at java.util.concurrent.FutureTask.run(FutureTask.java:266) 
~[na:1.8.0_112]
        at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
~[na:1.8.0_112]
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
[na:1.8.0_112]
        at 
org.apache.cassandra.concurrent.NamedThreadFactory.lambda$threadLocalDeallocator$0(NamedThreadFactory.java:79)
 [main/:na]
        at java.lang.Thread.run(Thread.java:745) ~[na:1.8.0_112]
Caused by: java.util.concurrent.ExecutionException: 
java.lang.ArithmeticException: / by zero
        at java.util.concurrent.FutureTask.report(FutureTask.java:122) 
~[na:1.8.0_112]
        at java.util.concurrent.FutureTask.get(FutureTask.java:192) 
~[na:1.8.0_112]
        at 
org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:398) 
~[main/:na]
        ... 7 common frames omitted
Caused by: java.lang.ArithmeticException: / by zero
        at 
org.apache.cassandra.index.SecondaryIndexManager.calculateIndexingPageSize(SecondaryIndexManager.java:629)
 ~[main/:na]
        at 
org.apache.cassandra.index.SecondaryIndexBuilder.build(SecondaryIndexBuilder.java:62)
 ~[main/:na]
        at 
org.apache.cassandra.db.compaction.CompactionManager$11.run(CompactionManager.java:1347)
 ~[main/:na]
        at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) 
~[na:1.8.0_112]
        at java.util.concurrent.FutureTask.run(FutureTask.java:266) 
~[na:1.8.0_112]
        at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) 
~[na:1.8.0_112]
        ... 5 common frames omitted
{code}
Any further queries using the index will fail:
{code}
SELECT * FROM k.t where ck = 'ck';
ReadFailure: Error from server: code=1300 [Replica(s) failed to execute read] 
message="Operation failed - received 0 responses and 1 failures" 
info={'failures': 1, 'received_responses': 0, 'required_responses': 1, 
'consistency': 'ONE'}
{code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to