Error in indexer and index not compact

Couchbase Server
1

Hi all ,

we have a cluster with 2 nodes index . In one of then we have a index that does not compressed :
Name : ### indexcard-DATE-2
Disk Size : 433 GB
Data Size ; 107 GB
Fragmentation : 75%

The size of the FS where the index are created is :
Filesystem Size Used Avail Use% Mounted on
/dev/sdc1 1.9T 686G 1.1T 39% /couchbase/disk1

I thnk there is enough space to compress the index .

Compression options for index :
Index Fragmentation
Write Mode: Circular Write Mode with time interval for when compaction is allowed to run
A ll days between 00:00 abd 23:59
Abort compaction if run time exceeds the set time interval

The indexer.log show the next errors related to the index

[root@sprocbi2 logs]# grep -i “indexcard-DATE-2” indexer.log.1
[FDB INFO] Forestdb opened database file /couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.455
[FDB ERR] Read error: read offset 235141020435845120 exceeds the file’s current offset 463582072832 in a database file ‘/couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.454’
[FDB INFO] Forestdb opened database file /couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.454
[FDB ERR] Crash Detected: Last Block not DBHEADER dd in a database file ‘/couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.455’
[FDB INFO] Forestdb opened database file /couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.455
[FDB INFO] Forestdb closed database file /couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.455
[FDB INFO] Forestdb opened database file /couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.455
[FDB INFO] Forestdb closed database file /couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.455
[FDB INFO] Forestdb opened database file /couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.455
[FDB INFO] Forestdb closed database file /couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.455
[FDB INFO] Forestdb opened database file /couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.455
[FDB INFO] Forestdb closed database file /couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.455
[FDB INFO] Forestdb opened database file /couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.455
[FDB INFO] Forestdb closed database file /couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.455
[FDB INFO] Forestdb opened database file /couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.455
[FDB ERR] Read error: read offset 235141020435845120 exceeds the file’s current offset 464727162880 in a database file ‘/couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.454’
[FDB INFO] Forestdb opened database file /couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.454
[FDB ERR] Crash Detected: Last Block not DBHEADER dd in a database file ‘/couchbase/disk1/index/@2i/evoapi_indexcard-Date-2_9429172763969244344_0.index/data.fdb.455’

Could somebody helps me to explain why the indexer does not compact the index ?

Many thanks in advance !!!

2

Hi @oramospato , Can you please let us know which version of Couchbase server you are using?

3

Hi … sorry … I’d forgottten to say the version . It’s 4.6.2

Thanks -!!

4

There were a few issues addressed in this area (block reuse, compaction) in newer versions. Please upgrade to a newer version and see if the issue occurs. Thanks.

5

I , we have a Project to upgrade the cluster, but now we can not address this task.

I other node we had the same problema and we solve it givind 4 times the total volumen of all indexes , but it hav not sense .

Thanks