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

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 5.5.0
    • 6.5.0
    • 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

      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

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

            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

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

            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

            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

            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

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

            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

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

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

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  PagerDuty