Details
-
Bug
-
Resolution: Fixed
-
Critical
-
5.5.0
-
Initial Version: 4.6.4-4590
Upgrade Version: 5.5.0-2907
Storage Mode: Memory Optimized
Cluster Config:
Node 1: kv (101)
Node 2: kv (102)
Node 3: Index, n1ql (103)
Node 4: Index (104)
-
Untriaged
-
Unknown
Description
[Please note this error occurs in two scenarios. First is in description. Second is mentioned in the comment]
- Create and configure cluster, Create and load buckets, Create indexes
- Failover cluster nodes one by one and upgrade and add back. Create equivalent indexes if failed over node is indexer to continue queries
- After adding back the node and rebalancing them in, remove the equivalent indexes created.
- Start the int 64 queries.
Failed Query:
SELECT sum(long_num) as long_num, name FROM default use index (int_64_936834_long_num_name) where long_num > 2147483600 group by name
|
Error Message:
{'Content-Type': 'application/x-www-form-urlencoded', 'Accept': '*/*', 'Authorization': 'Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==\n'} error: 500 reason: unknown {
|
|
"requestID": "fd7307b6-261b-4baf-b188-b278889b946f",
|
|
"signature": {"long_num":"number","name":"json"},
|
|
"results": [
|
|
],
|
|
"errors": [{"code":5000,"msg":" strconv.ParseInt: parsing \"9223372036854776000\": value out of range from [10.111.171.103:9101] - cause: strconv.ParseInt: parsing \"9223372036854776000\": value out of range from [10.111.171.103:9101]"}],
|
|
"status": "errors",
|
|
"metrics": {"elapsedTime": "33.185783ms","executionTime": "33.134507ms","resultCount": 0,"resultSize": 0,"errorCount": 1}
|
|
} auth: Administrator:password
|
Similar query passes on various other tests like test_offline_upgrade (http://qa.sc.couchbase.com/job/cen7-2i-plasma-set5-job1-upgrade-4-6-4-int64/51/consoleFull)
Logs:
https://s3.amazonaws.com/bugdb/jira/failover_upgrade/collectinfo-2018-06-21T094601-ns_1%4010.111.171.101.zip
https://s3.amazonaws.com/bugdb/jira/failover_upgrade/collectinfo-2018-06-21T094601-ns_1%4010.111.171.102.zip
https://s3.amazonaws.com/bugdb/jira/failover_upgrade/collectinfo-2018-06-21T094601-ns_1%4010.111.171.103.zip
https://s3.amazonaws.com/bugdb/jira/failover_upgrade/collectinfo-2018-06-21T094601-ns_1%4010.111.171.104.zip
Attachments
Issue Links
- is a backport of
-
MB-30207 [GSI] Error strconv.ParseInt: parsing "9223372036854776000": value out of range in SUM aggregate
-
- Closed
-
For Gerrit Dashboard: MB-31745 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
100974,3 | MB-31745: Fix SUM aggregate query for large integers | vulcan | indexing | Status: MERGED | +2 | +1 |