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

Select * from sasl bucket, 7M documents, shows results after about 15 minutes

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Critical
    • 4.0.0
    • 4.0.0
    • query
    • Security Level: Public
    • 350-1335
      1 Node, 8 CPU, 24G Ram
      2 Buckets - Default and Sasl ( with password)
    • Untriaged
    • Unknown

    Description

      1. Load 7M documents on the default and sasl bucket
      2. Incoming sets on the bucket at 8 K ops/sec
      3. Issue a create primary index on sasl - success
      4. Issue a select * from sasl limit 1 — Empty values

      Tried this about 10 times, the output is success with 0 items.

      After about 15 minutes, the exact same query returns the results.

      • This works okay w/ automation on smaller datasets and smllaer front load (100-200k docs )
        Expected query behaviour to me would be
      • Error out saying - Cannot fetch
      • Wait before the indexes are built?
      • Here again : Select * from system:indexes shows the indexes online, almost immediately after the indexes are defined i.e. "Create index".

      Once system:indexes are online - Should'nt users expect to see results on the buckets?

      Attachments

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

        Activity

          People

            keshav Keshav Murthy
            ketaki Ketaki Gangal (Inactive)
            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