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

Indexes online and contain no values; queries return blank results

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.0.0
    • 4.0.0
    • secondary-index
    • Security Level: Public
    • Build 1869. CentOS6. VM. Single Node Cluster, all three services. 2048 assigned to index memory, 1024 to k/v. `Travel-Sample` dataset and app loaded
    • Untriaged
    • Centos 64-bit
    • Unknown

    Description

      [1] Load CB 1869
      [2] Install Travel Sample Application prerequisites:
      sudo su
      curl -sL https://rpm.nodesource.com/setup | bash -
      yum install -y nodejs
      yum install -y gcc-c++ make
      yum install -y git
      cd /tmp
      git clone -b devprev https://github.com/ToddGreenstein/try-cb-nodejs.git
      cd /tmp/try-cb-nodejs/
      npm install
      node app.js
      [3] In a second terminal: curl -v -X POST http://127.0.0.1:3000/api/status/provisionCB
      [4] Once bucket is loaded, all indexes are built, all indexes are online, all queries come back blank. See output below and attached logs.

      cbq> select * from system:indexes;
      {
      "requestID": "28048a3c-96ec-4da1-9402-cf5ff9d08e36",
      "signature":

      { "*": "*" }

      ,
      "results": [
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "2923816629baa4a4", "index_key": [ "`airportname`" ], "keyspace_id": "travel-sample", "name": "def_airportname", "namespace_id": "default", "state": "online", "using": "gsi" }

      },
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "1348df1d908db683", "index_key": [ "`city`" ], "keyspace_id": "travel-sample", "name": "def_city", "namespace_id": "default", "state": "online", "using": "gsi" }

      },
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "50bb436315f4bba5", "index_key": [ "`icao`" ], "keyspace_id": "travel-sample", "name": "def_icao", "namespace_id": "default", "state": "online", "using": "gsi" }

      },
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "de0fdee685c8871f", "index_key": [ "`type`" ], "keyspace_id": "travel-sample", "name": "def_type", "namespace_id": "default", "state": "online", "using": "gsi" }

      },
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "efc2b5503b209ff", "index_key": [ "`faa`" ], "keyspace_id": "travel-sample", "name": "def_faa", "namespace_id": "default", "state": "online", "using": "gsi" }

      },
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "59a9591017f8422f", "index_key": [], "keyspace_id": "travel-sample", "name": "def_primary", "namespace_id": "default", "state": "online", "using": "gsi" }

      },
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "b3133da4b95c2362", "index_key": [ "`sourceairport`" ], "keyspace_id": "travel-sample", "name": "def_sourceairport", "namespace_id": "default", "state": "online", "using": "gsi" }

      }
      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "226.151605ms", "executionTime": "226.0879ms", "resultCount": 7, "resultSize": 2933 }

      }

      cbq> select count from `travel-sample`;
      {
      "requestID": "736b3cb8-48a3-4fbb-b0bd-50ab605f16e6",
      "signature":

      { "$1": "number" }

      ,
      "results": [

      { "$1": 31621 }

      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "29.781991ms", "executionTime": "29.704505ms", "resultCount": 1, "resultSize": 35 }

      }

      cbq> select * from `travel-sample`;
      {
      "requestID": "c3b7babf-a528-441a-b9af-5f1c3e126fed",
      "signature":

      { "*": "*" }

      ,
      "results": [
      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "19.213001ms", "executionTime": "19.139562ms", "resultCount": 0, "resultSize": 0 }

      }

      Attachments

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

        Activity

          People

            jliang John Liang
            tgreenstein Todd Greenstein [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty