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

[UI] Implicit ADVISE in Query workbench should be disabled in Community Edition

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • Cheshire-Cat
    • 7.0.0
    • UI
    • MacOS Community Edition 7.0.0 build 4458
    • Untriaged
    • 1
    • Unknown

    Description

      While testing transaction on community edition, I ran into following issue in Query Workbench:

      [
        {
          "_sequence_num": 1,
          "_sequence_query": "begin work;",
          "_sequence_query_status": "success",
          "_sequence_result": [
            {
              "txid": "989f4499-1131-4253-a4b1-3870b86de7d2"
            }
          ]
        },
        {
          "_sequence_num": 2,
          "_sequence_query": "\nselect count(*) from `travel-sample` where type = 'airport';",
          "_sequence_query_status": "Internal Server Error",
          "_sequence_result": [
            {
              "code": 3230,
              "msg": "Advise is enterprise level feature."
            }
          ]
        }
      ]

      If ADVISE is not available in CE, it should not be running in UI on CE.

      To repro, simply run following in query editor:

       begin work;
       select count(*) from `travel-sample` where type = 'airport';
       savepoint s1;
       rollback;

       

       

      Attachments

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

        Activity

          eben Eben Haber added a comment -

          I just merged a fix for this. ADVISE is not longer automatically run on non-EE clusters.

          eben Eben Haber added a comment - I just merged a fix for this. ADVISE is not longer automatically run on non-EE clusters.

          Build couchbase-server-7.0.0-4477 contains query-ui commit 4303055 with commit message:
          MB-44323 - Don't automatically run ADVISE in CE

          build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.0-4477 contains query-ui commit 4303055 with commit message: MB-44323 - Don't automatically run ADVISE in CE

          People

            eben Eben Haber
            pierre.regazzoni Pierre Regazzoni
            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