Indexer crashes and restarts frequently on 7.2 Community Edition

Couchbase Server
1

Indexer keeps crashing on our single node cluster with the following error message:

[ERRO][FDB] Error in reading the doc length metadata with offset 3539923261291652896 from a database file ‘/opt/couchbase/var/lib/couchbase/data/@2i/MyBucket_MyIndex_2473012883606259537_0.index/data.fdb.3’
[ERRO][FDB] docio_read_doc_key error: read failure on offset 3539923261291652896 in a database file ‘/opt/couchbase/var/lib/couchbase/data/@2i/MyBucket_MyIndex_2473012883606259537_0.index/data.fdb.3’ : FDB status -5, lastbid 0xffffffffffffffff, curblock 0xffffffffffffffff, curpos 0x0

There are about 800+ indexes and it takes a while for these indexes to warm up. We’re clueless as to why the indexer is crashing, please help

2

It sounds like that index is corrupt. Can you try moving that directory elsewhere (to /opt/couchbase/var/lib/couchbase would work), and then restarting couchbase? The index should be re-created on startup.