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

Fail to load travel-sample

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Yes

    Description

      Fail to load travel-sample on single node cluster.

      From log:

      2021-11-29T12:17:34.735-08: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":{"InnerError":{"InnerError":{},"Message":"ambiguous timeout"}},"OperationID":"http","Opaque":"090bb398-8dae-463b-8371-1070afed9b38","TimeObserved":30000874008,"RetryReasons":null,"RetryAttempts":0,"LastDispatchedTo":"http://127.0.0.1:8093","LastDispatchedFrom":"","LastConnectionID":""} | {"statement":"CREATE PRIMARY INDEX def_primary on `travel-sample` USING GSI WITH {\"defer_build\":true}","client_context_id":"090bb398-8dae-463b-8371-1070afed9b38"}
      JSON import failed: operation has timed out 

       

      Loading sample bucket travel-sample failed. Samples loader exited with status 1.
      Loader's output was:
       
      2021-11-29T12:17:01.233-08:00 (REST) (Attempt 1) (GET) Dispatching request to 'http://127.0.0.1:8091/pools'
      2021-11-29T12:17:01.234-08:00 (REST) (Attempt 1) (GET) (200) Received response from 'http://127.0.0.1:8091/pools'
      2021-11-29T12:17:01.235-08:00 (REST) (Attempt 1) (GET) Dispatching request to 'http://127.0.0.1:8091/pools/default'
      2021-11-29T12:17:01.239-08:00 (REST) (Attempt 1) (GET) (200) Received response from 'http://127.0.0.1:8091/pools/default'
      2021-11-29T12:17:01.240-08:00 (REST) (Attempt 1) (GET) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets'
      2021-11-29T12:17:01.242-08:00 (REST) (Attempt 1) (GET) (200) Received response from 'http://127.0.0.1:8091/pools/default/buckets'
      2021-11-29T12:17:01.242-08:00 (REST) Successfully connected to cluster | {"enterprise":true,"uuid":"5e93d9426c4095cc866a6203a10a4680","version":{"min_version":"7.1.0","is_mixed_cluster":false},"max_vbuckets":0,"uniform_vbuckets":true}
      2021-11-29T12:17:01.462-08:00 (REST) (Attempt 1) (GET) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:01.463-08:00 (REST) (Attempt 1) (GET) (404) Received response from 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:01.464-08:00 WARN: (REST) (Attempt 1) (GET) Request to endpoint '/pools/default/buckets/travel-sample' failed with status code 404 -- logging.(*ToolsCommonLogger).Log() at tools_common.go:28
      2021-11-29T12:17:01.464-08:00 (Plan) (Bucket) Creating remote bucket 'travel-sample' if it does not exist
      2021-11-29T12:17:01.464-08:00 (REST) (Attempt 1) (GET) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:01.466-08:00 (REST) (Attempt 1) (GET) (404) Received response from 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:01.466-08:00 WARN: (REST) (Attempt 1) (GET) Request to endpoint '/pools/default/buckets/travel-sample' failed with status code 404 -- logging.(*ToolsCommonLogger).Log() at tools_common.go:28
      2021-11-29T12:17:01.466-08:00 Bucket travel-sample does not exist, creating one with the specified settings
      2021-11-29T12:17:01.466-08:00 (REST) (Attempt 1) (POST) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets'
      2021-11-29T12:17:01.501-08:00 (REST) (Attempt 1) (POST) (202) Received response from 'http://127.0.0.1:8091/pools/default/buckets'
      2021-11-29T12:17:01.501-08:00 (REST) (Attempt 1) (GET) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:01.505-08:00 (REST) (Attempt 1) (GET) (200) Received response from 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:02.501-08:00 (REST) (Attempt 1) (GET) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:02.511-08:00 (REST) (Attempt 1) (GET) (200) Received response from 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:03.501-08:00 (REST) (Attempt 1) (GET) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:03.510-08:00 (REST) (Attempt 1) (GET) (200) Received response from 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:03.511-08:00 (Plan) (Bucket) Successfully ensured bucket 'travel-sample' exists | {"number":1,"duration":"2.046940296s"}
      2021-11-29T12:17:03.511-08:00 (Plan) (Bucket) Automatically creating/editing scopes/collections for bucket 'travel-sample'
      2021-11-29T12:17:03.511-08:00 (REST) (Attempt 1) (GET) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:03.520-08:00 (REST) (Attempt 1) (GET) (200) Received response from 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:03.521-08:00 (REST) (Attempt 1) (GET) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets/travel-sample/scopes'
      2021-11-29T12:17:03.522-08:00 (REST) (Attempt 1) (GET) (200) Received response from 'http://127.0.0.1:8091/pools/default/buckets/travel-sample/scopes'
      2021-11-29T12:17:03.522-08:00 (REST) (Attempt 1) (POST) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets/travel-sample/scopes/@ensureManifest/0'
      2021-11-29T12:17:03.526-08:00 (REST) (Attempt 1) (POST) (200) Received response from 'http://127.0.0.1:8091/pools/default/buckets/travel-sample/scopes/@ensureManifest/0'
      2021-11-29T12:17:03.527-08:00 (REST) (Attempt 1) (PUT) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets/travel-sample/scopes?validOnUid=0'
      2021-11-29T12:17:03.566-08:00 (REST) (Attempt 1) (PUT) (200) Received response from 'http://127.0.0.1:8091/pools/default/buckets/travel-sample/scopes?validOnUid=0'
      2021-11-29T12:17:03.566-08:00 (REST) (Attempt 1) (POST) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets/travel-sample/scopes/@ensureManifest/1'
      2021-11-29T12:17:04.191-08:00 (REST) (Attempt 1) (POST) (200) Received response from 'http://127.0.0.1:8091/pools/default/buckets/travel-sample/scopes/@ensureManifest/1'
      2021-11-29T12:17:04.191-08:00 (Plan) (Bucket) Successfully created/edited scopes/collections for bucket 'travel-sample' | {"number":2,"duration":"679.500864ms"}
      2021-11-29T12:17:04.191-08:00 (Plan) (Bucket) Transferring bucket configuration for bucket 'travel-sample'
      2021-11-29T12:17:04.191-08:00 (REST) (Attempt 1) (GET) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:04.198-08:00 (REST) (Attempt 1) (GET) (200) Received response from 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:04.199-08:00 Editing bucket to conform with settings provided
      2021-11-29T12:17:04.199-08:00 (REST) (Attempt 1) (POST) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:04.234-08:00 (REST) (Attempt 1) (POST) (200) Received response from 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:04.234-08:00 (REST) (Attempt 1) (GET) Dispatching request to 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:04.245-08:00 (REST) (Attempt 1) (GET) (200) Received response from 'http://127.0.0.1:8091/pools/default/buckets/travel-sample'
      2021-11-29T12:17:04.246-08:00 (Plan) (Bucket) Successfully transferred bucket configuration for bucket 'travel-sample' | {"number":3,"duration":"55.344149ms"}
      2021-11-29T12:17:04.246-08:00 (Plan) (Index) Transferring views definitions for bucket 'travel-sample'
      2021-11-29T12:17:04.453-08:00 (Plan) (Index) Successfully transferred views definitions for bucket 'travel-sample' | {"number":4,"duration":"206.919278ms"}
      2021-11-29T12:17:04.453-08:00 (Plan) (Query) Executing queries for bucket 'travel-sample'
      2021-11-29T12:17:04.667-08:00 (Couchbase) Creating Query connection to cluster 'couchbase://127.0.0.1:11210'
      2021-11-29T12:17:04.733-08:00 (Couchbase) Successfully created Query connection to cluster 'couchbase://127.0.0.1:11210'
      2021-11-29T12:17:34.735-08: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":{"InnerError":{"InnerError":{},"Message":"ambiguous timeout"}},"OperationID":"http","Opaque":"090bb398-8dae-463b-8371-1070afed9b38","TimeObserved":30000874008,"RetryReasons":null,"RetryAttempts":0,"LastDispatchedTo":"http://127.0.0.1:8093","LastDispatchedFrom":"","LastConnectionID":""} | {"statement":"CREATE PRIMARY INDEX def_primary on `travel-sample` USING GSI WITH {\"defer_build\":true}","client_context_id":"090bb398-8dae-463b-8371-1070afed9b38"}
      JSON import failed: operation has timed out 

      Attachments

        Issue Links

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

          Activity

            owend Daniel Owen added a comment -

            The changelog is small between 1800 and 1801, with no tools changes.

            Query changes between the 2 builds is:

            * Commit: 0eda17b722c3a996ab5072663145f7ae33765ebb in build: couchbase-server-7.1.0-1801
            MB-49753 Modify fix
             
            * Commit: 7d8ad550c9e42c860dab1341d7770d7a56662a74 in build: couchbase-server-7.1.0-1801
            MB-49532 UDF execute prepared returns no results
            

            owend Daniel Owen added a comment - The changelog is small between 1800 and 1801, with no tools changes. Query changes between the 2 builds is: * Commit: 0eda17b722c3a996ab5072663145f7ae33765ebb in build: couchbase-server-7.1.0-1801 MB-49753 Modify fix   * Commit: 7d8ad550c9e42c860dab1341d7770d7a56662a74 in build: couchbase-server-7.1.0-1801 MB-49532 UDF execute prepared returns no results
            owend Daniel Owen added a comment -

            Identified that the issue is being caused by
            Commit: 7d8ad550c9e42c860dab1341d7770d7a56662a74 in build: couchbase-server-7.1.0-1801
            MB-49532 UDF execute prepared returns no results

            Assigning to query.

            owend Daniel Owen added a comment - Identified that the issue is being caused by Commit: 7d8ad550c9e42c860dab1341d7770d7a56662a74 in build: couchbase-server-7.1.0-1801 MB-49532 UDF execute prepared returns no results Assigning to query.
            owend Daniel Owen added a comment -

            Hi Marco Greco
            The issue can be reproduced by just creating a single node cluster (with all services enabled) and then try to load the travel-sample.
            With 7d8ad550c9e42c860dab1341d7770d7a56662a74 we see
            Loading sample bucket travel-sample failed. Samples loader exited with status 1.

            owend Daniel Owen added a comment - Hi Marco Greco The issue can be reproduced by just creating a single node cluster (with all services enabled) and then try to load the travel-sample. With 7d8ad550c9e42c860dab1341d7770d7a56662a74 we see Loading sample bucket travel-sample failed. Samples loader exited with status 1.

            Build couchbase-server-7.1.0-1820 contains query commit 95d428a with commit message:
            MB-49823 cannot load travel sample

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1820 contains query commit 95d428a with commit message: MB-49823 cannot load travel sample

            Verified on 7.1.0-1827

            pierre.regazzoni Pierre Regazzoni added a comment - Verified on 7.1.0-1827

            People

              pierre.regazzoni Pierre Regazzoni
              pierre.regazzoni Pierre Regazzoni
              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