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

[windows] View Indexes in "pending" state returns "System database error: Failed to load indexes"

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • 4.0.0
    • 4.0.0
    • query
    • Security Level: Public
    • 400-2017
      Single Node, Single Bucket
      Node contains kv_query_index services
      Empty or nearly empty bucket
    • Triaged
    • Unknown

    Description

      Automated and Manual runs = both can easily run into this issue

      Automated test to repro:
      ./testrunner -i fournode_windows_2012_r2.ini -t tuqquery.tuq_dml.DMLQueryTests.test_update_where,force_clean=True,reload_data=False,nodes_init=1,skip_load=True

      What the test does

      • Create a bucket
      • create primary view index on the bucket
      • Issue INSERTs ( ~ 20) on the bucket
      • Check system:indexes to see if the indexes are online - Error:
        System database error: Failed to load indexes for keyspace default

      Successive attempts to read this as unsuccessful, after the index is completely online only - Can I get any results from system:indexes.

      Strange observations:

      • Indexing primary view index on a nearly empty bucket ( doc contains fewer than 2 records) taking more than a couple of minutes
      • While the index is being built , system catalog tables should display "pending" state, not sure why it throws up a System database error.
      • This impacts most of our tests, where we check if an index is online or not, and this above failure causes intermittent expectations on the test.

      Logs https://s3.amazonaws.com/cb-customers/a/1/collectinfo-2015-05-01T182445-ns_1%40172.23.107.90.zip

      Attachments

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

        Activity

          People

            isha Isha Kandaswamy (Inactive)
            ketaki Ketaki Gangal (Inactive)
            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