Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.1.0
-
Untriaged
-
0
-
Unknown
Description
1) Install travel-sample
2) Create FTS INDEX
curl -s -u Administrator:password http://localhost:8094/api/index/fix1 -H "Content-Type: application/json" -XDELETE
|
curl -s -u Administrator:password http://localhost:8094/api/index/fix1 -H "Content-Type: application/json" -XPUT -d '{
|
"name": "fix1",
|
"type": "fulltext-index",
|
"params": {
|
"mapping": {
|
"default_mapping": {
|
"enabled": true,
|
"dynamic": true
|
},
|
"default_type": "_default",
|
"default_analyzer": "standard",
|
"default_datetime_parser": "dateTimeOptional",
|
"default_field": "_all",
|
"store_dynamic": false,
|
"index_dynamic": true
|
},
|
"store": {
|
"indexType": "scorch",
|
"kvStoreName": ""
|
},
|
"doc_config": {
|
"mode": "type_field",
|
"type_field": "type",
|
"docid_prefix_delim": "",
|
"docid_regexp": ""
|
}
|
},
|
"sourceType": "couchbase",
|
"sourceName": "travel-sample",
|
"sourceUUID": "",
|
"sourceParams": {},
|
"planParams": {
|
"maxPartitionsPerPIndex": 171,
|
"numReplicas": 0
|
},
|
"uuid": ""
|
}'
|
3) \set -memory_quota 1000;
4) run query
SELECT RAW META(t1).id FROM `travel-sample` AS t1 WHERE SEARCH(t1, {"match": "United States", "field": "country"}) ;
|
{
|
"requestID": "0fe1e117-16de-4074-8d67-e0df4d8c4801",
|
"signature": "json",
|
"results": [
|
"airport_3834",
|
"airport_4388",
|
"landmark_26068",
|
"landmark_16096",
|
"landmark_35056",
|
"landmark_25138"
|
],
|
"errors": [
|
{
|
"code": 5500,
|
"msg": "Request has exceeded memory quota"
|
}
|
],
|
"status": "errors",
|
"metrics": {
|
"elapsedTime": "3.080918ms",
|
"executionTime": "3.011756ms",
|
"resultCount": 6,
|
"resultSize": 92,
|
"serviceLoad": 2,
|
"usedMemory": 18446744073709551614,
|
"errorCount": 1
|
}
|
}
|
|
When memory_quota is set track the values
https://github.com/couchbase/query/blob/master/execution/search_ftsindex.go
Also see other execution/scan*index*