An index creation got stuck

Couchbase Server
2

@petojurkovic, It appears you are running into a crash due to sizing issue as reported in Loading....

You can try changing the setting “max_array_seckey_size” to overcome the crash:

  1. Calculate the setting value:
    If the index definition is: create index idx on bucket( a, distinct (array (x.y) for x in b end) , c )
    then max_array_seckey_size = ( size ( a ) + size ( y ) + size ( c ) ) * (num of elements in b array)
    Here all sizes are in bytes. The default value is 10240 bytes (ie 10 KB).

  2. Apply the new setting:
    curl -X POST -u user:pass http://:9102/settings --data ‘{“indexer.settings.max_array_seckey_size”: size_in_bytes}’

1 Like