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

32 bit OS - cannot run any query with primary gsi index

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • 4.0.0
    • 4.0.0
    • secondary-index
    • Security Level: Public
    • None
    • 4.0.0-1716
    • Untriaged
    • Unknown

    Description

      Single node
      Create 1 bucket
      Load some items
      Create primary index using gsi
      run simple query
      iryna@ubuntu:~/couchbase/testrunner$ curl 'http://172.23.105.112:8093/query?statement=select%20*%20from%20default&scan_consistancy=request_plus'
      {
      "requestID": "e30c48d4-80d4-4cd5-84d9-e737b10f1d1f",
      "signature":

      { "*": "*" }

      ,
      "results": [
      ],
      "errors": [

      { "code": 5000, "msg": "GSI scan error - cause: WSARecv tcp 172.23.105.112:63760: An existing connection was forcibly closed by the remote host." }

      ,

      { "code": 5000, "msg": "GSI scan error - cause: WSARecv tcp 172.23.105.112:63761: An existing connection was forcibly closed by the remote host." }

      ],
      "status": "errors",
      "metrics":

      { "elapsedTime": "819.9963ms", "executionTime": "819.9963ms", "resultCount": 0, "resultSize": 0, "errorCount": 2 }

      }
      at the same time cbq shell shows syntax error for the query
      $ ./cbq.exe
      create primary index on default using gsi;
      {
      "requestID": "d37d05f1-6340-4af8-aa78-72aff01d3cbb",
      "signature": null,
      "results": [
      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "624.0001ms", "executionTime": "624.0001ms", "resultCount": 0, "resultSize": 0 }

      }

      select * from default;
      {
      "requestID": "82b03254-02e9-46a3-823e-8f676f7aaad5",
      "errors": [

      { "code": 3000, "msg": "syntax error" }

      ],
      "status": "fatal",
      "metrics":

      { "elapsedTime": "9.9969ms", "executionTime": "8.9981ms", "resultCount": 0, "resultSize": 0, "errorCount": 1 }

      }
      adding cbcollect logs

      Attachments

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

        Activity

          People

            prataprc Pratap Chakravarthy (Inactive)
            iryna iryna
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty