Error while using secondary index to filter the records


#1

com.aerospike.client.AerospikeException: Error Code 204: Index error at com.aerospike.client.command.MultiCommand.parseGroup(MultiCommand.java:89) at com.aerospike.client.command.MultiCommand.parseResult(MultiCommand.java:64) at com.aerospike.client.command.SyncCommand.execute(SyncCommand.java:82) at com.aerospike.client.query.QueryExecutor$QueryThread.run(QueryExecutor.java:141) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745)


#2

Client Version : 4.0.6 Server : 3.15

With out filter it works perfectly and from aql also it works perfectly with filters.


#3

You will need to look at the server logs for why this generic secondary index error occurred.


#4

It took almost two days to notice that error was not related to index instead it was because of passing null bin name in lists of bin names for projection. But i don’t understand why it was throwing index error it should provide error code or msg related to invalid bin names.