Hi,
I have noticed that whenever i add/remove nodes from my cluster, secondary index query returns empty result for some records even after migration completes. However they can be successfully retrieved using PK. I am using version 3.8.1 with RAM+HDD model. Currently i have to drop and create each secondary index manually every time. Is there better solution available for this?
Using AQL, see if all secondary indexes are ready after you add a node, before you run the query. Should be in R/W state. aql>show indexes
Also see Aerospike Server CE Release Note | Download | Aerospike looks like some bugs related to Secondary Indexes were fixed in later releases.
it’s already in RW state as migration completed long ago but query still returns missing results.
Did you look through the bug fixes in the release notes? Perhaps test with a later version of the server? Set up a small test cluster…