Unrecognized parameter in request: query_context error

faraz.kadri · November 3, 2023, 3:18pm

Hello, we get the following error when trying to run query on our Prod servers.

[{"code":1065,"msg":"Unrecognized parameter in request: query_context"}]

We are using the latest SDK

github.com/couchbase/gocb/v2 v2.6.5

I believe the CB server version is 6.6

faraz.kadri · November 3, 2023, 4:08pm

Doing some digging.

github.com

couchbase/gocb/blob/v2.6/scope_query.go

package gocb

import (
	"fmt"
	"time"
)

// Query executes the query statement on the server, constraining the query to the bucket and scope.
func (s *Scope) Query(statement string, opts *QueryOptions) (*QueryResult, error) {
	if opts == nil {
		opts = &QueryOptions{}
	}

	if opts.AsTransaction != nil {
		return s.getTransactions().singleQuery(statement, s, *opts)
	}

	start := time.Now()
	defer s.meter.ValueRecord(meterValueServiceQuery, "query", start)

This file has been truncated. show original

This line

	queryOpts["query_context"] = fmt.Sprintf("%s.%s", s.BucketName(), s.Name())

seem to be causing the problem. We tried removing it and it worked. It would be nice to mitigate this issue in the next release.

mreiche · November 3, 2023, 4:13pm

I opened an issue for you - GOCBC-1528

vsr1 · November 6, 2023, 1:30pm

query_context query parameter only supported CB 7.0 or higher

faraz.kadri · November 6, 2023, 9:23pm

Thanks. We changed the code to do the query at the cluster level which seems to be working.