Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
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
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 5.5.3 [ 15520 ] | |
| Fix Version/s | 6.0.1 [ 15522 ] |
| Description |
# 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: {noformat} 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{noformat} Error Message: {noformat} {'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{noformat} 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] |
[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: {noformat} 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{noformat} Error Message: {noformat} {'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{noformat} 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] |
| Link | This issue blocks MB-31456 [ MB-31456 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Resolved [ 5 ] |
| Actual End | 2018-10-30 07:45 (issue has been resolved) |
| Status | Resolved [ 5 ] | Closed [ 6 ] |