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.