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

[GSI] Error strconv.ParseInt: parsing "9223372036854776000": value out of range in SUM aggregate

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.5.0
    • Fix Version/s: 6.5.0
    • Component/s: secondary-index
    • Labels:
    • Environment:
      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)
    • Triage:
      Untriaged
    • Is this a Regression?:
      Unknown

      Description

      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

            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-5.5.3-4015 contains indexing commit e083223 with commit message:
            MB-31745: Fix SUM aggregate query for large integers

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-5.5.3-4015 contains indexing commit e083223 with commit message: MB-31745 : Fix SUM aggregate query for large integers
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-5.1.3-6207 contains indexing commit c9cba3e with commit message:
            MB-31746: Fix number decoding to handle values above MaxInt64

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-5.1.3-6207 contains indexing commit c9cba3e with commit message: MB-31746 : Fix number decoding to handle values above MaxInt64
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-6.0.1-1959 contains indexing commit d20c4bb with commit message:
            MB-31744: Backport MB-30207: Fix SUM aggregate query for large integers

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-6.0.1-1959 contains indexing commit d20c4bb with commit message: MB-31744 : Backport MB-30207 : Fix SUM aggregate query for large integers
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-6.5.0-1613 contains indexing commit 66a40d1 with commit message:
            MB-30207: Collatejson tests for number variations

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-6.5.0-1613 contains indexing commit 66a40d1 with commit message: MB-30207 : Collatejson tests for number variations
            Hide
            girish.benakappa Girish Benakappa added a comment -

            Verified with 6.5.0-4380 following the steps in MB-31745

            Show
            girish.benakappa Girish Benakappa added a comment - Verified with 6.5.0-4380 following the steps in MB-31745

              People

              Assignee:
              amit.kulkarni Amit Kulkarni
              Reporter:
              prasanna.gholap Prasanna Gholap [X] (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved:

                  Gerrit Reviews

                    PagerDuty