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

Select * query throws Failure contacting server for parquet files

    XMLWordPrintable

Details

    Description

      Steps to reproduce -
      1. Create a valid json file with a single record greater than 32 MB
      2. Converted the above json into parquet file (resultant file size 1,6 MB )
      3. Created dataset for parquet format.
      4. ran a count(*) query on the above created dataset.
      5. ran a select * query on the above created dataset.
      Count(*) query ran fine, but the select * query is giving following error -

      {"status": "Failure contacting server."}
      

      Attachments

        For Gerrit Dashboard: MB-52783
        # Subject Branch Project Status CR V

        Activity

          After initial investigation, it appears the issue only happens on the UI, executing the same query using curl works fine.

          I'm investigating the root causing for this behavior on the UI.

          Umang Can you please try the above using a curl and confirm that it returns the expected result?

          Hussain.Towaileb Hussain Towaileb added a comment - After initial investigation, it appears the issue only happens on the UI, executing the same query using curl works fine. I'm investigating the root causing for this behavior on the UI. Umang Can you please try the above using a curl and confirm that it returns the expected result?
          Hussain.Towaileb Hussain Towaileb added a comment - - edited

          The root cause of the issue turned out to be the regular expression we use to search the result output for any numbers requiring more than 53 bits, we handle these numbers differently to ensure that they are displayed without precision loss in the UI.

          However, if the field value is too large (for example, the value is more than 30mb in size like the previous example) it is possible for the regular expression to run into a javascript stack size exceeded error. In this case, we currently report “Failure contacting server” which is misleading to the user.
          To address this, the error message needs to be updated to clearly indicate that the result is returned correctly but could not be displayed.

          Hussain.Towaileb Hussain Towaileb added a comment - - edited The root cause of the issue turned out to be the regular expression we use to search the result output for any numbers requiring more than 53 bits, we handle these numbers differently to ensure that they are displayed without precision loss in the UI. However, if the field value is too large (for example, the value is more than 30mb in size like the previous example) it is possible for the regular expression to run into a javascript stack size exceeded error . In this case, we currently report “Failure contacting server” which is misleading to the user. To address this, the error message needs to be updated to clearly indicate that the result is returned correctly but could not be displayed.

          Build couchbase-server-7.2.0-1617 contains cbas-ui commit 1f97d13 with commit message:
          MB-52783: Update reported error to indicate result cannot be displayed

          build-team Couchbase Build Team added a comment - Build couchbase-server-7.2.0-1617 contains cbas-ui commit 1f97d13 with commit message: MB-52783 : Update reported error to indicate result cannot be displayed

          Build couchbase-server-7.1.2-3370 contains cbas-ui commit 1f97d13 with commit message:
          MB-52783: Update reported error to indicate result cannot be displayed

          build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.2-3370 contains cbas-ui commit 1f97d13 with commit message: MB-52783 : Update reported error to indicate result cannot be displayed

          Build couchbase-server-8.0.0-1053 contains cbas-ui commit 1f97d13 with commit message:
          MB-52783: Update reported error to indicate result cannot be displayed

          build-team Couchbase Build Team added a comment - Build couchbase-server-8.0.0-1053 contains cbas-ui commit 1f97d13 with commit message: MB-52783 : Update reported error to indicate result cannot be displayed
          umang.agrawal Umang added a comment -

          Verified with Enterprise Edition 7.1.2 build 3372

          New error message that is being displayed is -

          {"status": "Result is returned but cannot be displayed"}
          

          umang.agrawal Umang added a comment - Verified with Enterprise Edition 7.1.2 build 3372 New error message that is being displayed is - {"status": "Result is returned but cannot be displayed"}

          People

            umang.agrawal Umang
            umang.agrawal Umang
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty