Lost indexes spontaneously

4 days ago, When I was on a vacation, My service goes down and I get No index available on keyspace myapp that matches your query. Use CREATE INDEX or CREATE PRIMARY INDEX to create an index, or check that your expected index is online. error in couchbase

I have 3 nodes and 1 replicate for each index, I checked that there is no hardware and network failure in the system and all 3 nodes are UP and operating, I checked Indexes page of Couchbase admin panel and figured out

  1. In the first bucket all indexes lost and dropped (No body dropped indexes it’s dropped spontaneously)
  2. In the second bucket 3 of 6 indexes lost and dropped spontaneously
  3. In the third bucket all indexes exists and noting is wrong

Is there any known issue causes index lost? We have no hardware and network failure and no software update and changes, I am using Community Edition 6.6.0 build 7909

@socketman2016 , the only time index service can cleanup an index on its own is it detects a storage corruption. In that case, you should see messages like “Detected storage corruption for index [xxx], partition id [xxx]. Starting cleanup.” in the UI->Logs.

1 Like

I have no Detected storage corruption in logs

  1. What is a a storage corruption? is it a hardware failure?
  2. I have Deleting old data files of bucket "xxx" log, What is it?
  3. I have many of this log too
Client-side error-report for user "root" on node 'ns_1@xxx.xxx.xxx.xxx':
User-Agent:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36
Got unhandled javascript error:
name: TypeError;
message: Cannot read property 'trim' of undefined;
stack: TypeError: Cannot read property 'trim' of undefined
at canCreateBlankQuery (http://xxx.xxx.xxx.xxx:8091/_p/ui/query/qw_query_service.js:775:35)
at queryController.hasNextResult [as hasNext] (http://xxx.xxx.xxx.xxx:8091/_p/ui/query/qw_query_service.js:784:7)
at fn0 (eval at compile (http://xxx.xxx.xxx.xxx:8091/ui/libs/angular.js:1:1), <anonymous>:4:349)
at expressionInputWatch (http://xxx.xxx.xxx.xxx:8091/ui/libs/angular.js:16669:31)
at Scope.$digest (http://xxx.xxx.xxx.xxx:8091/ui/libs/angular.js:18372:34)
at Scope.$apply (http:/xxx.xxx.xxx.xxx:8091/ui/libs/angular.js:18649:24)
at http://xxx.xxx.xxx.xxx:8091/ui/libs/angular.js:20574:36
at completeOutstandingRequest (http://xxx.xxx.xxx.xxx:8091/ui/libs/angular.js:6428:10)
at http://xxx.xxx.xxx.xxx:8091/ui/libs/angular.js:6707:7;