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

Mechanism to log queries that cause panic/crashes in Query service

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • None
    • 5.1.1
    • query

    Description

      There are times when a client query causes the Query service to crash/panic and it is very difficult to identify the offending query. For example, a difficult scenario is when there is production impact due to intermittent crashes of the Query service and we cannot restore Query into a stable state because of the challenge in identifying the offending query in a time-efficient manner.

      It would be nice to have a log, similar to active and completed requests, whereby we can log suspect queries that potentially are culprits that caused a crash.

      Perhaps this is a simplistic view regarding a possible solution, but we could log every inbound query in a list (similar to active_requests and completed_requests) and remove them when they successfully complete. Queries that generate syntax errors would be ignored. Although this does not exactly identify which query causes a panic/crash, at least we can narrow down the list of queries that could be the culprit and speed up the process of identifying the problematic query.

       

      Attachments

        Issue Links

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

          Activity

            People

              marco.greco Marco Greco (Inactive)
              merrick.huang Merrick Huang (Inactive)
              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