Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-31745

[BP MB-30207] - [GSI] Error strconv.ParseInt: parsing "9223372036854776000": value out of range

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 5.5.0
    • 5.5.3
    • secondary-index
    • 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]

      1. Create and configure cluster, Create and load buckets, Create indexes
      2. Failover cluster nodes one by one and upgrade and add back. Create equivalent indexes if failed over node is indexer to continue queries
      3. After adding back the node and rebalancing them in, remove the equivalent indexes created.
      4. 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

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            There are no commits yet on this issue.

            People

              amit.kulkarni Amit Kulkarni
              jeelan.poola Jeelan Poola
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty