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

Query service returns Error performing bulk get operation

    XMLWordPrintable

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • Cheshire-Cat, 6.0.4, 6.5.1
    • Morpheus
    • query
    • None
    • Untriaged
    • 1
    • Unknown

    Description

      Repro:

      Install travel-sample with primary index
      create a.sql with following statement 50 times
      select x from `travel-sample` where x =10;
      create b.sql with following statement 50 times (t1 non existent bucket)
      select * from t1;
      In two windows simultaneously run following commands (cbq must be in the path) and check query.log
      session 1: cbq -e=127.0.0.1:8093 -u=Administrator -p=password < a.sql
      session 2: cbq -e=127.0.0.1:8093 -u=Administrator -p=password < b.sql
      

      In query log you see

      2020-06-07T12:24:34.266-07:00 [INFO] Pool Get returned travel-sample: no connection pool
      2020-06-07T12:24:34.266-07:00 [INFO] Pool Get returned travel-sample: no connection pool
      

      Some times you see :

      2020-06-07T12:24:34.266-07:00 [ERROR] bulkget exceeded MaxBulkRetries for travel-sample(vbid:46,keys:<ud>[landmark_33345]</ud>)
      

      When this happens query gets error something like this.
      "errors": [
      {
      "code": 12008,
      "msg": "Error performing bulk get operation - cause:

      {1 errors, starting with bulkget exceeded MaxBulkRetries for travel-sample(vbid:46,keys:\u003cud\u003e[landmark_33345]\u003c/ud\u003e)}

      ",
      "retry": true
      }
      ]

      if non existing bucket query not run there are no-errors. non-existing bucket should not impact other queries.

      Attachments

        Issue Links

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

          Activity

            Sitaram.Vemulapalli Sitaram Vemulapalli created issue -
            Sitaram.Vemulapalli Sitaram Vemulapalli made changes -
            Field Original Value New Value
            Link This issue blocks CBSE-8418 [ CBSE-8418 ]
            Sitaram.Vemulapalli Sitaram Vemulapalli made changes -
            Description Repro:


            {code:java}
            Install travel-sample with primary index
            create a.sql with following statement 50 times
            select x from `travel-sample` where x =10;
            create b.sql with following statement 50 times (t1 non existent bucket)
            select * from t1;
            In two windows simultaneously run following commands (cbq must be in the path) and check query.log
            session 1: cbq -e=127.0.0.1:8093 -u=Administrator -p=password < a.sql
            session 2: cbq -e=127.0.0.1:8093 -u=Administrator -p=password < b.sql
            {code}

            In query log you see

            {code:java}
            2020-06-07T12:24:34.266-07:00 [INFO] Pool Get returned travel-sample: no connection pool
            2020-06-07T12:24:34.266-07:00 [INFO] Pool Get returned travel-sample: no connection pool
            {code}

            Some times you see :

            {code:java}
            2020-06-07T12:24:34.266-07:00 [ERROR] bulkget exceeded MaxBulkRetries for travel-sample(vbid:46,keys:<ud>[landmark_33345]</ud>)
            {code}

            When this happens query gets error something like this.
            "errors": [
                    {
                        "code": 12008,
                        "msg": "Error performing bulk get operation - cause: {1 errors, starting with bulkget exceeded MaxBulkRetries for travel-sample(vbid:46,keys:\u003cud\u003e[landmark_33345]\u003c/ud\u003e)}",
                        "retry": true
                    }
            ]

            if non existing bucket query run no-errors. non-existing bucket should not impact other queries.

            Repro:


            {code:java}
            Install travel-sample with primary index
            create a.sql with following statement 50 times
            select x from `travel-sample` where x =10;
            create b.sql with following statement 50 times (t1 non existent bucket)
            select * from t1;
            In two windows simultaneously run following commands (cbq must be in the path) and check query.log
            session 1: cbq -e=127.0.0.1:8093 -u=Administrator -p=password < a.sql
            session 2: cbq -e=127.0.0.1:8093 -u=Administrator -p=password < b.sql
            {code}

            In query log you see

            {code:java}
            2020-06-07T12:24:34.266-07:00 [INFO] Pool Get returned travel-sample: no connection pool
            2020-06-07T12:24:34.266-07:00 [INFO] Pool Get returned travel-sample: no connection pool
            {code}

            Some times you see :

            {code:java}
            2020-06-07T12:24:34.266-07:00 [ERROR] bulkget exceeded MaxBulkRetries for travel-sample(vbid:46,keys:<ud>[landmark_33345]</ud>)
            {code}

            When this happens query gets error something like this.
            "errors": [
                    {
                        "code": 12008,
                        "msg": "Error performing bulk get operation - cause: {1 errors, starting with bulkget exceeded MaxBulkRetries for travel-sample(vbid:46,keys:\u003cud\u003e[landmark_33345]\u003c/ud\u003e)}",
                        "retry": true
                    }
            ]

            if non existing bucket query not run there are no-errors. non-existing bucket should not impact other queries.

            siri Sriram Melkote (Inactive) made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            marco.greco Marco Greco made changes -
            Link This issue relates to MB-39682 [ MB-39682 ]
            arunkumar Arunkumar Senthilnathan (Inactive) made changes -
            Link This issue relates to SDKQE-1914 [ SDKQE-1914 ]
            Sitaram.Vemulapalli Sitaram Vemulapalli made changes -
            Link This issue blocks MB-41535 [ MB-41535 ]
            marco.greco Marco Greco made changes -
            Link This issue blocks MB-42152 [ MB-42152 ]
            marco.greco Marco Greco made changes -
            Link This issue blocks MB-41535 [ MB-41535 ]
            marco.greco Marco Greco made changes -
            Link This issue is duplicated by MB-41535 [ MB-41535 ]
            isha Isha Kandaswamy (Inactive) made changes -
            Assignee Kamini Jagtiani [ kamini.jagtiani ] Isha Kandaswamy [ isha ]
            isha Isha Kandaswamy (Inactive) made changes -
            Fix Version/s CheshireCat.Next [ 16908 ]
            Fix Version/s Cheshire-Cat [ 15915 ]
            kamini.jagtiani Kamini Jagtiani (Inactive) made changes -
            Fix Version/s Morpheus [ 17651 ]
            Fix Version/s CheshireCat.Next [ 16908 ]
            isha Isha Kandaswamy (Inactive) made changes -
            Assignee Isha Kandaswamy [ isha ] Kamini Jagtiani [ kamini.jagtiani ]

            People

              kamini.jagtiani Kamini Jagtiani (Inactive)
              Sitaram.Vemulapalli Sitaram Vemulapalli
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty