Details
-
Bug
-
Resolution: Duplicate
-
Critical
-
4.0.0
-
Security Level: Public
-
None
-
centos 3 node cluster (1Data, 1Data+Query, 1Data+Index); 1M documents
Build 4.0.0-1510
-
Untriaged
-
Unknown
Description
simple query 'select `realm`, count from `bucket-1` group by `realm`.
there is a 2i index by_realm on `realm`.
query eventually starts streaming data but before finish reports:
"errors": [
],
"status": "errors",
"metrics":
workaround will be to reduce selectivity or use limit, but any query timeout should be user specifiable, and 4m shouldn't be the default!
explain:
cbq> explain select `realm`,count from `bucket-1` group by `realm`;
{
"requestID": "403fc452-7051-4a2f-aa0f-34a769703363",
"signature": "json",
"results": [
{
"#operator": "Sequence",
"~children": [
,
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
,
,
{ "#operator": "IntermediateGroup", "aggregates": [ "count(*)" ], "group_keys": [ "(`bucket-1`.`realm`)" ] } ]
}
},
,
,
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "InitialProject",
"result_terms": [
,
{ "expr": "count(*)" } ]
},
]
}
}
]
}
],
"status": "success",
"metrics":
}
don't know which side times out, but it appears that 2i initiates