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

Travel sample exits with status 1

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • None
    • 7.1.0
    • tools
    • None
    • Centos 7 64 bit; CB EE 7.1.0-1533

    Description

      What's the issue?
      'cbimport' (and 'docloader') can no longer import samples to a 7.1.0 cluster which has Query/Index services enabled. This appears to be due to a failure to bootstrap the 'gocb' cluster level agent to execute N1QL queries to create and build the sample buckets indexes.

      Looking at the verbose output, we see the following:

      # We're connecting at the cluster level using 'gocb'
      2021-12-03T11:11:28.863+00:00 (Couchbase) Creating Query connection to cluster 'couchbase://localhost:12000'
      # We've successfully called 'WaitUntilReady'
      2021-12-03T11:11:28.875+00:00 (Couchbase) Successfully created Query connection to cluster 'couchbase://localhost:12000'
      # We've failed to execute our first N1QL query
      2021-12-03T11:11:58.876+00:00 JSON import failed: failed to execute cluster operations: failed to execute bucket operation for bucket 'travel-sample': failed to execute queries for bucket 'travel-sample': failed to execute queries against sink bucket: failed to execute query: ambiguous timeout | {"InnerError":{"InnerEr
      ror":{"InnerError":{},"Message":"ambiguous timeout"}},"OperationID":"http","Opaque":"1de7783f-cb6a-44c8-a258-215f6d80b0da","TimeObserved":30000536462,"RetryReasons":null,"RetryAttempts":0,"LastDispatchedTo":"http://localhost:9499","LastDispatchedFrom":"","LastConnectionID":""} | {"statement":"CREATE PRIMARY INDEX def_p
      rimary on `travel-sample` USING GSI WITH {\"defer_build\":true}","client_context_id":"1de7783f-cb6a-44c8-a258-215f6d80b0da"}
      

      Observations
      1) This behavior worked in 7.0.0
      2) This behavior still works (with a 7.1.0 cbimport) against a 7.0.2 cluster
      3) This behavior no longer works against 7.1.0

      This suggests to me that this is either:
      1) An issue with the SDK communicating with 7.1.0
      2) An change in behavior of 7.1.0 which hasn't been accounted for (whether that be in 'cbimport' or another component)

      Steps to reproduce
      1) Create a single node cluster with KV/Query and Indexing
      2a) Import a sample bucket via the WebUI
      2b) Import a sample using 'cbimport json -c ${HOSTNAME} -u ${USERNAME} -p ${PASSWORD} -b travel-sample -d [file://${SOURCE}/install/samples/travel-sample.zip -f sample'

      In both cases, you'll see that a bucket is created, but 'cbimport' exits after failing to connect to execute N1QL queries.

      Logs for import using 7.1.0 to 7.0.2
      master-to-7.0.2 (cbimport with verbose SDK logging)
      collectinfo-2021-12-03T104546-ns_1@127.0.0.1.zip

      Logs for import using 7.1.0 to 7.1.0
      master-to-7.1.0 (cbimport with verbose SDK logging)
      collectinfo-2021-12-03T105534-n_0@cb.local.zip

      Attachments

        Issue Links

          For Gerrit Dashboard: MB-49043
          # Subject Branch Project Status CR V

          Activity

            People

              sumedh.basarkod Sumedh Basarkod (Inactive)
              sumedh.basarkod Sumedh Basarkod (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty