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

User field of completed requests lost from long running query that timed out

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Major
    • bug-backlog
    • 5.1.1, 5.5.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      Loaded up a dataset of ~200M items and created a primary index on it via the query workbench.  The query timed out after 10m as per the workbench settings but the completed_requests doesn't show the user (see screenshot).

       

      This should be reproducible with any query that runs for a long time and then times out in the workbench, the primary index creation was just an easy way of achieving that.

       

      I have also tested shorter running queries with a much lower timeout and the user is displayed properly so there is something specific to long-running timed out queries.  

       

      One thought from Marco Greco was that the user field may be getting "recycled" before the query times out and therefore not available when the timeout happens.

       

      This could be seen as both a security risk as well as an operational challenge if an administrator is not able to see which user executed a very long-running query.

      Attachments

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

        Activity

          People

            Donald.haggart Donald Haggart
            perry Perry Krug
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty