Drop all secondary indexes

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?

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