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

Queries don't show any results on Windows when cluster has more than 1 node, collation error

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 2.0
    • None
    • view-engine
    • Security Level: Public
    • None
    • windows server r2 2008, 2 VMs
      build #1660

    Description

      Structure:
      2 nodes
      3 buckets: default, and two sasl bucket
      each bucket has 2 items
      default bucket have 1 ddoc with 1 production view: view0 with map fn:
      function (doc, meta)

      { emit(meta.id, null); }

      docs are created from ui, body is not changed

      ep_queue_size is 0
      documents are present in vbuckets:
      Administrator@WIN-335SPEPOCGT /cygdrive/c/Program Files/Couchbase/Server/var/lib/couchbase/data/default
      $ ../../../../../bin/couch_dbdump 960.couch.1
      Doc seq: 1
      id: doc10
      rev: 1
      content_meta: 0
      cas: 3893546846755663, expiry: 0, flags: 0
      data:

      {"click":"to edit","new in 2.0":"there are no reserved field names"}

      Total docs: 1

      Exact query:
      iryna@ubuntu:~/couchbase/testrunner$ curl -v -X GET 'http://10.1.3.146:8092/default/_design/view0/_view/view0?stale=false&connection_timeout=60000&limit=10&skip=0'

      • About to connect() to 10.1.3.146 port 8092 (#0)
      • Trying 10.1.3.146...
      • connected
      • Connected to 10.1.3.146 (10.1.3.146) port 8092 (#0)
        > GET /default/_design/view0/_view/view0?stale=false&connection_timeout=60000&limit=10&skip=0 HTTP/1.1
        > User-Agent: curl/7.26.0
        > Host: 10.1.3.146:8092
        > Accept: /
        >
        < HTTP/1.1 200 OK
        < Transfer-Encoding: chunked
        < Server: MochiWeb/1.0 (Any of you quaids got a smint?)
        < Date: Thu, 30 Aug 2012 22:19:18 GMT
        < Content-Type: text/plain;charset=utf-8
        < Cache-Control: must-revalidate
        < {"total_rows":2,"rows":[ ] }
      • Connection #0 to host 10.1.3.146 left intact
      • Closing connection #0
        iryna@ubuntu:~/couchbase/testrunner$ curl -v -X GET 'http://10.1.3.147:8092/default/_design/view0/_view/view0?stale=false&connection_timeout=60000&limit=10&skip=0'
      • About to connect() to 10.1.3.147 port 8092 (#0)
      • Trying 10.1.3.147...
      • connected
      • Connected to 10.1.3.147 (10.1.3.147) port 8092 (#0)
        > GET /default/_design/view0/_view/view0?stale=false&connection_timeout=60000&limit=10&skip=0 HTTP/1.1
        > User-Agent: curl/7.26.0
        > Host: 10.1.3.147:8092
        > Accept: /
        >
        < HTTP/1.1 200 OK
        < Transfer-Encoding: chunked
        < Server: MochiWeb/1.0 (Any of you quaids got a smint?)
        < Date: Thu, 30 Aug 2012 22:19:26 GMT
        < Content-Type: text/plain;charset=utf-8
        < Cache-Control: must-revalidate
        < {"total_rows":2,"rows":[ ] }
      • Connection #0 to host 10.1.3.147 left intact
      • Closing connection #0

      it shows that there are 2 document, it's correct, but there are no any keys showing
      The same result i get for stale=update_after and stale=ok

      Attachments

        1. 10.1.3.146-8091-diag.txt.gz
          2.15 MB
        2. 10.1.3.147-8091-diag.txt.gz
          2.13 MB
        3. default-146.zip
          334 kB
        4. default-147.zip
          309 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            FilipeManana Filipe Manana (Inactive)
            iryna iryna
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty