Secondary index missing records after migration (add/remove node)

secondary
index

#1

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?


#2

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 http://www.aerospike.com/download/server/notes.html looks like some bugs related to Secondary Indexes were fixed in later releases.


#3

it’s already in RW state as migration completed long ago but query still returns missing results.


#4

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…