Service 'indexer' exited with status -107374079

Community
1

Hi, I’m using Community Edition 5.0.1 build 5003

Yesterday April 2, we had problems with the index in question:

CREATE INDEX GLOBAL_TYPE_INDEX ONdefault (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 …

workbench
workbench.PNG918×733 95.6 KB

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?

Thanks

2

From the error it looks like the index GLOBAL_TYPE_INDEX has issues. You can drop the index GLOBAL_TYPE_INDEX as you have created another equivalent index and try your query.

3

For the forestdb assertion, the vulcan branch has a fix to mitigate the issue (MB-28014).