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

[N1QL] Prepared pull does not work as expected

    XMLWordPrintable

Details

    • Untriaged
    • No

    Description

      The basic pull scenario in auto prepare tests is broken.

      2 node cluster (both with n1ql services)

      prepare statement p1:
      PREPARE P1 FROM select * from default limit 5

      delete prepare statement p1 from node2:
      delete from system:prepareds where node = '172.23.104.173:8091'

      run prepare statement p1 on node2 via node1:
      execute '[172.23.104.110:8091]P1'

      "code": 4040,
      "msg": "No such prepared statement: \"[172.23.104.110:8091]P1\", context ",
      "query": "execute '[172.23.104.110:8091]P1'"

      You get this error, however this prepared statement is indeed in the system:prepareds (see attatched screenshot)

      here is select * from system:prepareds output(it has two uses because i was checking if it can be used straight up on node1, which it can be):
      "prepareds": {
      "avgElapsedTime": "108.860281ms",
      "avgServiceTime": "108.785859ms",
      "encoded_plan": "H4sIAAAAAAAA/7SSwYrbMBCGX8X8ewu6pG0o6BbKLhS21CSllxKCsCeOurLkHY2XpEZ99iLbS9jd5lR6s2d+fUjfzADyVaip3nfOeGhA4UBGeqZPwQsHF6GX7xSsr+m07ux34miDh/6g4E1L0CiXmL5jZ6pcqOlgeidQCB2xkcDQA24uP1j3cgxsfxEUOrZP1lFDMafubRToHwO+GW5ILjR9oZZsn6A/pl1S+F0dratf87f02JOvMn4KMPmR+n9CJdvW8HlbGf8esyto3HRT/bm07zj8pEpGfwPm7v6BztDCPSWFBzq/tehsa7OJ1VXPfbS+gUYTLZJ6ebk7kuqIK+i/4V4DSsPGOXL4J9ufvRVrXDkpgAJT7J3shbiNY5pOXQ5GcgcoRDE8a9mlXcrDfgm8H62o52MrvI1shcm0uZEUHnvic15qOsm06NE2flz1/KAFNBZICnO/3NyW681tUS6Lu83XL0UkR5UUi+LAoS1mV8U4mmKF9CcAAP//3vYj2EkDAAA=",
      "featureControls": 12,
      "indexApiVersion": 4,
      "lastUse": "2020-03-17 13:11:07.284861128 -0700 PDT m=+165.500305632",
      "maxElapsedTime": "208.083856ms",
      "maxServiceTime": "208.025426ms",
      "minElapsedTime": "9.636706ms",
      "minServiceTime": "9.546293ms",
      "name": "P1",
      "node": "172.23.104.110:8091",
      "statement": "PREPARE P1 FROM select * from default limit 5",
      "uses": 2

      Logs attached

      Attachments

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

        Activity

          People

            marco.greco Marco Greco (Inactive)
            ajay.bhullar Ajay Bhullar
            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