Error while using secondary index to filter the records

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)

Client Version : 4.0.6 Server : 3.15

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

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

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.

© 2015 Copyright Aerospike, Inc. | All rights reserved. Creators of the Aerospike Database.