Hi, I’m using Community Edition 5.0.1 build 5003
Yesterday April 2, we had problems with the index in question:
Type) WHERE (
Type is not missing)
I rebooted the couchbase and nothing, restart the server and nothing too. In the Indexer.log "2019-04-02T02: 43: 21.912-03: 00 [ERROR] [FDB] doc_length body checksum mismatch error in a database file 'd: \ Couchbase \ Server \ var \ lib \ couchbase \ data \ @ 2i \ default_GLOBAL_TYPE_INDEX_16084542446045325639_0.index \ data.fdb.226 'crc 7b! = 31 (crc in doc) keylen 13367 metalen 12337 bodylen 875637814 bodylen_ondisk 859060022 offset 5534794243
2019-04-02T02: 43: 21.913-03: 00 [ERROR] [FDB] Error in reading a stale region info document from a database file 'd: \ Couchbase \ Server \ var \ lib \ couchbase \ data \ @ 2i \ default_GLOBAL_TYPE_INDEX_16084542446045325639_0.index \ data.fdb.226 ': revnum 93517, offset 5534794243 "
I recreated the index with another name (GLOBAL_TYPE_INDEX2) and it worked, but when the database came back it marked several records as _deleted and some records I am not able to do query by conditions, only with ID. In the logs of yesterday and today the workbench is presented to me a few times, in times of seconds …
And another, several times I query a document that has 96,000 records, sometimes it returns 30,000 others 40,000 and sometimes 100. I have to make 5 to 6 queries, until I return all the data.
Can someone help me how to solve this issue?