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

          blocks

          Improvement - An improvement or enhancement to an existing feature or task. MB-46215 Automation and Parse-Friendly System Event Feed

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. MB-48258 [ADVISOR] advisor stop session fails (panic) with Error evaluating projection - cause: Panic: interface conversion: interface {} is []interface {}, not map[string]interface {}

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          For Gerrit Dashboard: MB-47027
          # Subject Branch Project Status CR V
          159705,14 MB-47027 Add system event log events master query Status: MERGED +2 +1
          160651,2 MB-47027 Revise JSON output to match changed spec master query Status: MERGED +2 +1
          160653,2 MB-47027 Further revisions to JSON output to match changed spec master query Status: MERGED +2 +1
          161489,2 MB-47027 Correct timestamp format, fix auth information lookup, improve error reporting master query Status: MERGED +2 +1

          Activity

            Ascending order - Click to sort in descending order
            View 11 older comments
            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

            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
            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 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.)
            hareen.kancharla Hareen Kancharla added a comment -

            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-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

            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