I experienced an odd case that an index just disappeared. The server version is “Aerospike Community Edition build 3.3.21”
My first guess is I may have carelessly dropped an index. as create or drop index are logged similar to the following lines:
Nov 22 2014 08:01:42 GMT: INFO (info): (thr_info.c::6110) Index creation request received for NAMESPACE:INDEX via SMD Nov 22 2014 09:09:54 GMT: INFO (info): (thr_info.c::6188) Index deletion request received for NAMESPACE:INDEX via SMD
every log archive file are verified iteratively, and there is only one index creation 2 weeks ago and no index deletion.
The system has only 1 index, and the index was not used every day so all I can tell is it does exist a few days ago but suddenly disappeared. And the most likely relevant cause is I restarted the Aerospike instance 4 times to test a monitoring system yesterday. For the last restart, the log indicates it doesn’t scan every record to build index.
Any idea why an index will be dropped without a line of log? or is there any case a server restart will cause an index be dropped?