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

fail to create sequence with DURABILITY_IMPOSSIBLE with bucket replica 1 on single node

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.6.0
    • 7.6.0
    • query
    • None
    • 7.6.0-1670
    • Untriaged
    • 0
    • Unknown

    Description

      Repro:

      setup single node cluster

      create bucket:

      # couchbase-cli bucket-create -c localhost -u Administrator -p password --bucket default --bucket-type couchbase --bucket-ramsize 100 --bucket-replica 1 

      create sequence:

      create sequence default.`_default`.seq1; 

      gets following error:

      cbq> create sequence default.`_default`.seq1;
      {
          "requestID": "2e81a40c-c268-4638-8d30-190c729b1d79",
          "signature": null,
          "results": [
          ],
          "errors": [
              {
                  "code": 19101,
                  "msg": "Create failed for sequence 'default:default._default.seq1'",
                  "reason": {
                      "_level": "error",
                      "caller": "couchbase:2633",
                      "cause": {
                          "_level": "error",
                          "caller": "couchbase:2529",
                          "cause": {
                              "cause": {
                                  "_level": "exception",
                                  "caller": "memcached:493",
                                  "cause": {
                                      "attempts": 1,
                                      "cause": "DURABILITY_IMPOSSIBLE"
                                  },
                                  "code": 5502,
                                  "key": "datastore.couchbase.bucket.action",
                                  "message": "Unable to complete action after 1 attempts"
                              },
                              "key": "seq::00000000::_default.seq1"
                          },
                          "code": 12036,
                          "key": "datastore.couchbase.insert.error",
                          "message": "Error in INSERT of key: seq::00000000::_default.seq1"
                      },
                      "code": 12009,
                      "icause": "Error in INSERT of key: seq::00000000::_default.seq1",
                      "key": "datastore.couchbase.DML_error",
                      "message": "DML Error, possible causes include concurrent modification. Failed to perform INSERT on key seq::00000000::_default.seq1"
                  }
              }
          ],
          "status": "fatal",
          "metrics": {
              "elapsedTime": "86.091117ms",
              "executionTime": "85.823026ms",
              "resultCount": 0,
              "resultSize": 0,
              "serviceLoad": 6,
              "errorCount": 1
          }
      } 

      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:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty