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
In the first bucket all indexes lost and dropped (No body dropped indexes it’s dropped spontaneously)
In the second bucket 3 of 6 indexes lost and dropped spontaneously
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.
What is a a storage corruption? is it a hardware failure?
I have Deleting old data files of bucket "xxx" log, What is it?
I have many of this log too
Client-side error-report for user "root" on node 'firstname.lastname@example.org':
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
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 completeOutstandingRequest (http://xxx.xxx.xxx.xxx:8091/ui/libs/angular.js:6428:10)