Details
-
Bug
-
Resolution: Fixed
-
Critical
-
6.5.0
-
Untriaged
-
Centos 64-bit
-
Unknown
Description
Build: 6.5.0 build 2832
Cluster configuration:
- standard `default` bucket
- no GSI indexes
- FTS index:
{
|
"name": "custom_index", |
"type": "fulltext-index", |
"params": { |
"doc_config": { |
"docid_prefix_delim": "", |
"docid_regexp": "", |
"mode": "type_field", |
"type_field": "type" |
},
|
"mapping": { |
"default_analyzer": "standard", |
"default_datetime_parser": "dateTimeOptional", |
"default_field": "_all", |
"default_mapping": { |
"dynamic": true, |
"enabled": false |
},
|
"default_type": "_default", |
"docvalues_dynamic": true, |
"index_dynamic": true, |
"store_dynamic": false, |
"type_field": "type", |
"types": { |
"emp": { |
"dynamic": false, |
"enabled": true, |
"properties": { |
"manages": { |
"dynamic": false, |
"enabled": true, |
"properties": { |
"reports": { |
"enabled": true, |
"dynamic": false, |
"fields": [ |
{
|
"analyzer": "standard", |
"include_in_all": true, |
"include_term_vectors": true, |
"index": true, |
"name": "reports", |
"type": "text" |
}
|
]
|
}
|
}
|
},
|
"email": { |
"enabled": true, |
"dynamic": false, |
"fields": [ |
{
|
"analyzer": "en", |
"include_in_all": true, |
"include_term_vectors": true, |
"index": true, |
"name": "email", |
"type": "text" |
}
|
]
|
},
|
"join_date": { |
"enabled": true, |
"dynamic": false, |
"fields": [ |
{
|
"include_in_all": true, |
"include_term_vectors": true, |
"index": true, |
"name": "join_date", |
"type": "datetime" |
}
|
]
|
},
|
"mutated": { |
"enabled": true, |
"dynamic": false, |
"fields": [ |
{
|
"include_in_all": true, |
"include_term_vectors": true, |
"index": true, |
"name": "mutated", |
"type": "number" |
}
|
]
|
},
|
"name": { |
"enabled": true, |
"dynamic": false, |
"fields": [ |
{
|
"analyzer": "keyword", |
"include_in_all": true, |
"include_term_vectors": true, |
"index": true, |
"name": "name", |
"type": "text" |
}
|
]
|
}
|
}
|
}
|
}
|
},
|
"store": { |
"indexType": "scorch", |
"kvStoreName": "mossStore", |
"mossStoreOptions": {} |
}
|
},
|
"sourceType": "couchbase", |
"sourceName": "default", |
"sourceUUID": "04bfc667bdfddf6187cf3b7536414880", |
"sourceParams": null, |
"planParams": { |
"maxPartitionsPerPIndex": 171, |
"numReplicas": 0 |
},
|
"uuid": "472920f213a5cad3" |
}
|
Trying to run the following query:
select meta().id from default where type='emp' and search(default, {"field": "email", "prefix": "per"}) |
Getting the following error as a response:
{
|
"requestID": "55be2edf-268f-4e94-b5c2-2ecebbef41c3", |
"errors": [{"code":4000,"msg":"No index available on keyspace default that matches your query. Use CREATE INDEX or CREATE PRIMARY INDEX to create an index, or check that your expected index is online."}], |
"status": "fatal", |
"metrics": {"elapsedTime": "4.569962ms","executionTime": "4.526239ms","resultCount": 0,"resultSize": 0,"errorCount": 1} |
}
|