[ https://issues.apache.org/jira/browse/CASSANDRA-11021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15102181#comment-15102181 ]
Cédric Hernalsteens commented on CASSANDRA-11021: ------------------------------------------------- Same problem here. The insert works when the index is not present. I've been tracking this error since last night, great that you passe by on SO. qlsh:kepler> drop table test; cqlsh:kepler> CREATE TABLE test (k int, t int, s text static, v text, PRIMARY KEY (k, t)); cqlsh:kepler> INSERT INTO test(k, t, s, v) VALUES (0, 1, 'abc', 'def'); cqlsh:kepler> CREATE INDEX ix ON test (t); cqlsh:kepler> INSERT INTO test(k, t, s, v) VALUES (0, 1, 'abc', 'def'); Traceback (most recent call last): File "/local/chernals/apache-cassandra-3.2/bin/cqlsh.py", line 1246, in perform_simple_statement result = future.result() File "/local/chernals/apache-cassandra-3.2/bin/../lib/cassandra-driver-internal-only-3.0.0-6af642d.zip/cassandra-driver-3.0.0-6af642d/cassandra/cluster.py", line 3122, in result raise self._final_exception WriteFailure: code=1500 [Replica(s) failed to execute write] message="Operation failed - received 0 responses and 1 failures" info={'failures': 1, 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > Inserting static column fails with secondary index on clustering key > -------------------------------------------------------------------- > > Key: CASSANDRA-11021 > URL: https://issues.apache.org/jira/browse/CASSANDRA-11021 > Project: Cassandra > Issue Type: Bug > Components: Local Write-Read Paths > Reporter: Stefan Podkowinski > Assignee: Stefan Podkowinski > > Creating a secondary index on a clustering key fails with an exception in > case a static column is involved. > {code} > CREATE TABLE test (k int, t int, s text static, v text, PRIMARY KEY (k, t)); > CREATE INDEX ix ON test (t); > INSERT INTO test(k, t, s, v) VALUES (0, 1, 'abc', 'def'); > {code} > {code} > ERROR [SharedPool-Worker-2] 2016-01-15 11:42:27,484 StorageProxy.java:1336 - > Failed to apply mutation locally : {} > java.lang.ArrayIndexOutOfBoundsException: 0 > at > org.apache.cassandra.db.AbstractClusteringPrefix.get(AbstractClusteringPrefix.java:59) > ~[main/:na] > at > org.apache.cassandra.index.internal.composites.ClusteringColumnIndex.getIndexedValue(ClusteringColumnIndex.java:58) > ~[main/:na] > at > org.apache.cassandra.index.internal.CassandraIndex.getIndexedValue(CassandraIndex.java:598) > ~[main/:na] > at > org.apache.cassandra.index.internal.CassandraIndex.insert(CassandraIndex.java:490) > ~[main/:na] > at > org.apache.cassandra.index.internal.CassandraIndex.access$100(CassandraIndex.java:53) > ~[main/:na] > at > org.apache.cassandra.index.internal.CassandraIndex$1.indexPrimaryKey(CassandraIndex.java:437) > ~[main/:na] > at > org.apache.cassandra.index.internal.CassandraIndex$1.insertRow(CassandraIndex.java:347) > ~[main/:na] > at > org.apache.cassandra.index.SecondaryIndexManager$WriteTimeTransaction.onInserted(SecondaryIndexManager.java:795) > ~[main/:na] > at > org.apache.cassandra.db.partitions.AtomicBTreePartition$RowUpdater.apply(AtomicBTreePartition.java:275) > ~[main/:na] > at > org.apache.cassandra.db.partitions.AtomicBTreePartition.addAllWithSizeDelta(AtomicBTreePartition.java:154) > ~[main/:na] > at org.apache.cassandra.db.Memtable.put(Memtable.java:240) ~[main/:na] > at > org.apache.cassandra.db.ColumnFamilyStore.apply(ColumnFamilyStore.java:1145) > ~[main/:na] > at org.apache.cassandra.db.Keyspace.apply(Keyspace.java:494) > ~[main/:na] > at org.apache.cassandra.db.Keyspace.apply(Keyspace.java:384) > ~[main/:na] > at org.apache.cassandra.db.Mutation.apply(Mutation.java:205) > ~[main/:na] > at > org.apache.cassandra.service.StorageProxy$$Lambda$166/492512700.run(Unknown > Source) ~[na:na] > at > org.apache.cassandra.service.StorageProxy$8.runMayThrow(StorageProxy.java:1330) > ~[main/:na] > at > org.apache.cassandra.service.StorageProxy$LocalMutationRunnable.run(StorageProxy.java:2480) > [main/:n > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)