This is the second time it happens, it was solved by re-installing couchbase last time, but I think I need to figure out the reason.
I only use one small bucket for testing (less than 500 documents), so I don’t think this is related to ram/disk usage. It worked fine until a point when all queries fail to return anything(all queries return empty)
select MYBUCKET.* from MYBUCKET where someBool == false order by date desc
delete from MYBUCKET
does not do anything at all, even the delete query won’t delete anything. Weirdly, no error returned.
I tried to drop the primary index, it shows timeout but actually succeed.
Then I tried to create primary index again, this is the error message i got.
GSI CreatePrimaryIndex() - cause: Encounter errors during create index. Error=Request timed out. Index server may still be processing this request. Please check the status after sometime or retry. .
Is there any log or anything I should provide to help with debugging?
The queries are executed in admin page(
Using C# SDK to execute the query also result in the same.
Restarting does not solve the problem.