[RQG] Memory optimized indexes created WITH { "defer_build":true } not being dropped after the bucket is deleted

The cluster only has 1 node which has all 3 services on it:kv,indexer,n1ql.

Ran a rqg job which creates more than 1000 memory-optimized indexes with defer_build=True.

Example create index statement:

 CREATE INDEX simple_table_where_based_fields_occur_6012 ON simple_table_db_9643_simple_table( int_field1 ) WHERE   int_field1 < 4939      USING GSI WITH {'defer_build': 'true'}

The job finished and deleted the bucket simple_table_db_9643_simple_table.

The indexes were in pending state when the job finished.

But:

select * from system:indexes shows 0 index.

Now if I create a new bucket with 10 docs on the same node and tried creating primary index on it,I get the following error message:

 "msg": "GSI CreatePrimaryIndex() - cause: Request timed out. Index server may still be processing this request. Please check the status after sometime or retry."

I waited for the indexes to go for pending to created state.

Still:

select * from system:indexes shows 0 index.

stats show:

{

index_not_found_errcount: 0,

indexer_state: "Active",

memory_quota: 5364514816,

memory_used: 521123840,

memory_used_queue: 0,

memory_used_storage: 1048576,

needs_restart: false,

num_connections: 9,

storage_mode: "memory_optimized",

timings/stats_response: "8032 1250585881900 -5167687647310006112",

uptime: "4h31m11.763597693s"

}

http://172.23.107.165:9102/getindexStatus

404 page not found

I changed the indexer log level to debug and tried creating primary index on the new bucket with 10 docs:

create primary index on multiple_table_db_4060_simple_table_1;

[

  {

    "code": 5000,

    "msg": "GSI CreatePrimaryIndex() - cause: Request timed out. Index server may still be processing this request. Please check the status after sometime or retry.",

    "query_from_user": "create primary index on multiple_table_db_4060_simple_table_1;"

  }

]

Attaching logs: