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

[system test] All indexes are wiped out on the UI ( Index Tab, main console, etc) after a cluster reboot

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Test Blocker
    • 4.0.0
    • 4.0.0
    • secondary-index
    • Security Level: Public
    • 400-2093
      10 buckets, 10 gsi indexes
      1 index+kv_query node and 4 kv only nodes
    • Untriaged
    • adding logs.
    • Unknown

    Description

      0. create cluster, create indexes gsi on the buckets - all online and ok
      1. Load items on the buckets ( attached screenshot for item distribution)
      2. Reboot the cluster

      • Index Tab- Zero indexes present
      • Individual buckets from the main console - shows no presence of indexes

      Note : I had filed a bug earlier about Index stats being "N/A" for some nodes and this cluster now shows nothing present for indexes - which is very odd.

      The index directory contains teh index definition, though none of the queries can use any of the indexes

      • Query either hangs
      • shows index stale meta data

      cbq> explain select * from default where SequenceNumber>1 limit 1;
      {
      "requestID": "0198f5c0-47b9-4ea7-a06d-512aac5d7849",
      "signature": "json",
      "results": [
      {
      "#operator": "Sequence",
      "~children": [
      {
      "#operator": "Sequence",
      "~children": [
      {
      "#operator": "IndexScan",
      "index": "seq_num",
      "keyspace": "default",
      "limit": 9.223372036854776e+18,
      "namespace": "default",
      "spans": [
      {
      "Range":

      { "High": null, "Inclusion": 0, "Low": [ "1" ] }

      ,
      "Seek": null
      }
      ],
      "using": "gsi"
      },
      {
      "#operator": "Parallel",
      "~child": {
      "#operator": "Sequence",
      "~children": [

      { "#operator": "Fetch", "keyspace": "default", "namespace": "default" }

      ,

      { "#operator": "Filter", "condition": "(1 \u003c (`default`.`SequenceNumber`))" }

      ,
      {
      "#operator": "InitialProject",
      "result_terms": [

      { "star": true }

      ]
      },

      { "#operator": "FinalProject" }

      ]
      }
      }
      ]
      },

      { "#operator": "Limit", "expr": "1" }

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

      { "elapsedTime": "53.189384ms", "executionTime": "52.792062ms", "resultCount": 1, "resultSize": 2579 }

      }

      2015-05-13T12:32:32.967Z-07:00 [Error] [GsiScanClient:"10.6.2.167:9101"] connection "10.6.2.167:48581" response transport failed `read tcp 10.6.2.167:9101: i/o timeout`
      2015-05-13T12:32:32.967Z-07:00 [Error] [GsiScanClient:"10.6.2.167:9101"] Range() response failed `read tcp 10.6.2.167:9101:

      Attachments

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

        Activity

          People

            sarath Sarath Lakshman
            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