Querying not working anymore

Hi guys,
so today my service was working, and today is not working anymore.
If I try to query anything, the result is always null. I changed anything since yesterday, so I can’t explain why it’s not working.

Query example:

EXPLAIN SELECT cityname 
FROM unibo_international    
WHERE cityname = 'Kabul'

[
  {
    "plan": {
      "#operator": "Sequence",
      "~children": [
        {
          "#operator": "IndexScan",
          "covers": [
            "cover ((`unibo_international`.`cityname`))",
            "cover ((`unibo_international`.`countryname`))",
            "cover ((meta(`unibo_international`).`id`))"
          ],
          "index": "idx_cityname_countryname",
          "index_id": "e0cc44b3419b750",
          "keyspace": "unibo_international",
          "namespace": "default",
          "spans": [
            {
              "Exact": true,
              "Range": {
                "High": [
                  "successor(\"Kabul\")"
                ],
                "Inclusion": 1,
                "Low": [
                  "\"Kabul\""
                ]
              }
            }
          ],
          "using": "gsi"
        },
        {
          "#operator": "Parallel",
          "~child": {
            "#operator": "Sequence",
            "~children": [
              {
                "#operator": "Filter",
                "condition": "(cover ((`unibo_international`.`cityname`)) = \"Kabul\")"
              },
              {
                "#operator": "InitialProject",
                "result_terms": [
                  {
                    "expr": "cover ((`unibo_international`.`cityname`))"
                  }
                ]
              },
              {
                "#operator": "FinalProject"
              }
            ]
          }
        }
      ]
    },
    "text": "SELECT cityname \nFROM unibo_international    \nWHERE cityname = 'Kabul'"
  }
]


{
<other data...>
  "cityname": "Kabul",
  "countryname": "Afghanistan",
  "lat": "34.5553494",
  "lon": "69.207486"
}

It is covered query should have worked. Check the query.log and indexer.log. @deepkaran.salooja

SELECT MTEA().id, cityname FROM unibo_international WHERE cityname = ‘Kabul’;
Use the Id value and
SELECT * FROM unibo_international [id value from above] WHERE cityname = ‘Kabul’;;

The SELECT META().id cityname FROM unibo_international WHERE cityname = ‘Kabul’; query doesn’t work either, such as every other query.

What should I look for into the query and indexers logs? Both of them don’t update when i execute a query.

You should look for errors. Try the following

  1. SELECT MTEA().id, cityname FROM unibo_international WHERE cityname IS NOT NULL;
  2. Look for some documentKey from UI and try this
    SELECT * FROM unibo_international USE KEYS [ documet key ];

As Explain works and query returns seems query service fine. As it uses covered index we may not have got qualify documents from indexer.

The second query works.
I found this error from today while watching the query log

_time=2017-07-14T12:48:41.642+02:00 _level=WARN _msg=Error loading indexes for keyspace unibo_international, Error Failed to load indexes Keyspace unibo_international - cause: All nodes failed to respond or no healthy nodes for bucket found

and probably it’s from the time I restarted the server (from command line using “net start Couchbase Server”)

Also this one in inxeder log is weird 2017-07-14T16:25:18.978+02:00 [Error] updateIndexerList(): Cannot locate cluster node.

I’ve just tried to create a new bucket adding just the “Kabul” document, and querying there works fine, so I guess it’s something it has to do just with unibo_international bucket

Second query directly fetches data from data node without using index. cc . @deepkaran.salooja

@cecca_92, the indexer.log errors you mentioned are intermittent errors which can happen when you restart the couchbase service and should resolve on their own.

You can look up the UI Statistics mini-graphs for the index in question and see if there are any pending items. Also make sure the number of indexed items matches the expected number.

Also, you can change the index service log level from the UI -> Settings to “Verbose” and run your query again. indexer.log will then have the details of the query and how many rows it is fetching.

Hi, thanks for the answer.
I’ve just tried to execute the following query:

SELECT * FROM unibo_international WHERE cityname = 'Kabul'

The result is still empty, the explain is the following:

[
  {
    "plan": {
      "#operator": "Sequence",
      "~children": [
        {
          "#operator": "IndexScan",
          "index": "idx_cityname_countryname",
          "index_id": "e0cc44b3419b750",
          "keyspace": "unibo_international",
          "namespace": "default",
          "spans": [
            {
              "Exact": true,
              "Range": {
                "High": [
                  "successor(\"Kabul\")"
                ],
                "Inclusion": 1,
                "Low": [
                  "\"Kabul\""
                ]
              }
            }
          ],
          "using": "gsi"
        },
        {
          "#operator": "Fetch",
          "keyspace": "unibo_international",
          "namespace": "default"
        },
        {
          "#operator": "Parallel",
          "~child": {
            "#operator": "Sequence",
            "~children": [
              {
                "#operator": "Filter",
                "condition": "((`unibo_international`.`cityname`) = \"Kabul\")"
              },
              {
                "#operator": "InitialProject",
                "result_terms": [
                  {
                    "expr": "self",
                    "star": true
                  }
                ]
              },
              {
                "#operator": "FinalProject"
              }
            ]
          }
        }
      ]
    },
    "text": "SELECT * FROM unibo_international USE INDEX (idx_cityname_countryname USING GSI) WHERE cityname = 'Kabul'"
  }
]

Indexer.log with verbose rows are the following:

017-07-15T00:41:43.477+02:00 [Info] Indexer::ReadMemstats Time Taken 1.001ms
2017-07-15T00:41:53.477+02:00 [Info] Indexer::ReadMemstats Time Taken 0
2017-07-15T00:41:57.949+02:00 [Verbose] SCAN##35 REQUEST defnId:1012399843527210832, index:unibo_international/idx_cityname_countryname, type:scan, span:range (["Kabul"],["Kabul "] incl:low), limit:9223372036854775807, consistency:any_consistency, requestId:a73135fc-de4e-438d-b609-cee20a3163ce
2017-07-15T00:41:57.960+02:00 [Verbose] SCAN##35 requested timestamp: any_consistency => [] Crc64 => 0
2017-07-15T00:41:57.964+02:00 [Verbose] SCAN##35 snapshot timestamp: [0=0,1=0,2=0,3=0,4=0,5=0,6=0,7=0,8=0,9=0,10=0,11=0,12=0,13=0,14=0,15=0,16=0,17=0,18=0,19=0,20=0,21=0,22=0,23=0,24=0,25=0,26=0,27=0,28=0,29=0,30=0,31=0,32=0,33=0,34=0,35=0,36=0,37=0,38=0,39=0,40=0,41=0,42=0,43=0,44=0,45=0,46=0,47=0,48=0,49=0,50=0,51=0,52=0,53=0,54=0,55=0,56=0,57=0,58=0,59=0,60=0,61=0,62=0,63=0,64=0,65=0,66=0,67=0,68=0,69=0,70=0,71=0,72=0,73=0,74=0,75=0,76=0,77=0,78=0,79=0,80=0,81=0,82=0,83=0,84=0,85=0,86=0,87=0,88=0,89=0,90=0,91=0,92=0,93=0,94=0,95=0,96=0,97=0,98=0,99=0,100=0,101=0,102=0,103=0,104=0,105=0,106=0,107=0,108=0,109=0,110=0,111=0,112=0,113=0,114=0,115=0,116=0,117=0,118=0,119=0,120=0,121=0,122=0,123=0,124=0,125=0,126=0,127=0,128=0,129=0,130=0,131=0,132=0,133=0,134=0,135=0,136=0,137=0,138=0,139=0,140=0,141=0,142=0,143=0,144=0,145=0,146=0,147=0,148=0,149=0,150=0,151=0,152=0,153=0,154=0,155=0,156=0,157=0,158=0,159=0,160=0,161=0,162=0,163=0,164=0,165=0,166=0,167=0,168=0,169=0,170=0,171=0,172=0,173=0,174=0,175=0,176=0,177=0,178=0,179=0,180=0,181=0,182=0,183=0,184=0,185=0,186=0,187=0,188=0,189=0,190=0,191=0,192=0,193=0,194=0,195=0,196=0,197=0,198=0,199=0,200=0,201=0,202=0,203=0,204=0,205=0,206=0,207=0,208=0,209=0,210=0,211=0,212=0,213=0,214=0,215=0,216=0,217=0,218=0,219=0,220=0,221=0,222=0,223=0,224=0,225=0,226=0,227=0,228=0,229=0,230=0,231=0,232=0,233=0,234=0,235=0,236=0,237=0,238=0,239=0,240=0,241=0,242=0,243=0,244=0,245=0,246=0,247=0,248=0,249=0,250=0,251=0,252=0,253=0,254=0,255=0,256=0,257=0,258=0,259=0,260=0,261=0,262=0,263=0,264=0,265=0,266=0,267=0,268=0,269=0,270=0,271=0,272=0,273=0,274=0,275=0,276=0,277=0,278=0,279=0,280=0,281=0,282=0,283=0,284=0,285=0,286=0,287=0,288=0,289=0,290=0,291=0,292=0,293=0,294=0,295=0,296=0,297=0,298=0,299=0,300=0,301=0,302=0,303=0,304=0,305=0,306=0,307=0,308=0,309=0,310=0,311=0,312=0,313=0,314=0,315=0,316=0,317=0,318=0,319=0,320=0,321=0,322=0,323=0,324=0,325=0,326=0,327=0,328=0,329=0,330=0,331=0,332=0,333=0,334=0,335=0,336=0,337=0,338=0,339=0,340=0,341=0,342=0,343=0,344=0,345=0,346=0,347=0,348=0,349=0,350=0,351=0,352=0,353=0,354=0,355=0,356=0,357=0,358=0,359=0,360=0,361=0,362=0,363=0,364=0,365=0,366=0,367=0,368=0,369=0,370=0,371=0,372=0,373=0,374=0,375=0,376=0,377=0,378=0,379=0,380=0,381=0,382=0,383=0,384=0,385=0,386=0,387=0,388=0,389=0,390=0,391=0,392=0,393=0,394=0,395=0,396=0,397=0,398=0,399=0,400=0,401=0,402=0,403=0,404=0,405=0,406=0,407=0,408=0,409=0,410=0,411=0,412=0,413=0,414=0,415=0,416=0,417=0,418=0,419=0,420=0,421=0,422=0,423=0,424=0,425=0,426=0,427=0,428=0,429=0,430=0,431=0,432=0,433=0,434=0,435=0,436=0,437=0,438=0,439=0,440=0,441=0,442=0,443=0,444=0,445=0,446=0,447=0,448=0,449=0,450=0,451=0,452=0,453=0,454=0,455=0,456=0,457=0,458=0,459=0,460=0,461=0,462=0,463=0,464=0,465=0,466=0,467=0,468=0,469=0,470=0,471=0,472=0,473=0,474=0,475=0,476=0,477=0,478=0,479=0,480=0,481=0,482=0,483=0,484=0,485=0,486=0,487=0,488=0,489=0,490=0,491=0,492=0,493=0,494=0,495=0,496=0,497=0,498=0,499=0,500=0,501=0,502=0,503=0,504=0,505=0,506=0,507=0,508=0,509=0,510=0,511=0,512=0,513=0,514=0,515=0,516=0,517=0,518=0,519=0,520=0,521=0,522=0,523=0,524=0,525=0,526=0,527=0,528=0,529=0,530=0,531=0,532=0,533=0,534=0,535=0,536=0,537=0,538=0,539=0,540=0,541=0,542=0,543=0,544=0,545=0,546=0,547=0,548=0,549=0,550=0,551=0,552=0,553=0,554=0,555=0,556=0,557=0,558=0,559=0,560=0,561=0,562=0,563=0,564=0,565=0,566=0,567=0,568=0,569=0,570=0,571=0,572=0,573=0,574=0,575=0,576=0,577=0,578=0,579=0,580=0,581=0,582=0,583=0,584=0,585=0,586=0,587=0,588=0,589=0,590=0,591=0,592=0,593=0,594=0,595=0,596=0,597=0,598=0,599=0,600=0,601=0,602=0,603=0,604=0,605=0,606=0,607=0,608=0,609=0,610=0,611=0,612=0,613=0,614=0,615=0,616=0,617=0,618=0,619=0,620=0,621=0,622=0,623=0,624=0,625=0,626=0,627=0,628=0,629=0,630=0,631=0,632=0,633=0,634=0,635=0,636=0,637=0,638=0,639=0,640=0,641=0,642=0,643=0,644=0,645=0,646=0,647=0,648=0,649=0,650=0,651=0,652=0,653=0,654=0,655=0,656=0,657=0,658=0,659=0,660=0,661=0,662=0,663=0,664=0,665=0,666=0,667=0,668=0,669=0,670=0,671=0,672=0,673=0,674=0,675=0,676=0,677=0,678=0,679=0,680=0,681=0,682=0,683=0,684=0,685=0,686=0,687=0,688=0,689=0,690=0,691=0,692=0,693=0,694=0,695=0,696=0,697=0,698=0,699=0,700=0,701=0,702=0,703=0,704=0,705=0,706=0,707=0,708=0,709=0,710=0,711=0,712=0,713=0,714=0,715=0,716=0,717=0,718=0,719=0,720=0,721=0,722=0,723=0,724=0,725=0,726=0,727=0,728=0,729=0,730=0,731=0,732=0,733=0,734=0,735=0,736=0,737=0,738=0,739=0,740=0,741=0,742=0,743=0,744=0,745=0,746=0,747=0,748=0,749=0,750=0,751=0,752=0,753=0,754=0,755=0,756=0,757=0,758=0,759=0,760=0,761=0,762=0,763=0,764=0,765=0,766=0,767=0,768=0,769=0,770=0,771=0,772=0,773=0,774=0,775=0,776=0,777=0,778=0,779=0,780=0,781=0,782=0,783=0,784=0,785=0,786=0,787=0,788=0,789=0,790=0,791=0,792=0,793=0,794=0,795=0,796=0,797=0,798=0,799=0,800=0,801=0,802=0,803=0,804=0,805=0,806=0,807=0,808=0,809=0,810=0,811=0,812=0,813=0,814=0,815=0,816=0,817=0,818=0,819=0,820=0,821=0,822=0,823=0,824=0,825=0,826=0,827=0,828=0,829=0,830=0,831=0,832=0,833=0,834=0,835=0,836=0,837=0,838=0,839=0,840=0,841=0,842=0,843=0,844=0,845=0,846=0,847=0,848=0,849=0,850=0,851=0,852=0,853=0,854=0,855=0,856=0,857=0,858=0,859=0,860=0,861=0,862=0,863=0,864=0,865=0,866=0,867=0,868=0,869=0,870=0,871=0,872=0,873=0,874=0,875=0,876=0,877=0,878=0,879=0,880=0,881=0,882=0,883=0,884=0,885=0,886=0,887=0,888=0,889=0,890=0,891=0,892=0,893=0,894=0,895=0,896=0,897=0,898=0,899=0,900=0,901=0,902=0,903=0,904=0,905=0,906=0,907=0,908=0,909=0,910=0,911=0,912=0,913=0,914=0,915=0,916=0,917=0,918=0,919=0,920=0,921=0,922=0,923=0,924=0,925=0,926=0,927=0,928=0,929=0,930=0,931=0,932=0,933=0,934=0,935=0,936=0,937=0,938=0,939=0,940=0,941=0,942=0,943=0,944=0,945=0,946=0,947=0,948=0,949=0,950=0,951=0,952=0,953=0,954=0,955=0,956=0,957=0,958=0,959=0,960=0,961=0,962=0,963=0,964=0,965=0,966=0,967=0,968=0,969=0,970=0,971=0,972=0,973=0,974=0,975=0,976=0,977=0,978=0,979=0,980=0,981=0,982=0,983=0,984=0,985=0,986=0,987=0,988=0,989=0,990=0,991=0,992=0,993=0,994=0,995=0,996=0,997=0,998=0,999=0,1000=0,1001=0,1002=0,1003=0,1004=0,1005=0,1006=0,1007=0,1008=0,1009=0,1010=0,1011=0,1012=0,1013=0,1014=0,1015=0,1016=0,1017=0,1018=0,1019=0,1020=0,1021=0,1022=0,1023=0]
2017-07-15T00:41:57.964+02:00 [Verbose] SCAN##35 RESPONSE rows:0, waitTime:4.002ms, totalTime:4.002ms, status:ok

The real problem is that there are 0 total indexed items (from the UI mini-graph), and that’s the same for every single index. I’ll try to recreate every of them now, but I would like to know: how could that be possibile?

Ok, to recreate the indexes is the solution, but I’m still upset. I’m afraid that something like that could happen tomorrow, or later in the future.

@cecca_92, can you share the Couchbase Server version you are working with?

If you still have the setup, you can collect the logs from UI->Logs and share with us. We can take a look into what went wrong. We have not seen similar issue with any production environment so far.

Hi deepkaran.salooja, the version of Couchbase I’m using is Couchbase Server 4.6.2.

The log about that day is the one below. Troubles started at around 12:00 PM.

Bucket "unibo_international" loaded on node 'ns_1@127.0.0.1' in 0 seconds.	ns_memcached 000	ns_1@127.0.0.1	12:48:44 PM Fri Jul 14, 2017
Compactor for view `unibo_international/_design/dev_branches` (pid [{type,
                                                                     view},
                                                                    {name,
                                                                     <<"unibo_international/_design/dev_branches">>},
                                                                    {important,
                                                                     false},
                                                                    {fa,
                                                                     {#Fun<compaction_new_daemon.25.102846360>,
                                                                      [<<"unibo_international">>,
                                                                       <<"_design/dev_branches">>,
                                                                       {config,
                                      ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:48:39 PM Fri Jul 14, 2017
Compactor for view `mapreduce_view/unibo_international/_design/dev_branches/main` (pid [{type,
                                                                                         view},
                                                                                        {important,
                                                                                         true},
                                                                                        {name,
                                                                                         <<"mapreduce_view/unibo_international/_design/dev_branches/main">>},
                                                                                        {fa,
                                                                                         {#Fun<compaction_new_daemon.23.102846360>,
                                                                                          [<<"unibo_international">>,
                  ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:48:39 PM Fri Jul 14, 2017
I'm the only node, so I'm the master.	mb_master 000	ns_1@127.0.0.1	12:48:39 PM Fri Jul 14, 2017
Couchbase Server has started on web port 8091 on node 'ns_1@127.0.0.1'. Version: "4.6.2-3905-enterprise".	menelaus_sup 001	ns_1@127.0.0.1	12:48:37 PM Fri Jul 14, 2017
Node 'ns_1@127.0.0.1' synchronized otp cookie {sanitized,
                                               <<"/5fzk3LFUIm1lOmBbiDEIxi+bm4h20/ll5lfFpEmdSA=">>} from cluster	ns_cookie_manager 002	ns_1@127.0.0.1	12:48:37 PM Fri Jul 14, 2017
Control connection to memcached on 'ns_1@127.0.0.1' disconnected: {badmatch,
                                                                   {error,
                                                                    einval}}	ns_memcached 000	ns_1@127.0.0.1	12:48:11 PM Fri Jul 14, 2017
Bucket "unibo_international" loaded on node 'ns_1@127.0.0.1' in 1 seconds.	ns_memcached 000	ns_1@127.0.0.1	12:48:09 PM Fri Jul 14, 2017
Shutting down bucket "unibo_international" on 'ns_1@127.0.0.1' for reconfiguration	ns_memcached 000	ns_1@127.0.0.1	12:48:04 PM Fri Jul 14, 2017
Restarting bucket "unibo_international" due to configuration change	ns_memcached 000	ns_1@127.0.0.1	12:48:04 PM Fri Jul 14, 2017
Bucket priority changed from 8 to 3 for bucket "unibo_international"	ns_memcached 000	ns_1@127.0.0.1	12:48:04 PM Fri Jul 14, 2017
Updated bucket "unibo_international" (of type couchbase) properties:
[{num_replicas,1},
 {ram_quota,4194304000},
 {auth_type,sasl},
 {autocompaction,false},
 {purge_interval,undefined},
 {flush_enabled,false},
 {num_threads,3},
 {eviction_policy,value_only}]	menelaus_web_buckets 000	ns_1@127.0.0.1	12:48:01 PM Fri Jul 14, 2017
Bucket "unibo_international" loaded on node 'ns_1@127.0.0.1' in 1 seconds.	ns_memcached 000	ns_1@127.0.0.1	12:38:04 PM Fri Jul 14, 2017
I'm the only node, so I'm the master.	mb_master 000	ns_1@127.0.0.1	12:37:59 PM Fri Jul 14, 2017
Compactor for view `unibo_international/_design/dev_branches` (pid [{type,
                                                                     view},
                                                                    {name,
                                                                     <<"unibo_international/_design/dev_branches">>},
                                                                    {important,
                                                                     false},
                                                                    {fa,
                                                                     {#Fun<compaction_new_daemon.25.102846360>,
                                                                      [<<"unibo_international">>,
                                                                       <<"_design/dev_branches">>,
                                                                       {config,
                                      ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:37:59 PM Fri Jul 14, 2017
Compactor for view `mapreduce_view/unibo_international/_design/dev_branches/main` (pid [{type,
                                                                                         view},
                                                                                        {important,
                                                                                         true},
                                                                                        {name,
                                                                                         <<"mapreduce_view/unibo_international/_design/dev_branches/main">>},
                                                                                        {fa,
                                                                                         {#Fun<compaction_new_daemon.23.102846360>,
                                                                                          [<<"unibo_international">>,
                  ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:37:59 PM Fri Jul 14, 2017
Couchbase Server has started on web port 8091 on node 'ns_1@127.0.0.1'. Version: "4.6.2-3905-enterprise".	menelaus_sup 001	ns_1@127.0.0.1	12:37:56 PM Fri Jul 14, 2017
Node 'ns_1@127.0.0.1' synchronized otp cookie {sanitized,
                                               <<"/5fzk3LFUIm1lOmBbiDEIxi+bm4h20/ll5lfFpEmdSA=">>} from cluster	ns_cookie_manager 002	ns_1@127.0.0.1	12:37:56 PM Fri Jul 14, 2017
Control connection to memcached on 'ns_1@127.0.0.1' disconnected: {badmatch,
                                                                   {error,
                                                                    einval}}	ns_memcached 000	ns_1@127.0.0.1	12:37:33 PM Fri Jul 14, 2017
Bucket "unibo_international" loaded on node 'ns_1@127.0.0.1' in 5 seconds.	ns_memcached 000	ns_1@127.0.0.1	12:32:23 PM Fri Jul 14, 2017
Compactor for view `unibo_international/_design/dev_branches` (pid [{type,
                                                                     view},
                                                                    {name,
                                                                     <<"unibo_international/_design/dev_branches">>},
                                                                    {important,
                                                                     false},
                                                                    {fa,
                                                                     {#Fun<compaction_new_daemon.25.102846360>,
                                                                      [<<"unibo_international">>,
                                                                       <<"_design/dev_branches">>,
                                                                       {config,
                                      ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:32:16 PM Fri Jul 14, 2017
Compactor for view `mapreduce_view/unibo_international/_design/dev_branches/main` (pid [{type,
                                                                                         view},
                                                                                        {important,
                                                                                         true},
                                                                                        {name,
                                                                                         <<"mapreduce_view/unibo_international/_design/dev_branches/main">>},
                                                                                        {fa,
                                                                                         {#Fun<compaction_new_daemon.23.102846360>,
                                                                                          [<<"unibo_international">>,
                  ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:32:16 PM Fri Jul 14, 2017
Compactor for view `unibo_international/_design/dev_branches` (pid [{type,
                                                                     view},
                                                                    {name,
                                                                     <<"unibo_international/_design/dev_branches">>},
                                                                    {important,
                                                                     false},
                                                                    {fa,
                                                                     {#Fun<compaction_new_daemon.25.102846360>,
                                                                      [<<"unibo_international">>,
                                                                       <<"_design/dev_branches">>,
                                                                       {config,
                                      ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:31:46 PM Fri Jul 14, 2017
Compactor for view `mapreduce_view/unibo_international/_design/dev_branches/main` (pid [{type,
                                                                                         view},
                                                                                        {important,
                                                                                         true},
                                                                                        {name,
                                                                                         <<"mapreduce_view/unibo_international/_design/dev_branches/main">>},
                                                                                        {fa,
                                                                                         {#Fun<compaction_new_daemon.23.102846360>,
                                                                                          [<<"unibo_international">>,
                  ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:31:46 PM Fri Jul 14, 2017
Compactor for view `unibo_international/_design/dev_branches` (pid [{type,
                                                                     view},
                                                                    {name,
                                                                     <<"unibo_international/_design/dev_branches">>},
                                                                    {important,
                                                                     false},
                                                                    {fa,
                                                                     {#Fun<compaction_new_daemon.25.102846360>,
                                                                      [<<"unibo_international">>,
                                                                       <<"_design/dev_branches">>,
                                                                       {config,
                                      ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:31:20 PM Fri Jul 14, 2017
Compactor for view `mapreduce_view/unibo_international/_design/dev_branches/main` (pid [{type,
                                                                                         view},
                                                                                        {important,
                                                                                         true},
                                                                                        {name,
                                                                                         <<"mapreduce_view/unibo_international/_design/dev_branches/main">>},
                                                                                        {fa,
                                                                                         {#Fun<compaction_new_daemon.23.102846360>,
                                                                                          [<<"unibo_international">>,
                  ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:31:20 PM Fri Jul 14, 2017
I'm the only node, so I'm the master.	mb_master 000	ns_1@127.0.0.1	12:31:16 PM Fri Jul 14, 2017
Couchbase Server has started on web port 8091 on node 'ns_1@127.0.0.1'. Version: "4.6.2-3905-enterprise".	menelaus_sup 001	ns_1@127.0.0.1	12:31:07 PM Fri Jul 14, 2017
Node 'ns_1@127.0.0.1' synchronized otp cookie {sanitized,
                                               <<"/5fzk3LFUIm1lOmBbiDEIxi+bm4h20/ll5lfFpEmdSA=">>} from cluster	ns_cookie_manager 002	ns_1@127.0.0.1	12:31:06 PM Fri Jul 14, 2017
Service 'ns_server' exited with status 1. Restarting. Messages:  {init,start_em,1,[{file,"init.erl"},{line,1034}]}]
{"Kernel pid terminated",application_controller,"{application_start_failure,ns_server,{{shutdown,{failed_to_start_child,ns_server_nodes_sup,{shutdown,{failed_to_start_child,wait_for_couchdb_node,{abnormal,1}}}}},{ns_server,start,[normal,[]]}}}"}

Crash dump was written to: erl_crash.dump
Kernel pid terminated (application_controller) ({application_start_failure,ns_server,{{shutdown,{failed_to_start_child,ns_server_nodes_sup,{shutdown,{failed_to_start_child,wait_for_couchdb_node,{abn	ns_log 000	ns_1@127.0.0.1	12:31:04 PM Fri Jul 14, 2017
Bucket "unibo_international" loaded on node 'ns_1@127.0.0.1' in 1 seconds.	ns_memcached 000	ns_1@127.0.0.1	12:22:04 PM Fri Jul 14, 2017
Compactor for view `unibo_international/_design/dev_branches` (pid [{type,
                                                                     view},
                                                                    {name,
                                                                     <<"unibo_international/_design/dev_branches">>},
                                                                    {important,
                                                                     false},
                                                                    {fa,
                                                                     {#Fun<compaction_new_daemon.25.102846360>,
                                                                      [<<"unibo_international">>,
                                                                       <<"_design/dev_branches">>,
                                                                       {config,
                                      ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:21:50 PM Fri Jul 14, 2017
Compactor for view `mapreduce_view/unibo_international/_design/dev_branches/main` (pid [{type,
                                                                                         view},
                                                                                        {important,
                                                                                         true},
                                                                                        {name,
                                                                                         <<"mapreduce_view/unibo_international/_design/dev_branches/main">>},
                                                                                        {fa,
                                                                                         {#Fun<compaction_new_daemon.23.102846360>,
                                                                                          [<<"unibo_international">>,
                  ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:21:50 PM Fri Jul 14, 2017
I'm the only node, so I'm the master.	mb_master 000	ns_1@127.0.0.1	12:21:50 PM Fri Jul 14, 2017
Couchbase Server has started on web port 8091 on node 'ns_1@127.0.0.1'. Version: "4.6.2-3905-enterprise".	menelaus_sup 001	ns_1@127.0.0.1	12:21:47 PM Fri Jul 14, 2017
Node 'ns_1@127.0.0.1' synchronized otp cookie {sanitized,
                                               <<"/5fzk3LFUIm1lOmBbiDEIxi+bm4h20/ll5lfFpEmdSA=">>} from cluster	ns_cookie_manager 002	ns_1@127.0.0.1	12:21:46 PM Fri Jul 14, 2017
Shutting down bucket "unibo_international" on 'ns_1@127.0.0.1' for server shutdown	ns_memcached 000	ns_1@127.0.0.1	12:20:27 PM Fri Jul 14, 2017
Bucket "unibo_international" loaded on node 'ns_1@127.0.0.1' in 4 seconds.	ns_memcached 000	ns_1@127.0.0.1	12:01:28 PM Fri Jul 14, 2017
Compactor for view `unibo_international/_design/dev_branches` (pid [{type,
                                                                     view},
                                                                    {name,
                                                                     <<"unibo_international/_design/dev_branches">>},
                                                                    {important,
                                                                     false},
                                                                    {fa,
                                                                     {#Fun<compaction_new_daemon.25.102846360>,
                                                                      [<<"unibo_international">>,
                                                                       <<"_design/dev_branches">>,
                                                                       {config,
                                      ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:01:24 PM Fri Jul 14, 2017
Compactor for view `mapreduce_view/unibo_international/_design/dev_branches/main` (pid [{type,
                                                                                         view},
                                                                                        {important,
                                                                                         true},
                                                                                        {name,
                                                                                         <<"mapreduce_view/unibo_international/_design/dev_branches/main">>},
                                                                                        {fa,
                                                                                         {#Fun<compaction_new_daemon.23.102846360>,
                                                                                          [<<"unibo_international">>,
                  ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:01:24 PM Fri Jul 14, 2017
Compactor for database `unibo_international` (pid [{type,database},
                                                   {important,true},
                                                   {name,
                                                    <<"unibo_international">>},
                                                   {fa,
                                                    {#Fun<compaction_new_daemon.4.102846360>,
                                                     [<<"unibo_international">>,
                                                      {config,
                                                       {30,undefined},
                                                       {30,undefined},
                                                       undefined,false,false,
                                                       {daemon_config,30,
                                                        131072,20971520}},
                                                      false,
  ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:01:00 PM Fri Jul 14, 2017
I'm the only node, so I'm the master.	mb_master 000	ns_1@127.0.0.1	12:00:55 PM Fri Jul 14, 2017
Compactor for view `unibo_international/_design/dev_branches` (pid [{type,
                                                                     view},
                                                                    {name,
                                                                     <<"unibo_international/_design/dev_branches">>},
                                                                    {important,
                                                                     false},
                                                                    {fa,
                                                                     {#Fun<compaction_new_daemon.25.102846360>,
                                                                      [<<"unibo_international">>,
                                                                       <<"_design/dev_branches">>,
                                                                       {config,
                                      ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:00:55 PM Fri Jul 14, 2017
Compactor for view `mapreduce_view/unibo_international/_design/dev_branches/main` (pid [{type,
                                                                                         view},
                                                                                        {important,
                                                                                         true},
                                                                                        {name,
                                                                                         <<"mapreduce_view/unibo_international/_design/dev_branches/main">>},
                                                                                        {fa,
                                                                                         {#Fun<compaction_new_daemon.23.102846360>,
                                                                                          [<<"unibo_international">>,
                  ... show	compaction_new_daemon 000	ns_1@127.0.0.1	12:00:55 PM Fri Jul 14, 2017
Couchbase Server has started on web port 8091 on node 'ns_1@127.0.0.1'. Version: "4.6.2-3905-enterprise".	menelaus_sup 001	ns_1@127.0.0.1	3:18:46 AM Fri Jul 14, 2017
Node 'ns_1@127.0.0.1' synchronized otp cookie {sanitized,
                                               <<"/5fzk3LFUIm1lOmBbiDEIxi+bm4h20/ll5lfFpEmdSA=">>} from cluster	ns_cookie_manager 002	ns_1@127.0.0.1	3:18:42 AM Fri Jul 14, 2017

@cecca_92, the above errors are from Views based indexes. N1QL query is using GSI indexes in your explain plan. So these errors may not have an impact unless the cluster got into a bad shape due to these errors.

We’ll need to look at the indexer.log to see why the GSI index build was incomplete. In case you are not using these views for a purpose, it would be better to delete them.