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

[CURL] query returns results infinitely

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Critical
    • 5.5.0
    • 5.5.0
    • query
    • None
    • 5.5.0-1979
    • Untriaged
    • Yes

    Description

      This query:

       

      select * from default d where curl('http://192.168.10.12:8093/query/service', {'data' : 'statement=select raw d from default d limit 5&metrics=false&signature=false','user':'Administrator:password'}).results[0].name == 'employee-9'

       

      Does not stop returning results, ever (can observe by running it through CBQ 

      /opt/couchbase/bin/cbq -e 192.168.10.12:8093 -q -u Administrator -p password -s="select * from default d where curl('http://192.168.10.12:8093/query/service', {'data' : 'statement=select raw d from default d limit 5&metrics=false&signature=false','user':'Administrator:password'}).results[0].name == 'employee-9' ")

       

      Here is the explain:

      {
      "plan": {
      "#operator": "Sequence",
      "~children": [
      {
      "#operator": "PrimaryScan3",
      "as": "d",
      "index": "#primary",
      "index_projection": {
      "primary_key": true
      },
      "keyspace": "default",
      "namespace": "default",
      "using": "gsi"
      },
      {
      "#operator": "Fetch",
      "as": "d",
      "keyspace": "default",
      "namespace": "default"
      },
      {
      "#operator": "Parallel",
      "~child": {
      "#operator": "Sequence",
      "~children": [
      {
      "#operator": "Filter",
      "condition": "((((curl(\"http://192.168.10.12:8093/query/service\", {\"data\": \"statement=select raw d from default d limit 5&metrics=false&signature=false\", \"user\": \"Administrator:password\"}).`results`)[0]).`name`) = \"employee-9\")"
      },
      {
      "#operator": "InitialProject",
      "result_terms": [
      {
      "expr": "self",
      "star": true
      }
      ]
      },
      {
      "#operator": "FinalProject"
      }
      ]
      }
      }
      ]
      },
      "text": "select * from default d where curl('http://192.168.10.12:8093/query/service', {'data' : 'statement=select raw d from default d limit 5&metrics=false&signature=false','user':'Administrator:password'}).results[0].name == 'employee-9'"
      }

      I am unsure on what build this was last passing, and I am unsure if this is specifically a curl error or not, however this is the query I observe the issue on. Logs attached. Backup attached. There was a 3 node cluster, however I simply included the logs from the server I ran the query on. Let me know if the other logs are necessary.

      Attachments

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

        Activity

          People

            isha Isha Kandaswamy (Inactive)
            ajay.bhullar Ajay Bhullar
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty