hector 1.1-4 throws TimedOutException() execute_cql_query_result.read on Cassandra 2.1.12

[krishna81m]

I am testing if we can upgrade our cassandra 1.2 to 2.1.12 (thrift only deprecated BUT NOT removed) and spun up a single instance and populated data from 1.2 without any problem, everything works, even from a IDE client on thrift:9160 port is able to run this query.

However, hector throws an exception, cfstats does not get updated when run from hector whereas from thrift IDE client shows the request going through without a warning:

This is a simple multiple secondary index query (client needs ALLOW FILTERING).

SELECT "Value" from "Lookup" WHERE "Type" = 'preference' AND "active" = True;

Caused by: me.prettyprint.hector.api.exceptions.HTimedOutException: TimedOutException()
    at ..)
    at me.prettyprint.cassandra.model.CqlQuery$1.execute(CqlQuery.java:142)
    at me.prettyprint.cassandra.model.CqlQuery$1.execute(CqlQuery.java:106)
    at me.prettyprint.cassandra.service.Operation.executeAndSetResult(Operation.java:104)
    at me.prettyprint.cassandra.connection.HConnectionManager.operateWithFailover(HConnectionManager.java:253)
    at me.prettyprint.cassandra.model.ExecutingKeyspace.doExecuteOperation(ExecutingKeyspace.java:113)
    at me.prettyprint.cassandra.model.CqlQuery.execute(CqlQuery.java:105)
    at ...(SomeFactory....java:213)
    ... 82 more
Caused by: TimedOutException()
    at org.apache.cassandra.thrift.Cassandra$execute_cql_query_result.read(Cassandra.java:36641)
    at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)
    at org.apache.cassandra.thrift.Cassandra$Client.recv_execute_cql_query(Cassandra.java:1525)
    at org.apache.cassandra.thrift.Cassandra$Client.execute_cql_query(Cassandra.java:1511)
    at me.prettyprint.cassandra.model.CqlQuery$1.execute(CqlQuery.java:118)
    ... 88 more

And I only see a warning in Cassandra logs.

WARN  [SharedPool-Worker-1] 2016-01-27 05:15:47,624 AbstractTracingAwareExecutorService.java:169 - Uncaught exception on thread Thread[SharedPo
ol-Worker-1,5,main]: {}
java.lang.AssertionError: Sequential scan with filters is not supported (if you just created an index, you need to wait for the creation to be
propagated to all nodes before querying it)
        at org.apache.cassandra.db.filter.ExtendedFilter$WithClauses.getExtraFilter(ExtendedFilter.java:280) ~[apache-cassandra-2.1.12.jar:2.1.
12]
        at org.apache.cassandra.db.ColumnFamilyStore.getRangeSlice(ColumnFamilyStore.java:2189) ~[apache-cassandra-2.1.12.jar:2.1.12]
        at org.apache.cassandra.service.StorageProxy$LocalRangeSliceRunnable.runMayThrow(StorageProxy.java:1522) ~[apache-cassandra-2.1.12.jar:
2.1.12] at org.apache.cassandra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:2197) ~[apache-cassandra-2.1.12.jar:2.1.12]
        at org.apache.cassandra.concurrent.AbstractTracingAwareExecutorService$FutureTask.run(AbstractTracingAwareExecutorService.java:164) ~[a
pache-caat org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105) [apache-cassandra-2.1.12.jar:2.1.12]
        at java.lang.Thread.run(Thread.java:745) [na:1.7.0_91]
WARN  [SharedPool-Worker-1] 2016-01-27 05:15:57,642 AbstractTracingAwareExecutorService.java:169 - Uncaught exception on thread Thread[SharedPo
ol-Worker-1,5,main]: {}
java.lang.AssertionError: Sequential scan with filters is not supported (if you just created an index, you need to wait for the creation to be
propagated to all nodes before querying it)
        at org.apache.cassandra.db.filter.ExtendedFilter$WithClauses.getExtraFilter(ExtendedFilter.java:280) ~[apache-cassandra-2.1.12.jar:2.1.
12]
        at org.apache.cassandra.db.ColumnFamilyStore.getRangeSlice(ColumnFamilyStore.java:2189) ~[apache-cassandra-2.1.12.jar:2.1.12]
        at org.apache.cassandra.service.StorageProxy$LocalRangeSliceRunnable.runMayThrow(StorageProxy.java:1522) ~[apache-cassandra-2.1.12.jar:
2.1.12]
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) ~[na:1.7.0_91]) ~[apache-cassandra-2.1.12.jar:2.1.12]
        at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105) [apache-cassandra-2.1.12.jar:2.1.12]eExecutorService.java:164) ~[a
pache-caat java.lang.Thread.run(Thread.java:745) [na:1.7.0_91]

                        <dependency>
                <groupId>org.hectorclient</groupId>
                <artifactId>hector-core</artifactId>
                <version>1.1-4</version>
            </dependency>
            <dependency>
                <groupId>org.hectorclient</groupId>
                <artifactId>hector-object-mapper</artifactId>
                <version>3.1-09</version>
            </dependency>