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

cbimport periodically fails with Internal Server Error

    XMLWordPrintable

Details

    • Task
    • Resolution: Fixed
    • Major
    • 7.1.0
    • 7.1.0
    • tools
    • 1
    • Tools 2021 Nov, Tools 2021 Dec

    Description

      What's the issue?
      In our integration tests we are importing the sample 'travel-sample' dataset using the cbimport CLI command and it periodically fails with

      JSON import failed: failed to execute cluster operations: failed to execute bucket operation for bucket \'default\': failed to execute queries for bucket \'default\': failed to execute queries against sink bucket: failed to execute query: internal server failure | {"statement":"CREATE PRIMARY INDEX beer_primary on `default` USING GSI WITH {\\"defer_build\\":true}","client_context_id":"fc4c554b-0ade-4c56-ac38-096e51e572c4","errors":[{"Code":5000,"Message":"GSI CreatePrimaryIndex() - cause: Encountered transient error.  Index creation will be retried in background.  Error: Indexer Cannot Process Create Index In Paused State\\n"}]}\nJSON import failed: internal server failure\n'
      

      The full logs with one failing travel-sample cbimport test are attached. We also test cbimport with other sample datasets and I can't recall if they have ever failed, it only seems to be an issue with the 'travel-sample' tests which are the last ones in the test suite. Similar cbdocloader tests, which follow the cbimport tests, also occasionally fail even though they do not import 'travel-sample' so I'm not completely sure there is a correlation.

      Steps to reproduce:
      1) Set up a 1-node cluster with data, indexing and query services.
      2) Run

      cbimport json -c http://localhost:9000 -u Administrator -p asdasd -b default -f sample -d file:///home/username/source/install/samples/travel-sample.zip
      

      or run Examinador integration tests directly (requires cloning the Examinador repo and setting it up) by cherry-picking the latest patch from https://review.couchbase.org/c/examinador/+/165275 and running

      robot-env/bin/robot --variable SOURCE:/home/[name]/cb/source --variable SKIP_LOGS:True -L DEBUG cb_exp_imp_tests
      

      Attachments

        Issue Links

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

          Activity

            People

              maks.januska Maksimiljans Januska
              maks.januska Maksimiljans Januska
              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