Today we maxed out the number of secondary indexes and get the following error using the Java client:
com.aerospike.client.AerospikeException: Error Code 206: Create index failed: FAIL:206:Reached maximum number of sindex allowed
show indexes reveals there is ~1080 indexes
I tried manually deleting them one by one and reduced them to 1020, but we still get the same error. I tried restarting Aerospike and also the web client, but no joy.
How do I fix the error? I take it the limit is 1023 secondary indexes?
Is there a way to drop all secondary indexes in one go?