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

System Event Log - Query

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Done
    • 7.0.0
    • 7.1.0
    • query
    • 1

    Description

      In Neo we're introducing a system event log to record events that happen across the cluster, see the parent MB, https://issues.couchbase.com/browse/MB-46215 for more details. 

      For Query we need to capture the following events. 

      Query Service Events Additional Details Needed
      Query Engine Crash Name of process that crashed
      PID of crashed process
      Query Service Config Change Previous Setting and New Setting
      Per Query Memory Threshold Reached Hash of the query

      Attachments

        Issue Links

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

          Activity

            Build couchbase-server-7.1.0-1233 contains query commit 7e764f4 with commit message:
            MB-47027 Revise JSON output to match changed spec

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1233 contains query commit 7e764f4 with commit message: MB-47027 Revise JSON output to match changed spec

            Hareen Kancharla could you confirm how to retrieve the logged events?

            The spec indicates a GET on /events but (as of build 1286) all I get is a  404 Object Not found response:

             

            # curl -vu Administrator:password http://localhost:8091/events
            *   Trying 127.0.0.1:8091...
            * TCP_NODELAY set
            * Connected to localhost (127.0.0.1) port 8091 (#0)
            * Server auth using Basic with user 'Administrator'
            > GET /events HTTP/1.1
            > Host: localhost:8091
            > Authorization: Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==
            > User-Agent: curl/7.68.0
            > Accept: */*
            > 
            * Mark bundle as not supporting multiuse
            < HTTP/1.1 404 Object Not Found
            ...
            

            (Logging works; I get expected error responses for invalid JSON etc.)

            Donald.haggart Donald Haggart added a comment - Hareen Kancharla could you confirm how to retrieve the logged events? The spec indicates a GET on /events but (as of build 1286) all I get is a  404 Object Not found response:   # curl -vu Administrator:password http://localhost:8091/events * Trying 127.0.0.1:8091... * TCP_NODELAY set * Connected to localhost (127.0.0.1) port 8091 (#0) * Server auth using Basic with user 'Administrator' > GET /events HTTP/1.1 > Host: localhost:8091 > Authorization: Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA== > User-Agent: curl/7.68.0 > Accept: */* > * Mark bundle as not supporting multiuse < HTTP/1.1 404 Object Not Found ... (Logging works; I get expected error responses for invalid JSON etc.)

            Donald Haggart: Sent you over email the instructions to check the added event logs.

            hareen.kancharla Hareen Kancharla added a comment - Donald Haggart : Sent you over email the instructions to check the added event logs.

            Build couchbase-server-7.1.0-1298 contains query commit c28160e with commit message:
            MB-47027 Correct timestamp format, fix auth information lookup, improve error reporting

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1298 contains query commit c28160e with commit message: MB-47027 Correct timestamp format, fix auth information lookup, improve error reporting
            ajay.bhullar Ajay Bhullar added a comment -

            we have automated testing to check the query system events generated

            centos-query_system_event_logging_7.1_P0

            ajay.bhullar Ajay Bhullar added a comment - we have automated testing to check the query system events generated centos-query_system_event_logging_7.1_P0

            People

              ajay.bhullar Ajay Bhullar
              ianmccloy Ian McCloy
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty