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

[ui] index total committed items shows up as only 1 , for 100 documents

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.0.0
    • 4.0.0
    • UI
    • Security Level: Public
    • 400-3082
    • Untriaged
    • Unknown

    Description

      1. create bucket default
      2. create primary index using gsi
      3. load 100 doucments on default
      4. Check index stats - something odd about "total committed items" =1 , when I expect this to be actual document number of 100?

      attached screenshot

      Refer below information only for default bucket indexes.

      Ketakis-MacBook-Pro:dev_sabre ketaki$ curl -v -u Administrator:password 10.6.2.164:9102/getIndexStatus | jq '.'

      • About to connect() to 10.6.2.164 port 9102 (#0)
      • Trying 10.6.2.164...
      • Adding handle: conn: 0x7fd54a803a00
      • Adding handle: send: 0
      • Adding handle: recv: 0
      • Curl_addHandleToPipeline: length: 1
      • - Conn 0 (0x7fd54a803a00) send_pipe: 1, recv_pipe: 0
        % Total % Received % Xferd Average Speed Time Time Time Current
        Dload Upload Total Spent Left Speed
        0 0 0 0 0 0 0 0 -::- -::- -::- 0* Connected to 10.6.2.164 (10.6.2.164) port 9102 (#0)
      • Server auth using Basic with user 'Administrator'
        > GET /getIndexStatus HTTP/1.1
        > Authorization: Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==
        > User-Agent: curl/7.30.0
        > Host: 10.6.2.164:9102
        > Accept: /
        >
        < HTTP/1.1 200 OK
        < Content-Type: application/json
        < Date: Tue, 02 Jun 2015 20:17:10 GMT
        < Transfer-Encoding: chunked
        <
        { [data not shown]
        100 5282 0 5282 0 0 11767 0 -::- -::- -::- 11763
      • Connection #0 to host 10.6.2.164 left intact
        {
        "code": "success",
        "status": [
        { "defnId": 9883803739493546000, "name": "CU_ID_D_ID_W_ID", "bucket": "CUSTOMER", "secExprs": [ "`C_ID`", "`C_D_ID`", "`C_W_ID`" ], "status": "Ready", "definition": "CREATE INDEX CU_ID_D_ID_W_ID ON CUSTOMER(`C_ID`,`C_D_ID`,`C_W_ID`) USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }

        ,

        { "defnId": 10247099293776420000, "name": "PX_NEW_ORDER", "bucket": "NEW_ORDER", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_NEW_ORDER ON NEW_ORDER USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }

        ,

        { "defnId": 14985575270346473000, "name": "PX_ORDER_LINE", "bucket": "ORDER_LINE", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_ORDER_LINE ON ORDER_LINE USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }

        ,

        { "defnId": 1270260835808626000, "name": "PX_STOCK", "bucket": "STOCK", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_STOCK ON STOCK USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }

        ,

        { "defnId": 2701673555643606500, "name": "PX_WAREHOUSE", "bucket": "WAREHOUSE", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_WAREHOUSE ON WAREHOUSE USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }

        ,

        { "defnId": 6381697991753504000, "name": "WH_ID", "bucket": "WAREHOUSE", "secExprs": [ "`W_ID`" ], "status": "Ready", "definition": "CREATE INDEX WH_ID ON WAREHOUSE(`W_ID`) USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }

        ,

        { "defnId": 9185192370830670000, "name": "px_default", "bucket": "default", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX px_default ON default USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }

        ,

        { "defnId": 9811785622606940000, "name": "PX_DISTRICT", "bucket": "DISTRICT", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_DISTRICT ON DISTRICT USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }

        ,

        { "defnId": 2566741460479319000, "name": "px_history", "bucket": "HISTORY", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX px_history ON HISTORY USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }

        ,

        { "defnId": 11137462188741675000, "name": "PX_ITEM", "bucket": "ITEM", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_ITEM ON ITEM USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }

        ,

        { "defnId": 2192640717247959800, "name": "PX_ORDERS", "bucket": "ORDERS", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_ORDERS ON ORDERS USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 100 }

        ,

        { "defnId": 2846474247137516000, "name": "DI_ID_W_ID", "bucket": "DISTRICT", "secExprs": [ "`D_ID`", "`D_W_ID`" ], "status": "Ready", "definition": "CREATE INDEX DI_ID_W_ID ON DISTRICT(`D_ID`,`D_W_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }

        ,

        { "defnId": 1691336714202497300, "name": "IT_ID", "bucket": "ITEM", "secExprs": [ "`I_ID`" ], "status": "Created", "definition": "CREATE INDEX IT_ID ON ITEM(`I_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 0 }

        ,

        { "defnId": 11887412344709894000, "name": "ST_W_ID_I_ID1", "bucket": "STOCK", "secExprs": [ "`S_W_ID`", "`S_I_ID`" ], "status": "Ready", "definition": "CREATE INDEX ST_W_ID_I_ID1 ON STOCK(`S_W_ID`,`S_I_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }

        ,

        { "defnId": 16652031546379360000, "name": "#primary", "bucket": "default", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX #primary ON default USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }

        ,

        { "defnId": 422366478685375300, "name": "seq_num", "bucket": "default", "secExprs": [ "`SequenceNumber`" ], "status": "Ready", "definition": "CREATE INDEX seq_num ON default(`SequenceNumber`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }

        ,

        { "defnId": 17863168309128114000, "name": "PX_CUSTOMER", "bucket": "CUSTOMER", "isPrimary": true, "status": "Ready", "definition": "CREATE PRIMARY INDEX PX_CUSTOMER ON CUSTOMER USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }

        ,

        { "defnId": 12527636432321680000, "name": "CU_W_ID_D_ID_LAST", "bucket": "CUSTOMER", "secExprs": [ "`C_W_ID`", "`C_D_ID`", "`C_LAST`" ], "status": "Ready", "definition": "CREATE INDEX CU_W_ID_D_ID_LAST ON CUSTOMER(`C_W_ID`,`C_D_ID`,`C_LAST`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }

        ,

        { "defnId": 2601635105994920000, "name": "OL_O_ID_D_ID_W_ID", "bucket": "ORDER_LINE", "secExprs": [ "`OL_O_ID`", "`OL_D_ID`", "`OL_W_ID`" ], "status": "Ready", "definition": "CREATE INDEX OL_O_ID_D_ID_W_ID ON ORDER_LINE(`OL_O_ID`,`OL_D_ID`,`OL_W_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }

        ,

        { "defnId": 10968411149123822000, "name": "NO_D_ID_W_ID", "bucket": "NEW_ORDER", "secExprs": [ "`NO_O_ID`", "`NO_D_ID`", "`NO_W_ID`" ], "status": "Ready", "definition": "CREATE INDEX NO_D_ID_W_ID ON NEW_ORDER(`NO_O_ID`,`NO_D_ID`,`NO_W_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }

        ,

        { "defnId": 12730247324206440000, "name": "OR_O_ID_D_ID_W_ID", "bucket": "ORDERS", "secExprs": [ "`O_ID`", "`O_D_ID`", "`O_W_ID`", "`O_C_ID`" ], "status": "Ready", "definition": "CREATE INDEX OR_O_ID_D_ID_W_ID ON ORDERS(`O_ID`,`O_D_ID`,`O_W_ID`,`O_C_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }

        ,

        { "defnId": 4717892513257628000, "name": "OR_W_ID_D_ID_C_ID", "bucket": "ORDERS", "secExprs": [ "`O_W_ID`", "`O_D_ID`", "`O_C_ID`" ], "status": "Ready", "definition": "CREATE INDEX OR_W_ID_D_ID_C_ID ON ORDERS(`O_W_ID`,`O_D_ID`,`O_C_ID`) USING GSI", "hosts": [ "10.6.2.167:8091" ], "completion": 100 }

        ]
        }

      Attachments

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

        Activity

          People

            pavel Pavel Blagodov
            ketaki Ketaki Gangal (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty