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

[TLS] query hangs in transaction

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • 7.0.2
    • 7.0.2
    • query, secondary-index
    • None
    • 7.0.2-6544
    • Untriaged
    • 1
    • Unknown

    Description

      To repro:

      • setup 2 nodes cluster (kv:n1ql:index-kv)
      • load travel-sample bucket
      • enable N2N encryption: /opt/couchbase/bin/couchbase-cli node-to-node-encryption -c http://localhost:8091 -u Administrator -p password --enable
      • set TLS strict mode: /opt/couchbase/bin/couchbase-cli setting-security -c http://localhost:8091 -u Administrator -p password --set --cluster-encryption-level strict
      • Try simple select in transaction ... query hangs and eventually times out.

       cbq> begin work;
      {
          "requestID": "185daa00-dbd7-4c58-8eae-7d4d051eb2bf",
          "signature": "json",
          "results": [
          {
              "txid": "0756a4ca-d02f-4c02-8b6e-9f08b0a6fb20"
          }
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "1.067112ms",
              "executionTime": "901.84µs",
              "resultCount": 1,
              "resultSize": 62,
              "serviceLoad": 6,
              "transactionElapsedTime": "84.141µs",
              "transactionRemainingTime": "1m59.99989191s"
          }
      }
      cbq> select city,airportname from `travel-sample`.inventory.airport where lower(city) = 'lyon';
      {
          "requestID": "b976d0bd-cbb7-4b36-bc7b-fb1492675f8c",
          "signature": {
              "airportname": "json",
              "city": "json"
          },
          "results": [
          ],
          "errors": [
              {
                  "code": 1080,
                  "msg": "Timeout 1m55.648058014s exceeded",
                  "retry": true
              }
          ],
          "status": "timeout",
          "metrics": {
              "elapsedTime": "1m55.650817285s",
              "executionTime": "1m55.650571598s",
              "resultCount": 0,
              "resultSize": 0,
              "serviceLoad": 1,
              "transactionElapsedTime": "2m0.000363072s",
              "errorCount": 1
          }
      }

      outside of transaction, operations work fine.

      Attachments

        Issue Links

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

          Activity

            People

              jeelan.poola Jeelan Poola
              pierre.regazzoni Pierre Regazzoni
              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