Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-13677

Indexing appears to be stuck on creation of a primary view index.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.0.0
    • 4.0.0
    • query
    • Security Level: Public
    • 350-1335-rel
      Centos 6.4
      2 Buckets - Default, Sasl
      45M, 45M items on each bucket
    • Untriaged
    • attached logs from the node.
    • Unknown

    Description

      1. Load 45 M items on default and sasl bucket
      2. Create Primary index on default ( using views) –
      3. Select * from system:indexes – Shows this primary index to be "online" instantaneously ( which is strange)
      4. Incoming sets on the cluster at 10k ops/sec,

      Checked the UI - the primary index appears to be stuck.
      Checked via diag-eval – the index percentage keeps fluctuating between 0-7 percent.

      [root@centos-64-x64 logs]# curl -X POST -u Administrator:password http://127.0.0.1:8091/diag/eval -d 'ns_couchdb_api:get_tasks().' | grep primary -A9 -B2
      % Total % Received % Xferd Average Speed Time Time Time Current
      Dload Upload Total Spent Left Speed
      103 1518 101 1518 0 27 254k 4642 -::- -::- -::- 291k
      [

      {pid,<<"<0.15931.1>">>}

      ,

      {changes_done,900851}

      ,

      {design_documents,[<<"_design/ddl_#primary">>]},
      {indexer_type,main},
      {initial_build,false},
      {progress,5},
      {set,<<"saslbucket">>},
      {signature,<<"420ac07f14bef8f91a3f37c431faf4c8">>},
      {started_on,1425078643},
      {total_changes,17116873},
      {type,indexer},
      {updated_on,1425078766}],
      [{pid,<<"<0.16517.1>">>},
      {changes_done,119729},
      {design_documents,[<<"_design/ddl_#primary">>]}

      ,

      {indexer_type,main}

      ,

      {initial_build,false}

      ,

      {progress,0}

      ,

      {set,<<"default">>}

      ,

      {signature,<<"b73fee1f7677bf77e55b593af5af53b6">>}

      ,

      {started_on,1425078754}

      ,

      {total_changes,19014799}

      ,

      {type,indexer}

      ,

      {updated_on,1425078766}

      ]]

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            ketaki Ketaki Gangal (Inactive)
            ketaki Ketaki Gangal (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty