Unable to Drop Index in Aerospike Community Edition (Version 5.7.0.17)

1

I’m currently facing an issue with dropping an index in Aerospike Community Edition (version 5.7.0.17). Despite successfully creating indexes using the CREATE INDEX command, I encounter a “Namespace Not Found” error when trying to drop an index using the DROP INDEX command.

Details:

  • Aerospike Version: 5.7.0.17
  • Namespace: test
  • Set: newtable1
  • Index Name: age_index

Commands:

  1. Successfully created the index:

CREATE INDEX age_index ON test.newtable1 (aam) NUMERIC

  • Encountering an error when trying to drop the index:

DROP INDEX age_index ON test.newtable1

Error Message:

Error: (4) Namespace Not Found from 127.0.0.1:3000

Additional Information:

  • I have verified the existence of the namespace and set using the SHOW SETS command.
  • The SHOW INDEXES command lists the index correctly.

I have checked the Aerospike documentation and attempted various troubleshooting steps without success. Any insights or suggestions would be greatly appreciated.

Thank you!

2

Try:

DROP INDEX test.newtable1 age_index

1 Like
3

The suggested command to drop the index worked perfectly, and I can confirm that the issue has been resolved.

DROP INDEX test.newtable1 age_index

Thank you for your expertise and support.

1 Like