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

[TXN] Transaction fetch error on cluster with node to node encryption

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 7.0.0
    • Cheshire-Cat
    • query
    • 2 node cluster: kv:n1ql:index:fts-kv:n1ql:index
      setup with node-to-node-encryption
      Enterprise Edition 7.0.0 build 4907

    Description

      Simple update in transaction gets fetch error as follow:

      cbq> start transaction;
      {
          "requestID": "79c20840-dd51-4ee6-9a52-29bf19b05f9c",
          "signature": "json",
          "results": [
          {
              "txid": "6283ff75-f247-422b-898a-cc1e3661015a"
          }
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "3.337586ms",
              "executionTime": "3.122005ms",
              "resultCount": 1,
              "resultSize": 62,
              "serviceLoad": 6,
              "transactionElapsedTime": "61.767µs",
              "transactionRemainingTime": "1m59.99992038s"
          }
      }
      cbq> update `travel-sample` set city = 'lyon' where city = 'Lyon';
      {
          "requestID": "6dcb271d-4c7c-4b07-888b-0e173c5cc587",
          "signature": null,
          "results": [
          ],
          "errors": [
              {
                  "cause": {
                      "cause": {
                          "-": {
                              "InnerError": {
                                  "InnerError": {},
                                  "Message": "unambiguous timeout"
                              }
                          },
                          "i": "0x0",
                          "s": "LookupIn",
                          "t": 2500284
                      },
                      "raise": "failed",
                      "retry": true,
                      "rollback": true
                  },
                  "code": 17017,
                  "msg": "Transaction fetch error"
              }
          ],
          "status": "errors",
          "metrics": {
              "elapsedTime": "2.51043955s",
              "executionTime": "2.510160114s",
              "resultCount": 0,
              "resultSize": 0,
              "serviceLoad": 1,
              "transactionElapsedTime": "6.655637331s",
              "transactionRemainingTime": "1m53.344262311s",
              "errorCount": 1
          }
      } 

      From query log, also see:

      _time=2021-04-15T14:21:53.386-07:00 _level=WARN _msg=(GOCBCORE) CCCPPOLL: Failed to retrieve CCCP config. ambiguous timeout 

       

      For comparison, on same cluster outside the transaction the update statement is successful:

      cbq> update `travel-sample` set city = 'lyon' where city = 'Lyon';
      {
          "requestID": "ef292b1c-c14e-4bde-83fd-830bcd894bb2",
          "signature": null,
          "results": [
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "26.376296ms",
              "executionTime": "26.081391ms",
              "resultCount": 0,
              "resultSize": 0,
              "serviceLoad": 6,
              "mutationCount": 6
          }
      } 

      on another cluster with same config but no encryption, transaction is successful.

      Attachments

        Issue Links

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

          Activity

            People

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