Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.6.0, Cheshire-Cat
-
Untriaged
-
Centos 64-bit
-
-
1
-
Unknown
Description
Build: 7.0.0-2518
Cluster configuration: 4 nodes:
data, index, query, search
data
search
search
Bucket `default` contains 1000 docs like this:
{
|
"default": {
|
"dept": "Engineering",
|
"email": "kory@mcdiabetes.com",
|
"emp_id": "10000001",
|
"is_manager": true,
|
"join_date": "2015-08-13T09:30:00",
|
"languages_known": [
|
"Quechua",
|
"Portuguese",
|
"Africans"
|
],
|
"manages": {
|
"reports": [
|
"Hedda Wright",
|
"Callia Robinson Sr.",
|
"Trista Baker III",
|
"Joby Allen",
|
"Basha Foster",
|
"Salina Allen"
|
],
|
"team_size": 6
|
},
|
"mutated": 0,
|
"name": "Kory Palmer",
|
"salary": 75891.68,
|
"type": "emp"
|
},
|
"id": "emp_10000001"
|
}
|
bucket `default` is provided with primary index:
CREATE PRIMARY INDEX `primary_gsi_index` ON `default` |
fts index definition is:
{
|
"name": "default_index",
|
"type": "fulltext-index",
|
"params": {
|
"doc_config": {
|
"docid_prefix_delim": "",
|
"docid_regexp": "",
|
"mode": "type_field",
|
"type_field": "type"
|
},
|
"mapping": {
|
"default_analyzer": "keyword",
|
"default_datetime_parser": "dateTimeOptional",
|
"default_field": "_all",
|
"default_mapping": {
|
"default_analyzer": "keyword",
|
"dynamic": true,
|
"enabled": true
|
},
|
"default_type": "_default",
|
"docvalues_dynamic": true,
|
"index_dynamic": true,
|
"store_dynamic": false,
|
"type_field": "type"
|
},
|
"store": {
|
"indexType": "scorch",
|
"mossStoreOptions": {}
|
}
|
},
|
"sourceType": "gocbcore",
|
"sourceName": "default",
|
"sourceUUID": "38bb555c12c2483f7b934e28d57bad00",
|
"sourceParams": {},
|
"planParams": {
|
"maxPartitionsPerPIndex": 171,
|
"numReplicas": 0,
|
"indexPartitions": 6
|
},
|
"uuid": "37f61741e353a426"
|
}
|
While running query
select meta().id from default USE INDEX (USING FTS, USING GSI) where ( salary between 93000.0 and 96352.0) |
periodically I'm getting the following error:
[
|
{
|
"code": 5000,
|
"msg": "n1fty: client unavailable, try refreshing",
|
"query": "/*select meta().id from default where ( salary between 93000.0 and 96352.0)*/\nselect meta().id from default USE INDEX (USING FTS, USING GSI) where ( salary between 93000.0 and 96352.0)"
|
}
|
]
|
Attachments
Issue Links
- is duplicated by
-
MB-40125 [FTS+N1QL] During add-back after failover some nodes may be unavailable
-
- Closed
-
For Gerrit Dashboard: MB-40380 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
132322,2 | MB-40380: Initialize indexer client only when successful | master | n1fty | Status: MERGED | +2 | +1 |
132973,2 | MB-40515: Initialize indexer client only when successful | mad-hatter | n1fty | Status: MERGED | +2 | +1 |
136749,2 | MB-41603: [BP] Initialize indexer client only when successful | 6.5.1 | n1fty | Status: MERGED | +2 | +1 |